My Oracle Support Banner

R12: AP: Format Payment Instructions with Text Output Completed with Error: ORA-06512: at "APPS.CLE_F147_AP_ENDBAT_AIR1" (Doc ID 2827723.1)

Last updated on OCTOBER 12, 2024

Applies to:

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

Symptoms

Program "Format Payment Instructions with Text Output" (IBY_FD_PAYMENT_FORMAT_TEXT) completed with error:

Inside  the handleProgramException---  : iby.scheduler.FDExtractAndFormatting.runProgram()
oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.
at oracle.apps.iby.scheduler.FDExtractAndFormatting.postResults(FDExtractAndFormatting.java:583)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:357)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:179)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)

ex:oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.iby.scheduler.FDExtractAndFormatting.runProgram()
An error has occured while updating instruction and payment statuses and marking them as complete.
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.
CP main completed runProgram for oracle.apps.iby.scheduler.FDExtractAndFormatting

...

insert into ap_checks_all - 01-NOV-21 10:18:25.140467000 -07:00
ERROR Code : 100
ERROR Msg : ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.CLE_F147_AP_ENDBAT_AIR1", line 10
ORA-04088: error during execution of trigger 'APPS.CLE_F147_AP_ENDBAT_AIR1'
AP.PLSQL.AP_PMT_CALLOUT_PKG..payments_completed - insert into ap_checks_all - 01-NOV-21 10:18:25.304345000 -07:00
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Fatal: External app callout 'AP_PMT_CALLOUT_PKG.payments_completed', generated exception.
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL code: -20001
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL err msg: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.CLE_F147_AP_ENDBAT_AIR1", line 10
ORA-04088: error during execution of trigger 'APPS.CLE_F147_AP_ENDBAT_AIR1' occurred in
AP_PMT_CALLOUT_PKG.payments_completed
with parameters (Complted Payments Group id  = 71038)
while performing the following operation:
insert into ap_checks_all
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Exception occured when marking payments complete for payment instruction 80291
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQLCODE: -20001
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQLERRM: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.CLE_F147_AP_ENDBAT_AIR1", line 10
ORA-04088: error during execution of trigger 'APPS.CLE_F147_AP_ENDBAT_AIR1' occurred in
AP_PMT_CALLOUT_PKG.payments_completed
with parameters (Complted Payments Group id  = 71038)
while performing the following operation:
insert into ap_checks_all
Exit Mark Pmts Complete: Timestamp:01-NOV-21 10:18:25.307240000 -07:00
iby.plsql.IBY_FD_POST_PICP_PROGS_PVT.Post_Results:Error - Marking payment instruction
iby.plsql.IBY_FD_POST_PICP_PROGS_PVT.Post_Results:SQLCODE: 1
iby.plsql.IBY_FD_POST_PICP_PROGS_PVT.Post_Results:SQLERRM: User-Defined Exception

 

 

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Payables Responsibility
2. Payment -> Entry
3. Submit PPR


Changes

 

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


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