Search 800 + Posts

May 13, 2009

ORA-01403: no data found R11i , R12i

In Oracle Apps there are many reason for this Error

1.If you are using ship set and anytime during line processing user has removed the ship set, there is possibility that Ship_set has been removed from Order lines , but it still exists in the WSH Delivery tables (data corruption).Possible fix is Set the value of ship_set_id to NULL

2.SHIPPING_INTERFACED_FLAG = ‘Y’ in OE_ORDER_LINES_ALL , but there is no corresponding data in WSH_DELIVERY_DETAILS.

3.when the scheduled ship date for the newly added configured option class is not matching with the Schedule ship date for rest of the lines already in the MODEL system throws error "No Data...".

No comments:

Post a Comment