Error "ORA-02292" when Deleting a Pack Template Via Form Packtmpl
Last updated on MAY 01, 2017
Applies to:Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.
When trying to delete a pack template that was already used in a Purchase Order (PO), the following error message is displayed:
The issue can be reproduced at will with the following steps:
1. Go to Items>Diffs>Pack Templates and create a pack template.
2. Create a PO and, in ordmtxws screen, select an item and click on Apply Template.
3. Select the pack template created in step 1, filling the Vendor Desc in the New Parent Template screen.
4. Save the PO and go back to Items>Diffs>Pack Templates.
5. Select the template created in step 1 and click on Delete Template button. After confirming the deletion, the error message will be displayed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms