My Oracle Support Banner

AIP Online Batch: generate_pre_alloc_dcrp.sh Throws ORA-06512 (Doc ID 2393189.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Retail Advanced Inventory Planning - Version 15.0.3 and later
Information in this document applies to any platform.

Symptoms

When executing generate_pre_alloc_dcrp.sh script after the configuration merge in 15.0.3.5 we got the following error:

2645588 : 1520347105599 : DCRP_PRE_ALLOCATE[429] : INFORMATION :
get_alloc_breakable_sizes called.
2645588 : 1520347105601 : DCRP_PRE_ALLOCATE[472] : ERROR : ORA-00904:
"ALLOC"."DESTINATION_ID": invalid identifier
2645588 : 1520347105602 : DCRP_PRE_ALLOCATE[1329] : ERROR : ORA-00904:
"ALLOC"."DESTINATION_ID": invalid identifier


2645588 : 1520347105603 : DCRP_PRE_ALLOCATE[594] : INFORMATION : Starting
dcrp_pre_allocate.cleanup_work_tables
2645588 : 1520347105639 : DCRP_PRE_ALLOCATE[1916] : ERROR : ORA-20001:
ORA-00904: "ALLOC"."DESTINATION_ID": invalid identifier

--Error
Lines--
ORA-06512: at "AIP_OWNER.DCRP_PRE_ALLOCATE", line 474
ORA-06512: at
"AIP_OWNER.DCRP_PRE_ALLOCATE", line 1317




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!


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