My Oracle Support Banner

TAX_CURRENCY_CONVERSION_RATE IS NULL IN ZX_LINES FOR LINES WITH 0 AMOUNT (Doc ID 2436010.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receivables Uptake of EBTAX

ACTUAL BEHAVIOR
---------------
In ZX_LINES table the filed TAX_CURRENCY_CONVERSION_RATE is null for lines with 0 amount; the expected value is 0 - as it's available in field TAX_AMT and TAX_AMT_TAX_CURR

The rest of invoice lines are having populated the TAX_CURRENCY_CONVERSION_RATE with correct value

EXPECTED BEHAVIOR
-----------------------
In ZX_LINES table the filed TAX_CURRENCY_CONVERSION_RATE should be populated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Receivables Manager
2. Navigation: Transactions > Transactions
3. Create a new transaction

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the transaction has incorrect data.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.