Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Oracle Inventory: Unable to save New items



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


This post first appeared on EBiz Integration Technics, please read the originial post: here

Share the post

Oracle Inventory: Unable to save New items

×

Subscribe to Ebiz Integration Technics

Get updates delivered right to your inbox!

Thank you for your subscription

×