TCG ETL Error

 Error 1:-


Error code: 9154
ODI-1226:

 oracle.apps.grc.common.job.JobExecutionException: Scenario with id: 9154 failed - will set the job to failed.


oracle.apps.grc.common.job.JobExecutionException: Scenario with id: 51154 failed - will set the job to failed.

R12.1 EBS Application

Application Short Name	Application Name	Flog
AK 12.1	Common Modules-AK 12.1	Yes
ALR 12.1	Alert 12.1	Yes
AP 12.1	Payables 12.1	Yes
AR 12.1	Receivables 12.1	Yes
FND 12.1	Application Object Library 12.1	Yes
GL 12.1	General Ledger 12.1	Yes
PO 12.1	Purchasing 12.1	Yes
SYSADMIN 12.1	System Administration 12.1	Yes
XLA 12.1	Subledger Accounting 12.1	Yes
XLE 12.1	Legal Entity Configurator 12.1	Yes
ZX 12.1	E-Business Tax 12.1	Yes
iPO 12.1	Oracle iProcurement 12.1 (Purchasing)	Yes

How to find the multi org assigned in responsibility

Profile = MO%Sec%Pro%




SELECT   psp.SECURITY_PROFILE_NAME,
         psp.SECURITY_PROFILE_ID,
         hou.NAME,
         hou.ORGANIZATION_ID
FROM     PER_SECURITY_PROFILES psp,
         PER_SECURITY_ORGANIZATIONS pso,
         HR_OPERATING_UNITS hou
WHERE    pso.SECURITY_PROFILE_ID = psp.SECURITY_PROFILE_ID
         AND pso.ORGANIZATION_ID = hou.ORGANIZATION_ID
         AND SECURITY_PROFILE_NAME = ' <NAME>';

How to check the which responsibility under which Operating unit in oracle apps

Open the systemadmin



Click Responsibility - Give the Name of the Responsibility

Profile --> MO%Oper%