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.
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 .
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
The issue can be reproduced at will with the following steps:
1. These patches installed to facilitate the use of AGIS.
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.
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