Thursday, July 21, 2011

Error while compiling reports in Custom Top | Oracle EBS version 12.1.3

 $ rwconverter.sh userid=apps/apps_password source=$XXCUSTOM_TOP/reports/US/XXCCUSTOM.RDF stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes

Report Builder: Release 10.1.2.3.0 - Production on Tue Jul 19 20:05:49 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter Username: apps
Enter Password:
Enter Username: apps
Enter Password:
REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0501: Unable to connect to the specified database.
ORA-12154: TNS:could not resolve the connect identifier specified

REP-0309: Unable to connect to the specified database after three attempts. Access denied.



Solution :
Do Not Compile EBS R12 Reports Using rwconverter.sh or Reports Builder from IDS 10gR2 (Doc ID 786794.1)
Using the OracleAS 10.1.2 Forms and Reports Builders with Oracle Applications Release 12 (Doc ID 444248.1)

Steps :

$ unset DE_DISABLE_PLS_512
$ unset EVENT_10932


comment out the following in reports.sh

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG

No comments:

Post a Comment