11 Aug 2014

ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write



While saving the details entered in Sales order line, system throws error message "ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write" 
Reason:
The problem is the Warehouse is not getting populated in the order line.
Solution:
Check whether the Warehouse field displays an organization at the header level. If not enter and save, by default the warehouse will be populated for all the lines & the issue will be resolved.
If the system did not populate the warehouse information to the line even after entering at the header level, enter the warehouse at the line level & save the transaction.
If the issue occurs consistently raise an SR to Oracle, after analyzing your system the service engineer will provide you a patch for resolving the issue.
Note:
Until you get a permanent fix, we can enter the warehouse in line level and complete the transactions.

---X---

1 comment:

Copyright © 2015 an ORACLE APPS blog. All Rights Reserved.