Self Service 'Manage Payroll Payments' Err's: An unexpected error has occurred. &MSG occurred when the FND_FLEX_SERVER package tried to execute SQL Stmt (Doc ID 1371628.1)
Last updated on MARCH 27, 2017
Oracle Payroll - Version 126.96.36.199 and later Information in this document applies to any platform.
***Reviewed for relevance 15-JAN-2015***
When attempting to use the 'Manage Payroll Payments' function in Self Service, the following error occurs.
An unexpected error has occurred. Please inform your system administrator that the error: &MSG occurred when the FND_FLEX_SERVER package tried to execute the SQL statement below. If tables or sequences do not exist this may indicate a problem with your installation. Make sure grants and synonyms exist so that all tables, views, and sequences in the SQL statement are visible from the database account in which the FND_FLEX_SERVER package resides (usually APPLSYS). If this is a select statement and the last portion of the where clause is in incorrect, then an invalid where clause may have been supplied in the flexfield definition. The error is probably either in the form, or in a server-side package that calls the flexfield validation routine. SQL statement (first 1000 bytes): &SQLSTR (APP-)
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
Upgrade DB to 188.8.131.52
Employee Self Service => Personal Payment Method
Hit Add icon to Navigate to Add/Edit Pay method
Choose Payment Type "Direct Deposit"
Enter appropriate bank Info
Hit OK Button, error will pop up right away
Upgrade database to 11g
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