Bill Of Resources Load In Capacity Planning Error (Doc ID 2288049.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Capacity - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

While running the request, CYCROL: Bill of Resources Load, it is found that the request completes with the below mentioned error

Statement with the error:
SELECT /*+ RULE */ sys.inventory_item_id,
  sys.planning_make_buy



SQL Error Code: -1001
APP-FND-01564: ORACLE error 1036 in explode_end_items

Cause: explode_end_items failed due to ORA-01036: illegal variable name/number
.

The SQL statement being executed at the time of the error was: SELECT /*+ RULE */ sys.inventory_item_id,
  sys.planning_make_buy and was executed from the file .

***** End Of Program - Bill of Resources Load *****

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms