Friday, February 17, 2012

Common Issues in ADI

1.    TNS could not Resolve Service Name or any TNS entry related error during ADI logon.
Check the TNSNAMES.ora file in the network/ADMIN and NET80/ADMIN folders of the ADI Oracle Home. The TNS file should have one entry for DB instance and once for the file server. Below are the sample TNS entries for DB and File Server. Just make sure that DB and File server entries should have different port numbers.

DB
XYZ =  (DESCRIPTION =    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = TCP)(HOST = orxyz01.abc.com)(PORT = 1555)))    (CONNECT_DATA = (SERVICE_NAME = XYZ11) )  )

File Server
FNDFS_XYZ =  (DESCRIPTION =    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = TCP)(HOST = orxyz01.abc.com)(PORT = 1666)))    (CONNECT_DATA = (SERVICE_NAME = XYZ11) )  )
Also user should have full access on the TNSNAMES.ora files in the network/ADMIN and NET80/ADMIN folders of the ADI Oracle Home.

2.    Unable to Publish Output of the report.
You are able to run the report in ADI but when you try to publish the output you get the error "File Server Failed to Initialize". This error is because the ADI application is not able to connect to the file server. Check if the file server port is open and you are able to connect to the port. File server port is the port number in the File Server entry in the TNSNAMES.ora.

3.    Unable to upload through ADI
If you are not able to upload Journals or Budgets through ADI and getting error "File Server Failed to Initialize"  the issue is because the ADI application is not able to connect to the file server. Check if the file server port is open and you are able to connect to the port. File server port is the port number in the File Server entry in the TNSNAMES.ora.

4.    Macros related error in ADI upload
You get error "The macros in this project are disabled" during upload through ADI. The reason for this issue is because the Tools > Macro > Security is set to high. As ADI macros are unsigned they cannot be added to the Trusted Sources. Solution is to set the Tools > Macro > Security to Medium and accept Enable Macros when the template (Existing Worksheet) is opened if the template is from a known source.

3 comments:

rajeev said...

Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

Oracle Apps Technical Dot Com said...

25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students

Please Check https://www.oracleappstechnical.com for details