Recently, I have been developed application using Power Form in JD Edwards EnterpriseOne.
Maybe you are a JD Edwards developer and try to create customize forms using "Power Form". Then, this is a good article to start knowing about that (although you can read from manual in Oracle site but can be a little confusing :p )
I assume you have the basic JD Edwards Technical Skills and knowledge in creating form (such as Headerless and Header Detail form) before you read this.
In my opinion the advantages (pro) and cons if using power form:
The pros:
- You can add several irrelated data (different Business View) grid with Subform while other forms can't.
- You can also add different object application (Pxxxx object form / reuseable form) in this Power Form with Subform alias.
- User don't need to go from link to link to browse or edit related data/table.
- This form could be slower than the other forms (headerless or header detail), depend on how many Subform are created.
- Power form only run on the web.
- Power form can be a little confusing for develop.
Browse and Edit.
Browse are only for search and browse, more likely a select and search form.
Edit are for revise or create data, more likely a headerless form.
Okay the basic creation is like this:
- Create the Power Browse / Edit Form.
- Create a Standard Subform / Reuseable Subform.
- Create a Mapping Link.
- Using Power Forms System Functions and Event Rules
- Creating Grid
- I’ve assumed that you have two tables (for sample only) linked by its FK and PK, say the keys are DOCO, DCTO, KCOO.
- For table 1, it has DELN, AN8, ALPH and for table 2, it has LNID, ITM, LITM, DESC.
- Choose Power EDIT form and insert a subform (reusable or embedded, depends on your design).
- Attach Header BV to Power form and detail BV to subform. (procedure is similar to any form). Make sure the Parent are right (I think it will only be one available because you now only have 1 subform).
- Check if subform datastructure has DOCO, DCTO, KCOO in it (I think there will be there because they are Primary Keys) if not, just add them. The purpose is to receive subform interconnect values.
- In properties of Power form, select tab “Mapping links”. Check whether proper subform is selected in “Link To” combo box. Assign the correspond keys field/variable of power form which would contain keys values and needs to be passed to subform. You can select the proper direction "Link To Parent", "Link To Child" or "Link To Child and Back To Parent" symbol.
- Use system function “Notify Child” to pass control and data to subform. Most probably you would like to use this function in “Post dialog is initialized” event of Power Form.
- Once this function is executed, an event “Notified by Parent” would be invoked in subform.
- Assign Subform interconnect values (SI DOCO for example) to the filter fiield on subform. This would show all the detail records on subform.
- The detail records would be shown out if Automatic find on entry property is set on the grid of subform, otherwise you must do step 11.
- Add/insert manually "Push Button FIND" on the subform and add System Function "Press Button" FIND in the "Notified by Parent" event of Subform.
- Make it hidden if you don't want user to see.
- Insert a Push button with default functionality of “Save” on subform and Hide it if necessary.
- On Power form’s (Parent forms) OK button’s assign system function “Trigger Default Child Action” and choose SAVE button of subform. This would save the detail record along with header record. (there are other methods as well)
Hope it helps you
If anything wrong, feel free to inform me.
You can also get a complete overview for creating power form in powerpoint.
Just feel free to ask and comment.
