Thursday, June 25, 2015

UPK to EBS R12 - Step By Step.

Hi All

Here the step by step guide how to connect the Oracle EBS R12 to use UPK help.

1. Add the UPK to CUSTOM.pll file:
Backup the CUSTOM.plx before installation.
Copy the attached ODPN.pll file to $AU_TOP/resource.
Compile the ODPN.pll using:
frmcmp_batch userid=apps/apps module=ODPN.pll module_type=LIBRARY    
make sure that the ODPN.plx was created.
Convert the CUSTOM.pll to text file (ECM_CUSTOM.pld)
frmcmp_batch userid=apps/apps module= CUSTOM.pll module_type=LIBRARY script=Yes
Open the CUSTOM.pld
Add the fillowing line at the begining of the file:
.attach LIBRARY ODPN END NOCONFIRM
right after the last attached pll
Add the following at the end of the Event procedure (before the line with  "end event;"), save and close the file:
/*************** UPK Module ****************************************/
gkod_event(event_name, 'SPECIAL20');
/*******************************************************************/
Convert the ECM_CUSTOM.pld from text file to pll file (binary) using:
frmcmp_batch userid=apps/apps module= CUSTOM.pld module_type=LIBRARY parse=Yes (make sure that the CUSTOM.pll was created).
Compile the CUSTOM.pll using:
frmcmp_batch userid=apps/apps module= CUSTOM.pll module_type=LIBRARY (make sure that the CUSTOM.plx was created).

2. Copy the content of directory - Create Requisition Publish\Publishing content\PlayerPackage to $INST_TOP/portal/upk (or use windows shared directory so you need to mount directory and create a soft link 
cd $INST_TOP/portal
ln -s <shared directory>  upk ).

3. Login to Oracle Application and update Applications Help Web Agent profile with the following string:

http://<hostname>:<port>/upk/oracle/hemi/oracle_gateway.html

4. Restart Apache service
5. Now you can use the UPK to EBS functionality from EBS help menu.


Good Luck ...

2 comments: