Registering Custom Applications in Packager

Learn how to register any custom applications that have not been already registered in Packager settings.

To register custom applications:

  1. On the CEMLI home page, verify that your customer details are displayed.

  2. Click Packager.

    The Upload Customized Files tab is displayed by default.

    Note

    You must register only custom applications that are not already registered in Packager. Please only register custom applications that have Oracle Automated CEMLI Execution setup completed in your E-Business Suite environment.

    If a custom application is displayed in the Packager | Existing Products area, you do not need to register it again.

  3. Click Manage Custom Products.

  4. In the Register New Product area, enter the following information:

    • Product Name: Specifies the short name of the custom application, in lower case with no spaces.

    • Application Id: Specifies the ID for the application. Use a query to retrieve this value from the APPSFND_APPLICATION_VL view. See Sample Query.

    • Description: Provide a free-text description of the custom application.

    • DB Schema: Specifies the name of the database schema associated with the custom product.

    Note

    You will not be able to modify this information once it is saved.
  5. Click Create.

    The page is refreshed, displaying the custom application name and details in the Product List area, as follows:

    • Application Id: Specifies the ID for the application.

    • Name: Specifies the short name of the custom application, in lower case with no spaces.

    • Description: Provides a free-text description of the custom application. The information in this field can be edited and saved.

    • Active: Specifies whether the custom product is active or not. The information in this field can be edited and saved.

    • Schema: Specifies the name of the database schema associated with the custom product. The information in this field can be edited and saved.

    • Created By: Specifies the email address of the user who registered the product.

    • Created On: Specifies the date when the product was registered.

Sample Query:

The following query retrieves custom application information from the Oracle E-Business Suite database (DB):

select app.application_short_name, prod.application_id
from fnd_product_installations prod,
      fnd_application app
where app.application_id>20000
and app.application_id= prod.application_id

Where:

app.application_short_name is the short name of the application

prod.application_id is the production application ID

This example shows a typical output from this query:

APPLICATION_SHORT_NAME         APPLICATION ID  ORACLE_ID  PRODUCTION_VERSION
----------------------         --------------  ---------  ------------------
XBOL                           20003           0          11.5.0