R12: European Sales Listing Report (ZXXEUSL) Does Not Display Migrated Transactions (Doc ID 2116802.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
On Oracle E-Business Suite, 12.2 version, Migration from 11i, on Tax Reporting.
While running the European Sales Listing Report notice that the output of the report displays only the newly created transactions and not the migrated ones as well.


EXPECTED BEHAVIOR
-----------------------
Expect the report to display all data for the period for which the report is run. 

 

WHAT IS WORKING
-----------------------------
Newly created transactions are displayed on the report.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Tax Manager
2. Navigation: Requests > Submit Requests > Query the European Sales Listing Report
3. Enter the parameters and run the report > Review the output and see that the migrated transactions are not displayed.

 

Changes

For the migrated transactions the HQ_ESTB_REG_NUMBER is NULL in ZX_LINES and HQ_ESTB_PARTY_TAX_PROF_ID is null in ZX_LINES_DET_FACTORS.

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