Announcement

Collapse
No announcement yet.

Data upload error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data upload error

    I'm trying to upload the RATE_GEO_COST_GROUP table after loading the RATE_GEO table and I'm running into this error.

    RATE_GEO_COST_GROUP</TableName>
    <Exception>ORA-20000: lt error type="FK" pk_table_name="RATE_GEO" pk_column_name="RATE_GEO_GID" fk_table_name="RATE_GEO_COST_GROUP" fk_column_name="RATE_GEO_GID" fk_column_value="SCM.CCHDHK01010001000027" / gt ORA-06512: at "GLOGOWNER.RATE_GEO_COST_GROUP_XV", line 9 ORA-04088: error during execution of trigger 'GLOGOWNER.RATE_GEO_COST_GROUP_XV'</Exception>


    aAAny idea what could be causing this? Thanks for your help!

  • #2
    Re: Data upload error

    Looks to me like the Rate Geo Gid you are trying to upload SCM.CCHDHK01010001000027 does not exist on the rate geo table. The error type seems to be a FK violation between rate_geo and rate_geo_cost_group.

    Double check the data.

    Comment


    • #3
      Re: Data upload error

      Did you resolve this issue in the end ? What was the problem ?

      Comment

      Working...
      X