Oracle OAF Page Error

(oracle.jbo.common.ampool.ApplicationPoolException) JBO-30003: The application pool (.156A6DEE716) failed to checkout an application module due to the following exception:
----- LEVEL 1: DETAIL 0 -----
(oracle.jbo.JboException) JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: java.lang.ExceptionInInitializerError, msg=null
   ----- LEVEL 2: DETAIL 0 -----
   (oracle.jbo.JboException) JBO-29000: Unexpected exception caught: java.lang.ExceptionInInitializerError, msg=null
      ----- LEVEL 3: DETAIL 0 -----
      (java.lang.ExceptionInInitializerError) null

Console Log

"D:\OAF\jdevbin\jdk\bin\javaw.exe" -XX:MaxPermSize=256M -mx256m -DRUN_FROM_JDEV=true -DCACHENODBINIT=true -DFND_JDBC_STMT_CACHE_SIZE=200 -classpath "D:\OAF\jdevbin\BC4J\jlib\bc4jtester.jar;D:\OAF\jdevbin\jlib\jdev-cm.jar;D:\OAF\jdevbin\lib\xmlparserv2.jar;D:\OAF\jdevbin\jlib\help4.jar;D:\OAF\jdevbin\jlib\share.jar;D:\OAF\jdevbin\jlib\jewt4.jar;D:\OAF\jdevbin\jlib\oracle_ice.jar;D:\OAF\jdevbin\jlib\ojmisc.jar;D:\OAF\jdevbin\jdk\jre\lib\resources.jar;D:\OAF\jdevbin\jdk\jre\lib\rt.jar;D:\OAF\jdevbin\jdk\jre\lib\sunrsasign.jar;D:\OAF\jdevbin\jdk\jre\lib\jsse.jar;D:\OAF\jdevbin\jdk\jre\lib\jce.jar;D:\OAF\jdevbin\jdk\jre\lib\charsets.jar;D:\OAF\jdevbin\jdk\jre\lib\modules\jdk.boot.jar;D:\OAF\jdevbin\jdk\jre\classes;D:\OAF\jdevhome\jdev\myclasses;D:\OAF\jdevbin\jdev\lib\jdev-rt.jar;D:\OAF\jdevbin\jdbc\lib\ojdbc14dms.jar;D:\OAF\jdevbin\jdbc\lib\orai18n.jar;D:\OAF\jdevbin\jdbc\lib\ocrs12.jar;D:\OAF\jdevbin\diagnostics\lib\ojdl.jar;D:\OAF\jdevbin\lib\dms.jar;D:\OAF\jdevbin\BC4J\lib\adfshare.jar;D:\OAF\jdevbin\BC4J\lib\bc4jmt.jar;D:\OAF\jdevbin\BC4J\lib\collections.jar;D:\OAF\jdevbin\BC4J\lib\bc4jct.jar;D:\OAF\jdevbin\jlib\commons-el.jar;D:\OAF\jdevbin\jlib\jsp-el-api.jar;D:\OAF\jdevbin\jlib\oracle-el.jar;D:\OAF\jdevbin\BC4J\lib\bc4jctejb.jar;D:\OAF\jdevbin\j2ee\home\lib\ejb.jar;D:\OAF\jdevbin\BC4J\lib\bc4jmtejb.jar;D:\OAF\jdevbin\BC4J\jlib\bc4jhtml.jar;D:\OAF\jdevbin\BC4J\jlib\datatags.jar;D:\OAF\jdevbin\BC4J\jlib\bc4juixtags.jar;D:\OAF\jdevbin\BC4J\jlib\graphtags.jar;D:\OAF\jdevbin\j2ee\home\lib\ojsp.jar;D:\OAF\jdevbin\j2ee\home\jsp\lib\taglib\ojsputil.jar;D:\OAF\jdevbin\j2ee\home\oc4j.jar;D:\OAF\jdevbin\j2ee\home\lib\oc4j-internal.jar;D:\OAF\jdevbin\j2ee\home\lib\servlet.jar;D:\OAF\jdevbin\jdev\lib\ojc.jar;D:\OAF\jdevbin\jdev\appslibrt\regexp.jar;D:\OAF\jdevbin\jdev\appslibrt\share.jar;D:\OAF\jdevbin\jdev\appslibrt\ebsuix.jar;D:\OAF\jdevbin\oaext\mds\lib\mdsrt.jar;D:\OAF\jdevbin\oaext\lib\mdsdt.jar;D:\OAF\jdevbin\oaext\lib\oamdsdt.jar;D:\OAF\jdevbin\jdev\appslibrt\fwkjbo.zip;D:\OAF\jdevbin\jdev\appslibrt\fwk.zip;D:\OAF\jdevbin\jdev\appslibrt\atg.zip;D:\OAF\jdevbin\jdev\appslibrt\collections.zip;D:\OAF\jdevbin\jdev\appslibrt\concurrent.zip;D:\OAF\jdevbin\jdev\appslibrt\oamMaintMode.zip;D:\OAF\jdevbin\jdev\appslibrt\wsp.zip;D:\OAF\jdevbin\jdev\appslibrt\fwkCabo.zip;D:\OAF\jdevbin\jdev\appslibrt\diagnostics.jar;D:\OAF\jdevbin\jdev\appslibrt\oracle-portal-api.jar;D:\OAF\jdevbin\jdev\appslibrt\pdkjava.jar;D:\OAF\jdevbin\jdev\appslibrt\ptlshare.jar;D:\OAF\jdevbin\jdev\appslibrt\xml.jar;D:\OAF\jdevbin\jdev\appslibrt\wsrp-container-types.jar;D:\OAF\jdevbin\jdev\appslibrt\jaxb-impl.jar;D:\OAF\jdevbin\jdev\appslibrt\jaxb-libs.jar;D:\OAF\jdevbin\jdev\appslibrt\jazn.jar;D:\OAF\jdevbin\jdev\appslibrt\jazncore.jar;D:\OAF\jdevbin\bibeans\lib\biamlocal.jar;D:\OAF\jdevbin\bibeans\lib\bipres.jar;D:\OAF\jdevbin\bibeans\lib\bicmn.jar;D:\OAF\jdevbin\bibeans\lib\bidatasvr.jar;D:\OAF\jdevbin\bibeans\lib\bidataclt.jar;D:\OAF\jdevbin\bibeans\lib\bidatacmn.jar;D:\OAF\jdevbin\bibeans\lib\biext.jar;D:\OAF\jdevbin\bibeans\lib\bicmn-nls.zip;D:\OAF\jdevbin\bibeans\lib\bipres-nls.zip;D:\OAF\jdevbin\bibeans\lib\bidata-nls.zip;D:\OAF\jdevbin\bibeans\lib\olap_api.jar;D:\OAF\jdevbin\BC4J\lib\bc4jdomorcl.jar;D:\OAF\jdevbin\BC4J\jlib\bc4jdatum.jar;D:\OAF\jdevbin\jdev\appslibrt\rosettaRt.zip;D:\OAF\jdevbin\jdev\appslibrt\iasjoc.zip;D:\OAF\jdevbin\jdev\appslibrt\pat.zip;D:\OAF\jdevbin\jdev\appslibrt\patch_jars;D:\OAF\jdevbin\jdev\appslibrt\portalFlexComps.jar;D:\OAF\jdevbin\jdev\appslibrt\svc.zip;D:\OAF\jdevbin\jdev\appslibrt\svctester.jar;D:\OAF\jdevbin\lib\xml.jar;D:\OAF\jdevbin\BC4J\lib\adfm.jar;D:\OAF\jdevbin\BC4J\jlib\adfui.jar;D:\OAF\jdevbin\BC4J\lib\adfbinding.jar;" oracle.jbo.jbotester.MainFrame -X 156A6DEE716 -H "jar:file:/D:/OAF/jdevbin/jdev/doc/studio_doc/ohj/bc4j_f1.jar!/bc4j_f1.hs"

Aug 20, 2016 12:34:01 PM oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig

INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found

java.lang.IllegalArgumentException: Unknown signal: ALRM

at sun.misc.Signal.<init>(Signal.java:126)

at oracle.apps.fnd.framework.AppsDiagnosticsHandler.install(Unknown Source)

at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.initializeSignalHandler(Unknown Source)

at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.<clinit>(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:247)

at oracle.jbo.common.java2.JDK2ClassLoader.loadClassForName(JDK2ClassLoader.java:38)

at oracle.jbo.common.JBOClass.forName(JBOClass.java:164)

at oracle.jbo.common.JBOClass.findCustomClass(JBOClass.java:177)

at oracle.jbo.server.ApplicationModuleDefImpl.loadFromXML(ApplicationModuleDefImpl.java:836)

at oracle.jbo.server.ApplicationModuleDefImpl.loadFromXML(ApplicationModuleDefImpl.java:770)

at oracle.jbo.server.MetaObjectManager.loadFromXML(MetaObjectManager.java:534)

at oracle.jbo.mom.DefinitionManager.loadLazyDefinitionObject(DefinitionManager.java:587)

at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:449)

at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:382)

at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:364)

at oracle.jbo.server.MetaObjectManager.findMetaObject(MetaObjectManager.java:700)

at oracle.jbo.server.ApplicationModuleDefImpl.findDefObject(ApplicationModuleDefImpl.java:232)

at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:401)

at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:91)

at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:139)

at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:80)

at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:2468)

at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:536)

at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2094)

at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1961)

at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2793)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:453)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)

at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:419)

at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1546)

at oracle.jbo.client.Configuration.createRootApplicationModuleFromConfig(Configuration.java:1519)

at oracle.jbo.jbotester.ConnectionInfo.useApplicationModule(ConnectionInfo.java:129)

at oracle.jbo.jbotester.MainFrame.init(MainFrame.java:410)

at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:394)

ADOP Errors and Solutions

Error:
Lines #(178-182):
              [EVENT]     Calling: /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl
              [STATEMENT] Output directory: /opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod
              [UNEXPECTED]Error occurred while executing "perl /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/opt/oracle/TEST/fs1/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -patchcontextfile=/opt/oracle/TEST/fs2/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -promptmsg=hide -console=off -patchtop=/opt/oracle/TEST/fs_ne/EBSapps/patch -mode=update -sessionid=7 -timestamp=20160416_143741 -workercount=32 -outdir=/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod -autoskip=No"
              [UNEXPECTED]Error while runSyncFS sub-routine is called
              [PROCEDURE] [START 2016/04/16 14:39:50] Check and Stop patch Admin Server

Lines #(179-183):
              [STATEMENT] Output directory: /opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod
              [UNEXPECTED]Error occurred while executing "perl /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/opt/oracle/TEST/fs1/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -patchcontextfile=/opt/oracle/TEST/fs2/inst/apps/PROD_appsprod/appl/admin/PROD_appsprod.xml -promptmsg=hide -console=off -patchtop=/opt/oracle/TEST/fs_ne/EBSapps/patch -mode=update -sessionid=7 -timestamp=20160416_143741 -workercount=32 -outdir=/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod -autoskip=No"
              [UNEXPECTED]Error while runSyncFS sub-routine is called
              [PROCEDURE] [START 2016/04/16 14:39:50] Check and Stop patch Admin Server
                [EVENT]     [START 2016/04/16 14:39:51] Check and Stop patch FS Admin Server

Lines #(188-192):
                [EVENT]     [END   2016/04/16 14:39:59] Check and Stop patch Node Manager
              [PROCEDURE] [END   2016/04/16 14:39:59] Check and Stop patch Node Manager
              [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.
              [STATEMENT] SQL statement : "  update ad_adop_sessions
  set status='F'

/opt/oracle/TEST/fs_ne/EBSapps/log/adop/7/prepare_20160416_143741/PROD_appsprod/TXK_SYNC_update_Sat_Apr_16_14_39_29_2016/txkADOPPreparePhaseSynchronize_Sat_Apr_16_14_39_29_2016.log: 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Lines #(502-504):
TIME    : Sat Apr 16 14:39:50 2016
FUNCTION: main::execADPATCH [ Level 1 ] 
ERRORMSG: Application of patch did not go through successfully.


in abort.log file if you found these lines:

create or replace package APPS_DDL AUTHID DEFINER as * ERROR at line 1: ORA-00955: name is already used by an existing object

Solution:

Execute below query:

select * from dba_objects where object_name like '%APPS_DDL%' and object_type not in ('PACKAGE','PACKAGE BODY'); 


Drop synonym appeared in above query output.

Oracle Clone keep pointing to Source Server

Error:

When Set enviornment desitnation clone keep pointing to source server, This is the bug and the solution is:

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

grep: /d01/oracle/TEST/fs1/inst/apps/TEST_pcltest/appl/admin/TEST_pcltest.xml: No such file or directory

Solution:

The issue is a bug (yet to be logged) caused when using similar hostname from Source and Target, eg test & pcltest been used for your systems, but we can easily work around the issue by modifying the node_info.txt file 

1. On Target nodes backup and then open 

/opt/oracle/TEST/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt 

/opt/oracle/TEST/fs2/FMW_Home/Oracle_EBS-app1/applications/oacore/APP-INF/node_info.txt 

Linux Errors and Solutions

Error:
Package kit error

Solution
kill the pid in the list

----------------------------------------

Error:
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Solution
rpm --import http://oss.oracle.com/ol6/RPM-GPG-KEY-oracle

rpm -q gpg-pubkey-ec551f03-4c2d256a

Oracle EBS API Errors and Solutions

Error:

ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02902: Multi-Org profile option is required. Please set either MO: Security Profile or MO: Operating Unit profile option.

Solution:

Set Master Operating Unit at Site Level

Oracle Business Intelligence Application Errors and Solutions

Error:
In results tab following error start occuring:

Error
	View Display Error
	Error getting drill information: SELECT "Requisition Details"."Destination Type" saw_0 FROM "Procurement and Spend - Purchase Requisitions"   Error Details Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads Odbc driver returned an error (SQLSetStmtAttrW). State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. [nQSError: 12008] Unable to connect to port 9703 on machine testbi.fatima-group.com. (08004) SQL Issued: {call NQSGetLevelDrillability('SELECT "Requisition Details"."Destination Type" saw_0 FROM "Procurement and Spend - Purchase Requisitions"')}

Refresh

Solution:

---------------------------------------------------------------------------------------------------------

Error:
Source Extract and Load Error

Return Code

20942

Message

ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_ITEMCOSTGENERAL (5405500) fails with return code 20942. ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s). ODI-1232: Procedure Diagnostics Raise Exception execution fails. ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84) at java.lang.Thread.run(Thread.java:662)

Solution:


-----------------------------------------------------------------------------------------

Error:
While login to analytics Oracle Business Intelligence 11.1.1.x from a url like
http://<hostname>:9704/analytics

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error


The server encountered an unexpected condition which prevented it from fulfilling the request.

Solution:

Start OPMN Services 

1. export ORACLE_INSTANCE=/opt/OBI_Home/Middleware/instances/instance1 
2. cd /opt/OBI_Home/Middleware/Oracle_BI1/opmn/bin 
3. ./opmnctl stopall 

4. ./opmnctl startall

if still issue did not resolve follow the document.

Doc ID 1921886.1

-----------------------------------------------------------------------------------------


Error:
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_BOMITEMFACT_EXPLOSION (3326500) fails with return code 6576. 
ODI-1226: Step TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 fails after 1 attempt(s). 
ODI-1232: Procedure TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 execution fails. 
ODI-1228: Task TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 (Procedure) fails on the target ORACLE connection TEST. 
Caused By: java.sql.SQLException: ORA-06576: not a valid function or procedure name 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) 

Solution:

Please apply the patch Doc ID 1923841.1 based on source EBS version.  -------------------------------------------------------------------------------------------------------------------------


Error:
While executing Domain Load Plan in Oracle Business Intelligence OBIA 11.1.1.10.1

ODI-1519: Serial step "Start Load Plan (InternalID:8910500)" failed because child step "Global Variable Refresh (InternalID:8911500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:8911500)" failed because child step "1 Domain (InternalID:8918500)" is in error.
ODI-1519: Serial step "1 Domain (InternalID:8918500)" failed because child step "2 Domain SDE (InternalID:8995500)" is in error.
ODI-1519: Serial step "2 Domain SDE (InternalID:8995500)" failed because child step "Serial (InternalID:8996500)" is in error.
ODI-1519: Serial step "Serial (InternalID:8996500)" failed because child step "3 SDE General Domain (InternalID:9035500)" is in error.
ODI-1519: Serial step "3 SDE General Domain (InternalID:9035500)" failed because child step "Load Target Table (InternalID:9036500)" is in error.
ODI-1519: Serial step "Load Target Table (InternalID:9036500)" failed because child step "EBS_12_2 - DSN 1 (InternalID:9037500)" is in error.
ODI-1519: Serial step "EBS_12_2 - DSN 1 (InternalID:9037500)" failed because child step "DOMAIN (InternalID:9038500)" is in error.
ODI-1519: Serial step "DOMAIN (InternalID:9038500)" failed because child step "Parallel (InternalID:9039500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:9039500)" failed; 12 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step.  Failed child steps: SERVICE (InternalID:9291500), MFG (InternalID:9309500), FINANCIALS (InternalID:9173500), SOURCING (InternalID:9241500), EAM (InternalID:9329500), ORDER_MANAGEMENT (InternalID:9252500), PROJECTS (InternalID:9199500), COMMON (InternalID:9040500), COST (InternalID:9263500), HUMAN_RES (InternalID:9082500), PROC (InternalID:9221500), SUPP_CHAIN (InternalID:9286500)
ODI-1518: Parallel step "SERVICE (InternalID:9291500)" failed; 11 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step.  Failed child steps: SDE_ORA_DOMAINGENERAL_ACTIVITY_PRIORITY (InternalID:9295500), SDE_ORA_DOMAINGENERAL_ACTIVITY_STATUS (InternalID:9296500), SDE_ORA_DOMAINGENERAL_ACTIVITY_CATEGORY (InternalID:9297500), SDE_ORA_DOMAINGENERAL_AGREEMENTTYPE (InternalID:9294500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_BILLINGTYPE (InternalID:9303500), SDE_ORA_DOMAINGENERAL_FND_LOOKUPS AGREEITEM_BILLING_TYPE (InternalID:9307500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_AREA (InternalID:9302500), SDE_ORA_DOMAINGENERAL_AGREEITEMTYPE (InternalID:9293500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_STATUS (InternalID:9304500), SDE_ORA_DOMAINGENERAL_FND_LOOKUPS_ASSET_ACCOUNTING_MTHD (InternalID:9308500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_SEVERITY (InternalID:9305500)
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_DOMAINGENERAL_ACTIVITY_PRIORITY (472500) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942:
ORA-06512: at line 49

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:662)

Solution:

Check your Source Connection Details again

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Error:
java.io.FileNotFoundException: /opt/OBI_Home/BIAPPS/Oracle_BI1/oui/bin/oneclick.properties (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:146)
at java.io.FileInputStream.<init>(FileInputStream.java:101)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.loadProperties(OiocOneClickInstaller.java:514)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.init(OiocOneClickInstaller.java:379)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createFrameElements(OiocOneClickInstaller.java:365)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2171)
Exception in thread "main" java.lang.NullPointerException
at oracle.sysman.oio.oioc.OiocOneClickInstaller.setListProps(OiocOneClickInstaller.java:574)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.loadProperties(OiocOneClickInstaller.java:538)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.init(OiocOneClickInstaller.java:379)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createFrameElements(OiocOneClickInstaller.java:365)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2171)

Solution:

There is no need to execute config.sh as you have installed OBIEE through Enterprise install mode or config.sh has already been executed.
-----------------------------------------------------------------------------------------------------------------------------------------------------------

Error:

The JDK wasn’t found in the directory

Please edit this script so that the JAVA_HOME variable points to the location of your JRE”

Solution:

1) In a seperate window Locate the file CommEnv.cmd in $MIDDLEWARE_HOME\wlserver_10.3\common\bin\

2) Make a copy of the CommEnv.cmd file for backup purposes

3) Edit the CommEnv.cmd file to include the JAVA_HOME

For example:

@rem Reset JAVA Home
set  JAVA_HOME=D:\Oracle\Middleware\Oracle_BI1\jdk
FOR %%i IN ("%JAVA_HOME%") DO SET JAVA_HOME=%%~fsi

4) Save the file

5) Restart the nodemanager and continue with your config

-------------------------------------------------------------------------------------------------------------------

Error:
***************************************************************************
The WebLogic Server encountered a critical failure
Reason: Assertion violated
***************************************************************************
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class weblogic.protocol.ServerIdentityManager$Initializer
        at weblogic.protocol.ServerIdentityManager.findServerIdentity(ServerIdentityManager.java:65)
        at weblogic.protocol.URLManager.findAdministrationURL(URLManager.java:173)
        at weblogic.server.ServerLifeCycleRuntime.getLifeCycleOperationsRemote(ServerLifeCycleRuntime.java:1203)
        at weblogic.server.ServerLifeCycleRuntime.getLifeCycleOperationsRemote(ServerLifeCycleRuntime.java:1232)
        at weblogic.t3.srvr.ServerRuntime.sendStateToAdminServer(ServerRuntime.java:421)
        at weblogic.t3.srvr.ServerRuntime.updateRunState(ServerRuntime.java:407)
        at weblogic.t3.srvr.T3Srvr.setState(T3Srvr.java:209)
        at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:505)

        at weblogic.Server.main(Server.java:71)

Solution

-------------------------------------------------------------------------------------------------

Error:
ORA-14400: inserted partition key does not map to any partition .

Soluion:

Execute below statement and recheck:
 ALTER TABLE OBI_DW.W_AR_XACT_F SET INTERVAL(1); 

Oracle EBS Customer Upload Error and Solutions

Error:
Value for cust_account_id - party_site_id must be unique.

Solution:
Both sites are same, one should be in different org etc.

Oracle Inventory UOM Class Conversion

INV_CONVERT.CREATE_UOM_CONVERSION

SET SERVEROUTPUT ON;

DECLARE

    p_from_uom_code    VARCHAR2(200);
    p_to_uom_code      VARCHAR2(200);
    p_item_id          NUMBER;
    p_uom_rate         NUMBER;
    x_return_status    VARCHAR2(200);
    l_msg_data         VARCHAR2(2000); 
    v_context          VARCHAR2(100);

    CURSOR c IS
        select * 
        from cust_uom_api
        where line_id between 1 and 100;


        FUNCTION set_context( i_user_name    IN  VARCHAR2
                             ,i_resp_name    IN  VARCHAR2
                             ,i_org_id       IN  NUMBER)
        RETURN VARCHAR2
        IS
            v_user_id             NUMBER;
            v_resp_id             NUMBER;
            v_resp_appl_id NUMBER;
            v_lang                   VARCHAR2(100);
            v_session_lang VARCHAR2(100):=fnd_global.current_language;
            v_return              VARCHAR2(10):='T';
            v_nls_lang          VARCHAR2(100);
            v_org_id              NUMBER:=i_org_id;
        /* Cursor to get the user id information based on the input user name */
        CURSOR cur_user
        IS
            SELECT     user_id
            FROM       fnd_user
            WHERE      user_name  =  i_user_name;
        /* Cursor to get the responsibility information */
        CURSOR cur_resp
        IS
            SELECT     responsibility_id
                             ,application_id
                            ,language
            FROM       fnd_responsibility_tl
            WHERE      responsibility_name  =  i_resp_name;
        /* Cursor to get the nls language information for setting the language context */
        CURSOR cur_lang(p_lang_code VARCHAR2)
        IS
            SELECT    nls_language
            FROM      fnd_languages
            WHERE     language_code  = p_lang_code;
        BEGIN
            /* To get the user id details */
            OPEN cur_user;
            FETCH cur_user INTO v_user_id;
            IF cur_user%NOTFOUND
            THEN
                v_return:='F';
               
            END IF; --IF cur_user%NOTFOUND
            CLOSE cur_user;

            /* To get the responsibility and responsibility application id */
            OPEN cur_resp;
            FETCH cur_resp INTO v_resp_id, v_resp_appl_id,v_lang;
            IF cur_resp%NOTFOUND
            THEN
                v_return:='F';
               
            END IF; --IF cur_resp%NOTFOUND
            CLOSE cur_resp;

            /* Setting the oracle applications context for the particular session */
            fnd_global.apps_initialize ( user_id      => v_user_id
                                        ,resp_id      => v_resp_id
                                        ,resp_appl_id => v_resp_appl_id);

            /* Setting the org context for the particular session */
            mo_global.set_policy_context('S',v_org_id);

            /* setting the nls context for the particular session */
            IF v_session_lang != v_lang
            THEN
                OPEN cur_lang(v_lang);
                FETCH cur_lang INTO v_nls_lang;
                CLOSE cur_lang;
                fnd_global.set_nls_context(v_nls_lang);
            END IF; --IF v_session_lang != v_lang

            RETURN v_return;
        EXCEPTION
        WHEN OTHERS THEN
            RETURN 'F';
        END set_context;


--------------------------------------------------------------------------

    
BEGIN
--1. Set applications context if not already set.
          
       FOR i IN c LOOP   
          
          BEGIN
            v_context := set_context('AFF','Inventory',101);
            IF v_context = 'F'
            THEN
               DBMS_OUTPUT.PUT_LINE('Error while setting the context'||SQLERRM(SQLCODE));       
            END IF;
          END;
          
    
    
    
          
          p_from_uom_code := i.to_code;  -- Should be a Base unit for Intra-class conversion
          p_to_uom_code := i.from_code;
          p_item_id := i.itemid;
          p_uom_rate := i.rate;
         
         /*
          p_from_uom_code := 'SQM';  -- Should be a Base unit for Intra-class conversion
          p_to_uom_code := 'KGS';
          p_item_id := 81797;
          p_uom_rate := 0.13;
         */
          INV_CONVERT.CREATE_UOM_CONVERSION
                          (
                            P_FROM_UOM_CODE => p_from_uom_code,
                            P_TO_UOM_CODE   => p_to_uom_code,
                            P_ITEM_ID       => p_item_id,
                            P_UOM_RATE      => p_uom_rate,
                            X_RETURN_STATUS => x_return_status
                          );
         
              IF x_return_status = 'S' Then
                 dbms_output.put_line(' Conversion Got Created Sucessfully ');
              ELSIF x_return_status = 'W' Then
                 dbms_output.put_line(' Conversion Already Exists ');
              ELSIF x_return_status = 'U' Then
                 dbms_output.put_line(' Unexpected Error Occured ');
              ELSIF x_return_status = 'E' Then     
                 LOOP
                   l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
                   IF l_msg_data is NULL Then
                   EXIT;
                   END IF;
                   DBMS_OUTPUT.PUT_LINE('Message:' || l_msg_data);
                 END LOOP;  
              END IF; 
    
        END LOOP;   
  

END; 




UPDATE_UOM_CONVERSIONS
Oracle Inventory Inter-Class update UOM Conversion rate API

declare
    mc NUMBER;
    md VARCHAR2(2000);
    rs VARCHAR2(2000);
BEGIN    
    INV_UOM_API_PUB.UOM_CONVERSION (
        --p_lot_number    IN VARCHAR2 DEFAULT NULL,
        p_from_uom_code =>'SQM',
        p_to_uom_code   => 'KGS',
        P_ITEM_ID       => 80718,
        --p_org_id        IN NUMBER DEFAULT NULL,
        p_uom_rate      => 0.06,
        --P_DISABLE_DATE  IN DATE DEFAULT NULL,
        --p_reason_id     IN NUMBER DEFAULT NULL,
        p_onhand_update =>1,
        p_update_type   =>1,
        p_action_type   => 'U',
        x_msg_count     =>   mc, --OUT nocopy NUMBER,
        x_msg_data      =>   md, --OUT nocopy VARCHAR2,
        x_return_status =>    rs);--OUT nocopy VARCHAR2 );
       
        dbms_output.put_line('SUCCESS:'||md);
        
EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('ERROR:'||SQLERRM);

END;