Column TAX_CURRENCY_CONVERSION_RATE is Null in the Table ZX_LINES for Lines with Amount Zero
(Doc ID 2436010.1)
Last updated on APRIL 27, 2021
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!
