Featured post

General Ledger Revaluation

General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...

Tuesday, 31 January 2017

Press a button in Forms Personalisation



Mimic/automate the press of a push button in the PO Summary form


Create a when-new-form-instance personalization and create following actions

1)
Type: Builtin
Builtin Type: DO_KEY
Argument: ENTER_QUERY


Create a WHEN NEW ITEM INSTANCE personalisation and create the following actions

1)

Type: Builtin
Builtin Type: GO_ITEM
Argument: PO_HEADERS.SEGMENT1


2)
Type: Property
Object Type: Item
Target Object: PO_HEADERS.SEGMENT1
Property Name: VALUE
Value :==:'PO_HEADER_ID'

3)
Type: Builtin
Builtin Type: DO_KEY
Argument: EXECUTE_QUERY

Here in the below mentioned step

Type: Property
Object Type: Item
Target Object: PO_HEADERS.SEGMENT1
Property Name: VALUE
Value =:253253
If I hard code the value 253253(which is the header_id for PO_NUMBER 10031791) in the field 'value' then the PO_NUMBER form works as expected(PO Form opens up in queried mode and all the data of the PO_NUMBER is pre-populated)


Refer: https://community.oracle.com/thread/2518602?start=0&tstart=0

No comments:

Post a Comment

Please review my topic and update your comments

Note: only a member of this blog may post a comment.