Edi Yanto (何 萬 新)

Archive for January 2012

Populate Order Import Interface Tables From Existing Sales Order

Posted by: Edi Yanto on: January 26, 2012

The script below is used to populate the order import interface tables using data from an existing sales order. Interface Tables: OE_HEADERS_IFACE_ALL OE_LINES_IFACE_ALL OE_PRICE_ADJS_IFACE_ALL OE_PAYMENTS_INTERFACE OE_CREDITS_IFACE_ALL OE_LOTSERIALS_IFACE_ALL Base Tables: OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL OE_PRICE_ADJUSTMENTS OE_PAYMENTS OE_SALES_CREDITS OE_LOT_SERIAL_NUMBERS

Transact Move Order and Ship Confirm Using API

Posted by: Edi Yanto on: January 20, 2012

Transact Move Order Allocating Move Order using inv_replenish_detail_pub.line_details_pub. To delete the lot allocation record use inv_trx_util_pub.delete_lot_ser_trx and to insert new lot allocation record use inv_trx_util_pub.insert_lot_trx. Transact Move Order using inv_pick_wave_pick_confirm_pub.pick_confirm. Ship Confirm Ship Confirm using wsh_deliveries_pub.delivery_action p_action_code := ‘CONFIRM’ and p_sc_action_flag := ‘S’ Note: p_sc_action_flag => Ship Confirm option – S, B, T, A, C. [...]

Tags:

The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so the PO will be received. Records needs to be inserted into [...]

Tags:

RSS Syndication


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications




Enter your email address to follow this blog and receive notifications of new posts by email.

Join 992 other followers

Archives

 

January 2012
M T W T F S S
« May   Mar »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Top Rated

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.

Visitors

Categories

Blog Stats

  • 54,082 hits

Users Online

web counter

Pages

Follow

Get every new post delivered to your Inbox.

Join 992 other followers