Go: Process for Oracle EBS orders (Order->ar)

Directory (?) [-]

1. Basic process
2. Create an Order
3. Pick Release
1. Pick Confirm
4. Ship Confirm Deliveries
5. Interface Trip Stop-srs
6. Workflow background Process
7. AutoInvoice
8. Closing the Order
9. Ordershipping Transactions Status Summary

Basic process

Create an Order

Path: Order Management > Orders,returns > Sales Orders

Fill in the order header information, customer, order type, sales person

Fill in the Order body information, enter the material, quantity ...

Then book order, after the order book, you will find that the status of the order header becomes "booked", the status of the order line is "awaiting Shipping", record your order number, This order number is required for each step behind.

status : After the order book, this time the dispatch is also produced, if you go to shipping transactions form, find the order, you will find that the line status of the shipping order to Release,next Step for pick Release

Pick Release

Path: Order Management > Shipping > Release Sales orders > Release Sales orders

Pick release is commonly known as the pick-up library (that is, the selection of goods from the warehouse). Enter the order number for the selected library in order No.

Auto Pick confirm set to No

Auto allocate set to n

Auto allocate and Auto Pick confirm can be set to Yes, but in order to speak more detailed, here are set to No, set to Yes, then the back of the allocate and Pick confirm two steps, the system will automatically help you complete.

There are two buttons to perform pick release, "Concurrent" is pick release task sent to Concurrent request to execute, "execute Now" is the system to execute pick release in the previous paragraph, The control is not returned to user until the end of execution, where we click the Concurrent button.

Pick release backstage What's going on? Pick release creates a Pick wave type move order, which is used to move goods in stock to a temporary shipping area (Staging), and if you open the Inv log you can see that the system is called Inv_move_order_ PUB. Create_move_order_header to create a MOVE order. (for the background process of Pick release, see my summary: Pick release process)

Also mentioned is that after pick release, the system will generate a reservation (reservation) for your order, this time the reservation is called soft reservations, because there is no clear from which library shipped, so the org level to create a reservation for the item.

status : At this time, Shipping transaction's line status is "released to Warehouse" and Next step is "Transact Move order" , the status of the order header is still booked, and the line status is still "awaiting Shipping".

Pick Confirm

The action of Pick Confirm (pick library confirmation) is actually done in Transact move order, allocate pick the goods first, then Transact Move order.

Path: Inventory > Move orders > Transact move Orders

Query the page, Pick wave that tab, enter the order number

After entering the TMO main interface, click Allocate,allocate will select the goods according to your system default picking rule, then give you a suggestion pick-up item, suggestion record will be saved in Mtl_material_ Transactions_temp table (i.e. pending transactions).

In addition to completing the allocate, you will see the interface allocation item will appear single,multiple or none of the logo, single, the system gives you a suggestion transaction record, Multiple indicates that more than one is produced; none means that no suggestion records have been generated (most likely due to insufficient inventory in your system)

The next step is to transact this move Order

After pressing Transact, Inventory Transaction Manager handles suggestion transactions (MMTT), and then the movement of the material is true. The material is from the official subinventory to the temporary inventory area (Staging). This transction can be queried from the form of the material transaction.

In addition, for reservation, after transact, because the inventory is clear, reservation will become more clear, which sub,locator to make reservations.

status : At this time, Shipping transaction's line status is "Staged/pick confirmed" and Next step is "ship Confirm/close trip Stop" , the status of the order header is still booked, and the line status changes to "Picked".

Ship Confirm Deliveries

Path: Order Management > Shipping > Transactions

Switch to Delivery tab, prepare ship Confirm (delivery confirmation), if you do not select Autocreate Delivery when pick release, then the system will check define Shipping Parameters inside these two settings, if shipping parameters inside also have no choice, then you need to manually in the ship confirm when the action->auto-create deliveries.

Delivery information actually contains where you want to deliver the goods, which logistics company to use ....

Delivery tab, click the Ship Confirm button will pop up a window, "Defer Interface" if it is ticked on, stating that you want to manually run Interface trip Stop SRS, we hook up Defer Interface, click OK.

Delivery was successfully confirmed!!!

Ship confirm this action inserts a record into the Mtl_transactions_interface table, the type of the MTI record is Sales order Issue, and this record is processed by the next interface trip stop. The final transfer from MTI to the MMT table.

status : At this time, Shipping transaction's line status is "Shipped", Next step is "Run Interfaces", the status of the order header is still booked, the row status becomes " Shipped ".

Interface Trip Stop-srs

Because we set the defer Interface in the ship confirm, we also need to run Interface trip Stop-srs manually.

Path: Order Management > Shipping > Interface > Run > Request:interface trip Stop-srs

Interface trip Stop actually contains two parts: Order Management Interface SRS (update run status, ready to generate AR Invoice) and Inventory Interface SRS (Generate Inventory shipments transaction)

The Order Management Interface-srs is run before the inventory Interface SRS, and this request updates the run status to prepare for the AR invoice, and the OM Interface will be updated after the run is completed Wsh_ The Oe_interfaced_flag of the Delivery_details table is Y.

Inventory Interface SRS inserts records into MTI based on shipping transaction, and the Inv Manager will transfer this MTI record to the MMT table, a sales Order Issue's transaction record is generated, and the reduction of the inventory quantity and the deletion of reservation are completed. After the Inventory Interface SRS finishes running, the Inv_interfaced_flag field of the Wsh_delivery_details table is updated to Y.

status : At this time, Shipping transaction's line status is "interfaced", Next step is "not applicable", the status of the order header is still booked, the row status becomes " Shipped ".

For its, you can also refer to my other article: http://blog.csdn.net/pan_tian/article/details/8624936

Workflow background Process

Path: Inventory > Workflow Background Engine

Item Type:om Order Line

Process Deferred:yes

Process Timeout:no

After the program is run by the Workflow,workflow Background process that handles the deffered state, the relevant data is imported from the order table into the RA INTERFACE table (ra_interface_ Lines_all,ra_interface_salescredits_all,ra_interface_distribution)

You can view the RA interface information by using the SQL below:

1.SELECT * from Ra_interface_lines_all WHERE sales_order = ' 65961 ';

2.SELECT * from Ra_interface_salescredits_all

where interface_line_id in (SELECT interface_line_id from ra_interface_lines_all WHERE sales_order = ' 65961 ');

3.SELECT * from Ra_interface_distributions_all

where interface_line_id in (SELECT interface_line_id from ra_interface_lines_all WHERE sales_order = ' 65961 ');

After the data has been inserted into the RA INTERFACE, the Oe_order_lines_all invoice_interface_status_code field becomes the number of the order line that yes,invoiced_quantity becomes. And you will find that the order line status becomes closed, and the status of the order header is still booked.

AutoInvoice

Used to generate AR invoices

Path: Account receivable > Interface > AutoInvoice

Name:autoinvoice Master Program

Invoice Source:order Entry

Default Day: Current date

After submission, you can see the "AutoInvoice Import program" running in the request.

From, you can see that the Auto Invoice program is used to process the interface table of RA, and then generate real revenue invoice information, and the final data is inserted into the AR formal table (ra_customer_trx_all,ra_customer_trx_ Lines,ar_payment_schedules).

You can see the invoice information in order > Action > Additional information > Invoices/credit memos, or you can view the order and AR information through the SQL below.

SELECT Ooha.order_number, Oola.line_number so_line_number, Oola.ordered_item, oola.ordered_quantity * oola.unit_ Selling_price So_extended_price, Rcta.trx_number invoice_number, Rcta.trx_date, Rctla.line_number Inv_line_number, RC Tla.unit_selling_price Inv_unit_selling_price from Oe_order_headers_all Ooha, Oe_order_lines_all Oola, Ra_customer_ Trx_all rcta, Ra_customer_trx_lines_all rctla where ooha.header_id = oola.header_id and rcta.customer_trx_id = Rctla.cust omer_trx_id and Rctla.interface_line_attribute6 = To_char (oola.line_id) and rctla.interface_line_attribute1 = TO_CHAR ( Ooha.order_number) and order_number =:p _order_number;

If the AutoInvoice Import program has an error, you can view the Ra_interface_errors_all table Message_text field to get the wrong information.

Closing the Order

The order closure is automatic, and 0.5 days after all line workflow finishes (Close or cancel), the order header will also be closed under the impetus of workflow Background process.

There is another way of saying: You can wait until Month-end and the "Order flow–generic" workflow will close it for you.

order&shipping transactions Status Summary Line

Step	Order Header Status	Order Line Status	Order Flow Workflow Status (order Header)	Flow Workflow Status (Order line)	Shipping Transaction Status (released_status in WDD)
1. Enter an Order	Entered	Entered	Book Order Manual	Enter–line	N/A
2. Book The Order	Booked	Awaiting Shipping	Close Order	Schedule->create Supply->ship–line	Ready to Release (R)
3. Pick the Order	Booked	Picked	Close Order	Ship–line	1.Released to Warehouse (S) (Pick Release and not Pick confirm) 2.staged/pick confirmed (Y) (after Pick confirm)
4. Ship the Order	Booked	Shipped	Close Order	Fulfill–deferred	1.Shipped (after ship confirm) 2.Interfaced (C) (after its)
	Booked	Closed	Close Order	Fulfill->invoice Interface->close Line-End
5. Close the Order	Closed	Closed	End	End

For orders, shipping TXN status, see another article: http://blog.csdn.net/pan_tian/article/details/7696528

========update on 2015-07-14===========

Oracle Order Management Flow (Source Link)

Reprint Please specify source: http://blog.csdn.net/pan_tian/article/details/7693447

======eof======

Go: Process for Oracle EBS orders (Order->ar)