EGL9.2:Ledger Vs Journal Integrity Report (GLS7010.SQR) Abends Error 'SQL Status = 1756, SQL Error = ORA-01756: Quoted String Not Properly Terminated'
(Doc ID 2672745.1)
Last updated on MAY 27, 2020
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
Ledger Vs Journal Integrity Report (GLS7010.SQR) Abends Error 'SQL Status = 1756, SQL Error = ORA-01756: Quoted String Not Properly Terminated' when single Quote found in ChartField value
Replication Steps:
1) Create a new CHARTFIELD1 Value with a single quote as T'
2) Create a combo rule to purposefully enter wrong value in Journal
3) Set up 'Ledger For a Unit' for suspense
4) Create a journal and post journal with CHARTFIELD1 value as T'
5) Journal is in suspense and posted
6) Run Ledger Vs Journal Integrity report, which should include CHARTFIELD1
Error :
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |