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

Last updated on SEPTEMBER 06, 2016

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 PPR Includes Zero Amount Payment

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.


ERROR
-----------------------
ORA-06512; ORA-01422; ORA-01854

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

 

Changes

 N/A

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms