R12: ORA-20007 Unable to Apply Prepayment to the Standard Invoice (Doc ID 1645580.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Financials for India - Version 12.2.2 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.2 version, Invoices Prepayment Issues

When attempting to apply a prepayment which is not having TDS tax on a standard invoice which is having TDS
the following error occurs.

APP-SQLAP-10000: occurred in Apply_Prepay_Line     with parameters (& PARAMETERS) while performing the following operation: Distribute Tax.

1. Responsibility: Oracle Payables - India localization - 12.2.2
2. Path: Invoices -> Entry -> Invoices
3. Query an invoice
4. Try to apply a prepayment on the invoice
The following error occurs:

APP-SQLAP-10000: occurred in Apply_Prepay_Line  with parameters (& PARAMETERS) while performing the following operation: Distribute Tax.

Prepayment invoice does not have tds code attached to it while standard invoice has tds code attahced to it.
Both the invoices have been generated and tds invoices have been created for standard invoices.

5. FND Debug

JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.allocate_prepay_section().BEGIN JAI_AP_DTC_PREPAYMENTS_PKG: allocate_prepay_section()()+
JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.allocate_prepay_section() Loop1 ln_application_amount:1390091
JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.allocate_prepay_section() Loop2 ln_application_amount:1390091
JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.allocate_prepay_section().END JAI_AP_DTC_PREPAYMENTS_PKG: allocate_prepay_section()()-

 

JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 Error on ap_invoice_distributions_all : ORA-20007: Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : Cannot Apply Prepayment across TDS Section Codes


ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY RETURN_STATUS = E
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY Expected Error raised for Trx_id55162
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY Return Status after Recovery Determination : E
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 0 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()-
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY.Statistics Start Time :13-03-2014 13:41:20
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY.Statistics End Time :13-03-2014 13:41:20
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY.Statistics Total Time :0:0:0
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY.Statistics Number of records in ZX_TRX_HEADERS_GT :1
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY.Statistics Number of records in ZX_TRANSACTION_LINES_GT :2
AP.PLSQL.AP_ETAX_SERVICES_PKG.Distribute Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log

"APP-SQLAP-10000: occurred in
Apply_Prepay_Linewith parameters (&PARAMETERS)
while performing the following operation:
Distribute tax"



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply the prepayment to standard invoice.
Period Closure.

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