My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.