My Oracle Support Banner

Map Oracle Purchasing Categories Errors (Doc ID 2398299.1)

Last updated on MAY 14, 2018

Applies to:

Oracle iProcurement - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On Release 12.2.6 version, E-Content Manager

Map Oracle Purchasing Categories (Map Oracle Purchasing Categories) is completed in error

While mapping the PO category and shopping category the concurrent program is completing in error.

ERROR

POXMPCAT: Map Oracle Purchasing Categories
+-----------------------------------------+
 
Current system time is 03-MAY-2018 13:39:07
 
+------------------------------------------+

**Starts**03-MAY-2018 13:39:07
**SQL error and free**03-MAY-2018 13:39:07
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'ICX_CAT_MAP_CATEGORIES.MAP_CATEGORIES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The SQL statement being executed03-MAY-2018 13:39:07

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Sign on to Application
2. Select Responsibility: iProcurement Catalog Administration
3. Navigation: iProcurement Administration: Home Page ->> Select: "Schema" Tab >>
4. Sub Menu: "Category Mapping" >> Purchasing Category >> S
5. Select a Purchasing Category Name >> Purchasing Category Status = "Not Mapped"
6. Click: "GO" ->> Select : Purchasing Category Name ->> Click: "Map" ->>
7. Returns Error: ORACLE error 6550 in FDPSTP
    Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
    PLS-00201: identifier 'ICX_CAT_MAP_CATEGORIES.MAP_CATEGORIES' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

NOTE: <Patch: 21974301> :R12.ICX.D - Has been applied.


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot proceed with mapping Purchasing Categories.

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


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