My Oracle Support Banner

Subledger Security Setup - Data Query Errors: APP-FND-00906: You can only query existing flexfield code combinations (Doc ID 2478132.1)

Last updated on JULY 01, 2019

Applies to:

Oracle Public Sector Financials (International) - Version 12.0.0 and later
Information in this document applies to any platform.
Subledger Security

Symptoms

Subledger Security (SLS) setup is recently created.
Inventory-T3 accesses Group3 as default/security group.
Inventory-T4 accesses Group4 just the same.

Table secured: MTL_SYSTEM_ITEMS_B

Observed behavior:
New record created with setup in place: responsibilities query does not act the same (eg. one of them finds its own record, the other one does not)
Older record created without setup in place: responsibilities query does not act the same (eg. T3 errors, T4 queries fine)

ERROR
APP-FND-00906: You can only query existing flexfield code combinations. You entered query criteria in your flexfield that does not identify an existing code combination.
Therefore, your query will not return any rows.
Enter a valid code combination, or enter only the flexfield segment values you know, or do not enter any values in the flexfield.


STEPS
The issue can be reproduced at will with the following steps:
1. OPSFi Responsibility > Create Subledger Security Setup
2. Secure table MTL_SYSTEM_ITEMS_B
3. Query old and new records and observe the system does not act the same for different responsibilities

Changes

 New setup in place

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.