My Oracle Support Banner

R12: IBY: Format Payment Instructions Ends In Error (ORA-01422 ; ORA-01854) If Payment Process Request (PPR) Includes Zero Amount Payment (Doc ID 1611372.1)

Last updated on JUNE 20, 2019

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Format Payment Instructions Ends in Error If Payment Process Request (PPR) Includes Zero Amount Payment

 

ORA-06512; ORA-01422; ORA-01854

User is using a standard format.
User is able to create zero payment from Payment Workbench.
Internal bank account is set up for more than one payment document.
The issue is reproducible either using template while running PPR or not using the template.
There is no invalid objects.



Format Payment Instructions Log:
--------------------------------------------------

End doExtractAndFormatCore Timestamp: Thu Nov 21 11:39:01 GMT-07:00 2013
No extract has been previously created. Create extract.Timestamp: Thu Nov 21 11:39:01 GMT-07:00 2013
java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:85)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:234)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:90)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:456)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353
ORA-06512: at line 1


at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:234)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:90)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:456)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

SQLException occurred: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353
ORA-06512: at line 1


An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Enter:TIMESTAMP::iby.plsql.IBY_FD_EXTRACT_GEN_PVT.Create_Extract_1_0:: 21-NOV-13 11.39.02.172324000 AM -07:00
Enter:TIMESTAMP:: ExtractMainiby.plsql.IBY_FD_EXTRACT_GEN_PVT.Create_Extract_1_0:: 21-NOV-13 11.39.02.180663000 AM -07:00
Enter Get_Ins_PayerInstrAgg -Timestamp:21-NOV-13 11.39.02.500117000 AM -07:00
11:39:03  Debug: Program Step = IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg ,  Message Text = EXCEPTION in Get_Pmt_Ext_Agg ORA-01422: exact fetch returns more than requested number of rows
11:39:03  Debug: Program Step = IBY_FD_EXTRACT_EXT_PUB.Get_Pmt_Ext_Agg ,  Message Text = EXCEPTION in Get_Pmt_Ext_Agg ORA-01854: julian date must be between 1 and 5373484
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

 

PPR Data Collector:

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

IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS = PAYMENTS_CREATED
IBY_PAY_SERVICE_REQUESTS.ALLOW_ZERO_PAYMENTS_FLAG = Y
IBY_DOCS_PAYABLE_ALL.DOCUMENT_STATUS = PAYMENT_CREATED
IBY_PAYMENTS_ALL.PAYMENT_STATUS = INSTRUCTION_CREATED
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_INSTRUCTION_STATUS = CREATED_READY_FOR_PRINTING
CE_BANK_ACCOUNTS.ZERO_AMOUNT_ALLOWED = Y
IBY_FORMATS_B.FORMAT_CODE = IBY_PAY_CHK_STANDARD_1
IBY_FORMATS_B.FORMAT_TYPE_CODE = OUTBOUND_PAYMENT_INSTRUCTION
IBY_FORMATS_B.FORMAT_TEMPLATE_CODE = IBYDC_STD1

 

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
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.