Error When Using "Not IN" As A Condition In Requisition Approval (Doc ID 2153261.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Self Service Procurement - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.0.0 version, Approve Requisition

Error when using "Not IN" or "IN" as a condition in Requisition Approval

User trying to create a Rule that says If the Cost Center is NOT IN (117, 012) then use an approval group.


ERROR
-----------------------
ORA-12899: value too large for column "FUSION"."POR_AMX_CONDITION_INS"."SANDBOX_FLAG" (actual: 3, maximum: 1)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to: Setup and Maintenance > Manage Requisition Approvals
2. For the "Header Stage" with "Header Hierarchy" Participants, click Edit Rule
3. Click + to add new Rule "Cost center not in one created"
4. Click Add condition with the following : Cost Center Requisition Distribution not in (117,012)
5. Click Add action and route to approval.
6. Click Save and notice the above error.


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