GP ESP - CRA Report Generates <Error of assignment to "12568375,00": GPES_SS_CRA_RPT.GPES_SSTC_AMOUNT> (Doc ID 2044187.1)

Last updated on AUGUST 16, 2015

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

According to Social Security requests in Red Bulletin 8/2014, October 14th, the length of the segments of the CRA report was expanded so they could show amounts of 9 digits, (formerly showed 7 digits).
The change was applied on the CRA report but not on the field that stores the amount in the table GPES_SS_CRA_RPT (The field GPES_SSTC_AMOUNT)
When user exceeds this length, the CRA process ends incorrect with the following error:

Error of assignment to "12568375,00": GPES_SS_CRA_RPT.GPES_SSTC_AMOUNT. (2,119) GPES_SS_CRA.MAIN.GBL.default.1900-01

-01.Step02.OnExecute Name:Write_CRA_Records PCPC:18096 Statement:256


STEPS
-------------
The issue can be reproduced at will with the following steps:
1. Navigate to Global Payroll & Absence Mgmt-> Social Security / Insurance-> Create CRA File ESP
2. Create the CRA file
3. Get the error

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