My Oracle Support Banner

R12: JE: Italy E-Filing Of Payables Invoices XML File Running With Error: ORA-00904: "JE_IT_ELECTRONIC_INV_EXTRACT"."GET_REPORTING_CODE": invalid identifier (Doc ID 2847385.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Oracle Financials for EMEA - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

While attempting to run Italy e-Filing of Payables Invoices XML File, the following error is displayed in the log of the report :

java.sql.SQLSyntaxErrorException: ORA-00904: "JE_IT_ELECTRONIC_INV_EXTRACT"."GET_REPORTING_CODE": invalid identifier



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Italian AP localization responsibility
2. Go to View > Requests > Submit a new request
3. Run 'Italy E-filing Payables Invoices'


Changes

Apply patch 33521221

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.