Binary LoadHier Fails During RDM to Load Product Hierarchy with ‘purgeAge 0’ Argument Resulting in "Error ORA-1400: cannot insert NULL into (POSITION_NAME)"

(Doc ID 2135596.1)

Last updated on JUNE 16, 2016

Applies to:

Oracle Retail Predictive Application Server - Version and later
Information in this document applies to any platform.


The job that loads Product Hierarchy by running loadHier failed during RPAS Data Mart (RDM) update with "Error ORA-1400: cannot insert NULL into (POSITION_NAME)".  This occurs when purge age is set to zero.

Steps to Reproduce:

1.  Use a global domain that is registered to RDM.
2.  Produce a prod.dat file that excludes all positions of one local domain.
3.  Run loadHier -purgeAge 0 to remove that local domain.
4.  Observe the failure with 'ORA-01400' Oracle Database error.


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