11i: Invoice Tax Not Being Computed Via Calculate Tax Button

(Doc ID 2014831.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Payables invoices are not getting tax stamped, neither after clicking the 'Calculate Tax' button, nor after running invoice validation, despite specifying the Tax Code on the distributions. Entering a manual tax line works without issue.

Expectation
The tax should be calculated as per the 'Calculate Tax' button / invoice validation.

Steps to reproduce
Several scenarios were tested as per the results below.  Note that the invoices are created within the same invoice batch.

1. Test 1: Auto-calculate tax with Tax Calculation = 'Line'
(a) Entered Invoice where header shows Tax Calculation = 'Line'
(b) Distribution item line shows Tax Code defaulted in. No Tax Code at header.
(c) Click 'Calculate Tax'. Status bar shows message "FRM-40400:Transaction complete. 2 records applied and saved." But tax did not get calculated.

2. Test 2: Manual tax line
(a) Entered Invoice where header shows Tax Calculation = 'None'
(b) Distributions for the invoice show Tax Code is stamped. Invoice Total and Distribution Total differ; the latter is in red text. The 'Calculate Tax' button is greyed out.
(c) Enter a manual Tax line to make up the difference. Invoice Total and Distribution Total equalize.

3. Test 3: Auto-calculate tax with Tax Calculation = 'None' but enter Tax Code at Line level
(a) Entered Invoice where header shows Tax Calculation = 'None'
(b) In Distributionm change the Tax Code. The 'Calculate Tax' button is greyed out.
(c) Don't enter a manual Tax line as part of a further test.

4. Test 4: Auto-calculate tax with Tax Calculation = 'Line' but enter Tax Code at Header level
(a) Entered Invoice where header shows Tax Calculation = 'Line'
(b) Don't enter a manual Tax line as part of a further test.

5. Online validate invoice in point 2. Success.

6. Online validate invoice in point 3. Status: Needs Revalidation. Hold: Dist Variance

7. Status of invoices at this point:
- Test 1: Never Validated: Tax Calculation at line withOUT Header Tax Code entry - did not compute Tax
- Test 2: Validated: TAX Calculation NONE - did not compute so entered TAX manually
- Test 3: Needs Revalidation: TAX Calculation NONE - but entered Tax Code at Line Level - did not compute Tax
- Test 4: Never Validated: TAX calculation at line with Header Tax Code entry - did not compute Tax

8. Run the Invoice Validation concurrent request and input the batch name.

9. Request completes in error. Log file shows the message below:

MSG-00001: EXCEPTION : INIT_FAILURE : User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
...
Validating invoice &invoice_number
No holds placed or released.
Batch validation of the invoice failed

Error : ORA-20001: APP-SQLAP-10301: No holds placed or released

Business impact
Cannot get the tax calculated on the invoice.

 

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