EGL: Allocation Abended with message "An expression of non-boolean type specified in a context where a condition is expected, near 'AND'" or "ORA-920: invalid relational operator"
Last updated on OCTOBER 03, 2016
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.
Interunit copy Allocation process abended at step FS_ALLC_TRGT.ValBUL.ValBUL
Steps to replicate:
1. Set up Allocation step for Interunit Copy Allocation. Target tab doesn't contain Business Unit field. Offset tab set up includes populating Offset Business Unit as a Value directly.
2. Create allocation Pool data
3. Request Allocation process for the target Business unit.
SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 10.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.
The above was reported for Microsoft SQL Server database. For Oracle databases Allocation might abend with below error:
SQL error. Stmt #: 1603 Error Position: 150 Return: 920 - ORA-920: invalid relational operator
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