«

»

Jul 22 2009

Using Power Forms (JD Edwards EnterpriseOne 8.11 onwards)

VN:F [1.9.22_1171]
Rating: 2.9/5 (8 votes cast)

I’ve been pounded many a times by guys asking how to use Power forms.  There have been not much tutorials on using Power forms, and its benefits. So I thought of writing up a simple Power Form usage, and a basic tutorial/guide to help all of us.

Lemme try to summarize  Power Form System Functions and Event Rules. I’ll also try to make use of Saved Query Controls. I assume that you have basic JD Edwards Technical Skills and knowledge to accomplish this.

Following are the activities which I’m going to do in this example:

  • Create the Power Browse Form.
  • Create a Standard Subform.
  • Create a Mapping Link.
  • Create a Reusable Subform.
  • Using Power Forms System Functions and Event Rules
  • Create the Power Edit Form.
  • Using Automatic Features of FDA.
  • Using the Saved Query Control.
  • Creating Grid Icons

  1. I’ve assumed that you have two tables, linked by UKID. Say the table – 1 is made up of UKID, AN8 and ALPH. The Table – 2 is of UKID, ADD1, CTY, ADDS. Something like the Address Book setup.
  2. Take a Power EDIT  form & insert a subform (reusable or embedded anything would do, depends on your overall architecture). Note: if using resuable subform then take Reusable Edit Subform.
  3. Attach Header BV to Power form & detail BV to subform. (procedure is similar to any form)
  4. Check if subform datastructure has UKID in it (To receive subform interconnect values), if not then add (procedure is similar to any form)
  5. In properties of Power form, select tab “Mapping links”. Check whether proper subform is selected in “Link To” combo box. Assign the respective UKID field/variable of power form which would contain UKID values and needs to be passed to subform. Assign the proper direction i.e. From Power to Subform for this scenario.
  6. Use system function “Notify Child” to pass control & data to subform. Most probably you would like to use this function in “Post dialog is initialized” event of Power Form.
  7. Once this function is executed, an event “Notified by Parent” would be invoked in subform.
  8. Assign Subform interconnect values of UKID to the filter fiield on subform. This would show all the detail records on subform. (If Automatic find on entry property is set on the grid of subform). In our setup this property is somehow not working on subform grid.
  9. What we do is to have a “Hidden Find” button on subform which is pressed using system function in Notified by parent event.

These were the steps to show detail record(s) corresponding to header.

  1. Insert a Push button with default functionality of “Save” on subform & Hide it.
  2. On Power form’s OK button’s appropriate event use system function “Trigger Default Child Action” to press save button of subform. This would save the detail record along with header record. (there are other methods as well)

Please find the Developing Powerform-Based on JD Edwards EnterpriseOne Applications PDF from David Terborg –  

Please register to download the attachments in Using Power Forms (JD Edwards EnterpriseOne 8.11 onwards)


Thanks David.

Published under the license.

VN:F [1.9.22_1171]
Rating: 2.9/5 (8 votes cast)
Using Power Forms (JD Edwards EnterpriseOne 8.11 onwards), 2.9 out of 5 based on 8 ratings
(Visited 1,493 times, 3 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

17 comments

Skip to comment form

  1. Nikhil

    Can you give some more detailed steps on how to, including screen shots?

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh Divakaran

      I’ll try to do a full featured tutorial by the end of the week.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  2. Hari

    Would like to see the same with screenshots. I’m stuck on doing Power Browse forms. Please help.

    VA:F [1.9.22_1171]
    Rating: -1 (from 1 vote)
    1. Deepesh Divakaran

      I’m sorry as time not allowing i have not got a chance to write a complete tutorial. Will be doing it soon.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  3. Mukund

    Hi Deepesh,

    I am new t o JDE, I have been doing some testing, i am facing this issue in forms where when I login as a specific user say Service Rep, I am not able to find the OK button in the form to create contracts. When i access the same form through the seeded JDE user I can find it there and create the contract. This is replicated across many other forms across different modules like manufacturing and CRM.
    Any ideas on what might be the issue.
    Currently working on a JDE 9.0 instance

    Thanks

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh Divakaran

      Hi Mukund,
      This is due to the User/Role security feature in JD Edwards. You can set security for a particular user or a Role for Not to Save a record, or not to change the value of processing options, or say Only View the Records etc. You will have to ask your system administrator to switch off the security for “Save” or saving the records, to enable your OK button.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  4. Randy

    Good tuts. You also need to write the pre-requisites for doing such tuts.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  5. David Terborg

    Hi Deepesh,

    I can send you some pdf’s on this toopic if you want.
    Just let me know if you are interested.

    kind regards,
    David Terborg

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  6. David Terborg

    Hi all,

    I have pdf’s regarding creating powerforms.
    If anyone is interested please let me know and I will request the administrators to upload them.

    kind regards,
    David

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  7. Deepesh M Divakaran

    All,
    You can download the PDF on Power forms Uploaded by David Terborg. Download Link given in the Article.
    Thanks David.

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh M Divakaran

      William,
      There’s a download link for the pdf in the article

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  8. DawG

    A Power Edit (in ADD mode) has 2 subforms/tab pages with required fields. Its allowing the adds withh the OK without the required fields being entered.
    I would want the required fields to fire

    I even put the Get Error Count into subform but that seems to fire after the OK button so the errors would pick up after the fact.

    Do I have to manually validate those or can I put something in the to trigger the validation.

    Also if I happen to put a function in that fails in the OK button, it then does the required field validation. But then only does like a few of the required fields v. all of them.

    So that’s my question…

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  9. Ashish

    Hi,
    Your question is not clear. I assume that you have not put a Save button on the subform, which has to be triggered on the OK button of the main power form. Is it that you are never going to the subform? I mean the control is never focused on the subform? Can you elaborate further

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  10. dawg

    Actually I am doing the trigger the subform save, which typically just launches the same event for a save on the subform itself, right?

    But yes a user should go into several subformes and if all okay then I would trigger the subform save within the OK button v. doing a hidden save off the subform. Rather what I’m trying to do is if they do nothing in the assoc. subforms with the required fields then the errors pop up accordingly. It just completes normally ignoring the required fields.

    About it.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)

Leave a Reply