When performing Order Import via the Standard oracle Order Import Process or Entering Orders manually from the Sales Order Screen we may get the Error Message ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write .
This error may be because of the Actual reasons behind this issue , but one of the many scenarios when this order is raised by Oracle is when Defaulting rules fail and Oracle is not able to Default the value in the required fields which need to be maintained for Order Creation eg : Warehouse.
If you receive such and error please check the defaulting rules for these fields and try to find out which one of these rules is failing . Once corrected this error disappears in most of the scenarions faced.
This error may be because of the Actual reasons behind this issue , but one of the many scenarios when this order is raised by Oracle is when Defaulting rules fail and Oracle is not able to Default the value in the required fields which need to be maintained for Order Creation eg : Warehouse.
If you receive such and error please check the defaulting rules for these fields and try to find out which one of these rules is failing . Once corrected this error disappears in most of the scenarions faced.
No comments:
Post a Comment