My Oracle Support Banner

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
ORA-48912: Th

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

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