Article - CS295217
Error: "ORA-02292: integrity constraint (XXX.FK_BUDGET_TARGET_LOC) violated - child record found" when deleting a Location in Servigistics Click Parts Planning (C-Parts)
Modified: 25-Oct-2018
Applies To
- Servigistics Click Parts Planning 7.7 to 7.7.2.1
Description
- Removed data from Location
- Clear all schedule data by location using B220
- Clear all orderbook data using D345
- Remove the location from all location hierarchies
- Remove location from Batch Process Configuration for Auto-Forecasting
- Remove location from all Parameter Cases/Dimension Sets
- Remove Work Queue Configuration Table entries
- Remove Planning Hierarchy
- Still cannot delete Location from Data Management>Locations and Source Setup>Locations
- Error in $LPAVARDIR/Corba/Log/System.log.txt
- [SysTableMgr] **ERROR** 4248 xxx -2 Oracle Error: ORA-02292: integrity constraint (XXX.FK_BUDGET_TARGET_LOC) violated - child record found
[SysTableMgr] **ERROR** 4248 xxx -2 SQL statement failed in 'sqlexec': DELETE FROM XXX.location WHERE gid=yy AND updcount=zz
- [SysTableMgr] **ERROR** 4248 xxx -2 Oracle Error: ORA-02292: integrity constraint (XXX.FK_BUDGET_TARGET_LOC) violated - child record found
This is a printer-friendly version of Article 295217 and may be out of date. For the latest version click CS295217