My Oracle Support Banner

FA: SCM: PIM - Change Orders Getting Stuck In Scheduled Status with Errors JBO-27023, JBO-27024, ORA-01000 (Doc ID 2757002.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.10.0 version, Import Items

ACTUAL BEHAVIOR
---------------
Change Orders getting stuck in Scheduled status with below error

JBO-27023: Failed to validate all rows in a transaction

JBO-27024: Failed to validate a row with key oracle.jbo.Key

ORA-01000: maximum open cursors exceeded

 
EXPECTED BEHAVIOR
-----------------------
Expect the change orders to processed without error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
While approving the COs, change orders are getting stuck in Scheduled status and never getting completed.



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.