R12: ORA-20007 Unable to Apply Prepayment to the Standard Invoice
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.
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.
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()()-
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
Apply_Prepay_Linewith parameters (&PARAMETERS)
while performing the following operation:
The issue has the following business impact:
Due to this issue, users cannot apply the prepayment to standard invoice.
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