My Oracle Support Banner

JEITLSTR - Italian Annual Customer And Supplier Listing File Has A Wrong Group By (Doc ID 566627.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Financials for EMEA - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.
jeitcp.ldt
jeitlstb.pls
jeitlsts.pls

Symptoms

The Italian Annual Customer and Supplier Listing file has a wrong file format.

If you have two or more suppliers with the same tax registration number/tax payer id but different
supplier name - in the file you will have two or more records for this tax registration number/tax payer
id. When you will try to send this file to the fiscal autority file will be rejected because each tax
registration number/tax payer id should be only once in the file (as specified in the instruction
document for this file)


The issue can be reproduced at will with the following steps:
Create two suppliers with different supplier names and the same tax registration number/tax
payer id -
Make one VAT invoice for one supplier and one for the other
Run the Italian Annual Customer/Supplier List
Check the file you will have the same tax registration number/tax payer id two times



Changes

 

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
Changes
Cause
Solution
References


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