Create Settlement Batch Fails With Error ORA-20000 IBY_10003_ORA-06512 (Doc ID 2721360.1)

Last updated on JUNE 14, 2021

Applies to:

Symptoms

On Oracle Fusion Receivables Cloud Service: 11.13.20.07.0 version, Customer Payments (Receipts)

Create Settlement Batch to generate settlement file is failing with following error in ESS Log:

ERROR
-----------------------
oracle.apps.financials.payments.sharedSetup.formats.publicModel.util.ExtractGe
nerator::java.sql.SQLException: ORA-20000: IBY_10003_ORA-06512: at
_FUSION.IBY_EXTRACTGEN_PVT_, line 251_ORA-06512: at line 1_

oracle.apps.financials.payments.shared.util.publicModel.common.util.sql.SQLUti
ls::Processing SQLException: {sqlCode: 20000 errMessage: ORA-20000:
IBY_10003_ORA-06512: at _FUSION.IBY_EXTRACTGEN_PVT_, line 251_ORA-06512: at
line 1_}


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Funds Capture Dashboard
2. Submit Create Settlement Batches

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create settlement batch files

Cause

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