Oracle Apps Order to Cash important tables: | ||
Order entry | ||
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 | |
Order Booked | ||
OE_ORDER_HEADERS_ALL | Booked_Flag=Y, Order booked. | |
WSH_DELIVERY_DETAILS | Status Opened | |
WSH_DELIVERY_ASSIGNMENTS | WSH_DELIVERY_ASSIGNMENTS.delivery_id will be NULL as still pick release operation is not performed as final delivery is not yet created. | |
MTL_DEMAND. | ‘Demand interface program’ is triggered in the background and demand of the item with specified quantity is created | |
Order Scheduled/Reserved | This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background(if scheduled) and quantities are reserved. | |
OE_ORDER_LINES_ALL | Awaiting Shipping | |
MTL_RESERVATIONS | This is only soft reservations. No physical movement of stock | |
WSH_DELIVERY_DETAILS | R: Ready to Release: Line is ready to be released | |
Pick Released | Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order. | |
OE_ORDER_LINES_ALL | ||
WSH_DELIVERY_DETAILS | S: Released to Warehouse | |
WSH_NEW_DELIVERIES | A new record is created in WSH_NEW_DELIVERIES with status_code = ‘OP’ (Open). WSH_NEW_DELIVERIES has the delivery records. | |
WSH_DELIVERY_ASSIGNMENTS | Deliveries get assigned | |
WSH_PICKING_BATCHES | After batch is created for pick release | |
MTL_TXN_REQUEST_HEADERS | A move order is created in Pick Release process which is used to pick and move the goods to staging area (here move order is just created but not transacted). MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES are move order tables | |
MTL_TXN_REQUEST_LINES | move order line | |
Pick Confirm | Pick Confirm is to transact the move order created in Pick Release process | |
OE_ORDER_LINES_ALL | flow_status_code =’PICKED’ | |
MTL_MATERIAL_TRANSACTIONS_TEMP | (Record gets deleted from here and gets posted to MTL_MATERIAL_TRANSACTIONS) | |
MTL_MATERIAL_TRANSACTIONS | MTL_MATERIAL_TRANSACTIONS is updated with Sales Order Pick Transaciton | |
MTL_TRANSACTION_ACCOUNTS | updated with accounting information for mtl_material Transactions | |
WSH_DELIVERY_DETAILS | Y: Staged- Line has been picked and staged by Inventory | |
MTL_ONHAND_QUANTITIES | ||
Ship Confirmed | The goods are picked from staging area and given to shipping. “Interface Trip Stop” program runs in the backend. | |
OE_ORDER_LINES_ALL | .flow_status_code =‘SHIPPED’ Shipped_Quantity get populated | |
WSH_DELIVERY_DETAILS | Released_Status=C ;Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased | |
MTL_TRANSACTIONS_INTERFACE | Data from MTL_TRANSACTIONS_INTERFACE is moved to MTL_MATERIAL_TRANACTIONS | |
MTL_MATERIAL_TRANSACTIONS | updated with Sales Order Issue transaction | |
WSH_NEW_DELIVERIES | If Defer Interface is checked then OM & inventory not updated. If Defer Interface is not checked: Shipped | |
OE_ORDER_LINES_ALL | ||
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 | |
WSH_NEW_DELIVERIES | Data Deleted | |
MTL_RESERVATIONS | Data Deleted | |
MTL_DEMAND | Data Deleted | |
MTL_ONHAND_QUANTITIES | Item deducted from MTL_ONHAND_QUANTITIES | |
MTL_TRANSACTION_ACCOUNTS | updated with accounting information. | |
WSH_TRIPS | ||
WSH_TRIP_STOPS | ||
Auto Invoice | After shipping the order the order lines gets eligible to get transfered to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. | |
OE_ORDER_LINES_ALL | invoice_interface_status_code = ‘YES’ | |
WSH_DELIVERY_DETAILS | Released_Status=I | |
RA_INTERFACE_LINES_ALL | Data will be populated after work flow process. | |
RA_CUSTOMER_TRX_ALL | After running Auto Invoice Master Program for | |
RA_CUSTOMER_TRX_LINES_ALL | Specific batch transaction tables get populated | |
Close Order | Last step of the process is to close the order which happens automatically once the goods are shipped | |
OE_ORDER_LINES_ALL | flow_status_code =’CLOSED’ and open_flag = ‘N’ |
Saturday, March 30, 2013
Oracle Order to Cash tables: O2C tables
Subscribe to:
Post Comments (Atom)
8 comments:
What an excellent informative blog about Oracle. Thanks for sharing.
Best Mobility Services | Austere Technologies
Very good informative article. Thanks for sharing such nice article, keep on updating such good articles.
BEST MOBILE APPLICATION DEVELOPMENT SERVICES | MASSIL TECHNOLOGIES
awsome blog.
seo service
Excellent informative blog, keep for sharing.
Best System Integration services | Massil Technologies
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Hats off to your presence of mind..I really enjoyed reading your blog. I really appreciate your information which you shared with us.
Best quoting software
Thank you so much for detailed explaination with tables.
Post a Comment