My Oracle Support Banner

Post Upgrade Steps - Exception At ICX_CAT_SQE_PVT.sync_sqes_for_all_zones (Doc ID 2742528.1)

Last updated on JANUARY 08, 2021

Applies to:

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

Symptoms

On: 12.2.6 version, Installation, and Configuration

When attempting to run the following SQL statement for Post Upgrade steps:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the following statement:

SQL> exec icx_cat_sqe_pvt.sync_sqes_for_all_zones;
BEGIN  
      icx_cat_sqe_pvt.sync_sqes_for_all_zones; 
END;
2. The script completes in the reported error

Changes

 

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
Changes
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.