JGZZVATSP module: EMEA VAT: Selection Process Inserted 0 Records

(Doc ID 2013675.1)

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.

Symptoms

On : 12.1.3 version, Spanish Localizations for AR

ACTUAL BEHAVIOR

 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


 
EXPECTED BEHAVIOR

 Expect the process to insert data for the AR transactions


STEPS

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.


BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot run the EMEA VAT reports.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms