EMEA Localization: Italy VAT reports are getting error out (Doc ID 2697186.1)

Last updated on AUGUST 03, 2020

Applies to:

Symptoms

Italy VAT reports are getting error out .

ERROR
-----------------------

1. IT Purchase VAT Register

** Inside BeforeReport **
Fetching Register name...
Before Report Trigger
Calling jg_zz_common_pkg.tax_registration
JG_ZZ_VAT_REP_UTILITY.get_period_status
Error occurred in beforeReport.ORA-01403: no data found100

2. IT Sales VAT Register

before Report Trigger
Calling jg_zz_common_pkg.tax_registration
Calling jg_zz_common_pkg.company_detail
An error occured in the before report trigger. Exception : ORA-01403: no data found100


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Italy Localization Responsibility
2. Run IT Purchase VAT Register or IT Sales VAT Register
3. Program is getting error out

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate the output

Changes

Cause

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