Advanced Benefits - PSFT (MOSC)

MOSC Banner

Error Generating Batch of Confirmation Statements with BAS_CONFSTMT?

When running the process (BAS_CONFSTMT) to generate Confirmation Statements, we periodically receive the following error message, which causes the process to go to No Success:

File: C:\PT860P08B_2308160500-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 2161 Error Position: 0 Return: 12582 - ORA-12582: TNS:invalid operation
Failed SQL stmt: SELECT DATACHUNK, CHUNKSEQUENCE, CHUNKSIZE FROM PSFILEDATA WHERE FILEID = :1 ORDER BY CHUNKSEQUENCE

Error committing work. The host environment could not complete the CommitWork() function. (2,712) BAS_STATEMENT.PrintConfirmation.OnExecute Name:GenerateStatement PCPC:15599 Statement:216

We do have the output (Confirmation Statement) written to PDF file, which is saved on a server, that is then picked up and emailed to the employee through this same process.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center