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 #

All,
Did we have resolution for the issue..
The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 203:XX_FV_BE_INT_CP has the following error: API Parameter name is not defined in Attribute 1.
I applied all the requested patches but still same issue. I opened the SR with Oracle.

Thanks
Rajesh

Posted by guest on May 16, 2014 at 08:19 AM PDT #

Hi Rajesh,

The following consolidated patch should solve it:
Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

If issue persists despite this patch, Oracle Support should be able to help you. If your service request is stuck up, mail me your SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on May 19, 2014 at 06:44 AM PDT #

Hi Rekha,

How to migrate custom layout for Oracle Web ADI, as per Oracle bnelay.lct is deprecated, there is no provision to use bneintegrator.lct for layout and bneintegrator.lct downloads all layouts for that particular Integrator.
Is there any .lct file which we can use for downloading Web ADI Layouts?

#***********************************************************************
# $Header: bnelay.lct 120.0 2005/08/15 02:14:45 dvayro noship $
#dbdrv: none
#
#***********************************************************************
#* This loader file is deprecated. Please use patch/115/import/bneintegrator.lct
# * to export the layouts for your integrator.
#**********************************************************************
# FILENAME
# bnelay.lct - LAYOUTS
#
# DESCRIPTION
# Loader DOWNLOAD/UPLOAD configuration file for LAYOUTS
#***********************************************************************

Regards
Anil Bejugam

Posted by guest on June 11, 2014 at 06:34 AM PDT #

Hi Anil,

No, as of now, we don't have a way to download a particular layout. Please file a Service Request in My Oracle Support and, forward me the SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on June 12, 2014 at 11:46 PM PDT #

Hi Rekha,

I have raised SR and SR number is “3-9144886761 : WebADI Custom Layout Migration”

Regards
Anil Bejugam

Posted by guest on June 13, 2014 at 03:39 AM PDT #

I am trying to use pre-import in my template using pl/sql , and this procedure should return validation error to the spread sheet?
How to achieve this ?

Posted by guest on June 18, 2014 at 04:12 PM PDT #

Hello Guest,

Please refer the tutorial mentioned here for the steps to return error messages to spreadsheet https://blogs.oracle.com/stevenChan/entry/new_whitepaper_on_web_applications

Thanks,
Rekha

Posted by Rekha Ayothi on June 19, 2014 at 09:58 AM PDT #

Hi Rekha,

I found a problem with the new DIF in r 12.2. When I define the importer concurrent program parameters (values from interface table) it submits the concurrent program but without the parameter values. The values are present in the interface table and the definition of importer doesn't have errors. This is asynchronous conc req. The program submitted has paramters taken from interface table(so the right side column of parameter called source is "Interface Table". And correct values of column of interface table are passed. Please advice.

Regards,
Kaushik

Regards,
Kaushik

Posted by guest on July 11, 2014 at 09:41 AM PDT #

Hi Kaushik,

Please file Service Request in My Oracle Support. One of our Support Engineers will help you. Also, feel free to let me know the SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on July 14, 2014 at 03:52 AM PDT #

Hi Rekha,

The SR number is 3-9336840901. I haven't received any resolution to it so far. There are 2 other SR related to ADI 3-9350745921 and 3-9347159931. Please let me know if you have suggestions, I would be glad to try it out. We are running against critical deadlines and there doesn't seem to be any resolutions in sight.

Regards,
Kaushik

Posted by Kaushik Biswas on July 17, 2014 at 02:28 AM PDT #

Hi Rekha,

The SR number is 3-9336840901. I haven't received any resolution to it so far. There are 2 other SR related to ADI 3-9350745921 and 3-9347159931. Please let me know if you have suggestions, I would be glad to try it out. We are running against critical deadlines and we don't see any resolution doesn't in sight.

Regards,
Kaushik

Posted by Kaushik Biswas on July 17, 2014 at 02:31 AM PDT #

Hi Rekha,

I have created a custom integrator for Cost Import Process and it populates the interface table but errors when submitting the request with below error. I have SR 3-9347985647 : Web ADI not submitting Concurrent Request open for this issue and not getting anywhere. I appreciate any help in this regard.

The upload process has completed with errors. Press Close to return to the document and fix the errors.No concurrent import requests have been submitted
No rows uploaded
0 rows were invalid
The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 702:LOZIER_CST_UPD_INT_CP has the following error: API Parameter name is not defined in Attribute 1.

Thanks,
Srini

Posted by guest on July 18, 2014 at 09:07 AM PDT #

Hi Rekha,

We have build a custom integrator on Oracle Apps version 12.1.3.

When we double click on the custom Table validated LOV(Standard LOV) nothing happens.

But when i change the type of LOV in hte interface to POP LIST it works fine.

We are using MS-Office 2010.The error appears in the Excel 2010 template.

Your inputs on this issue will be very valuable & Help me a lot.

Many Thanks

Nandan.

Posted by guest on July 22, 2014 at 04:55 AM PDT #

Hi Nandan,

Thank you for your note.

I suspect, some of the LOV related metadata is either missing or incorrect. You may want to check the component name selected for 'Standard' LOV and, the definition of LOV component itself.

Please refer the tutorial mentioned here:
https://blogs.oracle.com/stevenChan/entry/video_tutorial_web_adi_how

Thanks,
Rekha

Posted by Rekha Ayothi on July 23, 2014 at 06:53 AM PDT #

Rekha,

I added parameter internal names (as declared in the package) and now I get below error:

The upload process has completed with errors. Press Close to return to the document and fix the errors.
No concurrent import requests have been submitted
No rows uploaded
0 rows were invalid
The import program could not be started. Contact your system administrator.. A error occurred while running a concurrent request:

Thanks,
Srini

Posted by guest on July 23, 2014 at 12:29 PM PDT #

Hello Rekha,

Thank you so much for your inputs on my query.It is resolved now.

I have two additional queries & it would be great if you can point me in the correct direction.

1)We have many custom Web Adi integrators in our Oracle Apps 11i sytem which we want as is on R12 instance.Can you please let us know how can it be migrated to the R12 system without making any changes.

2)Is there is any video or document which can be reffered to build a custom web adi i.e.(Integrator,Interface,Layout,Mapping,Uploader etc.)

Your inputs for the above queries will be very helpful.

Many Thanks!!

Nandan.

Posted by Nandan on July 24, 2014 at 01:57 AM PDT #

Hi Srini,

As I mentioned in my mail, ensure to provide unique Reference Name across Importer Rules defined for an integrator. It need not be necessarily the internal name.

Thanks,
Rekha

Posted by Rekha Ayothi on July 24, 2014 at 04:15 AM PDT #

You are welcome Nandan.

1) Desktop Integration Framework and the ability to define custom Web ADI integrators is available for EBS customers from R12.1 only. We can guide you on migration of Web ADI integrators built using DIF only. For your case, you may have to create custom Web ADI integrators using DIF in R12.1.

2) You may refer tutorials mentioned here:
https://blogs.oracle.com/stevenChan/entry/new_whitepaper_on_web_applications
https://blogs.oracle.com/stevenChan/entry/video_tutorial_web_adi_how

Thanks,
Rekha

Posted by Rekha Ayothi on July 24, 2014 at 04:33 AM PDT #

Hi Rekha,

We are in R12.1.2 version of apps and implementing custom web ADI for item price update and min max qty updates. Along the way, I noticed following issues where I need your help.

1) I want to add new column to an existing custom web adi intergator/interface of type PL/SQL package/procedure. I added the new argument into plsql package/procedure. But when I try to update the interface defintion, by default it will not display the attribute associated to new argument added. When I try to add new attribute, it adds with type custom and not real. I dont think, I can pass custom attributes types as argument to my API. How can I achieve this?

2) If I make any changes to existing integrator's interface like change attribute default value, validation or add/delete attributes, and tried to re-migrate using bneintegrator.lct/FNDLOAD, it won't reflect the changes properly. I see only new attribute gets added and it will not update existing ones. Also, it wont remove deleted attributes. Here is the way I am downloading and uploading this. How can this be achieved?

FNDLOAD apps/XXXXXX 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct /tmp/XXDL_TEST_WEB_ADI_XINTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN=XXDL INTEGRATOR_CODE=XXDL_TEST_WEB_ADI_XINTG
FNDLOAD apps/XXXXX 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct /tmp/XXDL_TEST_WEB_ADI_XINTG.ldt

3) During an upload using custom Web ADI, if one or a few rows error then the following message is displayed and the correct rows still get uploaded stating.

No rows uploaded
One row was invalid

Per say; I have to upload 100 rows; where 25th row is invalid due to some validation error (through raise application error) returns from API/procedure. Though the process continues further from 26th row till end, when it completes processing, I don't see Green color smiley for all successfully processed records and they do remain flagged for upload. Error record will be indicated through red smiley and a error message. Am i missing something here.

Looking forward to your response.

Thanks
Vasu

Posted by Vasu on July 28, 2014 at 01:52 PM PDT #

Hi Rekha,

I have followed the steps mentioned in this blog to create a accounting KFF LOV on the template.My integrator is registered with custom application.I have Grouped the accounting segement in the interface and have given the validation as 'Key Flex Field' & using the OA_FLEX Component registered under 'Web Applications Desktop Integrator'.I have also tried using the 'GL Flex' which registered under 'General Ledger' appication.

When i run the web adi template it gives me the following error:

Fatal error: Please have your system administrator view the bne.log file.
oracle.apps.bne.exception.BneInvalidException: The key flexfield identified by Application ID: 101, flexfield number: 101 and flexfield code: GL# is not defined in Oracle Applications.
Please contact your support representative.

We are trying to achieve the same functionality as found on the standard Web Adi 'GL Journals' where we can select the code combination.

Awaiting your inputs eagerly,

Many Thanks!!

Nandan.

Posted by guest on July 29, 2014 at 05:10 AM PDT #

Hi Rekha,

Under "Define Layout", I can see "Projects - Transaction Import" but I am not able to see it under "Create Document".

Do you have any idea about it?

Resp. Name: Desktop Integration / Oracle Web ADI
Version: 12.1.1 Vision Demo

Thanks,
Manish

Posted by Manish on July 30, 2014 at 10:26 PM PDT #

Hi Vasu,

Apologies for delay in response. Let me try to answer your queries.
1) If there is change in signature of API used as Interface, you would have to re-create the interface. That is, delete the interface for the integrator and, then create interface selecting the updated version of the API.

2) Usage of FNDLOAD to download and upload integrator definition is fine here. UPLOAD action will not remove existing attributes. However, let me understand the requirement here. Please raise ER in My Oracle Support and let me know the SR number.

3) That is the behavior in 12.1. If any of the rows error out, none of the records are uploaded. In 12.2, we have an option to upload each valid row.

Thanks,
Rekha

Posted by Rekha Ayothi on August 01, 2014 at 04:11 AM PDT #

Hi Nandan,

Please file Service Request in My Oracle Support. One of our Support Engineers will help you. Feel free to mail me the SR number if it is stuck up with Support.

Thanks,
Rekha

Posted by Rekha Ayothi on August 01, 2014 at 05:35 AM PDT #

Hi Manish,

All Web ADI integrators may not be available from Create Document function. Availability of an integrator from Create Document depends on Integrator and security rule definition. Projects - Transaction Import may have to be used as part of the Projects functional flow - not from 'Desktop Integration' responsibility.

Thanks,
Rekha

Posted by Rekha Ayothi on August 01, 2014 at 05:45 AM PDT #

Hi Rekha,

Thanks for the information.I have raised SR #3-9405026001 for issue#2 and 3.
On my issue#3, it is not behaving the way you described. Actually, I observed all rows are getting processed even after any one/few in middle fails. Also, it won't display green success smiley for success records and upload flag will remain with all records

Posted by Vasu on August 01, 2014 at 10:32 AM PDT #

Hi Rekha -

Is it possible to remove my email address (kaupvasu@gmail.com) from receiving emails when others reply/comment on this blog. I checked "Notify me by email of new comments" when I added my question.

Thanks,
Vasu

Posted by Vasu on August 01, 2014 at 10:35 AM PDT #

Hi, Vasu,

>Is it possible to remove my email address... from receiving emails when others reply/comment

No, unfortunately not. This blogging system is rather primitive, I'm afraid.

Regards,
Steven

Posted by Steven Chan on August 01, 2014 at 12:05 PM PDT #

Hi Rekha,

I have raised an Oracle "SR 3-9429337191 : Web ADI Template upload issue:Unable to load default value generator".

We were able to solve the issue i have mentioned in my previous pos but are now stuck with the Default value generator problem.

Please let me know youe inputs.

Nandan.

Posted by guest on August 03, 2014 at 11:20 PM PDT #

Hi Rekha/Steven,

If i create another attribute in interface definition (interface based on table and not api) can i map it to some column in table? Suppose the table has one column x_id. Can i create another column y_id and map it to the same column. I'll be displaying y_id in one layout but populating y_id would mean x_id gets populated.

Posted by Kaushik Biswas on August 04, 2014 at 08:54 AM PDT #

Hello Rekha,

I need to add default value of SQL Query on interface attribute, but this sql query depends on another attribute.
Is it possible to add dependent default value on interface attribute?

select msi.list_price_per_unit
from mtl_system_items_b msi
where msi.organization_id = 198
and msi.segment1 = P_ITEM value that user selected in P_ITEM field

Posted by oshrat on August 20, 2014 at 05:30 AM PDT #

Hi Kaushik,

Missed your comment earlier. You can create custom interface attribute and include that in layout as well. Second part of the requirement can be tricky - you may have to explicitly populate x_id column with value in y_id in importer program.

Thanks,
Rekha

Posted by Rekha Ayothi on August 20, 2014 at 10:00 AM PDT #

Hi Oshrat,

This is an interesting requirement. As of now, SQL Query cannot dependent on another interface attribute. However, you can achieve the required functionality by explicitly updating the interface attribute in the importer - may be as Pre-Import steps to ensure that the values are populated before main Importer program is executed.

Thanks,
Rekha

Posted by Rekha Ayothi on August 20, 2014 at 10:10 AM PDT #

Hi Rekha,

I have an issue with SSO login.
When i am working on the excel and the session is lost it pops up LOV for re-entering SSO credentials and on entering & submitting it works just fine.

But I shutdown the system and come back tomm and re-try upload or try to modify anything in excel it again popups up SSO credentials and on reentring and proceeding its just stuck in the SSO credential screen only it doesn't proceed ahead.

Any clue is this an issue or this is not feasible at all.

Thanks
Shubhadeep

Posted by Shubhadeep on September 11, 2014 at 05:13 AM PDT #

Hi Rekha,

We have developed one custom integrator where it will download the data to the excel sheet and we do modify some records and do the upload process. If there are any error in the corresponding record, error message will be updated to that record.

Lets say there are 10 records out of which we modified 5 records and did the upload process and during validation process say 3 records are error out.

All 10 records will insert to staging table with their updated error message ( here 3 records will have the error message).

Requirement was:- Once all records are uploaded, need to send an email with all the error records and their message.(This should be included in the upload process (importer type)).

Kindly let us know , can we achieve this. if so kindly provide the calling of concurrent program.

Thanks,
Prasad

Posted by guest on September 11, 2014 at 07:11 AM PDT #

Hi Shubhadeep,

It seems to be an issue. Please file Service Request in My Oracle Support, one of our Support Engineers will help you.

Thanks,
Rekha

Posted by Rekha Ayothi on September 11, 2014 at 07:26 AM PDT #

Hi Prasad,

Interesting requirement! As of now, we don't have Importer Rule that will send an email at the end of upload process. Please file Enhancement Request in My Oracle Support and let me know the SR number.

Taking a longer route, you may define a workflow process and send notification from PL/SQL Concurrent Program, which will be then used as main Importer program. You may refer this whitepaper (use Concurrent Program as Importer Type instead of PL/SQL API):
https://blogs.oracle.com/stevenChan/entry/new_whitepaper_on_web_applications

Thanks,
Rekha

Posted by Rekha Ayothi on September 12, 2014 at 04:57 AM PDT #

Hi Rekha,

I have a requirement of creating 2 KFF fields in my custom Web ADI,
I have tried and followed the methods mentioned in one of the above comments.
My problem is, Out of the 2 KFF fields i created 1 is working and the other is not.
I have used same settings/procedure to create both,still the 2nd field doesnt work.
Please help me. If any other procedure has to be followed.

Regards,
hema

Posted by Hema on September 20, 2014 at 12:18 AM PDT #

Any guide or examples on content based on Java Class. Can't seem to find any documentation pertaining to this anywhere

Posted by guest on September 21, 2014 at 02:25 AM PDT #

Hi Rekha,

I have created custom integrator but its not showing in create document integrator LOV.

while creating custom Integrator i have checked for Display in create document.

please suggest....

Posted by guest on September 25, 2014 at 09:29 PM PDT #

Hi Hema,

Well, one can certainly have more than one KFF fields in an integrator. I suggest to file a Service Request in My Oracle Support, one of our Support Engineers will help you.

Thanks,
Rekha

Posted by Rekha Ayothi on September 26, 2014 at 02:08 AM PDT #

Dear Guest,

As of now, we don't have any tutorial for Java content type. I will post it in blog as and when it is available.

Thanks,
Rekha

Posted by Rekha Ayothi on September 26, 2014 at 02:30 AM PDT #

Dear Guest,

To display custom integrator in Create Document LOV, ensure to:
1. Check 'Display in Create Document' checkbox
2. Add Security Rule for function 'Desktop Integration - Create Document'

Thanks,
Rekha

Posted by Rekha Ayothi on September 26, 2014 at 02:38 AM PDT #

Is there any way to auto-generate a different value from a sequence for each row. Specifying a SQL with sequence nextval is generating a single value for each row.

Thanks

Posted by guest on October 03, 2014 at 05:36 PM PDT #

Hi Rekha,

Is it possible to have dynamic heading columns to excel sheet after clicking on download.

Below is the scenario:-

lets assume there are 2 Special Information Type

SIT1 will capture the Disability details
Disability Structure
Segment1 -> Disability Type
Segment2 -> Certified Hospital Name

SIT2 will capture the Visa deatails
Visa Detail Structure
Segment1 -> Visa No
Segment5 -> Visa Applicant Name
Segment6 -> Visa Expiry date

For the custom integrator has a parameter Sit Name

When the user provided the name of the sit name and click on the create document. The Excel Sheet should display the names of the segment as Header.

Kindly suggest me in achieving this feature in Web adi.

Thanks
Prasad.

Posted by guest on November 06, 2014 at 05:42 AM PST #

Hi Prasad,

You can not change interface column headings dynamically. Not sure I understand your requirement completely. Are Disability and Visa - 2 structures of the same KFF? Or, they are 2 KFFs to be displayed based on selected SIT? Or, they are just columns and, not a KFF? Else, if requirement is as simple as it appears here - did you try having 2 different layouts for the same integrator?

I suggest to get in touch with Oracle Consulting, they will assist you.

Thanks,
Rekha

Posted by Rekha Ayothi on November 07, 2014 at 09:45 PM PST #

Hi Rekha,
I have defined a parameter as date type, And used it as content paramter.
The parameter will be used in content SQL query to limit the result.
But I got an sql error ORA-00932: inconsistent datatypes: expected DATE got NUMBER.
My Question is, for DIF,Can the parameter of date type be processed in SQL Query.

Best Regards

Posted by guest on November 10, 2014 at 03:14 AM PST #

Dear Guest,

Looks like you are missing something... you can have date type content parameter to limit the records returned by SQL query.

You may file service request in My Oracle Support, one of our Support Engineers will assist you.

Thanks,
Rekha

Posted by Rekha Ayothi on November 12, 2014 at 02:11 AM PST #

Hi Rekha,

We are looking at creating custom Web ADI integrations on R12 (12.1.3.). Will this require a separate license or are is this licensed as part of the application.

Thanks and Regards.

Posted by guest on January 09, 2015 at 06:48 AM PST #

Dear Guest,

I am afraid, this may not be the right place to discuss licensing terms. I suggest to get in touch with your Oracle account manager to discuss this further.

Thanks,
Rekha

Posted by Rekha Ayothi on January 12, 2015 at 01:43 AM PST #

We are having issues with SHA2 certificate on e-business 12.1.2 Oracle application server. Oracle has open bug with their development to make sure SHA1 cert can be supported on 12.1.2. In the mean time we have updated proxy behind oracle application server 10.1.3 apache with SHA2 cert and pass that to e-business apache. After making this change adi stopped working.

Can you let us know what files does oracle web ADI look into for validation of SSL certificate. If we know this information we are confident we can get solution with SHA1 certificate.

Thanks,
Sanjeev.

Posted by guest on January 23, 2015 at 10:40 AM PST #

Hi, Sanjeev,

We posted an article yesterday on SHA-2:

Using SHA-2 Signed Certificates with EBS
https://blogs.oracle.com/stevenChan/entry/using_sha2_signed_certificates_with

I'd like to ensure that you get some help with this. Can you send me your Service Request number for your current issue?

Regards,
Steven

Posted by Steven Chan on January 23, 2015 at 10:55 AM PST #

Hi Steven,

Logged SR 3-9980836301 : R12: SSL certificate with SHA2 option does not work
Bug 19815559 - NEED SHA2 SUPPORTED FOR EBS APPLICATIONS FOR OHS/TLS SERVER COMMUNICATION

On our PRD environment SSL certificate is expiring soon.(another 2 months).
It would be really helpful if you can get this to work for us on 12.1.2 with SHA1 instead of upgrade to 12.2(as we cant upgrade PRD so soon).

We also tried to get SHA1 certificate temporarily till we do the upgrade however vendors are not giving SHA1 cert and are suggesting to use atleast SHA2.

Thanks,
Sanjeev.

Posted by Sanjeev on January 23, 2015 at 11:10 AM PST #

Hi Steven,

Also this is the web-adi SR#:
3-10167686591 : web-adi is throwing errors during download of template

Thanks,
Sanjeev.

Posted by guest on January 23, 2015 at 11:12 AM PST #

Hi,

I would like to know if this can help me use my custom file to insert information into PIM as well.

Actually, when we use import from excel utility, we need to download and then copy paste information from our templates to PIM provided template, so can this be avoided and directly our file can be used as a source for PIM.

Please let me know your comments on same.

Thanks,
Deepti

Posted by guest on April 20, 2015 at 10:39 PM PDT #

Hi Deepti,

From Web ADI perspective, you can directly download data from text file to Web ADI spreadsheet, which can then be uploaded to EBS application. To achieve this functionality, define Content while creating custom Web ADI integrator. Refer the following document (Desktop Integration Framework Developer Guide):
http://docs.oracle.com/cd/E26401_01/doc.122/e22005/T544562T544566.htm#bnedgmidefcont

I am afraid, I may not be able to comment on PIM provided template. You may have to refer PIM documentation for the same.

Thanks,
Rekha

Posted by Rekha Ayothi on April 21, 2015 at 06:16 AM PDT #

Hi Pradeep,

For the flex LOV I followed the steps mentioned by you. But the value or the ID is not getting saved in the tabled. Am i missing some step. Kindly advise.

Thanks,
Pallavi

Posted by pallavi on April 29, 2015 at 04:45 AM PDT #

Hi Pallavi,

We have a tutorial on using Key Flexfield validated component in custom integrator. I suggest to refer the same. Here it is:
https://www.youtube.com/watch?v=x0pz1i-mBcA

Thanks,
Rekha

Posted by Rekha Ayothi on May 15, 2015 at 04:50 AM PDT #

I have virtually gone through all the comments in this article but haven't found yet one document that actually explains why parameter definitions are defined and how they will be used by Web ADI. Every time an answer is provided, an article is referenced and most of the article simply explains the step to define and maintain parameter lists and parameter. I'm sure these are available in "Window Help". What would really be useful is the 'why's. Simply put, why are parameters defined the way it is defined and how are they used? A single example would clear many questions. Your demo of returning errors back was good. A similar example, perhaps from your team that assists customers who open a related SR would be great. Is this too much to request? Thank you for your valuable time and contribution. As a product lead manager your time is a scare resource and I understand and appreciate that.

Thanks
Srikanth

Posted by Srikanth on May 25, 2015 at 09:55 AM PDT #

Hi Srikanth,

I am sorry to hear this. Please mail me the SR number at email address mentioned above in the blog article, let me followup.

Thanks,
Rekha

Posted by Rekha Ayothi on May 26, 2015 at 10:34 AM PDT #

I don't have a SR. I'm looking for some document that explains the concept of parameter and parameter lists.

Posted by Srikanth on May 27, 2015 at 11:50 AM PDT #

Hi Srikanth

The stage to use parameter in WebADI Query (for example):
1. create Uploader:
Uploader -> Uploader Name: 'Test-Uploader'
Uploader Parameteres -> Title: 'Upload Page', Header: 'Upload Parameters'
1.1. Add Parameter (in Uploader):
Display name: 'bne:contractnum' (contractnum-just for example)
Parameter Name: P_CONTRACT_NUMBER'
Data Type: String
Category: Field
Validation Tupe: Value set
Value Set Name: 'CONTARCT_NUM_LOV' (you must first create value set)
Prompt Left: xxx
Display Type: List Box
popualted all others Diaply Options
2. Create Content:
Type: SQLQUERY
2.1. Define query and content column, sql query depends on parameter:
select ... from oke_k_headers_full_v h where h.contract_number = $PARAM$.P_CONTRACT_NUMBER (parameter name)
2.2. Content Parameters -> parameter list - choose your uploader name ('Test-Uploader')

I wrote a little document with all stages, but I can attached it.
I hope it will help you

Posted by oshrat on May 28, 2015 at 03:25 AM PDT #

Hi Rekha,

Great blog. Thanks for all the informative comments.

We are on EBS release 12.1.3. Below is my issue and I have logged an SR as well.

How to add new parameters to API-Procedure type interface

I have created a custom integrator based on a custom API - Procedure interface type. The package procedure has 10 input parameters. Everything is working fine with this integrator. I had to add 5 more columns to the procedure. How can I add these additional 5 columns to the integrator without deleting the existing definition? I tried to delete the entire definition and keep getting the below error.

oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key

The only way I was able to achieve it was by creating a new integrator, rename the package procedure to a new one, give a new Interface name, new Package name, new Procedure/Function name. Thus I lost all the correct logical names I had given while developing it initially. Now all the names are like XX_1 and so on. I fear if I have to make another change, I would end up with XX_2 and so on.

Is there a better way to manage this without deleting and losing all the previous definition?

Thanks,
Sameer

Posted by Sameer on May 28, 2015 at 06:55 AM PDT #

Thanks Sameer.

Coming to your question:
Interface definition is tightly linked to the underlying API or Table. If there is any change in underlying API or Table, one needs to redefine the interface for integrator. That is, delete the existing Interface and create new Interface within the same Integrator. You need not create new integrator or, new package with different procedure/function name.

You may apply Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B) mentioned here:
https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web

Also, feel free to mail me the SR number.

Thanks,
Rekha

Posted by Rekha Ayothi on May 29, 2015 at 06:06 AM PDT #

Hi Rekha,

I have tried to follow steps provided by below user and it is for upload data, not for download parameter.

Posted by oshrat on May 28, 2015 at 03:25 AM PDT

Would you be able to point any link with simple example to create download WebADI using parameters in excel sheet. Excel sheet has item number, and would like to provide item number in parameter which should download. If it does not exists, it should just create blank excel sheet.

Thanks,
Srinivas

Posted by guest on June 29, 2015 at 08:32 AM PDT #

Good Morning Rekha!

I'm familiar with creating custom integrators. Until recently, after I imported, using FNDLOAD, a working version of my custom integrator, I started getting the JBO-25013 error. Now, I'm unable to create/modify ANY integrators. I'm stuck at this moment. I can't seem to find any web-adi resolution for this error. I have opened the following Service Request with Oracle.

SR 3-11059523951 : JBO-25013: Too many objects match the primary key oracle.jbo.Key Error while defining IMPORTER RULES

Can you please help?

Thanks
Srikanth

Posted by Srikanth on July 16, 2015 at 07:04 AM PDT #

Oshrat thanks for your mini document that you posted on May 28, 2015 at 03:25 AM PDT. Unfortunately I'm stuck with a SR related to too many objects issue. Until that gets resolved, I'll not be able to try your recommended steps. But I have copied it to my to-do list to check it out. Thanks!

Posted by Srikanth on July 16, 2015 at 11:40 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today