Skip to main content

UPK - Help Integration for Oracle E-Business Suite 11i

How do you integrate the UPK directly from the EBS Menu's? A feature is built into the UPK and just need to follow the steps that Oracle suppliers in the document, I have copied them here with some notes of my own:
Modify an Existing Custom Library (Custom.pll)
  1. Back up your existing CUSTOM.pll to CUSTOM.pll.orig.
  2. 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.
  3. Copy the APPCORE2.pll from $AU_TOP/resource folder on the Oracle Applications server to a client machine that has Oracle Forms Builder installed. This should be the same folder you used for the previous step. This may not be needed if you already are using FORMS60_PATH setup in the registry. We have created a network folder to the Development $AU_TOP folder that is visible to the developers and the registry key points to it.
  4. Locate the file in the ORACLE folder where the Developer is installed and extract the ODPN.pll file. Copy it to the client machine into same folder as previous file copies. I was not sure what Developer folder meant but this is where your your UPK Client is installed, we had it on a seperate stand alone machine so I found it by searching in the installation directory of the UPK (C:\Program Files\User Productivity Kit\UPK Developer 36Single User\oracle). This file contained both a CUSTOM.pll file and the ODPN.pll file.
  5. 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.
  6. Answer Yes, when asked to remove directory path.
  7. To make sure you have no customizations already using the SPECIAL7 menu run the following:
    • cd $AU_TOP/forms/US; grep -i APP_SPECIAL.ENABLE `find . -name "*.fmb" -print`| grep SPECIAL7| grep -i PROPERTY_ON
    • cd $AU_TOP/resource; grep -i APP_SPECIAL.ENABLE `find . -name "*.fmb" -print`| grep SPECIAL7| g rep -i PROPERTY_ON
  8. If you receive a result that looks like the statement below, the value is already being used.
    • ./CSCCCCRC.fmb:app_special.enable('SPECIAL7', PROPERTY_ON);
  9. In the CUSTOM Package Body modify the Event procedure by adding this line before the end of the procedure: 
    • gkod_event (event_name, 'SPECIAL7');
  10. Copy the CUSTOM.pll and ODPN.pll files from the client to the $AU_TOP/resource folder on the Oracle Applications server.
  11. Compile both the ODPN.pll and the CUSTOM.pll files: 
    • f60gen module=ODPN.pll module_type=LIBRARY userid=apps/$APPLPWD compile_all=yes
    • f60gen module=CUSTOM.pll module_type=LIBRARY userid=apps/$APPLPWD compile_all=yes
  12. Ensure that no one is currently using Oracle Applications (Web Forms). Shut down the Oracle Forms Server service.

UPK: Help Menu Integration Documentation (HEMI) for UPK 3.1.5 [ID 660602.1]  


Popular posts from this blog

Cancel or abort adop session

ADOP is in my opinion still pretty half baked. This is a critical tool that just isn't as intuitive as the old adpatch was. However we move with the times and get the hang of the new way of doing things. Along the way you might want to abort or cancel a patching cycling. With the two file systems and db editioning this can be a bit more to manage. I have learnt the hard way so you need to use the full cleanup after aborting a session.
adop phase=abort
adop phase=cleanup cleanup_mode=full

Creating new WLS domain ends with exit code 255

Cloning the instance I ran into this weird error. Was not sure what to do but after learning my lesson I dug through the error logs after seeing this in the adcfgclone log file.
START: Creating new WLS domain.
Running /u03/APPLYES/YES/fs2/FMW_Home/oracle_common/bin/ -javaHome /u03/APPLYES/YES/fs2/EBSapps/comn/util/jdk64 -al /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u03/APPLYES/YES/fs2/FMW_Home/user_projects/domains/EBS_domain_YES -tmw /u03/APPLYES/YES/fs2/FMW_Home -mpl /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply -silent true -debug true -domainAdminPassword /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 1903 milliseconds, returning status 255
ERROR: Script failed, exit code 255

Dig a bit deeper into the log files
cd /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply
cat CLONE2016-01-10_04-37-11PM.log

Failed to initialize the application 'EBSDataSource' due to error weblogic.application.ModuleException after FNDCPASS apps change

Started testing password changes in our clone environments. Weblogic seems to love throwing you curve balls and when I changes the apps password with the below:
I was not able to start the weblogic managed servers. A look in the log an I found this:

        at weblogic.jdbc.module.JDBCModule.prepare(
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(
        at weblogic.application.internal.flow.DeploymentCallbackFlow$
        at weblogic.application.utils.StateMachineDriver.nextState(
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(
        at weblogic.application.internal.BaseDep…