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 ODPNCustomPLL.zip 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.

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

Comments

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/pasteConfig.sh -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-

Error during rapid clone on pasteBinary.sh, exit code 255

I needed to run a clone and was running into a really head scratcher. As is Oracle\'s way they sometimes enjoy giving us DBA's a bit of detective work to do. As usual I kept knocking my head into various brick walls instead of tracking back through the logs. Eventually I came up with the problem Start to configure the run filesystem. You can do a dualfs from AD-TXK Delta 7 but for now I just needed to get this up and running: perl adcfgclone.pl appsTier START: Creating FMW Home. Running /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/ pasteBinary.sh -javaHome /u03/APPLUAT/UAT/fs1/EBSapps/comn/util/jdk64 -al /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl /u03/APPLUAT/UAT/fs1/FMW_Home -invPtrLoc /etc/oraInst.loc -ldl /u03/APPLUAT/UAT/fs1/inst/apps/UAT_erpapp05/admin/log/clone/fmwT2PApply -silent true -debug true -executeSysPrereqs false Script Executed in 21933 milliseconds, returning status 255 ERROR: Script failed, exit code 255 Oracle has left me a cryptic