Jai_ap_dtc_prepayments_pkg.allocate_prepay_section :ORA-01001: Invalid Cursor (Doc ID 2129390.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT
 =================
 On : 12.2.4 version, Tax Deducted at Source-Payables
 
 When attempting to apply a prepayment on an invoice,
 the following error occurs.

 ERROR
 -----------------------
 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 :
 jai_ap_dtc_prepayments_pkg.allocate_prepay_section :ORA-01001: invalid cursor
 
STEPS
 -----------------------
 The issue can be reproduced at will with the following steps:
 1. Create prepayment with 3 ITEM lines.
  1. Line 1 ==> TDS applied.
  2. Line 2 ==> No TDS
  3. Line 3 ==> No TDS
 2. Validate the invoice and make the prepayment "Available"
 3. Create the Standard Invoice (1 ITEM & 2 MISC. lines)
  1. Line 1 ==> With TDS (Amount = PP line 1 amount)
  2. MISC 1 ==> No TDS (Amount = PP line 2 amount)
  3. MISC 2 ==> No TDS (Amount = PP line 3 amount)
 4. Validated the invoice
 5. Try applying the prepayment onto the validated standard invoice.
 6. Observed the above error and could not able to apply the prepayment.

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

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