When Trying to Change or Delete Submitted Flexible Spending Account Claim, Error: SQL error in DescribeCol. (2,279) FSA_CLAIM.FSA_CLAIM_SUB_DT.Save Edit (Doc ID 2037665.1)

Last updated on DECEMBER 04, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to change or delete a claim that has been submitted but not yet paid in Flexible Spending Account Administration, the following error occurs if the claim being changed is not the claim with the most current effective service date:

ERROR
-----------------------
       A fatal PeopleCode SQL error occurred. Please consult your system log for details.

       SQL error in DescribeCol. (2,279) FSA_CLAIM.FSA_CLAIM_SUB_DT.Save Edit
       PCPC:1335 Statement:10
       During the execution of SQL, an error occurred in the DescribeCol subroutine. The
       preceding message should have described the details of the SQL being executed.

STEPS
-----------------------
1. In correction mode, change a claim amount on an unpaid Flexible Spending Account Administration; there should be at least one more unpaid claim for the employee with a more current Service Date that is also unpaid (Navigation: Benefits > Admin Flex Spending Acct US > Submit Claims > Modify Claims).
2. Click Save.
3. Upon error, attempt to delete the same claim.
2. Click Save.

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