Introduction


This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from V2 to V3. It is not meant to replace MOS Doc ID 2495053.1, which is very clear and detailed. We want to share our experience including faced errors and solutions.
For installation instructions of ECC V2 please refer to this post.
And good news for those who would like to see the latest ECC in action. You can try it yourself in our demo environment. Just log in and choose Payables manager or Receivables manager responsibility and navigate to the command center menu entry.

References


Following sources have been used to get ECC upgrade instructions:

Installing Oracle Enterprise Command Center Framework, Release 12.2 (Doc ID 2495053.1)

Requirements


Supported OS versions:

Oracle Linux 6 or Red Hat Enterprise Linux 6 (64-bit)
Oracle Linux 7 or Red Hat Enterprise Linux 7 (64-bit)

Our existing ECC installation uses standalone Oracle Linux 7 virtual machine.

Required OS resources

MOS Doc ID 2495053.1 provides table describing OS resources requirements. We started with minimal resources assignment as it can be easily changed for a virtual machine.

Number of usersNumber of recordsNumber of CoresRequired Memory
502 million25 GB

Perform backups


Ensure that you have sufficient disk space to back up the existing V2 installation backup and to extract the V3 .bsx file from the V3 quick install package.

Shutdown ECC

[oracle@ecc ~]$ ./stopecc.sh

Compress ECC installation directory

[oracle@ecc u01]$ nohup tar -czvf ecc_demo_v2_bkp.tar.gz ecc_demo>/tmp/bkp_log &

Export Oracle Enterprise Command Center Framework Schema

After adjusting directory path run the following commands to export the ECC_SCHEMA from the database instance as user with DBA privileges:

[oracle@ecc ~]$ sqlplus '/as sysdba'
SQL> create or replace directory ECC_EXP_DIR_NAME as '/backup/snapshots/BACKUPS/ecc/ECC_schema_backup';
SQL> grant read, write on directory ECC_EXP_DIR_NAME to ECC;
SQL> exit
[oracle@ecc ~]$ export ECC_SOURCE_SCHEMA=ECC;
[oracle@ecc ~]$ read -s ECC_SOURCE_SCHEMA_PASSWORD
[oracle@ecc ~]$ expdp ${ECC_SOURCE_SCHEMA}/${ECC_SOURCE_SCHEMA_PASSWORD} DIRECTORY=ECC_EXP_DIR_NAME DUMPFILE=ecc_dump.dmp LOGFILE=ECC_EXP_DIR_NAME:exportSchema.log

Run upgrade script


Create directory for ECC installation root. Example: /u01. It will be referred as $ECC_BASE

Download patch Patch 29905497 from MOS
Unzip patch into the stage directory

unzip p29905497_R12_GENERIC.zip

Copy the .bsx file to the $ECC_BASE directory. Add executable permissions to it

chmod +x *.bsx

From $ECC_BASE directory, execute ECC v3 installer:

./*.bsx

Installer creates two directories:

  • insta_client: The SQL*Plus client directory
  • Oracle: Oracle Enterprise Command Center Framework quick install scripts and software

Change to the /Oracle/quickInstall directory and run the upgrade.sh script.

cd Oracle/quickInstall
./upgrade.sh

When prompted, enter the following details:

  • The base directory of the existing V2 Oracle Enterprise Command Center Framework installation that you want to upgrade
  • The password for the Oracle Enterprise Command Center Framework domain admin user
  • The password for the Oracle Enterprise Command Center Framework database user

The script displays messages indicating the actions performed to carry out the upgrade.
These messages are also recorded in a log file in the directory specified for the ECC_LOG_DIR configuration property in your installation. The log file is named $ECC_LOG_DIR/upgrade.log.

Note: The following warning message may appear during the upgrade process:

java.rmi.RemoteException: [Deployer:149145]Unable to contact "eccManaged". Deployment is deferred until "eccManaged" becomes available.
WARNING: If this is a redeploy app and contains JSP pages that have been touched, these JSP changes won't be reflected when the server starts unless precompile is set to true in weblogic.xml

You can safely ignore this message. This is an informational message indicating that deployment is marked as delayed because the Oracle Enterprise Command Center Framework domain managed server is shut down at this point. The upgrade will proceed to the next step, and new deployment along with relevant changes will take effect when the upgrade script restarts the managed server.

Verify the upgrade

After the upgrade script finishes running, verify the upgrade by checking that the Search component appears in the components list when you define a dashboard.

To do it click ‘Open Component List’ control at the bottom right of the command center screen.

Image below shows the list of components in the ECC v2:

After the upgrade ‘Search’ component is added:

EBS 12.2.9 required patches


EBS patches need to be applied before configuring ECC. Below list of patches is specific for our EBS 12.2.9 instance as we have some of the patches applied. For example we had R12.AD.C.Delta.11 and R12.TXK.C.Delta.11 applied as we recently upgraded to EBS 12.2.9. First two patches: ATG consolidated patch and adapter patch are mandatory. Other patches depend on the products with Enterprise Command Centers that you want to use and installed languages.
Patches must be applied in the order below. MOS Document 2495053.1 prohibits merging between ATG consolidated patch,adapter patch and the product family consolidated patches. Following this rule I  applied ATG consolidated patch and its NLS patches, then adapter patch and its NLS patches. Then I merged and applied all product family consolidated patches including their NLS patches.

[-]28780011:R12.ATG_PF.C ATG consolidated patch for 12.2.9 release
	[+]12.2.3
	[+]R12.AD.C.delta.11
	[+]R12.ATG_PF.C.delta.8
	[+]R12.TXK.C.delta.11
[-]29499071:R12.ATG_PF.C. adapter patch
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29499123:R12.CC_PF.C //Customer Relationship Management consolidated patch
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29499116:R12.FIN_PF.C Financials consolidated patch.
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29501257:R12.HR_PF.C
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29499098:R12.PRC_PF.C // Procurement consolidated patch
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29499152:R12.PJ_PF.C // Projects  consolidated patch
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29499090:R12.SCM_PF.C //Supply Chain Management  consolidated patch
	[+]12.2.4
	[+]R12.AD.C.delta.11
	[+]R12.TXK.C.delta.11
[-]29921139:R12.CSD.C  Oracle Depot Repair Command Center required patch
	[+]12.2.3
	[+]R12.AD.C.delta.5
	[+]R12.ATG_PF.C.delta.4
	[+]R12.TXK.C.delta.5
[-]30204729:R12.INV.C //Oracle Inventory Management Command Center required patch
[+]28969483:R12.OKL.C // Oracle Lease and Finance Management Command Center required patch
	[+]12.2.3
	[+]R12.AD.C.delta.7
	[+]19060002 //R12.FIN_PF.C.Delta.5
	[+]19245366 //R12.ATG_PF.C.Delta.5 Release
	[+]R12.TXK.C.delta.7
	[+]18106421:R12.XLA.C – Import AAD With Overwrite Option for FAH Customers (bug 18106421)
	[+]26922723:R12.FA.C - ALLOW FULL RETIREMENT OVERLAPPING ADJ WHEN AMORTIZED ADJUSTMENTS IN
	[+]27193501:R12.FA.C - CONTRACT ID IS BLANKED OUT AFTER PERFORMING UNPLANNED DEPRECIATION
	[+]26962903:R12.FA.C - ALLOW CONTRACT ID UPDT SEPARATE FROM FINANCIAL ATTRIB UPDT FOR FULLY 
	[+]27673594:R12.FA.C - TRANSFER INTO PARTIAL UNIT DISTRIBUTIONS IN ADDITION PERIOD YIELDS 
	[+]27839335:R12.FA.C - ERROR WHEN PERFORMING MULTIPLE COST AND UNIT ADJUSTMENT IN PERIOD OF 
	[+]26437073:R12.AR.C - NOT ABLE TO APPLY AR PATCH 19663965:R12.AR.C
	[+]28528332:R12.OKL.C - WHEN APPLYING 12.2 UNIFIED PATCH, XLIFFLOADER.CLASS FAILED FOR ESA 
	[+]25467949:R12.OKS.C – USAGE LIMIT AND CONSOLIDATION BASED BILLING  (bug 25467949)
	[+]25609551:R12.OKS.C – USAGE LIMITAND CONSOLIDATION BASED BILLING PART 2 (bug 25609551)
	[+]25741450:R12.OKS.C – UNABLE TO ADD ASSET (COUNTER LINE) TO EXISTING USAGE ON AN ACTIVE 
	[+]23229913:R12.OKS.C - 12.1.3 -> 12.2.0 UPGRADE DRIVER WORKER FAILED OKSPDFSD.LDT 
	[+]25780023:R12.OKS.C - CONSOLIDATED GROUP BILLING IS NOT CONSIDER THE ROUND UP AMOUNT
	[+]20515032:R12.OKS.C - OKS_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT RETURN STATUS=W WHILE 
	[+]25962587:R12.OKC.C - INVALID VALUE FOR THE COLUMN LINE_RENEWAL_TYPE WHILE CALL OKS TERMINATION
	[+]26814339:R12.OKS.C - COUNTER BILLING AMOUNT FOR USAGE CONTRACTS IN PREVIEW MODE IS ALWAYS ZERO 
	[+]27667083:R12.OKS.C - E.TST1228:OKSHTMLUI:BILLING IS COMPLETED WITH WARNING WHEN CONSOLIDATION
[-]30192168:R12.PA.C // Oracle Projects Command Center required patch
[-]30215625:R12.PER.C // Oracle Human Resources Command Center required patch
[+]17361679:R12.ONT.C // Oracle Inventory Management Command Center data load required patch
[+]19766498:R12.HZ.C // Oracle Inventory Management Command Center data load required patch
[+]27073573:R12.INV.C // Oracle Inventory Management Command Center data load required patch
[-]17345755:R12.WMS.C // Oracle Inventory Management Command Center data load required patch
[-]30003234:R12.INV.C // Oracle Inventory Management Command Center data load required patch
[-]30134572 Customer Relationship Management (cc_pf) online help
[-]30134553 Financials (fin_pf) online help             
[-]30147344 Human Resources (hr_pf)  online help 
[-]30134539 Procurement (prc_pf)  online help			 
[-]30134564 Projects (pj_pf)  online help				 
[-]30134464 Supply Chain Management (scm_pf) online help

Start ADOP patching cycle

{ echo $appspass; echo $systempass; echo $wlspass; }|adop phase=prepare

Apply ATG consolidated patch and adapter patch plus NLS without merging them. Adop will apply them in the sequence they appear in the patch list.

{ echo $appspass; echo $systempass; echo $wlspass; }| adop phase=apply patchtop=/backup/patches/EBS12.2/V3_ECC patches=29499071:u29499071.drv,29499071_ZHS:u29499071.drv,29499071_F:u29499071.drv,29499071_D:u29499071.drv,29499071_AR:u29499071.drv,28780011:u28780011.drv,28780011_ZHS:u28780011.drv,28780011_F:u28780011.drv,28780011_D:u28780011.drv,28780011_AR:u28780011.drv

Apply rest of the patches plus NLS merging them

{ echo $appspass; echo $systempass; echo $wlspass; }| adop phase=apply patchtop=/backup/patches/EBS12.2/V3_ECC patches=30215625:u30215625.drv,30204729:u30204729.drv,30192168:u30192168.drv,30147344:u30147344.drv,30134572:u30134572.drv,30134564:u30134564.drv,30134553:u30134553.drv,30134539:u30134539.drv,30134464:u30134464.drv,30003234_ZHS:u30003234.drv,30003234_F:u30003234.drv,30003234_D:u30003234.drv,30003234_AR:u30003234.drv,30003234:u30003234.drv,29921139_F:u29921139.drv,29921139:u29921139.drv,29501257_ZHS:u29501257.drv,29501257_F:u29501257.drv,29501257_D:u29501257.drv,29501257_AR:u29501257.drv,29501257:u29501257.drv,29499152_ZHS:u29499152.drv,29499152_F:u29499152.drv,29499152_D:u29499152.drv,29499152_AR:u29499152.drv,29499152:u29499152.drv,29499123_ZHS:u29499123.drv,29499123_F:u29499123.drv,29499123_D:u29499123.drv,29499123_AR:u29499123.drv,29499123:u29499123.drv,29499116_ZHS:u29499116.drv,29499116_F:u29499116.drv,29499116_D:u29499116.drv,29499116_AR:u29499116.drv,29499116:u29499116.drv,29499098_ZHS:u29499098.drv,29499098_F:u29499098.drv,29499098_D:u29499098.drv,29499098_AR:u29499098.drv,29499098:u29499098.drv,29499090_ZHS:u29499090.drv,29499090_F:u29499090.drv,29499090_D:u29499090.drv,29499090_AR:u29499090.drv,29499090:u29499090.drv,17345755:u17345755.drv merge=yes

Issue

{ echo $appspass; echo $systempass; echo $wlspass; }|adop phase=actualize_all

Faced issue during actualize_all phase for FPA_ objects related to Projects application:

SQL> alter package APPS.FPA_MAIN_PROCESS_PVT compile;
alter package APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT compile
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT
ORA-00600: internal error code, arguments: [kql_tab_diana:dep copy],
[0x0D3EE13F0], [0x7F8D85D77260], [3], [], [], [], [], [], [], [], []

Workaround for this problem can be found in Bug 24489846 and Doc ID 2426230.1

The workaround process to accomplish cleanup of old editions is to connect to APPS account via sqlplus and execute the following

$ sqlplus apps/****
-----------------------------------------------------------------
exec ad_zd.set_edition('PATCH')
 
declare
cursor FPATYPES is
select object_name from user_objects
where object_type='TYPE' and object_name like 'FPA%';
begin
for rec in fpatypes loop
execute immediate 'alter type '||rec.object_name||' compile';
end loop;
end;
/

Please note that it’s not required to run actualize_all phase and finalize and cleanup phases in full mode every patching cycle. I did it to get rid of old patching editions in the database.

{ echo $appspass; echo $systempass; echo $wlspass; } | adop phase=finalize finalize_mode=full
 
{ echo $appspass; echo $systempass; echo $wlspass; } | adop phase=cutover
 
source ~/EBSapps.env run
{ echo $appspass; echo $systempass; echo $wlspass; } | adop phase=cleanup cleanup_mode=full
 
{ echo $appspass; echo $systempass; echo $wlspass; } | adop phase=fs_clone

Import Enterprise Command Center Applications


Copy $ECC_BASE/Oracle/quickInstall/scripts/patchEccFiles.pl script from ecc host to EBS host.

Login to EBS server and apply run fs environment.

[oracle@demo ~]$ . ./EBSapps.env run

Create empty staging directory.

[oracle@demo scripts]$ mkdir /tmp/staging

Run patchEccFiles.pl script

[oracle@demo tmp]$ ./patchEccFiles.pl
Enter temporary directory for ECC Files (Should be used only for this task and be empty): /tmp/staging
Enter EBS DB apps user id (default: apps) :
 
Enter EBS DB apps user password:
List of languages installed in EBS:
--------------------------------------------------
| Language| ECC Language Code|
--------------------------------------------------
| ARABIC | ar |
| GERMAN | de |
| FRENCH | fr |
| AMERICAN | en |
| SIMPLIFIED CHINESE | zh-Hans |
---------------------------------------------------
 
List of languages supported in ECC:
Arabic(ar), Brazilian Portugese(pt), Canadian French(fr-CA),Croatian(hr), Cyrillic Kazakh(kk), Cyrillic Serbian(sr), Czech(cs), Danish(da), Dutch(nl), English(en), Finnish(fi), French(fr), German(de), Greek(el), Hebrew(he), Hungarian(hu), Indonesian(id), Italian(it), Japanese(ja), Korean(ko), Latin Spanish(es-419),Latin Serbian(sr-Latn), Lithuanian(lt), Norwegian(no), Polish(pl), Portugese(pt-PT),Romania(ro), Russian(ru), Simplified Chinese(zh-Hans), Slovak(sk), Slovenian(sl), Spanish(es), Swedish(sv), Thai(th), Traditional Chinese(zh-Hant), Turkish(tr), Ukranian(uk), Vietnamese(vi)
 
NOTE: Only languages installed and enabled in ECC will be processed successfully
Example: Enter ar,pt for Arabic and Brazilian Portugese language respectively. Enter all(ALL) for all languages
 
Enter the Language code(s) from the list mentioned above to run the translation for:
 
Do you want to add all products at once(Y) or specify the subset(N): Y
 
Adding product top AP
 
Adding product top AR
 
Adding product top BOM
 
Adding product top CN
 
Adding product top CS
 
Adding product top EAM
 
Adding product top FA
 
Adding product top GMO
 
Adding product top ICX
 
Adding product top INV
 
Adding product top JMF
 
Adding product top OKL
 
Adding product top OKS
 
Adding product top ONT
 
Adding product top OZF
 
Adding product top PA
 
Adding product top PO
 
Adding product top WIP
 
Importing application /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc
ECC Application File:/tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
Importing file /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095220.log"}]
Imported application /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip successfully
 
Importing application /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip
ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc
ECC Application File:/tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip
Importing file /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095227.log"}]
Imported application /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip successfully
 
Importing application /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip
ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc
ECC Application File:/tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip
Importing file /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095228.log"}]
Imported application /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip successfully
 
Importing application /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip
ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc
ECC Application File:/tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip
Importing file /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095229.log"}]
Imported application /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip successfully
 
SUMMARY REPORT:
-----------------------------------------------
| Product| Application | Status|
-----------------------------------------------
| AP | ap_ecc.zip | Success |
| AR | ar_ecc.zip | Success |
| FA | fa_ecc.zip | Success |
| OKL | okl_ecc.zip | Success |
-----------------------------------------------

Loading product data to ECC


Run concurrent programs for each product to perform full data load into the ECC. Programs should also be scheduled to perform periodic incremental loads to update the data.

Example for the Oracle Receivables : Receivables Command Center Data Load

To run this request you need to switch to Receivables responsibility as it’s not available under System Administrator responsibility. I used ‘Receivables manager’ responsibility.

To update data, requests can be rerun in INCREMENTAL_LOAD mode. Example of Payables Command Center Data Load:


Providing users access to ECC


This step needs to be performed for the new command centers after the upgrade. Also perform this step if you notice any changes in the roles, responsibilities or permission sets names provided in the MOS Doc ID 2495053.1.
Product-specific roles are used to provide access to ECC.
For list of the roles please refer to Doc ID 2495053.1.
Below is the example of role assignment performed in our system.

Providing access manually

In Oracle E-Business Suite, log in to the User Management responsibility, and navigate to the Roles and Role Inheritance page.

Search for desired responsibility

Click the “View In Hierarchy” icon for your responsibility

Click the Add Node icon for your responsibility

Search for the role you want to add and click ‘Select’

Next step is to update the associated grant for the product-specific Enterprise Command Center roles to reference the specific responsibility as the security context.

Click on expand to see the added role and click on update icon for the new role:

If this is the first responsibility to which you are adding to the role, click the Update icon for the grant you want to update.

Enter the name of the responsibility to which ECC role is added and click Apply

After this step Receivables Command Center should appear under Receivables Manager responsibility.

Note: If you don’t see function appear after the responsibility, you may need to clear EBS cache using Functional Administrator responsibility.

Automating access provision using script

To automate roles and grants configuration following script can be used. It should be ran from EBS run fs:

source EBSapps.env run
$FND_TOP/bin/UMX_ENDECA_RBACAuto.sh

It will prompt for csv file location, which should be prepared before running the script. If csv file is called UMX_ENDECA_RBAC.csv and located under same directory as UMX_ENDECA_RBACAuto.sh, it will be used automatically. Example of the file we used in our system to assign payables and receivables ecc roles to Payables manager, Receivables manager and ECC Developer:

PERMISSION_SET_CODE,RESPONSIBILITY_CODE,ENDECA_ROLE_CODE
AP_ECC_ACCESS_PS,FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD,UMX|AP_ECC_ACCESS_ROLE
AP_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|AP_ECC_ACCESS_ROLE
AR_ECC_ACCESS_PS,FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD,UMX|AR_ECC_ACCESS_ROLE
AR_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|AR_ECC_ACCESS_ROLE
IAR_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|IAR_ECC_ACCESS_ROLE
IAR_ECC_INT_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE

Example output:

[oracle@demo bin]$ ./UMX_ENDECA_RBACAuto.sh
 
APPS username: apps
 
APPS password:
 
Executing for Permission_set AP_ECC_ACCESS_PS , Responsibility_name FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD and Endeca_Role UMX|AP_ECC_ACCESS_ROLE
old 6: L_MENU_NAME varchar2(100) := '&1';
new 6: L_MENU_NAME varchar2(100) := 'AP_ECC_ACCESS_PS';
old 8: l_responsibility_name varchar2(300) := '&2';
new 8: l_responsibility_name varchar2(300) := 'FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD';
old 10: endeca_role_name varchar2(300) := '&3';
new 10: endeca_role_name varchar2(300) := 'UMX|AP_ECC_ACCESS_ROLE';
Completed Successfully.
 
PL/SQL procedure successfully completed.
Executing for Permission_set AP_ECC_ACCESS_PS , Responsibility_name FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD and Endeca_Role UMX|AP_ECC_ACCESS_ROLE
old 6: L_MENU_NAME varchar2(100) := '&1';
new 6: L_MENU_NAME varchar2(100) := 'AP_ECC_ACCESS_PS';
old 8: l_responsibility_name varchar2(300) := '&2';
new 8: l_responsibility_name varchar2(300) := 'FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD';
old 10: endeca_role_name varchar2(300) := '&3';
new 10: endeca_role_name varchar2(300) := 'UMX|AP_ECC_ACCESS_ROLE';
Completed Successfully.
 
PL/SQL procedure successfully completed.
Executing for Permission_set AR_ECC_ACCESS_PS , Responsibility_name FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD and Endeca_Role UMX|AR_ECC_ACCESS_ROLE
old 6: L_MENU_NAME varchar2(100) := '&1';
new 6: L_MENU_NAME varchar2(100) := 'AR_ECC_ACCESS_PS';
old 8: l_responsibility_name varchar2(300) := '&2';
new 8: l_responsibility_name varchar2(300) := 'FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD';
old 10: endeca_role_name varchar2(300) := '&3';
new 10: endeca_role_name varchar2(300) := 'UMX|AR_ECC_ACCESS_ROLE';
Role - Responsibility relationship already exists
Grant already exists
 
PL/SQL procedure successfully completed.
Executing for Permission_set AR_ECC_ACCESS_PS , Responsibility_name FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD and Endeca_Role UMX|AR_ECC_ACCESS_ROLE
old 6: L_MENU_NAME varchar2(100) := '&1';
new 6: L_MENU_NAME varchar2(100) := 'AR_ECC_ACCESS_PS';
old 8: l_responsibility_name varchar2(300) := '&2';
new 8: l_responsibility_name varchar2(300) := 'FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD';
old 10: endeca_role_name varchar2(300) := '&3';
new 10: endeca_role_name varchar2(300) := 'UMX|AR_ECC_ACCESS_ROLE';
Completed Successfully.
 
PL/SQL procedure successfully completed.

Access provision for all command centers.

I prepared UMX_ENDECA_RBAC.csv containing all responsibilities, permission sets and roles matched between each other.

FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE
FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE
FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE
FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE
FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE
FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE
FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE
FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE
OZF_CLAIM_ECC_MENU,FND_RESP|OZF|OZF_USER|STANDARD,UMX|OZF_ECC_ACCESS_ROLE
OZF_CLAIM_ECC_MENU,FND_RESP|OZF|OZF_AR_DED_SET_RESP|STANDARD,UMX|OZF_ECC_ACCESS_ROLE
PO_CLM_ECC_CO_PS,PUR_CLM_SUPER_USER,UMX|PO_CLM_ECC_CO_ROLE
PO_CLM_ECC_PMO_PS,SELF_SERV_CLM_PURCHASING_5,UMX|PO_CLM_ECC_PMO_ROLE
CST_ECC_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_ACCESS_ROLE
CST_ECC_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CST_ECC_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CST_ECC_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CST_ECC_GMF_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE
CSD_ECC_RO_MGR_ACCESS_PS,FND_RESP|CSD|DEPOT REPAIR|STANDARD,UMX|CSD_ECC_RO_MGR_ACCESS_ROLE
WIP_ECC_ACCESS_PERM_SET,FND_RESP|MSC|MFG_AND_DIST_SUPER_USER_APS|STANDARD,UMX|WIP_ECC_ACCESS_ROLE
EAM_ECC_ACCESS_PS,FND_RESP|EAM|MSU_VIS_OPS|STANDARD,UMX|EAM_ECC_ACCESS_ROLE
PER_ECC_PERSON_SEARCH_PS,FND_RESP|PER|US_SHRMS_MANAGER|STANDARD,UMX|PER_ECC_PEOPLE_SEARCH_ROLE
CN_ICM_ECC_ACCESS_PS,FND_RESP|CN|CN_INC_COMP_MANAGER|STANDARD,UMX|CN_ICM_ECC_ACCESS_ROLE
WSH_ECC_DASHBOARD_ACCESS_PS,FND_RESP|INV|INV_HTML|STANDARD,UMX|WSH_ECC_DASHBOARD_ACCESS_ROLE
ICX_ECC_ACCESS_PS,FND_RESP|ICX|SELF_SERVICE_PURCHASING_5|STANDARD,UMX|ICX_ECC_ACCESS_ROLE
IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE
IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE
IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE
IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE
IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE
IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE
IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE
IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE
OKL_ECC_OKL_PS,FND_RESP|OKL|LEASE SUPER USER|STANDARD,UMX|OKL_ECC_ACCESS_ROLE
ONT_ECC_PS,FND_RESP|ONT|ONT_HTMLUI_RESP|STANDARD,UMX|ONT_ECC_ROLE
JMF_ECC_ACCESS_PS,FND_RESP||JMF||JMF_SHIKYU_SUPER_USER||STANDARD,UMX|JMF_ECC_ACCESS_ROLE
AP_ECC_ACCESS_PS,FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD,UMX|AP_ECC_ACCESS_ROLE
GMO_ECC_ACCESS_PS,FND_RESP||GME||PRODUCTION SUPERVISOR||STANDARD,UMX|GMO_ECC_ACCESS_ROLE
PA_ECC_ACCESS_PS,FND_RESP|PA|PA_PRM_PROJ_SU_SVCS|STANDARD,UMX|PA_ECC_ACCESS_ROLE
PO_PCC_ECC_PS,FND_RESP|PO|PURCHASING_OPERATIONS|STANDARD,UMX|PO_PCC_ECC_ROLE
AR_ECC_ACCESS_PS,FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD,UMX|AR_ECC_ACCESS_ROLE
CS_ECC_SR_MGR_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE
CS_ECC_SR_MGR_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE
CS_ECC_SR_MGR_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE
CS_ECC_SR_MGR_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE
CS_ECC_SR_AGNT_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE
CS_ECC_SR_AGNT_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE
CS_ECC_SR_AGNT_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE
CS_ECC_SR_AGNT_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE
OKS_ECC_ACCESS,FND_RESP|OKS|OKS_MANAGER|STANDARD,UMX|OKS_ECC_ACCESS_ROLE

Clear cache

Command centers didn’t appear under the responsibilities after running above script. It was fixed by clearing EBS cache using Functional Administrator responsibility.

Conclusion


At this stage ECC installation and integration is complete. Reminding you again that you can try ECC in our demo instance. Just log in as DEVELOPER and choose desired product responsibility and find associated command center menu entry.
Please leave your comments if this article helped you or you faced any issues – we’re always happy to help you.