Build Custom WebADI Integrators with EBS 12.1.2 Desktop Integration Framework

[Nov. 22, 2010 Update:  Office 2010 (32-Bit) is now certified with the E-Business Suite; see this article for details]

Oracle Web Application Desktop Integrator (Web ADI) is Oracle E-Business Suite's solution for integrating E-Business Suite applications with desktop applications such as Microsoft Excel, Word and Projects.  "Integrators" encapsulate the metadata and other information needed to integrate a particular Oracle E-Business Suite task with a desktop application.

I'm pleased to announce the availability of Oracle E-Business Suite Desktop Integration Framework (DIF), a design time framework that you can use to create custom integrators for Oracle Web ADI in Oracle E-Business Suite Release 12.1.2.

Several Oracle E-Business Suite applications provide seeded integrators out-of-the-box. You can now use the Desktop Integration Framework to define custom integrators for tasks of your own.

dif1.jpg

Oracle E-Business Suite Desktop Integration Framework provides a graphical user interface which you can use to define integrators and associated supporting objects.  You can reduce development time by using the GUI instead of working directly with the underlying Oracle Web ADI tables and APIs.  This user interface makes it easier to maintain your integrators, too.  The Desktop Integration Framework supports native Oracle Application Framework (OAF) UI widgets like Flex-fields, List Of Values, Pop-lists and Date pickers.

dif2.jpg
The Desktop Integration Framework allows you to:
  • Create Integrators using a wizard-based user interface
  • Define Integrators to upload data through PL/SQL APIs or directly to tables
  • Define Integrators to download data from text files or using SQL Queries
  • Define data validation rules
  • Embed UI widgets (List of values, Pop lists, Date pickers, Flexfields) in spreadsheets
  • Use the Oracle E-Business Suite Security Model
  • Define layouts and mappings for custom integrators
Your feedback is welcome

We are very interested in hearing about your experiences with this new tool.  Please post your comments here or drop me an email at email.jpg

Comments:

Rekha,

Is DIF likely to be back-ported to the versions of R12 prior to 12.1.2?

Regards,

Ketan

Posted by Ketan Thanki on February 14, 2010 at 10:46 PM PST #

Hi Ketan,

Currently there are no plans for back-porting to releases prior to 12.1.2. However, based on need we will evaluate this requirement.

Regards,
Rekha

Posted by Rekha Ayothi on February 16, 2010 at 02:58 PM PST #

Rekha,
DIF is a very useful framework for R12.1.2.Thanks for the info.

This helps us to build some stunning solutions without playing around with the code much.

Regards
Sudhakar Mani

Posted by Sudhakar Mani on February 17, 2010 at 12:54 AM PST #

Thank you Sudhakar.
We are eager to hear your experiences with DIF.
Regards
Rekha

Posted by Rekha Ayothi on February 21, 2010 at 03:33 PM PST #

Rekha,

We are looking at this functionality to insert data into our custom schema (11.5.10 R2). Any plans for getting this released for 11.5.10. Or if you could suggest ways to do it in 11.5.10.

Regards
Venkat

Posted by Venkata Mellacheruvu on March 02, 2010 at 12:14 PM PST #

Could someone please help me with this... I am an oracle applications user and trying to export data into excel, error: APP-PER-289793.. System Administrator must define a Web ADI integrator and associate it with this window. However, it used to work perfectly and i could get excel files but suddenly stopped, i am not getting any help from the administrator as he says nothing has changed on his side.. Is there any reason why the association could just break?? thanks, Bob

Posted by Bob on March 26, 2010 at 12:04 AM PDT #

Hi, Bob,

I'm sorry to hear that you're encountering problems with this. Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on March 26, 2010 at 02:08 AM PDT #

We would be very intereted in this being back ported to R 12.0.4

Posted by Grant Newcomer on March 30, 2010 at 02:02 PM PDT #

Hi Rekha,

I had build a custom integrator to upload data in a custom staging table. It is working find and doing its job well. Now, i need to call a concurrent program at the end of uploading process. Say, when all the rows are uploaded into the staging table, execute the concurrent program to read these rows and insert data into base tables.

Can you help me in this???

Did i mention, ADI and DIF rocks!!!!!!!!!!!!!!!!!!!!!

best regards
Nitesh Sharma

Posted by Nitesh on June 02, 2010 at 05:51 PM PDT #

Hi Rekha,

I has similar requirement as Nitesh , calling a concurrent program at the end of uploading process. I could submit concurrent program from Web ADI based on one of the thread in oracle forum but i could not pass parameter from Excel to concurrent program.

Any points on this is appriciated.
rupa

Posted by Rupa on August 19, 2010 at 03:48 AM PDT #

Hi Rekha,
How to end date or inactivate a particular WEB ADI Layout.?
All I can see in the "Layout" screen is to delete.
I just wanted to inactivate few layouts instead of deleting them completely.

Any idea.

Posted by Chandra on September 21, 2010 at 10:41 PM PDT #

Hi Rekha,

We have the similar problem as Rupa, that we cannot pass the parameter when calling a concurrent program after uploaded data to the interface table. Either the concurrent program can be submitted without parameter passed in; or error caught (ORA-00900) when call the concurrent program.

Please kindly advise.

HY

Posted by HY on September 26, 2010 at 07:19 PM PDT #

Hi Rekha and Steven,

We would also be interested in having this functionality for R12.1.1. Let me know if there are plans do back port the same.

Thanks
Sachin

Posted by Sachin Singh on October 19, 2010 at 06:03 AM PDT #

Hi Steven.
I was wondering if its possible to create java desktop application and get database connection from apps user authentication.
I've done this desktop application and I used jdbc connection with apps credentials but in PRODUCTION I got no apps password. so I have to change my connection to authenticate fnd user and pass to get a session then get database connection from that session.
I'm cannot see the way to do this. is there any Java API??
Any help would be great.

Regards!!

Posted by Ash on October 22, 2010 at 07:00 AM PDT #

Ash,

You might find this article useful:

AppsDataSource and Java Authentication and Authorization Service for Oracle E-Business Suite
http://blogs.oracle.com/stevenChan/2010/01/appsdatasource_jaas_ebs.html

It's designed to support Java EE programs deployed on application servers rather than desktops, so it might not be completely applicable to your requirements, but it's a start.

Regards,
Steven

Posted by Steven Chan on October 28, 2010 at 07:19 AM PDT #

Sachin,

Thanks for your feedback. We have no plans to backport this functionality to EBS 12.1.1 at this point.

Regards,
Steven

Posted by Steven Chan on October 28, 2010 at 07:31 AM PDT #

Should DIF be available through the 12.1.2 patch, I don’t see the ‘Desktop Integrator Manager’ menu/responsibility

Posted by Anjana Ghosh on December 17, 2010 at 04:13 AM PST #

Hi Anjana,

If you want to use Oracle E-Business Suite Desktop Integration Framework in Oracle E-Business Suite Release 12.1.2, apply the DIF: New Responsibility and Function for Desktop Integration Manager patch (9055234:R12.BNE.B, Patch 9055234) on top of Oracle E-Business Suite Applications Technology Release 12.1.2 (R12.ATG_PF.B.DELTA.2), Patch 7651091. After you apply the patch, assign the new Desktop Integration Manager responsibility to the developers in your enterprise who will define custom integrators.

The above and required setup steps are mentioned in Oracle Web Applications Desktop Integrator Release Notes, Release 12.1.2 (My Oracle Support Knowledge Document: 950876.1)

Regards,
Rekha

Posted by Rekha Ayothi on December 19, 2010 at 03:41 PM PST #

Hi guys,

Actually I want to download data from Oracle E-Business by providing parameters and then want to make few changes, upload back to E-business..is it possible here.

If yes, can you please send me some sample document as we want to do some POC.

Posted by srisu on January 03, 2011 at 02:39 AM PST #

Hello Rekha,

Like the posting of Nitesh and Rupa, would you please publish informaiton on how to call a concurrent program once the Upload is complete in Ebusiness 12.1.2?
Thanks
Santosh Rao

Posted by Santosh on January 05, 2011 at 09:16 AM PST #

Hi Santosh,

Wish you very happy new year!

Thanks for raising this query, let me address it.
Desktop Integration Framework was introduced in Oracle E-Business Suite R12.1.2 as part of Web ADI as a tool to define custom integrators. It provides basic ability to create simple custom integrator - download data, work on it and upload data.

In Oracle E-Business Suite R12.1.3, Desktop Integration Framework is enhanced to provide advanced features like "Ability to define importer rules" (call concurrent program after upload) for a custom integrator.

Please refer Oracle E-Business Suite R12.1.3 Desktop Integration Framework Developer's Guide E15877-02 for details on Importer Rules.

Thanks,
Rekha

Posted by Rekha Ayothi on January 05, 2011 at 09:38 PM PST #

Hello Rekha,

Thank you and wish you a very Happy New Year too

So calling a concurrent program using Importer rules is only possible in R12.1.3, Desktop Integration Framework ?

The reason i ask is that reading note Is it Possible to Launch a Standard Concurrent Program From a Custom WebADI Integrator? (Doc ID 1160340.1), i thought it is possible in 12.1.2 version

Can you please confirm?

Also, can you give some pointers/links to how to achieve the same in 12.1.2 , thanks for your time
Thanks
Santosh Rao

Posted by Santosh Rao on January 06, 2011 at 04:42 AM PST #

There are so many questions asked w.r.t the article posted by Rekha. When will these questions by answered? The author posts some article and goes away forgetting to answer the questions.

Posted by guest on June 03, 2011 at 03:58 AM PDT #

Hi All, Apologies for my delayed response, and thanks to dear guest for raising this point. As I scan through the posts, I see the following open questions, I will try to resolve them: Q 1) I want to download data from Oracle E-Business by providing parameters and then want to make few changes, upload back to E-business..is it possible here. Ans: Yes, it is possible. You may define an integrator with Content Parameters. While creating document, user will be prompted to entire value, and based on user entered value and Content definition, data will be extracted from source and presented in spreadsheet. Data in spreadsheet can be updated, and uploaded back to Oracle E-Business Suite. For more details, please refer Desktop Integration Framework Developers Guide (Note 979354.1), and R12.1.2 TOI: Implement and Use E-Business Suite Desktop Integration Framework from Oracle University. Q 2) How to call a concurrent program once the Upload is complete in E-business 12.1.2? Ans: Calling a concurrent program after upload is part of Importer process. Ability to define custom Importer for custom Web ADI Integrators using Desktop Integration Framework is only available from Oracle E-Business Suite R12.1.3. Q 3) How to pass parameter when calling a concurrent program after uploading data? Ans: Please refer R12.1.3 TOI: Implement and Use Web Applications Desktop Integrator from Oracle University. Regards, Rekha

Posted by Rekha Ayothi on June 07, 2011 at 03:38 AM PDT #

Could you please help me on this?

1.I call a custom PL/SQL API as an interface to insert data into a custom table. When testing, the records are getting insert into this custom tables, no errors.

2.In the importer section, I call another custom PL/SQL API to validate the data entered in this custom table. This program is also working fine.

3.Now, I need to show the corresponding error/success messages for those records that were inserted in step #1.

My Questions:
1. 'Document row - interface attribute mapping' shows the attributes from the PL/SQL API defined in #1 above. The 'Error row definition' I put a SQL query 'select * from xx_custom_table where status='ERROR'.

How do I use the above two import rules to achieve my purpose of showing the error message on the excel spreadsheet? THanks a lot, in advance.

The interface table is defined in a custom schema.

Posted by guest on June 16, 2011 at 03:43 AM PDT #

Dear Guest,

For how to use Importer Rules, please refer R12.1.3 TOI: Implement and Use Web Applications Desktop Integrator from Oracle University.

Regards,
Rekha

Posted by Rekha Ayothi on June 16, 2011 at 09:43 PM PDT #

Does anyone know of a solution to create a custom integrator for AR Transactions? I have tried to use the seeded Transaction API package but then it asks for ONE procedure or function. This API has many procedures in the one package.
I have heard the word 'wrapper' custom package mentioned in blogs but have not seen any solutions nor have any idea what this is and how to pass it to a technical resource. Has anyone achieved such a package? Many thanks. Geoff

Posted by Geoff Dale on September 28, 2011 at 06:34 PM PDT #

Hi Geoff,

I do not have expertise on AR Transactions, but let me try to understand your requirement in general, from Web ADI perspective.

The API that you are intending to use as Interface may have multiple procedures and/or functions. And, for a particular task (and hence custom integrator), you may want to use more than one procedure.

For example, say a ficticious API 'Employee Record' has procedures to 'Create Employee', 'Update Employee', 'Get Employee'. And, you want to use both Create and Update Employee APIs as interface for a custom integrator.

Please note, as of now, DIF does not support multiple interfaces for an integrator. Having said that, if your requirement is as mentioned above then, here is what you can do:

Create a custom API, say 'My Employee Record' with a procedure, say 'Create', with set of parameters as required for Employee Record. In addition, include one parameter say 'flag' to indicate if record needs to be created or updated. Within the custom procedure, based on the flag value, you may invoke both, 'Create Employee' and 'Update Employee' from original 'Employee Record' API. That is, the single custom procedure 'Create' of 'My Employee Record' performs the functionality of 2 procedures 'Create Employee' and 'Update Employee' of original API 'Employee Record'.

And, use the custom API 'My Employee Record' and single procedure 'Create' as interface while creating the custom integrator. In this case, the custom API is commonly referred as 'wrapper' API (as it wraps/ covers the original APIs based on some logic).

Hope this answers your query!

Thanks,
Rekha

Posted by Rekha Ayothi on October 04, 2011 at 12:26 AM PDT #

Thanks Rekha

I will pass on your comments to a technical resource to see if they can work something out. The issue we have is that creating AR Transactions has a procedure for Create Invoice Header and Create Invoice Lines with the two being linked. To do this in ADI the spreadsheet would need to have sections for both that are somehow linked during upload. I know More4Apps does this but we are trying to have an internal solution to avoid licence fees!

Cheers
Geoff

Posted by Geoff Dale on October 05, 2011 at 10:55 AM PDT #

Hi Rekha,

Thanks for your post on the bog, which gives more information.

I am working on WEB ADI R12.1.3 version.

I have create ADI template and able uplaod the data. I have created Interface based on API.
My query is, For each record it inserting valid into the some staging table. For example in the excel sheet if we have 5 rows if all the rows are valid then only the data need to be inserted into staging table. If any one of row validation fails all the rows need not be inerted.

How to achive this. Please advise us.

Thanks
Ravinder

Posted by guest on October 11, 2011 at 10:07 PM PDT #

I have created Web ADI Letters on DEV instance for OLM and moved to Test instance using FNDLOAD. Even though FND load download and upload completed successfully, when ever we click on Export data from Request Letters window we get error APP-PER-289793 with message "Before you can run Mail merger using this letter, Your System Administrator must create WEB ADI Layout and Integrators. the Layout must match the letter name and must be associated with Integrator which must also be attached with LETTER group."
Please note : My Letter name and Layout name is same.
Integrator and layout present on Test instance via FNDLOAD.
But still I am getting this error.
Please Help.

Posted by guest on November 29, 2011 at 11:18 PM PST #

Hello, Guest,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our WebADI specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on November 30, 2011 at 03:09 AM PST #

I am currently working on an upgrade of HRMS 11.5.10 to 12.1.4 and part of my work involves ensuring the Web ADI customisations work as per normal. I am highly disappointed about the lack of information about changes we need to make to ensure these customisations work in R12. I have spent weeks trawling metalink to find bits of information residing in different documents. Surely someone in Oracle should be be able to write a simple guide for people to follow ?. The fact that excel spreadsheets now gets generated regardless of the fact that you have chosen Word as the default viewer is a fundamental change that I cannot seem to find documented anywhere. I raised an SR few weeks ago and I was advised by one of your analysts that Excel and then Word would be opened every single time i am trying to generate a word document via Web ADI and I find this astonishing.

Posted by guest on December 09, 2011 at 01:27 AM PST #

Hi,

I am new to web ADI and want to build a custom integrator for oracle projects to upload the data into UDA table. so i started with a test (created a new custom table and create a simple package to insert values into the custom table, then layout and everything) and I am struck up. I have 3 queries..
1. I am unable to create the document. when i click on create document my excel opens and it never creates the document..
2. Is there any standard API for oracle projects to insert data into table? I'v referred the API guide but i unable to find out.
3. I also want to create dependent LOV's for the web ADI. How can i do that?

Hope you help me out..

Thanks
Sunil

Posted by guest on December 18, 2011 at 09:19 PM PST #

Hi Sunil,

I am sorry to hear that you are unable to create the document. I suggest you log a Service Request via My Oracle Support.

On 2nd query,
For any information on standard APIs from Oracle Projects, you may have to refer Oracle Projects documentation. You can also look for E-Business Suite public APIs from "Integration Repository" of your hosted instance. [Hint: For Oracle E-Business Suite R12.1.x, you can access Integration Repository of your E-Business Suite instance using Integrated SOA Gateway responsibility]. If you are unable to find an API, please log a separate Service Request for Oracle Projects.

On 3rd query - yes, dependent LOV's are supported by Web ADI framework, and used by Oracle seeded integrators. However, as of R12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV from UI.

Thanks,
Rekha

Posted by Rekha Ayothi on December 20, 2011 at 10:22 PM PST #

For a Custom WebADI I created Content which has date columns. The view which I am using for downloading the data has date values with timestamp.
When the data is downloaded into the WebADI the date values are coming in without timestamp.
I tried looking if there is some setup but could not find it.

Thanks in advance for the help.

Thanks
Vishwa

Posted by Vishwa on January 26, 2012 at 08:12 AM PST #

Hi Vishwa,

Web ADI does not support timestamp. The supported data types are number, string and date; the same is mentioned in Desktop Integration Framework Developer Guide.

If you have requirement for timestamp, please enter enhancement request in My Oracle Support, based on need we will evaluate the requirement.

Thanks,
Rekha

Posted by Rekha Ayothi on January 27, 2012 at 12:02 AM PST #

Hi Rekha,

Thanks for the response.

You mentioned that WebADI supports date data type.

My question was that does it support this kind of date which has timestamp also.

For example: '01/27/2012 23:59:59'

As I mentioned the custom WebADI which I have built has a Content defined for downloading the data. The sql for this has columns which have date (including timestamp).

When the data is downloaded I see only the date value 01/27/2012 and not 01/27/2012 23:59:59.

Please confirm if this is a bug or standard functionality.

Thanks
Vishwa

Posted by Vishwa on January 27, 2012 at 10:45 AM PST #

Hi Vishwa,

Web ADI supports date type 'without timestamp'. Hence, even if sql has columns with date-timestamp type, when data is downloaded to the worksheet, you may see it as 'date' only type (without timestamp). From your example, I see you are experiencing the expected behavior.

Thanks,
Rekha

Posted by Rekha Ayothi on February 09, 2012 at 11:02 PM PST #

Hi Rekha,

Please can you tell me the difference in wed ADI in 11i and R12?

We are in the process of creating a web ADI for oracle projects in 11i, we would be upgrading to R12 very soon.

My question is should we wait for the upgrade to R12 or should we just go ahead a create a new integratot in 11i?

Thanks for your help in advance.

Regards
New_user

Posted by new_user on April 09, 2012 at 08:51 AM PDT #

Hi,

Please refer My Oracle Support Note: 404152.1 -> Applications Technology Family RCD for enhancements in Web ADI R12 over 11i.

Regarding custom Web ADI integrators, please note that Web ADI provides DIF to create custom integrators from Oracle E-Business Suite R12.1.2. As of today, this capability is not available in 11i.

Hope that helps!
Regards,
Rekha

Posted by Rekha Ayothi on April 10, 2012 at 10:46 PM PDT #

We have integrated Oracle EBS with SSO using OAM 10g.

1. Logged in to EBS using SSO.
2. Downloaded Web ADI xls file. The file is opened sucecssfully and logged in to form automatically.
3. Now we logged in to another Oracle EBS instance.
4. Now opened the same xls file downloaded with first EBS instance.
5. Now the form does not logs in. Also it asks to select the responsibility but after selecting a responsibility, it throws a error.

Can you pls tell - after logging in to another EBS, why the automatic login to xls form downloaded from first EBS instance fails ?

Posted by guest on May 23, 2012 at 12:50 AM PDT #

Dear Guest,

I am sorry to hear that you encountered this error. It needs to be investigated further.

I suggest you log a Service Request via My Oracle Support (formerly Metalink).

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Rekha

Posted by guest on May 23, 2012 at 05:18 AM PDT #

I have created a custom integrator succesfully where I want to download some 10 rows from a custom table to a xl file. But I am not able to see or view the file consisting those records in the desktop.
Please let me know what is missing here.

Thanks,
Ahamed.

Posted by guest on June 08, 2012 at 04:27 AM PDT #

Hi Ahamed,

The basic steps to create custom integrator in Desktop Integration Framework are:
1. Create integrator
a) Define basic Integrator information and Security
b) Define Interface (if you want to upload data to Oracle E-Business Suite)
c) Define Content
d) Define Uploader (if you want to upload data to Oracle E-Business Suite)
e) Define Importer (if you want to validate and import data from Interface to Oracle E-Business Suite base tables)
2. Define Layout
3. Define Mapping (if you want to upload data to Oracle E-Business Suite)
4. Preview Integrator

I am not sure if you have followed these steps. For more information on each of these steps, please refer Oracle E-Business Suite Desktop Integration Framework Developer's Guide, Release 12.1.3, Part Number E15877-02.

Thanks,
Rekha

Posted by Rekha Ayothi on June 08, 2012 at 05:45 AM PDT #

Hi,

I had created custom integrator in 11i and in that i want to use Date LOV for one column. Is it possible?if yes can you give me the brief information.

Posted by Naveen on June 27, 2012 at 01:52 AM PDT #

Hi Naveen,

Date LOV can be defined for a column, for integrators created using Desktop Integration Framework (DIF). However, please note that the ability to create custom integrator in Web ADI is available only from Oracle E-Business Suite Release 12.1.2. Custom integrators are not supported in 11i. And, one should use DIF to create custom integrators.

Thanks,
Rekha

Posted by Rekha Ayothi on June 27, 2012 at 06:01 AM PDT #

Hi Rekha,

I have developed Web ADI custom integrator in 11i using API's and we are using it from long time.Now my requirement is to add a calender LOV when we click on the date column.

Thanks,
Naveen

Posted by guest on June 27, 2012 at 08:33 AM PDT #

Hi I am wondering if any one submitted concurrent program through the importer as a last step in the custom integrator. if so can you please share the steps.
Thank you
-Seshu

Posted by guest on July 06, 2012 at 03:31 PM PDT #

Hi Rekha,
I have created custom integrator and it is working fine and I am trying to run the interface as part of the custom integrator by
Defining Importer (if you want to validate and import data from Interface to Oracle E-Business Suite base tables)

I have a pl/sql concurrent program which I am planning to run at the end and trying to define importer and it is failing to create. Do you have any example/specific instructions for this step.
Thank you
-Seshu

Posted by guest on July 06, 2012 at 03:42 PM PDT #

Hi Seshu,

Couple of months back, we announced an important update for Web ADI R12.1.3:
Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

(Ref: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web)

This update includes a number of new fixes and consolidates previously-released patches that address issues in the Desktop Integration Framework of Web ADI Release 12.1.3.

If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you.

Thanks,
Rekha

Posted by Rekha Ayothi on July 09, 2012 at 05:02 AM PDT #

Hi Rekha,

Do you have ant steps or docs for Depenedent LOV in WEB ADI.

Regards
Niraj

Posted by guest on July 16, 2012 at 02:18 AM PDT #

Hi Niraj,

Web ADI framework supports dependent LOV, and Oracle-seeded integrators use them. However, as of Oracle E-Business Suite Release 12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV from UI.

Regards,
Rekha

Posted by Rekha Ayothi on July 16, 2012 at 09:54 AM PDT #

Thank you Rekha,
The patch worked and I could attach concurrent program to the custom Integrator now.

-Seshu

--------------------------------------

Hi Seshu,

Couple of months back, we announced an important update for Web ADI R12.1.3:
Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

(Ref: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web)

This update includes a number of new fixes and consolidates previously-released patches that address issues in the Desktop Integration Framework of Web ADI Release 12.1.3.

If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you.

Thanks,
Rekha

Posted by guest on July 19, 2012 at 09:55 AM PDT #

Hi Rekha,

I have defined importer. It is a pl/sql package procedure. Interface is a custom table.

When I upload data using Web ADI template, data is loaded into the table ( as expected ) but it is not firing ( executing ) pl/sql package defined in the importer.

There is no error and not sure how to debug this one.

Any pointers to resolve the issue.

Cheers

Posted by guest on July 31, 2012 at 06:49 PM PDT #

Hi Mahesh,

One of the seeded Upload Parameters - 'Automatically Submit Import', determines the submission of import program. Ensure to set the value of this parameter as true. Please refer the guide for more information on this Upload Parameter - Oracle E-Business Suite Desktop Integration Framework Developer's Guide [Part No: E15877-02].

Also, we published a white paper on how to define importer that returns error message. You may refer this step-by-step tutorial.

(Ref: https://blogs.oracle.com/stevenChan/entry/new_whitepaper_on_web_applications)

If you encounter the said issue after following the above suggested steps, please log a Service Request in My Oracle Support, one of our support engineers will assist you.

Thanks,
Rekha

Posted by Rekha Ayothi on August 01, 2012 at 12:41 AM PDT #

We are in 11.5.10.2 and created lot of Custom Integrators using Web ADI applications. We did not use any custom LOV's in them. Now we would like to use LOV capability with custom integrators (As we see this feature with default integrators provided by Oracle such as Journel Import, etc).

In a white paper i found that we can use BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV package.procedure to enable this feature. But in our instance we see the package but this procedure is missing. Wanted to know if this is R12 only feature. If so can we get a patch to back port it to 11i.

Posted by Ashok on November 05, 2012 at 12:32 PM PST #

Hi Ashok,

Please note, Web ADI provides Desktop Integration Framework (DIF) to create custom integrators from Oracle E-Business Suite R12.1.2. As of today, Desktop Integration Framework and, hence the capability to create custom integrators is not available in 11i.

However, you may refer following recorded online course for steps to create LOV in custom integrator in R12.1.2:
Implement and Use Oracle E-Business Suite Desktop Integration Framework (http://oukc.oracle.com/static05/opn/metalinklogin/?t=offering&c=765622276)

Thanks,
Rekha

Posted by Rekha Ayothi on November 06, 2012 at 04:45 AM PST #

Hi Rekha,

I have few questions, I want to add new where condition to existing LOV in seeded Integrator(Transaction Source LOV and Expenditure Type LOV) in PAXTTRXB (Projects- Transaction Import). is this possible?

If not how to copy same integrator and customize?
I tried using FNDLOAD its only copying Integrator definition and interface, but not Importer definition.
Please advice

Thanks
Anil B

Posted by Anil on December 24, 2012 at 12:03 AM PST #

Hi Anil,

Thanks for your query. Please note that you may not be able to modify Oracle seeded integrators.

As of now, we do not have an ability to duplicate an existing integrator definition and then, customize it. This is a good requirement, we may evaluate to include this feature in future release. Please log an enhancement request in My Oracle Support.

Thanks,
Rekha

Posted by Rekha Ayothi on December 24, 2012 at 01:49 AM PST #

Hello Rekha,

Can you please let me know how to get concurrent program parameters displayed in WebADI when i have an importer defined for a concurrent program after data upload.

We are on R12.1.3

Thanks
Rakesh

Posted by Rakesh on January 22, 2013 at 03:22 PM PST #

Hi Rakesh,

Thanks for the query. You can capture user-entered value during Upload process and, pass that value as Concurrent Program parameter value to Importer. Here is what you need to do while creating integrator:
1. Create Upload Parameter
2. In Concurrent Program Submission page, select 'Upload Parameter' as Source of Concurrent Program parameter.
3. Enter Upload Parameter name defined in step 1 here.

For details, refer Oracle E-Business Suite Desktop Integration Framework Developer's Guide [Section: To define a concurrent program request submission importer rule]:
http://docs.oracle.com/cd/B53825_08/current/acrobat/121bnedg.pdf

Thanks,
Rekha

Posted by Rekha Ayothi on January 23, 2013 at 01:09 AM PST #

Hello Rekha,

Thanks a lot, i am able to get the parameters for submission of the concurrent program but when i pass the parameters, I get the following error

The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 20003:ZENGL_SUMM_LOAD_CP has the following error: API Parameter name is not defined in Attribute 1.

The program has only 2 parameters , please advise.

Thanks
Rakesh

Posted by Rakesh on January 23, 2013 at 09:45 AM PST #

Hello Rekha,

Applied Patch#11704204 and still getting the same error.

Please let me know.

Thanks
Rakesh

Posted by Rakesh on January 23, 2013 at 02:08 PM PST #

Hello, Rakesh,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to Rekha and I if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on January 23, 2013 at 03:03 PM PST #

Hi,
I wanted to know if the Layout is customizable (Not just customization of Columns) like adding another detail region.

E.g if there is a Header Record to be uploaded in Standard, I would like to create another Detail region and then store it in a custom table. I also have to take care of the relationship.

Possible?

Regards,
Satya

Posted by guest on February 04, 2013 at 11:19 PM PST #

Hi Satya,

Layout lets you customize the way fields are presented in spreadsheet. So you can determine the fields displayed in spreadsheet, their position, etc. The fields may be placed in Context or Header or Line (i.e., Details) region. Web ADI supports single Context and single Line region. You may have multiple Header regions.

For more information on Layout capabilities, refer Oracle Web Applications Desktop Integrator Implementation and Administration Guide:
http://docs.oracle.com/cd/B53825_08/current/acrobat/121bneig.pdf

If your requirement is to introduce new fields and capture the data in custom table, you may have to create custom integrator. And, Desktop Integration Framework is the tool for creating custom Web ADI integrators.

Thanks,
Rekha

Posted by Rekha Ayothi on February 05, 2013 at 02:59 AM PST #

Rakesh

Did you find a resolution to the issue whereby you received the error:

The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 20003:ZENGL_SUMM_LOAD_CP has the following error: API Parameter name is not defined in Attribute 1.

after applying patch #11704204?
I am running into the same issue and as I am new to building custom integrators I can't tell if it's me or the application that is not working correctly.

Posted by Lance on February 05, 2013 at 01:27 PM PST #

Hi Lance,

Last year, we announced an important update for Web ADI R12.1.3:
Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

Refer: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web

This patchset includes fixes to issues such as this one in Desktop Integration Framework R12.1.3.

If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you. Please feel free to forward me the Service Request number if it gets stuck up in support process for some reason.

Thanks,
Rekha

Posted by Rekha Ayothi on February 06, 2013 at 02:09 AM PST #

Thanks Rekha.
We already have applied this patch as well which was why I was hoping that Rakesh may have found a resolution. I have opened a case with Oracle support and will keep all updated on what we find.
Many Thanks
Lance

Posted by Lance on February 06, 2013 at 11:03 AM PST #

Hi rekha
Thanks a lot for speedy reply.
What I understand from ur reply is that its not possible to achieve what I want to.. to create another line (detail region).
There cud be technical reasons i can think of like linking detail region record to another CORRESPONDING sub-detail records.even if that is possible how would you link that to multiple tables or map records to api.Nevertheless its a great feature. I am only concerned how much time oracle would spend to include new features specially when fusion already has these features included out of the box.
Satya
PS: Forgot to add my name in last comment, adding it now so that it is easy to follow.

Posted by Satya on February 06, 2013 at 09:07 PM PST #

Hi Satya,

Please log a formal enhancement request for this new feature via My Oracle Support. And, send me your Service Request number.

Thanks,
Rekha

Posted by Rekha Ayothi on February 07, 2013 at 09:22 AM PST #

Rekha,

I need to add a custom DFF field to the HR Integrator Setup template. I have made a copy of the template, but cannot figure out how to add our descriptive flexfield. Can this be done?

Thank you,
JudyZ

Posted by JudyZ on February 12, 2013 at 08:15 AM PST #

Hi JudyZ,

HR Integrator Setup is one of the Oracle seeded integrators from HRMS. I may not be able to comment on its behavior with custom DFF.

Thanks,
Rekha

Posted by Rekha Ayothi on February 13, 2013 at 01:18 AM PST #

Hi,
I went through all the Q&A in this page, but i didnt found my answer. Or probably i have missed it somehow. Well, my concern is i have upgraded my EBS system from 12.1.1 to 12.1.3. After login as sysadmin, i am unable to see the "Desktop Integration" responsibility.

Please suggest, how can i see this responsibility ? Do i need to apply the patches which are mentioned for 12.1.2 ? or there is separate ML id to follow ?

Thanks & Regards,
Saroj Mahanta

Posted by Saroj Mahanta on February 26, 2013 at 07:33 AM PST #

Hi Rekha,

We have an issue to be sorted out urgently. We are trying to upload asset activity association using webADI, we have built a custom integrator using the API EAM_ITEM_ACTIVITIES_PUB.Insert_item_activities

However the upload always fails giving SQL cannot upload error. Our only suspicion is the pm_last_service_tbl column. We haven't given any value for this column, it is a mandatory field, so this might be the reason why our upload failed. Now if we have to give the value, how is it supposed to be given? The type is table and we don't know how to pass the value for this column. Please advise how a value for a column type as table needs to be populated in the excel cell.

Thanks

Posted by guest on February 28, 2013 at 10:27 AM PST #

Hi, Guest,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on February 28, 2013 at 03:48 PM PST #

Hi Saroj,

No, the patches mentioned in Web ADI Release notes 12.1.2 (My Oracle Support Knowledge Document: 950876.1), need not be separately applied for "Desktop Integration" responsibility in 12.1.3. "Desktop Integration" responsibility should continue to be accessible after you upgrade E-Business Suite from 12.1.1 to 12.1.3.

Ensure that "Desktop Integration" responsibility assigned to "sysadmin" user is active (check Effective From and To dates from User Management screens).

Still, if you are unable to access this responsibility, log a service request in My Oracle Support and feel free to send me the SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on March 05, 2013 at 03:52 AM PST #

I want to create dependent LOV's for the web ADI.

For eg: Supplier and Supplier Site

Supplier Field : LOV displaying all the active suppliers
Supplier Site Field: Dependent LOV displaying all the sites under the Supplier entered.

thanks,
Ram

Posted by guest on March 25, 2013 at 04:58 AM PDT #

Hi Ram,

Currently, Dependent LOV is used by Oracle seeded integrators. As of R12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV for custom integrators.

Please log enhancement request in My Oracle Support for Dependent LOV in Desktop Integration Framework.

Thanks,
Rekha

Posted by Rekha Ayothi on March 25, 2013 at 07:06 AM PDT #

Does WebADI DIF support multi-DescFlexField on one excel row?

I am testing DFF function and it is working fine.

Now I want to import 2 diffent DFFs from one excel row, such as header's DFF and line's DFF.

Is possible or not?

Thx!

Regards,
Jasper

Posted by jasper on April 15, 2013 at 02:53 AM PDT #

Hi Jasper,

Yes, you can have multiple DFFs defined in an integrator; and, it can be in a row.
I didn't quite understand your requirement of Header DFF and Line DFF in a row - did you mean Header DFF would be repeated for all Line items? Can you mail me the use case with example?

Thanks,
Rekha

Posted by Rekha Ayothi on April 15, 2013 at 06:14 AM PDT #

Hi All,
My concern is that if we have 5 rows in web-adi excel and if all the rows are valid then only the data need to be inserted into staging table. If any one of row validation fails all the rows need not be inserted. please tell me how we can achieve it.

Regards
manish gupta

Posted by guest on June 08, 2013 at 12:06 PM PDT #

Hi All,
I have an issue in web-adi that if we have 5 rows in web-adi sheet and if all the rows are valid then only the data need to be inserted into staging table. If any one of rows validation failed then all the rows need not be inserted.Please suggest me.

Thanks
Manish

Posted by manish kumar gupta on June 08, 2013 at 12:30 PM PDT #

Hi Manish,

I didn't quite get your concern because, as of today, Web ADI behaves the way you have mentioned. That is, if multiple rows are being uploaded from Web ADI spreadsheet, and if any of the row fails validation rules, then none of the rows are uploaded. The rows are uploaded only if all of them pass validation rules. And, as of R12.1.3, you don't have to do anything special to achieve this functionality.

By any chance, are you referring to any specific Oracle seeded Web ADI integrators?

Thanks,
Rekha

Posted by Rekha Ayothi on June 10, 2013 at 02:21 AM PDT #

Hi,
In Excel 2013 for 'Add-ins' WHICH Name or Location (from Right Panel) is to select so that 'Add-Ins' is added and Displayed in EXCEL MENU bar?

It is observed that sometime this 'Add-Ins' appears / displays in the MENU and other times it doesn't.

Similarly while uploading, the data, only first 10 rows are uploaded. Where is setup we are missing?
Purpose is to upload any number of rows, as there are thousands of lines / rows to upload.

We are uploading PO and Supplier Prices data in a customized Table first. Then a procedure (already developed) will validate the data and fill-in PO Interface tables (2 or 3 depending on uploaded data), from where the standard "Import Price Catalogs" or "Import Standard Purchase Orders" will process the data.

Also what is community name for WEB ADI in the MOS communities?

Best regards,

MohammadYar

Posted by guest on June 15, 2013 at 03:03 AM PDT #

Hi Mohammad Yar,

Please note Web ADI is not yet certified with Excel 2013. Let me know, if you are facing this issue in Excel 2010 or earlier versions.

We do have plans to certify with Office 2013. Refer this blog:
https://blogs.oracle.com/stevenChan/entry/plans_for_certifying_microsoft_office

Feel free to subscribe to our blog, we will announce as and when it is certified.

Thanks,
Rekha

Posted by Rekha Ayothi on June 17, 2013 at 05:17 AM PDT #

Hi Rekha

Thanks for the post. I need to upload a GL Journal using WebADI. Before submitting I need to call a webservice or a pl/sql API to an other system to perform Custom Cross validation of the GL segements (Thrid party system which maintains cross validation rules).

Can I achieve it using a DIF. Appreciate your input.

Thanks
Sunil

Posted by Sunil Atluri on August 02, 2013 at 10:57 AM PDT #

Hi Sunil,

DIF provides an ability to call PL/SQL API registered in APPS schema, before submitting the main import program. As of now, it does not provide an ability to invoke web service from another application. It is definitely a good requirement. I will note it down. Meanwhile, you can log an Enhancement Request in My Oracle Support to track this requirement.

Thanks,
Rekha

Posted by Rekha Ayothi on August 05, 2013 at 04:32 AM PDT #

Hi Rekha,

In Addtion to the below mail from wrote by Anil on December 24, 2012 at 12:03 AM PST.

Do you have any update on the below issue?

I have few questions, I want to add new where condition to existing LOV in seeded Integrator(Transaction Source LOV and Expenditure Type LOV) in PAXTTRXB (Projects- Transaction Import). is this possible?

If not how to copy same integrator and customize?
I tried using FNDLOAD its only copying Integrator definition and interface, but not Importer definition.
Please advice

Thanks
Sekhar G

Posted by Sekhar G on August 12, 2013 at 06:14 AM PDT #

Hi Sekhar,

Thanks for your query and reference.

We have Enhancement Request 14068572 to track this requirement internally. If you wish to strengthen this ER, please log formal Service Request in My Oracle Support with your business case. This will help in prioritizing this ER.

Thanks,
Rekha

Posted by Rekha Ayothi on August 13, 2013 at 02:02 AM PDT #

Hello Rekha,

I am using the fnd_global.conc_request_id in my custom package for custom webADI Integrator and it is generating -1. Can you please advise.

Thanks
Rakesh

Posted by Rakesh on October 07, 2013 at 02:40 PM PDT #

Hi Rakesh,

I am sorry to hear that you are facing this issue. Please file a Service Request in My Oracle Support, one of our Support Engineers will help you.

Thanks,
Rekha

Posted by Rekha Ayothi on October 11, 2013 at 12:34 AM PDT #

Hi,
We are defining a custom Integrator based on the standard Project Interface table, PA_TRANSACTION_INTERFACE_ALL.
I had few queries -
Should we define a way for generating a value for the INTERFACE_ID (The column uniquely identifies the Record into the Interface table).

Also, currently I am getting an error during upload -
Unable to perform column validation due to program error.

Any help would be appreciated.

Thanks
Regards

Pradeep

Posted by Pradeep on November 13, 2013 at 06:19 AM PST #

Also experts, my other query is -

If i use Table as my Interface, and develop a Web ADI Template (without any Pre-Import Rules)-

Use that Web ADI Template (Excel Sheet) to enter table data and further Upload it, will the insert directly happen into the Table.

Sorry for my simple queries. As I am yet to do a cycle of Insertion. Struggling due to an error above. I guess the error came due to some columns being "Not Null" or "REquired in all Layouts" but not displayed. I am looking into it and checking it.

Regards

Pradeep

Posted by Pradeep on November 13, 2013 at 11:24 PM PST #

Hi All,

I was able to do a upload of data to the PA_TRANSACTION_INTERFACE_ALL from Web ADI Template (After unchecking the check box - Validate Before Upload). Request experts to share a knowledge on - Where do we build this Validation? It is not Pre-Import rules right. Or is the Validation on the Data assigned using LOV?

An interesting thing i noted is the coloumn - TRX_INTERFACE_ID.
I have not defined any logic to derive the data for this coloumn.
Request experts to share some knowledge on how this data was derived for this column.
Appreciate your help.

Regards

Pradeep

Posted by Pradeep on November 14, 2013 at 03:13 AM PST #

Hi Pradeep,

Let me try to answer some of your queries in last 3 comments:
1. On generating unique value for ID column
Yes, there is a way. 'Sequence' is one of the Pre-Import Rule Types. So, you can create a sequence, define pre-import rule and assign sequence value to the interface attribute. However, I am not the right person to answer how INTERFACE_ID column in Oracle Projects table PA_TRANSACTION_INTERFACE_ALL works.

2. Upload data without pre-import rules
As such defining an Importer is optional. That is, you may have Web ADI integrator without an importer. In this case, data from spreadsheet will be uploaded to Interface Table.

3. On Validate Before Upload
This option refers to the validation defined at the Interface Attribute level such as, LOV. It is not referring to Pre-Import rules.

I did not understand your query about TRX_INTERFACE_ID. You may raise Service Request in My Oracle Support for such queries as well - one of our Support Engineers will help you.

Thanks,
Rekha

Posted by Rekha Ayothi on November 14, 2013 at 10:46 AM PST #

Hi Rekha

I have a similar query to the one above regarding populating interface_id.

I therefore have a database sequence and have created a pre-import rule for this sequence. However, can you please explain how to assign this to my interface attribute? It does not appear obvious and I cannot find it explained in documentation

Thanks

Rob

Posted by Rob on November 18, 2013 at 12:52 PM PST #

Thanks Rekha for your comments. Appreciate your reply.

(1)
For the TRX_INTERFACE_ID, i could see a value generated in the Table, PA_TRANSACTION_INTERFACE_ALL. But i have not defined any Sequence, etc to assign a value for this Interface Attribute.

I have seen other Integrators where a sequence is assigned to the Interface Attribute as a Default SQL Query and the Default Value as - select XXXXXXX.NEXTVAL from dual. In my case, there is no such sequence defined or assigned.

(2)
How to create a LOV for a Key Flexfield Segments where User selects each segments. And based on security rules a valid code combination is selected.
There is an option for defining an Interface Attribute using Key Flexfield and also a Component based on FLEX. But this does not seem to work. Giving an error -
The value for Application ID supplied to the page flow is invalid

Regards
Pradeep

Posted by Pradeep on November 19, 2013 at 03:45 AM PST #

Dear All,

I was able to get the Key Flexfield Values populated per my expectation after a long try with trail and error. Putting across the steps i did for benefit of all -

Define individual segments to the Integrator
Step (1):

Attribute Name - Segment1...... (Define attributes equivalent to the number of segments in the KFF)
Enables for Mapping - checked
validation Type - Key Flexfield Segment
Group Name - <Auto Selected based on below Group Setup>
Segment Number - <Enter the Segment Number in the KFF Segment definition>

Step (2):
Define a Placeholder to hold the segment values
Attribute Name - ACCOUNT_FLEX_FIELD_CR
validation Type - Key Flexfield
Group Name - Choose the Group Name created below
Validation Entity - oracle.apps.bne.integrator.validators.BneKFFValidator
Key Flexfield - <Instance specific flexfield>
Concat Segment Values - Yes
Component Name - OA_FLEX Component (Web ADI)

Step (3):
Define a Group to combine the above segment Segments

Group Name - ACCOUNT_CR
Attribute Name - ACCOUNT_FLEX_FIELD_CR
Validation Type - Key Flexfield
Key Flexfield - <Select the Key Flexfield>
Validation Entity - <Auto Selected>
Concat Segment Values - Yes
Component Name - OA_FLEX Component (Web ADI)

In the Select Group Attributes section -

Select the Attributes defined as segments from Step (1)

Regards
Pradeep

Posted by Pradeep on November 25, 2013 at 01:55 AM PST #

Dear Folks,

We have build a web ADI Template to load data to the Interface table. Post loading we are calling a PL/SQL Package procedure.
Post entering data in the web ADI Template, and selecting Upload, we get the below error -

Error validating bne:integrator attribute in bne:data element:. No parameter definition found

Has anybody faced similar issue

Regards
Pradeep

Posted by Pradeep on December 04, 2013 at 08:13 AM PST #

Hi Pradeep,

I am sorry to hear that you are facing this issue. Please log formal Service Request in My Oracle Support, one of our Support Engineers will assist you. Feel free to forward me the SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on December 04, 2013 at 08:42 AM PST #

I am wondering whether I can use Web ADI 12.1.3 to upload data using a record type API. There is no interface table in this case. Most of the hz APIs are like this, for example hz_party_contact_v2pub. I added attributes to the interface for the user to supply the detail fields, but I don't see how to pass the individual fields to the api where it is expecting a full record. I thought to create an importer but I'm not sure if I need pre-import rules or add source/value on the PL/SQL API call. Or is it not possible to use record type APIs.

Posted by guest on December 05, 2013 at 02:35 PM PST #

Hello Guest,

As of today, Web ADI does not support APIs with record type parameters. There is a workaround - you may create custom PL/SQL procedure with native data types. Within the custom PL/SQL procedure, you may create record type structure and call Oracle seeded HZ API with record type parameter. And, use custom PL/SQL procedure as Interface for Integrator in Web ADI.

However, please log formal Enhancement Request in My Oracle Support and forward me the SR number. This will help in tracking the ER.

Thanks,
Rekha

Posted by Rekha Ayothi on December 05, 2013 at 11:22 PM PST #

I was facing the following issue when uploading data using Web ADI which i reported earlier -

"Error validating bne:integrator attribute in bne:data element:. No parameter definition found"

I did the following changes -

- There was some problem in the logic inbuilt in my pre-import PL/SQL package. I ran the PL/SQL package independently and there was some issues. Post debugging it, this error did not come

I am facing another issue now. Would request Experts to help -

I am using a Pre-Import Rule with a PL/SQL Package Procedure. The Parameters to the Package PL/SQL procedure is derived based on IMPORT as the Source with values derived from the Excel Template. We see that the Parameters are not passed to the Package during Upload and as a result, the Pre-Importer rule is not executed. The Parameter is <INTERFACE_TABLE_NAME.COLUMN_NAME>. Value for the COLUMN_NAME is entered in the Excel.

However, if I pass a hard coded value (Default Value), it is picked and the PL/SQL Pre-Import Package is executed.

Can any experts throw some light. Am i doing anything wrongly.

Regards
Pradeep

Posted by Pradeep on December 11, 2013 at 02:39 AM PST #

Hi

I have a custom Integrator to upload data in a table using Oracle Web Applications Desktop Integrator and I want to know how to create an Importer clean up (step 5)?

The Oracle official documentation does not have examples. Someone could give me an example or a guide?

We have Oracle EBS r12.1.3

Thanks for advance. Excellent blog congratulations.

Leonardo Morera

Posted by Leonardo on December 11, 2013 at 05:58 AM PST #

I have raised an issue earlier where my Importer (A standard PL/SQL package) to import the Project Cost was not getting values from the Source as Importer and Value as - PA_TRANSACTION_INTERFACE_ALL.TRANSACTION_SOURCE

I defined this column in the Group Attribute. Post this definition, this parameter value appeared in the table, BNE_PARAM_LIST_ITEMS. After this, the standard package picked the value from the source and run successfully.

I still have one issue where the Pre-Importer PL/SQL package is not getting values from the Source (Import) and value from PA_TRANSACTION_INTERFACE_ALL.TXN_INTERFACE_ID

Regards
Pradeep

Posted by Pradeep on December 17, 2013 at 03:22 AM PST #

I was facing an issue with Pre-Importer API not getting executed as the Input value to the API parameter was not flowing from the Source (Import) and Value (PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1)

I defined the column (PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1) in the Group Attribute.
Post this definition, this parameter value appeared in the table, BNE_PARAM_LIST_ITEMS. After this, the custom Pre-Importer package picked the value from the source and run successfully.

Regards
Pradeep

Posted by Pradeep on December 18, 2013 at 07:09 AM PST #

Pradeep

I think we are attempting something similar and it looks like you may have achieved it.

Can you explain a little more how you achieved this? Is PA_TRANSACTION_INTERFACE_ALL.ORIG_EXP_TXN_REFERENCE1 unique in each row of your spreadsheet? Is so was that pre-populated in the spreadsheet or defined by the user?

I am looking to do the following.
Have an attribute (RUN_ID) that is unique to the loader only, so this is easy with a sequence from sql.
Then for each record in that load spreadsheet I want them to be unique (RECORD_ID).

The 2nd part I cannot default in spreadsheet as far as I can see. So when loaded to interim staging table RECORD_ID is NULL. Perhaps I can use pre-importer, but would need to pass in RUN_ID (which is your issue). Ideally we should be able to default both these at the start which would allow error messages to flow back into spreadsheet easily...

Any help would be great

Thanks

Rob

Posted by Rob on December 24, 2013 at 03:04 AM PST #

Hi Rekha,
I encountered a problem.Can you help me with it?
I user the webADI to inport data into our system,but after I finish it and return to the home page,the main menu on the left is disappeared.

Regards
Whu

Posted by guest on December 26, 2013 at 05:23 PM PST #

Hi, Whu,

I'm sorry to hear that you've encountered an issue with this.

We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

Please feel free to forward your Service Request number to Rekha and I if it gets stuck in the support process for some reason.

Regards,
Steven

Posted by Steven Chan on December 27, 2013 at 09:22 AM PST #

Hi Rob,

If RUN_ID needs to be called into a Pre-Importer Package to generate a RECORD_ID, i would define RUN_ID as a Group Definition. The value of RUN_ID from the spreadsheet would flow to the Pre-Importer Package as a input variable and will do per the logic defined there.

Does the above answer the query.

Regards
Pradeep

Posted by Pradeep on January 02, 2014 at 01:32 AM PST #

My request to folks who are in R12.1.3 release.

Please apply the

Patch 9790225: Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1

It helped me resolve an error i was getting when trying to display the Error Message at the spreadsheet. Currently, the error message has disappeared.

Regards
Pradeep

Posted by Pradeep on January 02, 2014 at 01:35 AM PST #

Hi Pradeep

Yes I have it working exactly as you described using a pre-importer.

I think it would be a lot more flexible if you could have each record in the original spreadsheet with a unique record_id defaulted in - I can't see how to do this.

Rob

Posted by Rob on January 02, 2014 at 11:31 AM PST #

Hi Rob,
I tried acheiving what you planned to by creating a Sequence and allowing it to default on the spreadsheet. But this does not work as the Sequence defaults the same value to all rows of the spreadsheet. This is not a possible solution.

Fortunately for me, i am using a standard PA (Project Accounting) Interface table, PA_TRANSACTION_INTERFACE_ALL. The unique column in this Table is TXN_INTERFACE_ID. I found out that when you do a upload to this table from the Web ADI, a value is populated on this column (I believe it would be a inbuilt sequence in this table, I am not sure) though i have not inbuilt any setup to populate this column.

From your requirement, would you be defining a unique BATCH NAME to the set of rows uploaded at one load using Excel Template. So you can call the Pre-Importer based on this BATCH NAME. And in the Pre-Importer, you can assign unique data to each of the rows within the BATCH NAME.

Regards
Pradeep

Posted by Pradeep on January 06, 2014 at 06:57 AM PST #

Hi Rekha ,

We are planing to create and API that directly loads data in to the WEB ADI interfaces tables so that in a single phase we can put extracted data in to interfaces tabel and can migrate in to other environment.

please suggest about interfaces tables.

Praveen

Posted by praveen Singh on January 16, 2014 at 04:35 AM PST #

Hi Praveen,

Each of Oracle E-Business Suite modules have published the Open Interface Tables available for integration. You can view this list of Open Interface Tables in Integration Repository.

Now, what is Integration Repository? In one line .. It is a catalog of all public integration interfaces available from E-Business Suite. In R12.1, Integration Repository UI is accessible via Integrated SOA Gateway responsibility. You may also find Concurrent Program associated with Open Interface Table from this UI.

Refer Chapter 3 of this guide for steps to navigate through Oracle Integration Repository:
http://docs.oracle.com/cd/B53825_08/current/acrobat/121isgug.pdf

Thanks,
Rekha

Posted by Rekha Ayothi on January 16, 2014 at 09:29 AM PST #

Hi, Rekha,

For webadi's validation, I develop several java classes. Every time the java class is changed, I have to bounce apache server to make the modification is enabled.

But the EBS instance is shared by all team members, when apache server is restarted, other OAF developers got an error web page.

Is there a better way to avoid bounce apache server?

Hope your help.

Thx!

jasper

Posted by guest on January 27, 2014 at 10:16 PM PST #

Hi Jasper,

Any change in Java class requires restart of server. I am not aware of any automatic reload option for EBS.

Thanks,
Rekha

Posted by Rekha Ayothi on February 03, 2014 at 01:45 AM PST #

Hi, Rekha,

Got it. Thx!

Regrads,
Jasper

Posted by guest on February 05, 2014 at 10:19 PM PST #

hi Rekha,
I'm trying to have KFF and DFF in my cutom integrator. but I'm getting erorr. support is also not helping much. can you please look into SR SR 3-7864088981 : WEB ADI giving VB compilation error. and provide me any input. or do you have soem doc for providing steps for DFF fields and KFFs in a custom integrator. urgently needed. please help.

Rgds,
Shahnawaz

Posted by Shahnawaz on February 19, 2014 at 01:16 AM PST #

Hi Rekha

I have seen this tool in other instances, but now i am working on 12.1.1 instance but not able to see Desktop Integrator Manager Responsibility.

Desktop Integrator/Integration is available.

Please advice further ASAP.

Thanks

Posted by Dnyaneshwar on March 05, 2014 at 04:43 AM PST #

Hi Dnyaneshwar,

Desktop Integration Framework is not available in R12.1.1. It is available from R12.1.2 onwards. Also, advanced features are introduced in Desktop Integration Framework in R12.1.3. Please refer:
- Oracle Web Applications Desktop Integrator (Web ADI) Release Notes for Release 12.1.3 (Doc ID 1095155.1)
- Oracle E-Business Suite Desktop Integration Framework Release Notes for Consolidated Patch 9790225:R12.BNE.B (Doc ID 1450420.1)

Thanks,
Rekha

Posted by Rekha Ayothi on March 06, 2014 at 12:05 AM PST #

Hi, Rekha,

Like "pre-import rule", can we have a "pre-upload" process?

Whit this process we can do some prepare job, such as purge upload target table.

Thanks.
Jasper

Posted by guest on April 03, 2014 at 02:04 AM PDT #

That's a good requirement, Jasper. For tracking purpose, I encourage you to create Enhancement Request in My Oracle Support.

Thanks,
Rekha

Posted by Rekha Ayothi on April 03, 2014 at 08:38 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
23
24
25
26
27
28
29
30
   
       
Today