Sairam Nimmagadda

Understanding data flow for “Standard Order” 1. Order Entry This is first stage when Order in enter in system. When the order is entered it basically creates a record in order headers and Order Lines table. •oe_order_headers_all (Here the flow_status_code as entered) •oe_order_lines_all (flow_status_code as entered) ( order number is generated) 2. Order Booking This is next stage , when Order which is entered in step 1 is booked and Flow status changed from Entered to Booked.At this stage , these table get affected. •oe_order_headers_all (flow_status_code as booked, booked_flag updated) •oe_order_lines_all (flow_status_code as awaiting shipping, booked_flag updated) •wsh_new_deliveries (status_code OP open) •wsh_delivery_details (released_status ‘R’ ready to release) Same time, Demand interface program runs in background And insert into inventory tables mtl_demand 3. Reservation This step is required for doing reservations SCHEDULE ORDER PROGRAM runs

We have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i. Some places you need to put the custom form (fmb) under $AU_TOP/forms/US. In some places i have seen the form(fmb) under source code directories. Either is the the case, you need to compile the fmb and place the fmx in the appropriate directory Step 1: Login to application server Step 2:  Go to the directory $AU_TOP/forms/US                      --> Place “.fmb” file in binary mode Step3:  Execute the “f60gen” command to generate “.fmx”.  Syntax: f60gen module=.fmb userid=apps/ output_file=.fmx module_type=form batch=no compile_all=special Sample Syntax:  f60gen module=$AU_TOP/forms/US/XXCUSTOM.fmb userid=apps/appspassword output_file=$CUSTOM_TOP/forms/US/XXCUSTOM.fmx module_type=form  batch=no compile_all=special