Business Issue : Form with multiple tabs taking long time to Open

Reason : One of block was having multiple Order by clauses and was picking all runs data ,
all data was not needed on initial form opening.

Solution : Get only recent run data at time of form opening , that will reduce the records to load.
Used onetime_where block property and populated it dynamically on WHEN_NEW_BLOCK_INSTANCE

SET_BLOCK_PROPERTY ('WB_BLK', onetime_where, l_where);

As name suggests onetime_where is appended to block query only once.
On F11 afterwards , regular where condition and supplied value is used by block query.




 

FRM-41042: No such property

Error while running form - FRM-41042: No such property for set_item_property

Cuase : Some visual attribute classes were causing properties to be set for displayed Item

Solution - changed Item Type from "Displayed Item" to "Text Item"

link to ‘Compare to Original PO ‘ – I receive the error that I do not have privileges

Custom Responsibility to PO Inquiry causes error - "You have insufficient privileges for the current Operation. Please contact your System Administrator."
Navigation : XXX PO Inquiry ALL(Resp) > Purchase Orders > PO Change History 

To resolve this issue -

We need to add function ‘View Purchase Order History’ to Custom Menu : XXXX:PO_PURCHASE_ORDERS_GUI_B.