You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Accounting rule condition in SLA setup is showing error "Possibly blind query executed ...."

in Subledger Accounting & Accounting Hub

Summary: Issue with Accounting Rule Condition in SLA Setup

We encountered an error when adding more values to an existing SLA rule condition using "OR". The error message displayed is: "Possibly blind query executed .... 204".

Oracle Note: According to Oracle Note (Doc ID 2721144.1), there's a limitation of 200 conditions due to Bug 22137961. When there are more than 200 conditions, the rule conditions do not display.

Suggested Solution: Oracle suggests splitting the rule into multiple rules, each with its own set of conditions, or using mapping sets.

Our Question: When we validate or Save and Close, the system does not show any error, so we proceed to activate the SLA Rule. However, after activation, the conditions get deleted, and we see the message: "Possibly blind query executed .... 204".

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!