Purchase Order

Creation Of Item

Create an Item and assign that to both the source and destination organization

Attributes

• Purchased
• Purchasable
• Internal Order Enabled
• Shippable
• OE transactable

Creation of Internal Requisition

Now go ahead and create and Internal Requisition

Go to Purchasing Responsibility

Requisitions -> Requisitions

Note: You should have been defined as an employee/ buyer to create a requisition

1. Type should be Internal Requisition
2. Enter the item in Lines Tab
3. Enter Quantity
4. Enter Need By Date
5. Select the Destination Organization
6. Destination Location
7. Select Source Organization

Click on Save, It will generate the Requisition Number. Note down the requisition number
Now need to Approve the Requisition
If you want to approve this requisition, then you should have required approval authority.
Lets do the required setup
Go to Human Resources (if Installed) responsibility
People -> Enter and Maintain

else in purchasing
Go to Setup -> Personnel -> Employees
Find the employee (if not created already, select new and create one)

Select Assignment

Here assign a Job

Now lets go and check whether this Job has Requisition Approval authority or not

For this, navigate to Purchasing responsibility

Setup -> Approvals ->Approval Assignments

In this form, select the Job which you have assigned to the employee

Now you can see which all document types are authorized to approve

Make sure Approve Internal Requisitions is entered here

If you can’t see this, then add the value

Make sure the Approval Group which you are assigning here that has the approval limit authorization with in which your IR amount comes

As in this case

Here the limit is max $50,000 and our IR amount is only $100

Now Go back to the requisition and approve the same

Query the requisition and click on the approve button

Make sure Submit for Approval selected (it should be by default) then click on OK

Wait for few min as the background process will check and clear the Approval workflow

And re-query the IR again

If Workflow Background Process not scheduled, you can go ahead and manually submit

Now again requery the IR from requisition summary form

You will see the IR is approved

Creation of Internal Order

Next step is to Run the Create Internal Order concurrent program which will interface the data to Order management for creating internal order

Go to View -> Requests -> Submit a new request -> Single Request

Select Create Internal Orders and submit

Once the program is completed, check the log file,

It means the data transferred to Order Entry

Now lets go to Order Management and import the data to create the Internal Order

Navigate to Order Management responsibility

Go to Orders, Returns -> Import Orders -> Order Import Requests

Now enter the below parameters

1. Source as Internal
2. Select your IR number in Order Reference field

Then Click Ok and Submit.

This will spawn another child order import program

Now go ahead and query your Internal order which is just created by importing the data in order organizer form

Orders, Returns -> Order Organizer

Give today’s date to refine

Select the source as Internal and give the IR number in the Order Source Reference

Now Click on Open.

Your internal order is ready

Order to Cash Tables and Data Flow

--ORDER MAIN TABLES
select flow_status_code, booked_flag, a.* from oe_order_headers_all a where order_number = '4025794';
select flow_status_code, a.* from oe_order_lines_all a where header_id = 795291;
select * from oe_price_adjustments where header_id = 795291 and line_id = 2440080;
select * from oe_order_price_attribs where header_id = 795291 and line_id = 2440080;
select * from oe_order_holds_all where header_id = 795291 and line_id = 2440080;

--DELIVERY TABLES
select * from wsh_delivery_details where source_header_id = 795291 and source_line_id = 2440080;
select * from wsh_delivery_assignments where delivery_detail_id = 4537129;

--PICK RELEASE (from SHIPPING tab)
--Concurrent Program "Pick Selection List Generation" kicks off after releasing order from SHIPPING.
--This in turn kicks off "Pick Slip Report" and "Auto Ship Confirm Report (Auto Ship Confirm Report)"
select * from wsh_new_deliveries where delivery_id = 653581;
select * from wsh_picking_batches where name = '653581';
select * from wsh_serial_numbers where delivery_detail_id = 4537129;

--MOVE ORDER
select * from mtl_txn_request_headers where request_number = '689455';
select * from mtl_txn_request_lines where header_id = 690521;

--SHIP CONFIRM
--Shipping Transaction for after entering serial numbers.
--Kicks off "Interface Trip Stop" very imp program that affects Inventory.
select * from mtl_material_transactions where source_code = 'ORDER ENTRY' and transaction_reference = 795291 and trx_source_line_id = 2440080;
select * from mtl_unit_transactions where inventory_item_id = 379603 and serial_number in ('SUMIT00','SUMIT01'); 
select * from mtl_serial_numbers where inventory_item_id = 379603 and upper(serial_number) in ('SUMIT00','SUMIT01');

--Run "Workflow Background Process" for "OM Order Line" 
select * from ra_interface_lines_all where interface_line_context = 'ORDER ENTRY' and interface_line_attribute1 = '4025794';
select * from ra_interface_salescredits_all where interface_line_context = 'ORDER ENTRY' and interface_line_attribute1 = '4025794';
select * from ra_interface_distributions_all where interface_line_context = 'ORDER ENTRY' and interface_line_attribute1 = '4025794';

--Run "Auto Invoice Master Program" and that will kick "Auto Invoice Import" program that will create invoice for the order
-- "Prepayment Matching Program (Prepayments Matching Program)"
select * from ra_customer_trx_all where interface_header_attribute1 = '4025794' and creation_date >= trunc(sysdate);
select * from ra_customer_trx_lines_all where interface_line_attribute1 = '4025794' and creation_date >= trunc(sysdate);
select * from ra_cust_trx_line_salesreps_all where customer_trx_line_id = 5758780;
select * from ra_cust_trx_line_gl_dist_all where customer_trx_line_id = 5758780;
select * from ar_payment_schedules_all where trx_number = '50133102';

--Receipt against invoice
select * from ar_cash_receipts_all where receipt_number like '12345%' and creation_date >= trunc(sysdate);
select * from ar_receivable_applications where cash_receipt_id in (130168,130169);

--Run "General Ledge Transfer Program" 
--This kicks off "Revenue Recognition" and "Revenue Contingency Analyzer" and "Update Posting Control" program 
select * from gl_interface where date_created >= '10-JUN-2011' and user_je_category_name = 'Sales Invoices' and user_je_source_name = 'Receivables'
and reference10 like '%50133102%' and reference24 = '50133102' and reference23 = '42596305';

--Run "Journal Import" 
select * from gl_je_batches where creation_date >= '13-JUN-2011' order by je_batch_id desc;
select * from gl_je_headers where je_source = 'Receivables' and je_category = 'Sales Invoices' and je_batch_id = 1592931;
select * from gl_je_lines where je_header_id = 1750124;

--Post Journals "Posting"
select * from gl_balances where last_update_date >= '13-JUN-2011' ;