My Oracle Support Banner

R12:IBY:Payment Process Profiles Migration Errored Out When Process From One Instance To Another Instance. (Doc ID 2141365.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Payments - Version 12.2.5 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to move payment process profile from one instance to another instance by iSetup the following error occurs

ERROR
-----------------------

**************************************************************************
*** WARNING: Oracle BC4J debug build executing - do not use for timing ***
**************************************************************************
Mar 16, 2016 4:11:46 PM oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found

***********************************************************
Execution is finished for API [Entity Name: Payment Process Profile, Api Code=IBY_PaymentProcessProfile]
API Type: BC4J
Executable Path: oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfAM
Ignore Warnings and Continue: No
Update Existing Records: Yes
oracle.apps.fnd.framework.OARowValException: Application: AZ, Message Name: AZW_FWK_ENTITY_EXCEPTION. Tokens: APINAME = null; ENTITYNAME = IbyAcctPmtProfilesEO; KEY = Payment Profile Id = '&id';
at oracle.apps.az.fwk.server.BEEntityImpl.wrapperEntityException(BEEntityImpl.java:408)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:246)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4614)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:230)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2648)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getIbyAcctPmtProfilesVO(Unknown Source)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getAttrInvokeAccessor(Unknown Source)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.az.fwk.server.BEExport.xmlDisplayViewObjectAttributes(BEExport.java:603)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:377)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:274)
at oracle.apps.az.fwk.server.BEApplicationModuleImpl.exportToXML(BEApplicationModuleImpl.java:361)
at oracle.apps.az.r12.api.BC4JAPI.exportAPI(BC4JAPI.java:326)
at oracle.apps.az.r12.extractor.cpserver.APIExtractor$APIExecuter.run(APIExtractor.java:728)
## Detail 0 ##
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO IBY_ACCT_PMT_PROFILES_B(PAYMENT_PROFILE_ID,SYSTEM_PROFILE_CODE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER) VALUES (?,?,?,?,?,?,?,?)".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:569)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5743)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbyAcctPmtProfilesEOImpl.doDML(IbyAcctPmtProfilesEOImpl.java:115)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:230)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4614)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:230)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2648)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getIbyAcctPmtProfilesVO(Unknown Source)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getAttrInvokeAccessor(Unknown Source)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.az.fwk.server.BEExport.xmlDisplayViewObjectAttributes(BEExport.java:603)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:377)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:274)
at oracle.apps.az.fwk.server.BEApplicationModuleImpl.exportToXML(BEApplicationModuleImpl.java:361)
at oracle.apps.az.r12.api.BC4JAPI.exportAPI(BC4JAPI.java:326)
at oracle.apps.az.r12.extractor.cpserver.APIExtractor$APIExecuter.run(APIExtractor.java:728)
## Detail 0 ##
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("IBY"."IBY_ACCT_PMT_PROFILES_B"."CREATED_BY")

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.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5743)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbyAcctPmtProfilesEOImpl.doDML(IbyAcctPmtProfilesEOImpl.java:115)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:230)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4614)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.apps.az.fwk.server.BEEntityImpl.postChanges(BEEntityImpl.java:230)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2648)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getIbyAcctPmtProfilesVO(Unknown Source)
at oracle.apps.iby.ispeed.paymentprocessprofile.server.IbySysPmtProfilesVORowImpl.getAttrInvokeAccessor(Unknown Source)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.az.fwk.server.BEExport.xmlDisplayViewObjectAttributes(BEExport.java:603)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:377)
at oracle.apps.az.fwk.server.BEExport.exportToXML(BEExport.java:274)
at oracle.apps.az.fwk.server.BEApplicationModuleImpl.exportToXML(BEApplicationModuleImpl.java:361)
at oracle.apps.az.r12.api.BC4JAPI.exportAPI(BC4JAPI.java:326)
at oracle.apps.az.r12.extractor.cpserver.APIExtractor$APIExecuter.run(APIExtractor.java:728)
....

Status of API [Entity Name: Payment Process Profile, Api Code=IBY_PaymentProcessProfile] : ERROR
***********************************************************

Extract failed:
java.lang.Exception: API execution terminated because of error
at oracle.apps.az.r12.extractor.cpserver.APIExtractor.callAPIs(APIExtractor.java:190)
at oracle.apps.az.r12.extractor.cpserver.ExtractorContextImpl.export(ExtractorContextImpl.java:61)
at oracle.apps.az.r12.extractor.cpserver.ExtractorCp.runProgram(ExtractorCp.java:63)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

Concurrent program completed for Extract.
End - iSetup ExtractorCp.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run the extraction job in iSetup

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot transfer PPP from one instance to another

Changes

Upgrade from 11.5.10 to 12.2.5

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.