Account Inquiry Form (GLXIQACC) Have The Following Error: ORA-00912 Followed By the Next Error: FRM-92101
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
Million Knowledge Articles and hundreds of Community platforms