1 2 Previous Next 19 Replies Latest reply on May 15, 2013 6:59 PM by 994670

    How to Integrate ADFDI with Fusion Compensation

    Kaja Rajesh
      Hi,

      We are implementing Fusion Compensation Module on Premise and using Release 4.

      We have a requirement to implement a ADFDI excel sheet to mass update UDT and Alert values. In this regard is there any documentation or White paper which tells us how to integrate ADFDI with Oracle fusion Application.

      I am finding lot of documentation on the ADFDI but they all talk about integrating with Stand Alone ADF Application.

      Can anyone point me to documentation which lists the steps on how to Extend Seeded Fusion Compensation Application to Integrate the ADFDI.

      Thanks
      Kaja
        • 1. Re: How to Integrate ADFDI with Fusion Compensation
          Jani Rautiainen-Oracle
          Can you clarify your use case, are you attempting customize a ADFdi feature implemented by Fusion Application or are you attempting to create your own worksheet to mass update the UDT (User Defined Table) separately from any existing functionality? If latter what is the intended integration with the Compensation; i.e. would there simply be a menu entry that would invoke your functionality or something more complicated ?

          I am not aware of any product specific integration guide for ADFdi. There are some documents in support system (e.g. Doc ID 1498601.1) that describe how to use ADFdi feature for a product however your use case is different and I will have to reach out to a colleague for more information once your use case is clear.

          For reference ADFdi related documentation:
          <li>[url http://www.oracle.com/technetwork/developer-tools/adf/overview/index-085534.html]OTN Oracle ADF Desktop Integration
          <li>[url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/toc.htm]Oracle Fusion Middleware Desktop Integration Developers Guide for Oracle Application Development Framework
          <li>[url http://docs.oracle.com/cd/E37017_01/index.htm]Oracle Fusion Applications Product specific documentation
          <li>[url http://docs.oracle.com/cd/E37017_01/doc.1115/e22774/toc.htm]Oracle Fusion Applications Compensation Management, Incentive Compensation Guide
          <li>[url https://wikis.oracle.com/display/jdeveloperandadf/ADF+Desktop+Integration+Troubleshooting+Guide]ADF Desktop Integration Troubleshooting Guide

          --
          Jani Rautiainen
          Fusion Applications Developer Relations
          https://blogs.oracle.com/fadevrel/
          1 person found this helpful
          • 2. Re: How to Integrate ADFDI with Fusion Compensation
            Kaja Rajesh
            Hi Jani,

            Thanks for your Inputs.

            Yes, We are trying to implement new ADFDI with Mass Update feature for UDT and Alert values. Yes, We need a Menu entry or want to add this new functionality as Task List Name.

            As soon as User Clicks on this Task List or Menu entry, this ADFDI entry has to be launched and allow users to mass update the details.

            Thanks
            Kaja
            • 3. Re: How to Integrate ADFDI with Fusion Compensation
              Jani Rautiainen-Oracle
              Wouldn't your use case then be a "Stand Alone ADF Application"; i.e. the application is separate from the FA and simply invoked from a main menu as needed ? See [url http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e16691/ext_nm.htm#BABFCCFE]Customizing the Navigator Menu for information on how to add a item to the menu. Other than that are you able to proceed with the details in [url http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_59/jdtut_11r2_59_1.html]Getting Started with ADF Desktop Integration Tutorial and [url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/toc.htm]ADFdi developers guide to create the "Stand Alone ADF Application", if not can you clarify what type of documentation you are looking for ?
              --
              Jani Rautiainen
              Fusion Applications Developer Relations
              https://blogs.oracle.com/fadevrel/
              • 4. Re: How to Integrate ADFDI with Fusion Compensation
                Kaja Rajesh
                Hi Jani,

                Thanks for the information.

                I might have created some confusion with my previous update. let me clarify.

                Normally in Fusion compensation, Work sheet there is an icon 'Export' which will export to the worksheet compensation data to Excel sheet. In our Requirement for Mass Update, We want to create an iCon or Button on 'User defined Table Value' screen and as Users click on that Icon, We want to launch the ADFDI template and allow them to do the Modifications to the UDT values or Create new Values.

                Can we do this way?

                Thanks
                Kaja
                • 5. Re: How to Integrate ADFDI with Fusion Compensation
                  Jani Rautiainen-Oracle
                  Sorry to persist but I am still a bit unclear on the use case. Since I don't currently have your screen setup in our test environment let me try to describe an example flow I can take in our test environment.
                  1) User logs in and from "Navigator" chooses "Compensation")
                  2) On "Compensation" application select "Export Salaries" entry
                  3) On "Export Salaries" query data in a table by clicking the "Preview Export" button
                  4) On the table click the table toolbar button "Export" to export the data
                  -> excel sheet is downloaded

                  Can you describe your case with similar steps and indicate which step you want to change and how. Also can you confirm my understanding is correct;
                  1) You are not querying / updating any FA data only data in UDT
                  2) You are not changing any existing ADFdi feature, rather just adding a button to a table button bar that invokes a new ADFdi feature
                  3) Requirement is to be able to download the data from a ADF table into a excel worksheet, update the data in the worksheet and upload the data back to the system

                  If I have understood correctly would these requirements be met with the [url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/work_table_comp.htm#CHDGIIHG]ADF Table Component with [url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/work_table_comp.htm#BABBIDEG]custom upload dialog if needed? Also note the following features that may be useful:
                  <li>[url http://docs.oracle.com/cd/E21043_01/apirefs.1111/e12419/tagdoc/af_exportCollectionActionListener.html]exportCollectionActionListener tag that can be used to do simple export without ADFdi
                  <li>[url http://fmwdocs.us.oracle.com/doclibs/fmw/E10285_01/web.1111/b31973/af_table.htm#CHDFDJFA]Exporting Data from Table documentation on how to use exportCollectionActionListener
                  <li>[url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/ap_enduseractions.htm#CIHJJAIE]Importing Data from a Non-Integrated Excel Worksheet

                  --
                  Jani Rautiainen
                  Fusion Applications Developer Relations
                  https://blogs.oracle.com/fadevrel/
                  1 person found this helpful
                  • 6. Re: How to Integrate ADFDI with Fusion Compensation
                    Kaja Rajesh
                    Hi Jani,

                    Thanks for very Useful Info.

                    Let me list out the steps for our requirement.

                    1. Login to the Application
                    2. Click on 'Administration' -> Setup and Maintenance
                    3. Go 'Manage USer Defined Tables' Task List
                    4. Click on Actions -> Edit on any UDT
                    5. On Edit User-Defined Table Screen, We want to add an Icon (Say 'Perform Mass Update')
                    6. Once User Clicks on it, User should be allowed to start with Mass update of UDT values

                    Questions are

                    1. For Step 6, Do we need to start creating a new jspx page with ADF table containing UDT data and have ADFDI Functionality (By Having an UPLOAD Button on Table) associated to this page?
                    2. Is this feasible to do? As we are not sure which EAR to be used for Customization and First of all is this screen Customizable?

                    To Answer your other questions

                    1. Yes, we will not query any FA data. We might need to write our own VO with UDT data.
                    2. Yes, We want to add a Button to 'Edit USer-Defined Table' Screen which will take user to new ADFDI Implementation.
                    3. Yes, We want to Provide way to download, Modify/Add for a certain data (In this case UDT Data with a Custom Vo) and Upload Ability. Once Uploaded We want to perform a Operation to make necessary Updates/Inserts to UDT Tables.

                    Please let us know if you see any other alternatives to meet this solution.

                    Thanks
                    Kaja
                    • 7. Re: How to Integrate ADFDI with Fusion Compensation
                      Jani Rautiainen-Oracle
                      I think I understand the question now; the question is whether the FA ADF table can be customized to enable support for ADFdi export / import or whether you would need to build a separate UI for it. Let me know if I have misunderstood.
                      Supporting ADFdi on the table involves various properties and changes on the page definition. I have not tested this and will need to get some input from colleagues, I will update the thread once get response.
                      --
                      Jani Rautiainen
                      Fusion Applications Developer Relations
                      https://blogs.oracle.com/fadevrel/
                      • 8. Re: How to Integrate ADFDI with Fusion Compensation
                        Kaja Rajesh
                        Hi Jani,

                        Just wanted ti check if you have got any update from your colleagues?

                        Thanks
                        Kaja
                        • 9. Re: How to Integrate ADFDI with Fusion Compensation
                          Jani Rautiainen-Oracle
                          I got a response, however still looking for a contact for your specific case:
                          >
                          There is no direct "connection" between the ADF Faces table seen in a web page and the ADFdi Table seen in a worksheet. So, customizing the web page has no direct effect on any ADFdi integrated workbooks.

                          Furthermore, ADFdi integrated workbooks do not currently support any kind of MDS-based customization.

                          However, ADFdi Tables do support a dynamic column feature. This feature can be used together with various Model features to create very different tables at runtime.

                          Non-dynamic columns can be hidden dynamically using the Visible property.

                          Dev guide: http://docs.oracle.com/cd/E23943_01/web.1111/e10139/toc.htm
                          ....
                          Creating a new integrated workbook implies becoming an workbook developer. So, you can just refer them to the dev guide. However, they would need to create at least one new page def and redeploy the application. This step implies having access for the FA source and knowing how to build it.

                          Ultimately, it is probably best for this customer to be working on this project directly with the FA dev team that created the application.
                          >
                          --
                          Jani Rautiainen
                          Fusion Applications Developer Relations
                          https://blogs.oracle.com/fadevrel/
                          • 10. Re: How to Integrate ADFDI with Fusion Compensation
                            Kaja Rajesh
                            Hi Jani,

                            Thanks for all your help.

                            Yes, from the threads and from my reading, the tentative design i am thinking is like this.

                            1. Customize EarHcmPayroll.ear to add a Button on 'Edit USer-Defined Table' Screen
                            2. Create a new Page and Page Def with required UDT data and provide a upload button (as if new ADFDI Development)
                            3. In the Workbook, Implement the required validations and Column level Visibility options (Hopefully i can do this from Standard ADF DI Functionality)
                            4. Once Users Click Upload, Call a Custom Method having call to pl/sql utility to update/insert UDT value data. (Is it possible to have a PL/SQL utility Call upon Clicking Upload on Workbook?)

                            While you are trying to get Specific Contact on my earlier questions, Can you also provide or get Inputs on above design approach.

                            Thanks Again
                            Kaja
                            • 11. Re: How to Integrate ADFDI with Fusion Compensation
                              Jani Rautiainen-Oracle
                              Seems like a feasible approach to me. Not sure if PLSQL APIs is the easiest option though, consider using regular ADFbc objects instead. You can have validations and dynamic behavior on the worksheet, see:
                              <li>[url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/add_valid_conv.htm]Adding Validation to an Integrated Excel Workbook
                              <li>[url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/interactiv_app.htm]Adding Interactivity to Your Integrated Excel Workbook

                              For custom upload processing see following:
                              <li>[url http://docs.oracle.com/cd/E23943_01/web.1111/e10139/work_table_comp.htm#BABBIDEG]How to Create a Custom Upload Dialog

                              however as stated I would recommend proceeding with the ADFbc objects unless you have a reason why PLSQL APIs would be better choice ?
                              --
                              Jani Rautiainen
                              Fusion Applications Developer Relations
                              https://blogs.oracle.com/fadevrel/
                              1 person found this helpful
                              • 12. Re: How to Integrate ADFDI with Fusion Compensation
                                Kaja Rajesh
                                Hi Jani,

                                Yeah, i might be wrong on using PL/SQL API. But let me ask this question.

                                The UDT data (Table name, Columns,Rows,values) which are coming from Multiple tables. I am just not sure if i create a updatable VO with all these entities, does the inserts/updates will happen seamless from ADF Bc objects?

                                As i am not sure, i am thinking about having a PL/SQL API through which i can identify all workbook attributes and have own insert/update mechanism.

                                Please correct me on my approach.

                                Thanks
                                Kaja
                                • 13. Re: How to Integrate ADFDI with Fusion Compensation
                                  Jani Rautiainen-Oracle
                                  You can have several updatable EO references in a VO. See:
                                  <li>[url http://docs.oracle.com/cd/E29597_01/web.1111/e28164/bcquerying.htm]Defining SQL Queries Using View Objects
                                  <li>[url https://forums.oracle.com/forums/thread.jspa?threadID=2341054]JDev forum thread -- How to create View Object with Multiple Updatable Entity Objects

                                  Also note that I found a contact within the product team. They are evaluating the use case so you might want to hold off on implementation until they have confirmed whether base functionality can be used to achieve the requirement.
                                  --
                                  Jani Rautiainen
                                  Fusion Applications Developer Relations
                                  https://blogs.oracle.com/fadevrel/
                                  • 14. Re: How to Integrate ADFDI with Fusion Compensation
                                    Kaja Rajesh
                                    Hi Jani,

                                    Just want to check if you got any update from your Contacts.

                                    Thanks
                                    Kaja
                                    1 2 Previous Next