Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, December 24, 2015

Effected Tables in Order Management in Different Stages

Entered

oe_order_headers_all
1 record created in header table
oe_order_lines_all
Lines for particular records
oe_price_adjustments
When discount gets applied
oe_order_price_attribs
If line has price attributes then populated
oe_order_holds_all
If any hold applied for order like credit check etc.


Booked

oe_order_headers_all
Booked_flag=Y Order booked.
wsh_delivery_details
Released_status Ready to release


PickReleased

wsh_delivery_details
Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)
wsh_picking_batches
After batch is created for pick release.
mtl_reservations
This is only soft reservations. No physical movement of stock


FullTransaction

mtl_material_transactions
No records in mtl_material_transactions
mtl_txn_request_headers

mtl_txn_request_lines

wsh_delivery_details
Released to warehouse.
wsh_new_deliveries
if Auto-Create is Yes then data populated.
wsh_delivery_assignments
deliveries get assigned


PickConfirmed

wsh_delivery_details
Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock


ShipConfirmed

wsh_delivery_details
Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged
mtl_material_transactions
On the ship confirm form, check Ship all box
wsh_new_deliveries
If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped
oe_order_lines_all
Shipped_quantity get populated.
wsh_delivery_legs
1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all
If all the lines get shipped then only flag N


Autoinvoice

wsh_delivery_details
Released_status=I Need to run workflow background process.
ra_interface_lines_all
Data will be populated after wkfw process.
ra_customer_trx_all
After running Autoinvoice Master Program for
ra_customer_trx_lines_all
specific batch transaction tables get populated

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect