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

Last updated on APRIL 04, 2025

Applies to:

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

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