Order-to-Cash cycle
Data flow for Order-to-Cash cycle 1. Order Entry This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table. Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table oe_order_headers_all flow_status_code = ENTERED, booked _ flag = N), Primary key=HEADER_ID No record exist in any other table for this order till now. Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID. oe _ order _ lines _ all ( flow_status_code = ENTERED, booked _ flag = N, open _ flag = Y) Primary key= LINE_ID 2.Order Booking This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below ...