Oracle R12 API to insert Default Receiving Subinventory

DECLARE

CURSOR c1
IS
SELECT msi.organization_id,
       msi.inventory_item_id,
       ood.organization_code
FROM mtl_system_items_b msi,
     org_organization_definitions ood
WHERE stock_enabled_flag = 'Y'
AND msi.organization_id = ood.organization_id;

x_return_status varchar2(100);
x_msg_count NUMBER;
x_msg_data varchar2(100);

BEGIN

FOR i in c1
LOOP

            inv_item_sub_default_pkg.insert_upd_item_sub_defaults
                          (x_return_status          => x_return_status,
                           x_msg_count              => x_msg_count,
                           x_msg_data               => x_msg_data,
                           p_organization_id        => i.organization_id,
                           p_inventory_item_id      => i.inventory_item_id,
                           p_subinventory_code      => i.organization_code,
                           --shipping_subinv2,
                           p_default_type           => 2,
                           p_creation_date          => SYSDATE,
                           p_created_by             => -1,
                           p_last_update_date       => SYSDATE,
                           p_last_updated_by        => -1,
                           p_process_code           => 'INSERT',
                           p_commit                 => 'Y'
                          );
                         
END LOOP;                         
                         
                          COMMIT;
                         
      DBMS_OUTPUT.PUT_LINE(x_msg_data);                   
                         
END;

R12 Form Compile and FNDLOAD commands

Set environment variable before running commands. The environment variable needs to set from appl top.

FNDLOAD commands to move objects:

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct /d01/bkptest/apps/apps_st/appl/xx_top/12.0.0/reports/US/XX_SALES_ORDER.ldt PROGRAM APPLICATION_SHORT_NAME="XX_TOP" CONCURRENT_PROGRAM_NAME="XX_SALES_ORDER"

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_SALES_ORDER.ldt

Command to compile pll:

frmcmp_batch module=WIPTXSFM.pll userid=apps/apps output_file=WIPTXSFM.plx module_type=LIBRARY batch=yes compile_all=special

Command to compile form:

frmcmp_batch userid=apps/app321 module=WIPTXSFM.fmb output_file=/test/apps/apps_st/appl/wip/12.0.0/forms/US/WIPTXSFM.fmx module_type=form batch=no compile_all=special

List objects on Run of Application in APEX

Objective:

                On clicking Run button of Application, the home page will run. In order to list the objects within the application, we can create a list and attach the list to region.

When we click on Run in application, then the home page will run as shown below.

Creating List:

Click on Edit page. Right click on Lists and click on Create.

Click on next in following screen.

Enter the name of List in following screen.

Enter the List Entry Label, for ex., name of the object and give the page number that it refers to in the Target Page ID or custom URL.

Then click on Create List in following screen.

Adding list to Region:

Right click on Region and click Create.

Choose the Region type as List.

Enter the title of Region in following screen.

Select the List from the List LOV.

Then click on Create Region. We can see that Region and List got created in following screen.

When we click on Run in Application, then the following screen will appear showing the list of objects.