Generate Trading Partner Keys and Generate Item & Category keys requests failing with ORA-12801, ORA-02097 and ORA-48912 errors
(Doc ID 2732501.1)
Last updated on NOVEMBER 28, 2020
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.9 and later
Information in this document applies to any platform.
On : 12.2.9 version, Data Collections in UAT instance
When attempting to run complete refresh data collections in a newly created instance, Generate Items and Category Sets Keys request fails
the following error occurs.
Also the Generate Trading Partner Keys request fails with similar error.
[23-OCT-2020 09:59:52]: **Starts**
[23-OCT-2020 09:59:54]: **SQL error and free**
[23-OCT-2020 09:59:54]: ORACLE error 12801 in FDPSTP
Cause: FDPSTP failed due to ORA-12801: error signaled in parallel query server P003
ORA-06512: at "APPS.MSC_CL_ITEM_ODS_LOAD", line 2199
ORA-02097: parameter cannot be modified because specified value is invalid
The issue can be reproduced at will with the following steps:
1. Enter the application.
2. Run complete refresh data collections.
3. See the above failure.
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