Using Power Forms (JD Edwards EnterpriseOne 8.11 onwards)

Posted on by

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)

25 thoughts on “Using Power Forms (JD Edwards EnterpriseOne 8.11 onwards)”

  1. Nikhil Reply

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

  2. Hari Reply

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

  3. Mukund Reply

    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

    • Deepesh Divakaran Post authorReply

      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.

  4. Randy Reply

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

  5. David Terborg Reply

    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

  7. Nesrine Reply

    Hi Deepesh!
    I’m new on JDE and i have to developpe an application and i’m trying to use Power forms. So if you can send me some PDF on Power Forms! You can mail it to nesrine87@msn.com
    thanks a lot!

  8. Tammy Reply

    Hi,
    I have a strange thing happening with my Power Edit form. If I enter an invalid value in a grid cell and press , I get the error message for the invalid value. I correct the value and presss again. In the Button Clicked and Post Button Clicked Event Rule of the OK button, I Set Save Behavior on OK (Save and Clear). This code is getting executed yet the End Dialog Event Rule also gets executed afterwards which I was not expecting. The program is closing which I want it to remain open – just clear the screen. This only happens if I enter an invalid value first. If I enter a valid value then press button, the Set Save Behavior on OK (Save and Clear) executes followed by my Post Dialog is Initialized displaying my cleared screen. Any ideas? thank you in advance.

  9. Raja Reply

    Hi Deepesh,
    I am fresher in JDE. Currently, I am working in power forms. Please help me to understand Transaction Properties. ie Subform Transaction only, Include in Parent Transaction, Transaction Disabled with some examples.
    Thanks in Advance

    • Deepesh Divakaran Post authorReply

      Hi Raja,
      The PDF Documentation from Oracle does have incredible information regarding Transaction Processing, and flow.
      It would not be possible to detail it here completely.

  10. saswat das Reply

    will send me the complete tutorial regarding power forms with screen shot

  11. Sid Reply

    Hi Deepesh,
    Using JDE Enterprise One version 8.11sp1. Oracle 10gR2.
    I can use optimizer hints on the Oracle queries at the server level.
    But how to use optimizer hints in JDE. Say want to use parallel hint on a query in JDE
    Regards,
    Sid

    • Deepesh Divakaran Post authorReply

      Hi Sid,
      Only way you can use the Optimizer’s or run Stats on the Oracle queries is to find the SQL being built underneath the JDE applications/reports, and then use those for optimization. There in you can add indexes and/or run statistics on the queries.
      You will need to enable the Debuglog for JDE to view the SQL’s being generated.

  13. Mohamed Attia Reply

    Hi Deepesh,
    Using JDE Enterprise One version PD810.
    1) How I can add to the work order attached e.g. picture, forms.
    2) How I can add a new page to the work order collecting data from the system.
    3) How I can print from the JDE on two face.
    Regards,
    Mohamed

  14. Mohamed Attia Reply

    Hi Deepesh, Thanks for your interesting,
    1) Yes, I mean the attached to the work order records.
    2) I need to add a new page it’s required for our operation (work permit)this work permit data to be taken from the work order data e.g. (Requested Date, Equipment item, Department, supervisor, assigned to,..etc). Also this work permit page to be print with related work order.
    3) Considering the environment and cost saving before printing, I’m asking if we can print the work order on the two faces of the page.
    Regards,
    Mohamed

  15. Sameer Reply

    Hi Deepesh,
    As per the client requirement, I need to customize the copy of P42101 to set the control error on grid cell of LOB field of sub form S421002C.
    Could please through some light on this subject?
    Awaiting your immediate reply
    Thanks
    Sameer

  16. football Reply

    Many years ago, Net sports activities book betting was risky.
    The different types of defensive football positions are:.
    In a very short time he built a very, very thorough roster that can beat you in a number of ways.

  17. Laura Engdahl Reply

    I have a power form with grid errors. I am forcing the grid cell to be red and setting the grid cell error. The top of the form shows the errors – but not all. As I move from one row to the next it seems that only the first error and the most recent error are the only ones notated at the top of the form. (Using JDE E1 9.10). There is a copy row feature in the form so that the user only enters the first two columns in the grid row (after the first row) and the remaining cells are copied from row one or programmatically updated after the copied cells. Because I force the cells to be red in editing they show red but no error message at the top of the form. Is this due to the fields are not being “cursor exited” and thus the form is not realizing the error in order to put the error at the top of the form?
    Any insight (as soon as possible – working on a deadline and this is a most frustrating issue!!!) would be greatly appreciated!!!

Leave a Reply