Oracle EBS 12.2.x Notes

---------------------------------------------------------------------------------------------------
To display the current connected edition

$echo $FILE_EDITION

$ sqlplus apps/apps
SQL> select ad_zd.get_edition_type from dual;

---------------------------------------------------------------------------------------------------
Useful metalink notes:
* Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)

* How to deploy customizations that are created in the package oracle.apps.xxprod.* rather than xxprod.oracle.apps.* or xxprod.oracle.apps.xxprod.* on EBS 12.2.X? (Doc ID 1609939.1)

---------------------------------------------------------------------------------------------------
OAF deployment steps 12.2.x:

1) Connect to middle tier
2) Source to Run file system
$. ./EBSapps.env
3) Then enter 'R'
4) Go to JAVA TOP
$cd $JAVA_TOP
5) Backup customall.jar file
6) Run adcgnjar by entering apps DB password to regenrate customall.jar file and check the time stamp
$adcgnjar
7) Restart OACORE by giving weblogic admin password.
$admanagedsrvctl.sh stop oacore_server1
$admanagedsrvctl.sh start oacore_server1
---------------------------------------------------------------------------------------------------

Workflow Notes

Download Workflow Builder:

Download workflow builder from Metalink - Patch Number 6970344.

Workflow builder works on both 32 bit machine and 64 bit machine. But if you are using 64 bit machine you need to have Admin Access on your 64 bit system from where you are launching the Workflow builder.

Refer note Recommended Set Up for Client/Server Products with Oracle E-Business Suite 11i and R12 (Doc ID 277535.1) for getting appropriate Workflow builder patch.

Workflow Access Levels:

   0-9           Reserved for Oracle Workflow
   10-19       Resereved for Oracle Application Object Library
   20-99       Resereved for Oracle Applications Development

   100-999   Reserved for Customer Organization
    1000       Public

When developing custom workflow or modifying a seeded workflow you need to set the access level to 100. Setting any other access level and modifying seeded workflow objects may corrupt the workflow and you might see abnormal functionality.

If any activity/object is locked by Oracle Applications Development the protection level will be 20 and you will not be able to modify with access level 100. If it is not locked the protection level will be 1000 and you will be able to modify with access level 100.

After you modify, you need to check the preserve customiztions and lock at this access level to protect the customizations from upgrade/patching. With this Customization value will be 100 and Protection will also be 100. However by checking Allow modifications to customized objects Oracle App development will also be able to modify.

Set the access level from workflow bulider Help (Menu) --> About Workflow Builder

WFLOAD Commands:

Download workflow from the instance:
WFLOAD apps/<apps pwd> 0 Y DOWNLOAD XXCUST.wft <ITEMTYPE>

Upload workflow to database - Upgrade mode:
WFLOAD apps/<apps pwd>0 Y UPGRADE XXR2REXT820B.wft

Upgrade mode honours both protection and customiztion levels of data

Upload workflow to database - Upload mode:
WFLOAD apps/<apps pwd>0 Y UPLOAD XXR2REXT820B.wft

Upload mode honours only protection levels of data.

Upload workflow to database - Force mode:
WFLOAD apps/<apps pwd> 0 Y FORCE XXR2REXT820B.wft
Force upload  does not honor both protection and customiztion levels of data

Below are some useful metalink notes on workflow:
How To Use WFLOAD To Download, Upload, Upgrade, Force Upload A Workflow To Database? (Doc ID 1569004.1)
How to Ensure Workflow File Customizations/Changes Are Not OverWritten By Upgrades/Patches (Doc ID 1343956.1)
WFLOAD Fails On Customizations (Doc ID 1015861.102)

Compile Flexfiled or Concurrent Program Flexfields

When running concurrent program some times we get error Concurrent program flexfield not compiled or not freezed. You can do it through Compile All Flex fields concurrent program or using below command

fdfcmp apps/<apps password> 0 Y D 'XXCUST'  '$SRS$.XX_CONC_PROG_SHORT_NAME'

XXCUST --> Concuurent program application short name
XX_CONC_PROG_SHORT_NAME --> Concurrent program short name

Scripts required for 12.2.X custom table development

1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in APPS schema.

exec AD_ZD_TABLE.UPGRADE('XXCUST','XX_CUST_TBL1');

2) For table alteratuons - after running the DDL run below script to regenerate the editioning view for syncing any table changes.

exec AD_ZD_TABLE.PATCH('XXCUST','XX_CUST_TBL1')

3) Table grants must be done through API to avoid invalids.

exec AD_ZD.GRANT_PRIVS('SELECT','XX_CUST_TBL1','XX_ROLE0')

4) To view objects in all editions..add _ae to the data dictionary views

select * from user_objects_ae;

5) To update seed data tables in Patch edition, execute prepare command.

example:
 exec ad_zd_seed.prepare('WF_MESSAGES');

The prepare will create a edition based storage for the run edition data for which the updates will be made. During cutover, the run time data will be synced using forward/reverse cross edition triggers.