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.

Internal content