Italian XML Invoice Failing After Updating Nature of VAT at the Tax Rate Level With ORA-06503: PL/SQL: Function returned without value ORA-06512: at "APPS.JE_IT_ELECTRONIC_INV_EXTRACT", line 2243
(Doc ID 2826601.1)
Last updated on DECEMBER 07, 2021
Applies to:Oracle Financials for EMEA - Version 12.1.3 and later
Information in this document applies to any platform.
As part of the Italian E-invoicing upgrade, the customer applied the Patch 33197523:R12.JE.C to bring in the E-Filing of Payables Invoices. The patch brought in the required packages and concurrent requests.
The users tested few existing invoices in AP (Payables) and the XML got generated with the below error, when the users add a 'Nature of VAT' to the tax rate code. The error can be seen in the log file of the Italy E-Filing of Payables Invoices report.
[110321_052936436][STATEMENT] 1: trx_id:XXXXXXXX
java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.JE_IT_ELECTRONIC_INV_EXTRACT", line 2243
Steps to reproduce the issue
The issue can be reproduced at will with the following steps:
1. Apply the Patch 33197523
2. Go to Italian Localizations Responsibility
3. Navigate to View > Request > Submit a New Request
4. Run Italy E-Filing of Payables Invoices > generated Italy E-Filing of Payables Invoices XML File Output > got error in the log file
Apply the Patch 33197523:R12.JE.C
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