Friday, March 2, 2012

Multi-Record Update using Forms Personalization

One of my client has an interesting requirement, In Sales order form when user changes the ORDER pricing date then it needs cascade with ALL existing LINES pricing date.

I tried a traditional way by using 'When New Block Instance' or 'When New Record Instance' for block LINE and added an action.

 Its working good only when user enter/update the sales order line.

Cascading is not happening when there are multiple lines exist and user changing the pricing date at header
and closing the form (with out going to Line block).
In order achieve that, used BuiltIn Type to 'Execute a Procedure'.

In Procedure, used API oe_order_pub to update lines.

Thanks, Vijay