Interested to Buy Any Domain ? << Click Here >> for more details...
explain o2c cycle? what are the table reflected for this
process?
- 1 Answers
- 8547 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / fayazapps
Oracle Order to Cash tables: O2C tables
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’
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many schemas we have? how many you have used?
what is pay run id ?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
List the types of flexfield?
What are the different components of soa suite?
How to create a purchase order without a requisition?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can you differentiate between mediator and osb?
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
How can you achieve loose coupling in soa framework?
In sequence i want to 11 and 15th values how we will write?
Do you know what is applysys in oracle application database schema, what is apps?
testing tools?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is the differences between internal requisition and internal sales order?
