APP-SQLAP-10000

Try To Apply Prepayment To Invoice Receive Error 'APP-SQLAP-10000' [ID 984524.1]

Applies to:

Oracle Payables - Version: 12.0.0 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.
APXINWKB.fmb
zxifsrvctypspkgb.pls

Symptoms

Problem:

While try to apply prepayment to invoice, Receive error
"APP-SQLAP-10000: An unexpected error has occurr occurred in Apply_Prepay_Line<-Apply Prepayment Form with parameters (&PARAMETERS)
while performing the following operation:
Call to calculate tax"

Steps To Reproduce:
1. Enter an invoice
2. Validate the invoice
3. Go to the actions button > check on apply prepayment
4. Select the prepayment and save
5. The error displays

Business Impact:
Users do not have the right functionality

Cause

Invoice had more than 1000 ITEM lines. The line numbers are not in sequence. Also, there are various line level action - CREATE, UPDATE and DISCARD.

There are cases where line number of 'CREATE' record is lesser than line number of 'UPDATE', 'DISCARD' records. This is because of the GAP left in invoice while entering, while applying prepayment to such an invoice, while updating lines detfactors (this is a tax less invoice and prepayment), system throws an error 'Element at index does not exist'.

Not all the columns used in the update are being fetched. 2 columns added: tax_processing_completed_flag and tax_processing_done_flag

The issue has been fixed in zxifsrvctypspkgb.pls package.

Issue discussed in BUG 8873180 - ERROR APP-SQLAP-10000 WHEN TRY TO APPLY PREPAYMENT TO INVOICE

Solution

1) Please download and review the readme for Patch 8873180:R12.ZX.A

2) Please apply patch in a test environment.

3) Please confirm the following file versions:
         $ZX_TOP/patch/115/sql/zxifsrvctypspkgb.pls 120.230.12000000.73
    You can use the commands like the following:
         strings -a ffffffff |grep '$Header'

4) Please retest the issue.

5) If the issue is resolved, please migrate the solution as appropriate to other environments.