We receive the following error when the sell shipment costs are adjusted:
insert into allocation_order_release_d (alloc_seq_no,alloc_cost_seqno,order_release_gid,c ost_description,accessorial_code_gid,cost,general_ ledger_gid,exchange_rate_date,exchange_rate_gid,do main_name,cost_currency_gid,cost_base) values (?,?,?,?,?,?,?,?,?,?,?,?); [242803, 3, KIIMI.460712, A, KING.FSC_PCT_IMI_SELL, 5.85 USD, null, null, DEFAULT, KIIMI] [agentPlanning - 2]
java.sql.SQLException: ORA-28117: integrity constraint violated - parent record not found
glog.util.exception.CreateExceptionWrapper
This error is inconsistent and we will receive the error on some orders but not on others. There seems to be no difference between the orders and the only difference I see between the shipments is that the TOTAL TRANS COST field is not populated on the shipments where we see the error.
I can't find the root of the problem and would be open to any help.
Thanks,
Chris
insert into allocation_order_release_d (alloc_seq_no,alloc_cost_seqno,order_release_gid,c ost_description,accessorial_code_gid,cost,general_ ledger_gid,exchange_rate_date,exchange_rate_gid,do main_name,cost_currency_gid,cost_base) values (?,?,?,?,?,?,?,?,?,?,?,?); [242803, 3, KIIMI.460712, A, KING.FSC_PCT_IMI_SELL, 5.85 USD, null, null, DEFAULT, KIIMI] [agentPlanning - 2]
java.sql.SQLException: ORA-28117: integrity constraint violated - parent record not found
glog.util.exception.CreateExceptionWrapper
This error is inconsistent and we will receive the error on some orders but not on others. There seems to be no difference between the orders and the only difference I see between the shipments is that the TOTAL TRANS COST field is not populated on the shipments where we see the error.
I can't find the root of the problem and would be open to any help.
Thanks,
Chris
Comment