Account Inquiry Form (GLXIQACC) Have The Following Error: ORA-00912 Followed By the Next Error: FRM-92101

(Doc ID 2248446.1)

Last updated on MAY 05, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLXIQACC - Account Inquiry form


Doing inquiry on GL Balances, error message appears: ORA-00912: INPUT PARAMETER TOO LONG in GLXIQACC form

Issue looks the same as <Bug 22777795> : GLXIQACC - ORA-00912: INPUT PARAMETER TOO LONG FRM-40505: ORACLE ERROR: UNABLE T

Note the issue does not appear every time doing inquiry. Sometimes (with the same parameters) it appears and sometimes not.
Note: in the bug is told that using a range on the natural account would be a workaround, but it does not affect the behavior.
Sometimes error appears and sometimes no, when using a range at the natural account.

ORA-00912 , FRM-92101

The issue can be reproduced at will with the following steps:
1. GL responsibility
2. Account Inquiry> Button [Show Balances]
3.Then Button [Detail Balances]
4. Error: ORA-00912 Input parameters too long
5. Then Error: FRM-92101 There was a Failure in the Forms Server during startup.




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms