OracleAppsBlog

A day in the life of an Oracle Applications Consultant

Applications Desktop Integrator (ADI)

Friday, February 03, 2006

Oracle Navigation and ADI Tip Sheets

Last year I worked with Nici Aldridge on an IMSCAN document management and scanning solution for an Oracle E-Business Suite implementation. Nici is an Oracle Applications Consultant who does quite a substantial amount of Oracle Training - read her profile here. She shared with me some “tip sheets” she has produced for Oracle Applications Navigation and Oracle’s Application Desktop Integrator (ADI). These tips sheets are very short documents which are aimed at providing users with the basic information they need to get started with.

Other tip sheets are available for:

• Office 2000 - Generic Information for Office 2000
• Word 2000 - For those converting to Word 2000
• Outlook 2000 - For those converting to Outlook 2000
• PowerPoint 2000 - For those converting to PowerPoint 2000
• PowerPoint for Presenters - Suggestions for using PowerPoint effectively in PC-based presentations
• Visual Aids - Suggestions for choosing and using visual aids, including PC slides

Thursday, April 07, 2005

FSG YTD-Actual Problem and Resolution

This post contains the solution for a small problem we encountered when trying to produce an FSG report.

When trying to produce an FSG report in ADI the other day we noticed a problem with the YTD-Actual column in the report. We wanted to print the report as at December 2005 (i.e. the last month of the year) so that we could see what the budget figures looked like. When trying to print the report in this fashion the YTD-Actual column for Dec 2005 was displaying zero values even though we knew there should be data in the report. We tried printing the report from within General Ledger but still the same result, zero values in the YTD-Actual Column. We knew that there should be values in this column as January and February had already been closed and most of the entries for March had been processed. Even when performing a drill down to the detail in the General Ledger we could see that there were values present.

The problem was a simple one which we found the resolution for buried in point 30 of Metalink Note:108236.1 entitled FSG Functional FAQ. The solution suggested that in order for the YTD-Actual data to display in the report you should ensure that the GL periods upon which you were reporting should be open or closed. In our instance the periods from April to December were still Future Enterable and hence we resolved the problem by opening these periods and immediately closing them so that they now had a status of closed. Once this simple task had been performed we were able to see data in our report.

Friday, February 04, 2005

ADI Journal Upload Problem Resolution

I received an interesting error message when trying to perform a journal upload in ADI at a client site yesterday, here’s the solution to the problem.

The error message received was “Segment is not defined, is a parent, or is disabled.”

According to Metalink Note:160622.1 the cause is as follows: -

The validation that ADI uses for client side validation cannot dynamically create a new flexfield, only the server-side validation has been designed to dynamically create valid flex code-combinations - Bug:1924015.

The simple solution to the problem is to set the Profile Option profile Flexfields: Validate on Server to Yes. It’s also important to note that Cross-validation checking is only performed if you have this option set to Yes.

Another Metalink Note 251463.1 provides the same solution for the system allowing the upload of Disabled Accounting Flexfield segments to General Ledger via ADI.

Tuesday, June 15, 2004

Installing, Configuring and Using Oracle ADI (Applications Desktop Integrator)

Recently I wrote about configuring the ADI client to connect to the Oracle Database. I have subsequently come across an excellent site which has a page on how to Install, Configure and Use Oracle ADI (Applications Desktop Integrator). The page outlines how to: -

Install ADI

Start ADI

Define a Database Connection

Use ADI

 

It can be found on the University of Virginia site here.

Saturday, June 12, 2004

Configuring the ADI client to connect to the database

This post outlines how to configure the ADI client software to connect to the database. It’s aimed at non-technical people and assumes that you have already configured the TNSNAMES.ora file.

Assumed TNSNAMES.ORA file settings

ADI database connection settings

To get to the settings displayed below, from the ADI toolbar click on the signon button. In the Signon screen, on the bottom left hand side of the screen you should then click on the Define Basis button and configure your connection.

The name and description you give to the database connection can be user defined. The GWYUID and FNDNAM settings are consistent for most databases that you connect to and lastly, the connect string should be the same as the SID contained in the TNSNAMES.ORA