Article ID: 121700, created on May 23, 2014, last review on Aug 12, 2014

  • Applies to:
  • Business Automation 5.5

Symptoms

FEA_CalculateNip feature is activated. NIP orders for resellers fail to be generated, there is an error in BM.log

Collectiong NIP on Account #<ID> failed with exception: ODBC code #23503: ERROR: update or delete on table "OrdDet" violates foreign key constraint "ResellerTrans_ReselOrdDetID" on table "ResellerTrans"
Key (DetID)=(<ID>) is still referenced from table "ResellerTrans".;

The resellers billing order (for the period when the feature was activated) does not contain all the transactions it shall include.

Cause

The issue is identified as bug #PBA-54590.

Resolution

Install hotfix 121670 as soon as possible. The bug is fixed in PBA 5.5.6.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF