ORACLE OM Technical

Order Management

Create Order, Order Line and Book Order.html
Order Management tables and details

Sales Order -> Actions -> Preview & Print

How to Customize Preview and Print / Sales Order Acknowledgement

Custom Template on Sales Order Form -- Actions > Preview and Print

Add more fields in ONTORDDFN.xsd

How to Modify Seeded Order Managment XML Template/Data Definition Source (Doc ID 341206.1)

Example of How To Modify 'Print & Preview' Document (Doc ID 1451634.1)

SQL Query and Information about Sales Order Line Number

Sales Order Line Numbers

What is ship_to_org_id and ship_from_org_id in Oracle Order Management.

 

Queries

Query to get customer site contact details - R12

Query To Fetch Customer Account/Site Contact Details in R12

Links between HZ module and other ERP Modules (CSI,IB &OM )

sql-query-to-get-customer-details

Hold Query in SO

Sales Order Hold Information Queries

Query relating Delivery legs and its Trips ( R12 )

Useful Order Management Queries

Onhand Quantity Query with Api
query for item onhand quantity & Lot wise query

Move Order Process

Move Orders

Partial Shipments of a Sales Order Using API

Pick Release Sale Order API

PERFORMING PICK RELEASE USING WSH_DELIVERY_PUB API
 

Item Allocation and Transact Move

Oracle Apps R12 Transact Move Order in Inventory API

Query providing Order,Delivery and its Move Order information (R12)

 

Useful queries code scripts in order

 

ORDER TO CASH PROCESS

Order to Cash - Technical Flow in R12

Order To Cash Life cycle with Table Details

Sales Orders Workbench
MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2
OM Order Processing

Release Sales Order

Assign Delivery Detail to delivery

Releasing Sales Orders for Picking

Update Shipping Attributes

 Script to Update Shipping Attributes in wsh_delivery_details

Ship Confirmation API

Ship Confirm through API

API – SHIP CONFIRM OF THE DELIVERIES

Oracle API Script for Ship Confirm Process in Oracle Management

Oracle Applications: Oracle API Script for Ship Confirm Process in Order Management

Ship Confirm using WSH_DELIVERIES_PUB.Delivery_Action
PERFORMING SHIPPING TRANSACTION USING WSH_DELIVERY_PUB API
API wsh_deliveries_pub.delivery_action
Bulk Shipment Confirmation Development wsh_deliveries_pub.delivery_action
Order Management Package

 

Partial Ship Confirmation

PARTIAL SHIPMENTS OF A SALES ORDER USING API

Unable to Split so Line During Pick Confirm Through Api Call (Doc ID 739159.1)

Sales Order line split in 2 delivery lines within 1 delivery (R12)

Split Delivery Detail API

Auto Splitting of Sales Order in R12

Partial Shipments of a Sales Order Using API

Oracle API script for Ship Confirm

 Trip Stop API

Query relating Delivery legs and its Trips ( R12 )

Trip Id, Delivery ID, Sales Order

 

Interface Trip Stop Functionality,Interface trip stop program Technical details , ITS program

Trying to complete a Shipment when the line status is Interfaced

Interface Trip Stop STS

Interface Trip Stop Process

Partial Shipments of a Sales Order Using API
Interface Trip Stop

Auto Invoice Program

Sample PLSQL Script to call Autoinvoice Import Program RAXTRX using fnd_request.submit_request

Sales Order Type Name in Oracle Apps 11i and 12i