Defect HC-4439

Oracle staging triggers on PLPAGE lead to stageprop error

Software

Customer case Applies to Corrected in
CS0132191 V8.0.4.0 8.0.4.25

Observed behavior

The Oracle staging triggers are creating staglog entries with incorrect key values, leading to problems in the stagingprop operation.

Expected behavior

The triggers were incorrectly recording the storeent_id value instead of the plpage_id for the records being touched.

Resolution

The Oracle triggers for table PLPAGE,

ISTG_PLPAGE, USTG_PLPAGE, DSTG_PLPAGE

were updated to record the page_id instead of the storeent_id