CHAPTER 2: Oracle Apps Order to cash(O2C) Cycle

CHAPTER 2: Oracle Apps Order to cash(O2C) Cycle:--

Pick Release


------------------


here pick release is the process of picking items from our ware house(inventory) and releasing items for shipping to destination inventory


organization(customer ship to location).


In other words Pick Release is the process in which the items on the sales order are taken out from inventory.


navigation:


-------------


Order management > shipping> Release sales orders>Release sales orders





Based on rule field - enter as= standard


order -- enter the sales order number.


press tab.


Go to shipping tab --make the below 3 flags yes


Auto create delivery--yes


Auto pack delivery-- yes


Auto pick confirm – yes


(create-pack-pick delivery)





Go to Inventory tab --choose the warehouse


Click on save or execute (in the office we need to click on concurrent), you


Will get auto pack report, pick slip report AND shipping exceptions report in SRS(view->request)


-----------------


1.auto pack report


2.pick slip report


3.shipping exceptions report


1.auto pack report:--


----------------


it will display packing instructions and error messages related to packing.


2.pick slip report:--


------------


it will give the warehouse name,delivery number,sub inventory , quantity and , uom.


3.shipping exceptions report:--


------------------------


it will give the error message related packing


example: the packing operation completed with errors.


1-- delivery line had error


0-- lines had warning and only '0' lines were packed successfully.





select released_status,DELIVERY_DETAIL_ID from wsh_delivery_details


where source_header_id='94619'


here y-- means pick release happened


(earlier it was 'R')-ready to release


select * from wsh_delivery_assignments


where delivery_detail_id='2351590'--From above query, get the delivery_id value
-- copy delivery_id value .


select status_code


from wsh_new_deliveries


where delivery_id='80881'
--status_code='OP'
--Here op means open


Ex: during entering and booking sales order-- So= 69503, status=entered


select * from oe_order_headers_all where order_number='69503';--Always use apps.oe_order_headers_all when running the code in production instance.





select * from oe_order_lines_all where header_id='399784';


select * from wsh_delivery_assignments where delivery_detail_id='6257051';


select status_code from wsh_new_deliveries where delivery_id='6271831';


Shipping:--


---------


At this step we will deliver all the goods to the customer location.


navigation:---


----------


Order management>shipping-->transactions-->enter the order number(give same so number in from order number field and to order number field).


-->click on find-->go to delivery tab-->click on ship confirm button-->ok


it will display the message "delivery was successfully confirmed"


back end tables and flag changes details:--


-------------------------------------------


select released_status,DELIVERY_DETAIL_ID from wsh_delivery_details


where source_header_id='94619'; (source_header_id means header_id)


-- C-- means Shipped


--(earlier it was 'Y')


select * from wsh_new_deliveries where delivery_id='80881';


--status_code='CL'


--Here CL means closed





select flow_status_Code from oe_order_lines_all where header_id='94619';

-- flow_status_Code=shipped,earlier it was awaiting shipping.


At this stage we can see the following concurrent programs(srs):--


1.Bill of Lading


2.Packing Slip Report


3.Commercial Invoice


4.Vehicle Load Sheet Details


5.Interface Trip Stop—main program


1. Bill of Lading:--


--------------------


This report will give the details like


Shipper/Exporter, Consignee name, address (Name, Full Address) Seller Licenses and Full Address) F.M.C. No.)


Here consignee means customer,shipping instructions ,and items weight,courier method.


2. Packing Slip Report:--


------------------------


This report will display the details like


from address and to address,how many items that package contains and what is it total weight, expected pickup date.


3. Commercial Invoice:--


----------------------------


It is simply acknowledgement of items. we need to give the signature in it.


4. Vehicle Load Sheet Details:--


------------------------


It will display the details like vehicle type, Planned Arrival Date, Planned Departure Date ,Gross Weight, Delivery Status








5. Interface trip stops:--


--------------------


Interface Trip Stop is one of the main interface programs which can be triggered at the time of ship confirm or later as Interface Trip stop - SRS concurrent request.


Interface trip stop has two parts and it updates the Two interface tables:--


1. Order Management Interface (First part)


2. Inventory Interface (Second part)


Order Management Interface part update the order management tables like OE_ORDER_LINES_All.


(Update Shipped_Quantity, Shipping_Quantity, Actual_Shipment_Date) and WSH_DELIVERY_DETAILS (make Released_status, OE_INTERFACED_FLAG = ‘Y’) table.


The Inv_Interfaced_Flag remains = X (Pending) or N which will changes to Y after execution of second part.


Only when the value of OE_INTERFACED_FLAG = "Y" will the second portion, which is the Inventory Interface, be activated; otherwise, it won't.


These lines will not be chosen for processing, regardless of whether you attempt to execute this from SRS.Data related to the inventory interface is moved from MTL_TRANSACTIONS_INTERFACE to MTL_MATERIAL_TRANACTIONS, and Sales Order Issue transactions are modified in MTL_MATERIAL_TRANACTIONS.Additionally, information is removed from WSH_NEW_DELIVERIES, MTL_RESERVATIONS, and MTL_DEMAND.


Quantity of items decreased from MTL_ONHAND_QUANTITIES, and accounting data is updated in MTL_TRANSACTION_ACCOUNTS.


Link between sales order and customer details:--


SELECT hp.party_name customer_name, hca.account_number customer_number,


ooh.order_number,salesrep_id


FROM hz_parties hp,


hz_cust_accounts hca,


oe_order_headers_all ooh


WHERE hp.party_id = hca.party_id AND ooh.sold_to_org_id = hca.cust_account_id


and ooh.order_number ='69338';


NOTE:party name= Customer name


How to display sales representative name :--


select ooh.order_number,jrs.name


from JTF_RS_SALESREPS jrs,


oe_order_headers_all ooh


where jrs.SALESREP_ID=ooh.SALESREP_ID


and ooh.order_number='69334';