Cloud O2C – Oracle Cloud Order to Cash (O2C) Cycle Process with Technical Flow

The Order to Cash cycle comprises of the following steps,

01. Create Sales Order

02. Create Pick wave

03. Create Pick Confirm

04. Create Ship Confirm

05. Transfer to Receivables

06. Verify the Transaction

07. Create Receipt and Apply the transaction

08. Transfer Invoice to General Ledger

09. Transfer Receipt data to General Ledger

10. Verify the Journal Batches

 

Step 1: Create Sales Order

Nav: Order Management àOrder Management

Click on the Create Order button or Tasks àCreate Order

 Enter the customer details and Click on Save 

Once save it order number will generate and Order status is Draft

 

Below is the Query:
SELECT

 h.org_id

,hou.name BU_NAME

,h.header_id

,h.order_number

,hp.party_name Cust_name

,hca.account_number Cust_Acct

,h.sold_to_contact_id Contact

,h.ordered_date

,h.customer_po_number PO_NUM

,h.order_type_code

,h.status_code Heder_Status

,h.open_flag

,h.canceled_flag

,h.sold_to_customer_id

,h.transactional_currency_code CURR

,h.source_order_number src_order_num

,h.source_order_system src_order_sys

,h.source_revision_number src_rev_num

,h.orig_sys_document_ref src_order_ref

,bill_hp.party_name Bill_To_Cust

,bill_add.cust_acct_site_use_id Bill_site_use_id

,bill_hl.Address1||' '||bill_hl.Address2||' '||bill_hl.city||' '||bill_hl.county||' '||NVL(bill_hl.STATE,bill_hl.PROVINCE)||' '||bill_hl.Postal_code||' '||bill_hl.COUNTRY  Bill_TO_Addr

,ship_hp.party_name ship_To_Cust

,ship_add.cust_acct_site_use_id ship_site_use_id

,ship_hl.Address1||' '||ship_hl.Address2||' '||ship_hl.city||' '||ship_hl.county||' '||NVL(ship_hl.STATE,ship_hl.PROVINCE)||' '||ship_hl.Postal_code||' '||ship_hl.COUNTRY  ship_TO_Addr

from

 fusion.doo_headers_all_v h

,fusion.hr_operating_units hou

,fusion.hz_parties hp

,fusion.hz_cust_accounts hca

,fusion.doo_order_addresses_v bill_add

,fusion.hz_cust_accounts bill_hca

,fusion.hz_parties bill_hp

,fusion.hz_cust_site_uses_all bill_hcsu

,fusion.hz_cust_acct_sites_all bill_hcas

,fusion.hz_party_sites bill_hps

,fusion.hz_locations bill_hl

,fusion.doo_order_addresses_v ship_add

,fusion.hz_cust_accounts ship_hca

,fusion.hz_parties ship_hp

-- ,fusion.hz_cust_site_uses_all ship_hcsu

-- ,fusion.hz_cust_acct_sites_all ship_hcas

,fusion.hz_party_sites ship_hps

,fusion.hz_locations ship_hl

where 1=1

and hou.organization_id = h.org_id

and hp.party_id (+)= h.sold_to_Party_id

and hca.party_id (+) = h.sold_to_Party_id

and bill_add.address_use_type = 'BILL_TO'

AND H.header_id = bill_add.header_id (+)

and bill_add.cust_acct_id = bill_hca.cust_account_id (+)

AND bill_hca.party_id = bill_hp.party_id (+)

AND bill_add.cust_acct_site_use_id = bill_hcsu.site_use_id (+)

AND bill_hcsu.cust_acct_site_id = bill_hcas.cust_acct_site_id (+)

AND bill_hcas.party_site_id = bill_hps.party_site_id (+)

AND bill_hps.location_id = bill_hl.location_id (+)

and ship_add.address_use_type = 'SHIP_TO'

AND H.header_id = ship_add.header_id (+)

and ship_add.cust_acct_id = ship_hca.cust_account_id (+)

AND ship_hca.party_id = ship_hp.party_id (+)

-- AND ship_add.cust_acct_site_use_id = ship_hcsu.site_use_id (+)

-- AND ship_hcsu.cust_acct_site_id = ship_hcas.cust_acct_site_id (+)

-- AND ship_hcas.party_site_id = ship_hps.party_site_id (+)

AND ship_add.party_site_id = ship_hps.party_site_id (+)

AND ship_hps.location_id = ship_hl.location_ID (+)

and h.order_number = '98430'

 

 In Order Lines, search with item number

 Select the Item number and click on ok button

Item details will show, click on the Add button to add the line to order

 Once the line is added, the line status will be Open

SELECT

 h.org_id

,hou.name BU_NAME

,h.header_id

,h.order_number

,hp.party_name Cust_name

,hca.account_number Cust_Acct

,h.sold_to_contact_id Contact

,h.ordered_date

,h.customer_po_number PO_NUM

,h.order_type_code

,h.status_code Heder_Status

,h.open_flag

,h.canceled_flag order_canc_flag

,h.sold_to_customer_id

,h.transactional_currency_code CURR

,h.source_order_number src_order_num

,h.source_order_system src_order_sys

,h.source_revision_number src_rev_num

,h.orig_sys_document_ref src_order_ref

,bill_hp.party_name Bill_To_Cust

,bill_add.cust_acct_site_use_id Bill_site_use_id

,bill_hl.Address1||' '||bill_hl.Address2||' '||bill_hl.city||' '||bill_hl.county||' '||NVL(bill_hl.STATE,bill_hl.PROVINCE)||' '||bill_hl.Postal_code||' '||bill_hl.COUNTRY  Bill_TO_Addr

,ship_hp.party_name ship_To_Cust

,ship_add.cust_acct_site_use_id ship_site_use_id

,ship_hl.Address1||' '||ship_hl.Address2||' '||ship_hl.city||' '||ship_hl.county||' '||NVL(ship_hl.STATE,ship_hl.PROVINCE)||' '||ship_hl.Postal_code||' '||ship_hl.COUNTRY  ship_TO_Addr

,l.display_line_number

,l.line_id

,l.line_number

,l.source_line_number src_line_num

,l.inventory_item_id

,esi.item_number item_num

,l.inventory_organization_id inv_org_id

,l.ordered_qty

,l.Unit_list_Price

,l.canceled_flag line_canc_flag

,l.canceled_qty

,l.shipped_qty

,l.ordered_uom

,l.Unit_Selling_Price

,l.extended_amount

,l.line_type_code

,l.status_code line_status

,fl.request_ship_date

,fl.schedule_ship_date

,fl.promise_ship_date

,fl.customer_po_line_number

from

 fusion.doo_headers_all_v h

,fusion.hr_operating_units hou

,fusion.hz_parties hp

,fusion.hz_cust_accounts hca

,fusion.doo_order_addresses_v bill_add

,fusion.hz_cust_accounts bill_hca

,fusion.hz_parties bill_hp

,fusion.hz_cust_site_uses_all bill_hcsu

,fusion.hz_cust_acct_sites_all bill_hcas

,fusion.hz_party_sites bill_hps

,fusion.hz_locations bill_hl

,fusion.doo_order_addresses_v ship_add

,fusion.hz_cust_accounts ship_hca

,fusion.hz_parties ship_hp

-- ,fusion.hz_cust_site_uses_all ship_hcsu

-- ,fusion.hz_cust_acct_sites_all ship_hcas

,fusion.hz_party_sites ship_hps

,fusion.hz_locations ship_hl

,fusion.doo_lines_all_v l

,fusion.doo_fulfill_lines_all fl

,fusion.egp_system_items esi

where 1=1

and hou.organization_id = h.org_id

and hp.party_id (+)= h.sold_to_Party_id

and hca.party_id (+) = h.sold_to_Party_id

and bill_add.address_use_type = 'BILL_TO'

AND H.header_id = bill_add.header_id (+)

and bill_add.cust_acct_id = bill_hca.cust_account_id (+)

AND bill_hca.party_id = bill_hp.party_id (+)

AND bill_add.cust_acct_site_use_id = bill_hcsu.site_use_id (+)

AND bill_hcsu.cust_acct_site_id = bill_hcas.cust_acct_site_id (+)

AND bill_hcas.party_site_id = bill_hps.party_site_id (+)

AND bill_hps.location_id = bill_hl.location_id (+)

and ship_add.address_use_type = 'SHIP_TO'

AND H.header_id = ship_add.header_id (+)

and ship_add.cust_acct_id = ship_hca.cust_account_id (+)

AND ship_hca.party_id = ship_hp.party_id (+)

-- AND ship_add.cust_acct_site_use_id = ship_hcsu.site_use_id (+)

-- AND ship_hcsu.cust_acct_site_id = ship_hcas.cust_acct_site_id (+)

-- AND ship_hcas.party_site_id = ship_hps.party_site_id (+)

AND ship_add.party_site_id = ship_hps.party_site_id (+)

AND ship_hps.location_id = ship_hl.location_ID (+)

and h.header_id = l.header_id (+)

AND l.line_id = fl.line_id (+)

and esi.inventory_item_id = l.inventory_item_id

and esi.organization_id = l.inventory_organization_id

and h.order_number = '98430'

 

Please click on the below link for more details:

Cloud O2C – Oracle Cloud Order to Cash (O2C) Cycle Process with Technical Flow
https://drive.google.com/file/d/11ClavaFtmyl3e5QwCAeKKUWJXZqP1ECZ



Join the https://t.me/OracleApps88 group or message me at @apps88 (https://t.me/apps88) or (+91) 9059574321 in Telegram, to get more information on Oracle EBS R12/Cloud (Fusion) applications.