"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 JULY 20, 2024
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |