AP Period Close Helper Diagnostics Program ends with ORACLE error 6550 in FDPSTP PLS-00201: identifi
Hi All,
Our customer implemented PCH in their development instance by following Method 2 from 'How to Register the Period Close Helper - Diagnostic as a Concurrent Program [ID 1489916.1]'.
We received error APP-FND-01564: ORACLE error 1406 in FDFGVD
Cause: FDFGVD failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: SELECT L.LEDGER_ID,L.NAME VALUE, L.DESCRIPTION DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM GL_ACCESS_SET_LEDGERS AC, GL_LEDGERS L WHERE ( AC.ACCESS_SET_ID=:b1 AND L.LEDGER_ID = AC.LEDGER_ID ) AND L.LEDGER_ID = :X and was executed from the file &ERRFILE.
Our customer implemented PCH in their development instance by following Method 2 from 'How to Register the Period Close Helper - Diagnostic as a Concurrent Program [ID 1489916.1]'.
We received error APP-FND-01564: ORACLE error 1406 in FDFGVD
Cause: FDFGVD failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: SELECT L.LEDGER_ID,L.NAME VALUE, L.DESCRIPTION DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM GL_ACCESS_SET_LEDGERS AC, GL_LEDGERS L WHERE ( AC.ACCESS_SET_ID=:b1 AND L.LEDGER_ID = AC.LEDGER_ID ) AND L.LEDGER_ID = :X and was executed from the file &ERRFILE.
Tagged:
0