Register Custom Applications in Packager
Learn how to register any custom applications that have not been already registered in Packager settings.
- In the Customer Success Services home page, click the menu icon at the upper left corner.
- Under Services, click Customer Self Service.
- In the Customer Self Service page, click CEMLI. (or)
- On the OCSN-Self Service Plaform Dashboard, under Quick Links, click CEMLI.
- On the CEMLI home page, verify that your customer details are displayed.
- Click Manage Custom Products.
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.
- 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.
- 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.
What to do next:
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