Map Oracle Purchasing Categories Errors (Doc ID 2398299.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

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.

Changes

Cause

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