Skip to main content

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

By Unknown
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]  
Labels:

Comments

Post a Comment

Popular posts from this blog

Cancel or abort adop session

By Unknown
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
Post a Comment
Read more

Launching a Concurrent with Form Personalization on EBS 11i

By Unknown
There are two methods when it comes to running a concurrent from a Form Personalization in Oracle. The thing you need to do in either case is create a menu option for the form in question. This is generally done on a WHEN-NEW-FORM-INSTANCE Trigger Event. If you already have an event like this then you can add it there. I personally like to group my customizations together so there is not much overlap. Whichever catches your fancy will work. Setup the menu with the name: You now have a menu item for the launching of the concurrent program. This is where the two methods separate and you may choose which ever is more appropriate to you. Launch FNDRSRUN (Submit Request) This will use the zoom feature of Oracle Form Personalization to open the Submit Request Form, and pass the parameters to it. This involves personalization in two forms. The sending form needs to call the Form Function and pass the parameters and the Submit Request form needs to receive and process those parameters....
2 comments
Read more

Creating new WLS domain ends with exit code 255

By Unknown
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-...
Post a Comment
Read more