Answer / 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’

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

---

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,

---

What is an Index , Types od index why we are use index.

2 Answers   IBM,

---

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

Which oracle apps version you are very confident in?

0 Answers  

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

why we can use synonym?

6 Answers  

---

how many sections are there in report?

1 Answers  

---

The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---