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" (Doc ID 2189553.1)

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.

Symptoms

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

Error
--------

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

 

Note
------

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

Cause

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