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.
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
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
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