My Oracle Support Banner

Opening Horizontal Plan Fails With HP QUERY ERROR (SQLERR=ORA-22160 (Doc ID 1180633.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Using Advanced Supply Chain Planning / Planner's Workbench
When attempting to open the Horizontal Plan for an item the following error occurs.

ERROR
-----------------------
HP QUERY ERROR (SQLERR=ORA-22160: element at index [153] does not exist
ORA-06512: at "APPS.MSC_HORIZONTAL_PLAN_SC", line 2572)

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
(R) Advanced Supply Chain Planner
1. Navigate to Planner Workbench>View by Item
2. Select Plan>Item>Item
3. Enter Criteria, Item equals
4. Select item for a specific Org.
5. Select Horizontal Plan
6. Observe HP Query data error encountered

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


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