Repair PO Scrap/adj Sporadically Errors With GL Account Segment Security Error (Doc ID 1922772.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Spares Logistics

When attempting to enter a scrap or adjustment transaction for a repair PO, the following error occurs sporadically .

ERROR
-----------------------
The External RO Detail page with the error
The transaction failed because there was an error. Invalid distribution account s. Value 201 for the flexfield segment XXX_BOOKS does not exist in the value set XXX_BOOKS


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. These patches installed to facilitate the use of AGIS.
10108052
11895700
12381785
12715686
13003235
16460312
16983914
17187659
17233375
17448042
18177472

2. Since then, the above error happens sporadically when entering a scrap or adjustment transaction for a repair PO.
The error is "Invalid distribution account s. Value 201 for the flexfield XXX_BOOKS does not exist in the value set XXX_BOOKs." But all the setups are accurate for this valueset and for the security rules for this accounting segment.

3. The same user can get this error on a repair PO one minute, but then not get the error on the same repair PO on a 2nd try.
Users are getting this error on both repair PO scraps and adjustments, but it is sporadic.

4. They have a 6-segment chart-of-accounts and XXX_BOOKS is related to segment1 (named SOBP - set of books partition).

5 These May-02 Patches impacted Security Settings which has caused the SOBP segment issues throughout ERP for Web based forms.
The issue is sporadic in other modules, Cash Management, iProcurement, and Eb-Tax.

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