JGZZVATSP module: EMEA VAT: Selection Process Inserted 0 Records
Last updated on MAY 05, 2016
Applies to:Oracle Financials for EMEA - Version 12.1.3 and later
Oracle Financials Common Country - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Spanish Localizations for AR
EMEA VAT: Selection Process does not insert records in jg_zz_vat_trx_Details. The log shows the following:
Record successfully inserted = 0
Also the FND Debug Log shows the below error:
ZX.TRL.ZX_AR_POPULATE_PKG.update_additional_info : -6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Expect the process to insert data for the AR transactions
The issue can be reproduced at will with the following steps:
1. Run the EMEA VAT: Selection Process for AR transactions.
2. The log shows no records inserted.
The issue has the following business impact:
Due to this issue, users cannot run the EMEA VAT reports.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms