Concurrent Program completing with Running- Paused status. "CONC-COPY DB FILE FAILURE" is the msg
Hello, We are currently on EBS R1, 12.2.11 version. We have set of concurrent programs(CP) running since 8 yrs. Suddenly we observed that Concurrent Programs completing with Running- Paused status for application short name XXXFRONTARENAFAH(16 character). "CONC-COPY DB FILE FAILURE" is the msg we can see when we click on "View Details" button on the CP form. And the LOG file says
=====================================================================================================
APP-FND-01564: ORACLE error 1406 in get_req_app_short_name
Cause: get_req_app_short_name failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: select lower(application_short_name) from fnd_concurrent_requests, fnd_application where request_id = :1 and program_application_id = application_id and was executed from the file &ERRFILE.