Posts

Showing posts from August, 2017

DISALLOW USER TO CANCEL PO LINE IF QUANTITY RECEIVED

In Oracle EBS R12, currently system allow user to Cancel PO Line even if quantity is received against the PO Line (Partial/Full). Oracle explains this functionality in following note: WHY DOES APPLICATION ALLOW You TO CANCEL A PO LINE WHEN FULLY RECEIVED? (Doc ID 93690.1) For few businesses scenario is not same and admin needs to restrict user to cancel PO Lines against which there is received quantity. Following personalizations on Purchase Order Entry Form helps to serve the business need. PERSONALIZATION 01 Seq Description 10 SMA-LOCK CANCEL PURCHASE LINE BUTTON IF RECEIPT EXISTS Condition Triger Event WHEN-NEW-ITEM-INSTANCE Triger Object PO_DOCON_CONTROL.ACTION Condition :PO_LINES.TOTAL_QUANTITY_RECEIVED is not Null and :PO_LINES.TOTAL_QUANTITY_RECEIVED >0 Actions Seq 10 Type Property Object Type Item Target Obj...