Article ID: 121649, created on May 20, 2014, last review on May 9, 2016

  • Applies to:
  • Business Automation 5.5


When trying to delete subscription period from plan one of the errors appear:

This Subscription Period is used in Order Items.


ODBC code #23503: ERROR: update or delete on table "PlanPeriod" violates foreign key constraint "OrdDet_PlanPeriodID" on table "OrdDet" Key (PlanPeriodID)=(ID) is still referenced from table "OrdDet".; Error while executing the query


There are orders for this subscription period that should be archived first.


Locate all orders that have reference to this subscription period. It can be done via BA database:

select distinct "OrderDocOrderID","subscriptionID" from "OItem" where "PlanPeriodID" = [ID of he plan period you want to delete];

Then please archive all these orders via BA CP.

Search Words

delete suscription period from service plan

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF