UPK can capture a Context-ID’s for the Oracle objects from the E-Business Suite during the recording phase. Think of a Context-ID as a unique identifier for a particular page or function in the Oracle E-Business Suite. You can integrate UPK with the EBS Help Menu and when the user clicks on the help menu, the user will be directed to the respective action for that particular function or page by looking up the Context-ID.
If you want to implement context-sensitive Help for Oracle E-Business Suite applications, the correct Context IDs of the objects in Oracle must be captured while the content is recorded. To enable this, you must deploy or modify the custom library (CUSTOM.pll) on the Oracle serverbefore content creation begins.
Deploy a Custom Library
Use the following steps if you have not deployed a custom library on your Oracle Applications
server.
- Back up your existing CUSTOM.pll to CUSTOM.pll.orig.
- Locate the ODPNCustomPLL.zip file in the ORACLE folder where the Developer is installed and retrieve the CUSTOM.pll file. Then copy it to the $AU_TOP/resource folderon the Oracle Applications server.
- Locate the ODPNCustomPLL.zip file in the ORACLE folder where the Developer isinstalled and retrieve the ODPN.pll file. Then copy it to the $AU_TOP/resource folder on the Oracle Applications server.
- Ensure that no one is currently using Oracle Applications (web Forms).
- While in the $AU_TOP/resource, compile the ODPN.pll and CUSTOM.pll library filesusing the command for your specific EBS version:
For Oracle E-Business Suite 11.5.9
f60gen module=ODPN.pll module_type=LIBRARY userid=apps/apps@<instance>
compile_all=yes
f60gen module=CUSTOM.pll module_type=LIBRARY userid=apps/apps@<instance>
compile_all=yes
For Oracle E-Business Suite 11.5.10
ifcmp60 module=ODPN.pll module_type=LIBRARY userid=apps/apps@<instance> compile_all=yes
ifcmp60 module=CUSTOM.pll module_type=LIBRARY userid=apps/apps@<instance> compile_all=yes
For Oracle E-Business Suite R12
frmcmp module=ODPN.pll userid=apps/apps@<instance> module_type=library compile_all=yes
frmcmp module=CUSTOM.pll userid=apps/apps@<instance> module_type=librarycompile_all=yes
*Replace the database connect string to reflect your instance.
Modify an Existing Custom Library
Use the following steps if you have custom logic in your custom library (CUSTOM.pll) that you do not want to overwrite. You must place a line of code in the custom library that will call out to new library (ODPN.pll). After doing this, you will only need to recompile your existing CUSTOM.pll if you receive new versions of ODPN.pll with software upgrades.
- 1. Backup your existing CUSTOM.pll to CUSTOM.pll.orig.
- Copy the CUSTOM.pll from the $AU_TOP/resource folder on the Oracle Applications server to a client machine that has Oracle Forms Builder installed.
- Copy the APPCORE2.pll from $AU_TOP/resource folder on the Oracle Applicationsserver to a client machine that has Oracle Forms Builder installed. This should be the same folder you used for step 2.
- Locate the ODPNCustomPLL.zip file in the ORACLE folder where the Developer isinstalled and retrieve the ODPN.pll file. Then copy it to the client machine into same folder as previous file copies. Note that this library is not version-specific to 11i or R12.
- Open CUSTOM.pll using Oracle Forms Builder and attach ODPN.pll. Place this file in the same folder on the client side as your CUSTOM.pll prior to the attachment.
- Answer Yes, when asked to remove directory path.
- Add the following code to the Event procedure:gkod_event (event_name, ‘SPECIAL15’);
- Ensure that no one is currently using Oracle Applications (web Forms). Shut down Oracle Forms Server service.
- Copy the CUSTOM.pll and ODPN.pll files from the client to the $AU_TOP/resourcefolder on the Oracle Applications server.
- Compile both the ODPN.pll and the CUSTOM.pll files using steps 5 and 6 in the previous section.
* Reference taken from UPK Content Administration Guide: CH 6 Help Menu Integration for the Oracle E-Business Suite