Total Pageviews

June 26, 2017

6/26/2017 03:43:00 AM



Oracle Inventory
Unable to save new item in Master Items form

Symptom :After saving, nothing happens. No error occurs and no message is shown on the message bar at the bottom of the form.

Steps:
The issue can be reproduced at will with the following steps:
1. INV(N)Items > Master Items
2. Fill the mandatory fields and save.
3. No error occurs and no message is shown on the message bar at the bottom of the form.

Solution:The invalid custom trigger causes ORA-04098 when inserting the record to mtl_system_items_b
Disable the custom Trigger

select * from dba_triggers
where table_name='MTL_SYSTEM_ITEMS_B'



ALTER TRIGGER ERP_DEMO_TRIGGER DISABLE;

After disabling create new item and save.It works now


Click here for more Inventory related issues and Solutions
 
Related Posts Plugin for WordPress, Blogger...