How to Copy a Sales order from backend

Following is the piece of code to copy a Sales order from backend

declare

        l_return_status               varchar2(1);

        l_order_number_from           number :=XYZ; -- Sample order

        l_order_source_id             number :=1041;

begin

        oe_debug_pub.debug_on;

        oe_debug_pub.initialize;

How to generate a debug file in Order Management

A. To generate a debug file from the Sales Orders form:

1. Set the following profile options:
   OM: Debug Level - set to 5
   OM: Debug Log Directory - any directory that can be written to by the database
   

To check, run the following SQL statement:

Code:

select value from v$parameter where name = 'utl_file_dir'

Oracle apps Order Management (OM) Module Material Download

Oracle apps Order Management (OM) Module is explained in detailed with screen shots. Following setups are included in the download:

• Apply Sales Order Hold Training
• Cancel Sales Order Training
• Change Sales Order Training
• Copy Sales Order Training