"ORA-02291: integrity constraint (GLOGOWNER.FK_GDMRF_TRANS_REFNUM_QUAL) violated - parent key not found" Error When Generating Declaration Message (Doc ID 2299080.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Trade Compliance - Version 6.4.2 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.

Symptoms

When trying to generate declaration message from declaration the following error is seen:

insert into gtm_decl_message_refnum (gtm_decl_message_gid,gtm_trans_refnum_qual_gid,refnum_value,domain_name) values (?,?,?,?);
http://ANAS.0170727-00000001, DECLARATION MESSAGE NUMBER, ANAS.20170726-00000006-0170727-00000001, ANAS [
2017-07-27 12:41:54.43 251366 Debug Sql {call vpd.set_user_r(?,?,?,?)}; inParams=http://ANAS.ADMIN, ADMIN, null, STATIC [
2017-07-27 12:41:54.431 251366 Debug Sql select error_translation_gid, solution_translation_gid from oracle_error where error_code=? and constraint_id=?; 2291, FK_GDMRF_TRANS_REFNUM_QUAL [
2017-07-27 12:41:54.448 251366 Debug Sql {call vpd.set_user_r(?,?,?,?)}; inParams=http://ANAS.ADMIN, ADMIN, null, STATIC [
2017-07-27 12:41:54.449 251366 Debug Sql select s.table_name, s.column_name, m.table_name from all_constraints c, all_cons_columns s, all_cons_columns m where c.owner='GLOGOWNER' and s.owner='GLOGOWNER' and m.owner='GLOGOWNER' and c.constraint_name=? and s.constraint_name=c.constraint_name and m.constraint_name=c.r_constraint_name and m.position=s.position order by s.column_name; FK_GDMRF_TRANS_REFNUM_QUAL [
2017-07-27 12:42:00.093 251366 Error Exception 008419 Cannot update the GTM_DECL_MESSAGE_REFNUM record. GTM_TRANS_REFNUM_QUAL_GID must reference a valid GTM_TRANS_REFNUM_QUAL record.
java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_GDMRF_TRANS_REFNUM_QUAL) violated - parent key not found

java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_GDMRF_TRANS_REFNUM_QUAL) violated - parent key not found

 

Steps to reproduce:

1. Go to Declaration Management -> Declarations
2. Search for the declaration id
3. Check it and go to Actions-> Generate Declaration Message -> it fails with the above exception

 

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