Category Archives: R12 - Page 10

Sample 11.5.9 to 12.1.1 Upgrade Steps

Posted by on January 7, 2010 No comments

1. Preparing for the Upgrade

Apply 11i.AD.I
Back up database, Applications, and customizations
Prepare an upgrade plan for customizations
Convert to Multiple Organizations architecture
Review sizes of old and new tablespaces
Review Upgrade Tasks and Apply 11i.AD.I

Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
Financials and Procurement Tasks
Gather schema statistics for CBO
Back up the database
Run Rapid Install
Migrate or upgrade your database to Oracle 10g Release 2
Port application to Linux servers

2. Upgrading to Release 12

Disable AOL Audit Trail
Migrate database to Oracle10g Release 2
Back up the database
Apply Release 12 AD minipack
Run the American English upgrade patch driver
Run the NLS upgrade patch driver
Apply latest product patches
Synchronize NLS and American English product patches
Back up Oracle Applications

Finish the Upgrade
Configure Applications client software for forms applet (required)
Reapply customizations (conditional)
Integrate custom objects and schemas (conditional)

Finish System Administration Tasks
Complete Workflow Notification Mailer configuration (required)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)

3. Post-upgrade Tasks
Install online help
Update/verify custom responsibilities
Migrate custom development to new technologies
Migrate the CUSTOM library
Copy and re-customize modified scripts or reports
Review user responsibility assignments
Associate organization names with custom Alert definitions
Set operating unit mode for customizations
Assign the Report Manager Data Migration Program to a request group
Run the Data Migration Program

Update Status Monitor URLs
Synchronize Product License and Workflow BES license status
Financials and Procurement Tasks
Additional Tasks

ORA-1654: unable to extend index

Posted by on November 12, 2009 No comments

This documentation shows the SQL*Plus output for resolving the ORA-01654 error.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and Settingsoracle>f:
F:>cd oraclePRODdbtech_st10.2.0
F:oraclePRODdbtech_st10.2.0>PROD_mainfinsrv1.cmd
ECHO is off.
ECHO is off.
Thu 11/12/2009 08:04 PM
PROD_mainfinsrv1.cmd exiting with status 0
F:oraclePRODdbtech_st10.2.0>cd adminPROD_mainfinsrv1bdump
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>tail -40 alert_prod.log
Thu Nov 12 19:54:51 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
Thu Nov 12 19:55:21 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>sqlplus apps/apps
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 12 20:05:07 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc dba_indexes
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
UNIQUENESS VARCHAR2(9)
COMPRESSION VARCHAR2(8)
PREFIX_LENGTH NUMBER
TABLESPACE_NAME VARCHAR2(30)
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
PCT_THRESHOLD NUMBER
INCLUDE_COLUMN NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
PCT_FREE NUMBER
LOGGING VARCHAR2(3)
BLEVEL NUMBER
LEAF_BLOCKS NUMBER
DISTINCT_KEYS NUMBER
AVG_LEAF_BLOCKS_PER_KEY NUMBER
AVG_DATA_BLOCKS_PER_KEY NUMBER
CLUSTERING_FACTOR NUMBER
STATUS VARCHAR2(8)
NUM_ROWS NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
PARTITIONED VARCHAR2(3)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
BUFFER_POOL VARCHAR2(7)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
PCT_DIRECT_ACCESS NUMBER
ITYP_OWNER VARCHAR2(30)
ITYP_NAME VARCHAR2(30)
PARAMETERS VARCHAR2(1000)
GLOBAL_STATS VARCHAR2(3)
DOMIDX_STATUS VARCHAR2(12)
DOMIDX_OPSTATUS VARCHAR2(6)
FUNCIDX_STATUS VARCHAR2(8)
JOIN_INDEX VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
DROPPED VARCHAR2(3)
SQL> select owner, index_name, index_type, tablespace_name, initial_extent, next_extent,
min_Extents, max_extents from dba_indexes where index_name = 'FND_CRM_HISTORY_U2';
OWNER INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE TABLESPACE_NAME INITIAL_EXTENT
--------------------------- ------------------------------ --------------
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
----------- ----------- -----------
APPLSYS FND_CRM_HISTORY_U2
NORMAL APPS_TS_TX_IDX 131072
131072 1 2147483645
SQL> DESC DBA_DATA_FILES
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> SELECT FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'APPS_TS_TX_IDX';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND05.DBF
APPS_TS_TX_IDX 1273
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND04.DBF
APPS_TS_TX_IDX 1287
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND03.DBF
APPS_TS_TX_IDX 1577
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND02.DBF
APPS_TS_TX_IDX 1200
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND01.DBF
APPS_TS_TX_IDX 1200
SQL> ALTER TABLESPACE APPS_TS_TX_IDX
2 ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M;
ALTER TABLESPACE APPS_TS_TX_IDX
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> CONNECT SYSTEM/MANAGER
Connected.
SQL> L
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
SQL> R
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
Tablespace altered.
SQL> DISC
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> EXIT
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>

After R12 Vision Installation, Concurrent Manager Not Starting

Posted by on November 11, 2009 No comments

Problem: Oracle E-Business Suite R12 was installed on appswindows3. After installation, the Concurrent Manager is not starting.

Solution: Checked Event Viewer. The following messages appear:

Restart ICM (Retries left:0)
ICM process exited with error(1)
FNDLIBR Stopped(1)

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=591003&start=15&tstart=0

Checked directory: %APPLCSF%%APPLLOG%
G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>type CM_VIS12_appswindows3.log

List of errors encountered:
………………………………………………………..

_ 1 _
Routine AFPCAL received a return code of failure from routine spiini.

Review your concurrent request log file for more information.
………………………………………………………..

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

Type CM_VIS12_appswindows3.log:
Routine AFPCAL received a return code of failure from routine spiini.

To reproduce error, source apps environment and run:

FNDCPUCF apps/apps 0 Y %AD_TOP%admintemplateadctxinf.tmp

Metalink Reference:
Subject: Concurrent Manager Service Fails To Start With Error Code 1067
Doc ID: 434444.1

Cause
The issue is caused because of uninitialized string (New Value #1) in the registry under APPL_CONFIG.

The uninitialized key is causing Concurrent Managers not to come up. In the Task manager FNDLIBR.exe comes up briefly and dies.

Solution
To implement the solution, please execute the following steps:

1. Go into the registry

2. Delete uninitialized key under APPL_CONFIG

3. Retest the issue by starting concurrent manager service

Ran AutoConfig on the database tier:

The above did not work, as there was no uninitialized key under APPL_CONFIG.

Stopped all Oracle application tier services and ran AutoConfig:
cd G:oracleVIS12instappsVIS12_appswindows3adminscripts
adautocfg.cmd

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: G:oracleVIS12instappsVIS12_appswindows3admininstall
afcpctx.cmd INSTE8_PRF 1

AutoConfig is exiting with status 1

Metalink Reference:
Bug No: 3815440 (AFCPCTX.CMD FAILS WHEN AUTOCONFIG IS RUN)

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: 11i : Oracle Application Object Library Concurrent Manager Setup Test
Doc ID: 200360.1

Subject: Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release 11i Troubleshooting
Doc ID: 216208.1

R12 Log File Locations

Posted by on November 5, 2009 No comments

Concurrent Manager Log: %APPLCSF%%APPLLOG%

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog

%APPLCSF%%APPLLOG%

%APPLCSF%%APPLOUT%

Application TNS Listener executable:

G:oracleVIS12appstech_st10.1.2BINTNSLSNR

Application TNS Listener config file:

G:oracleVIS12instappsVIS12_appswindows3ora10.1.2networkadminlistener.ora

Location of dbc file (VIS12.dbc):

G:oracleVIS12instappsVIS12_appswindows3applfnd12.0.0secure

Apache Root:

G:oracleVIS12appstech_st10.1.2ApacheApache

Wiping R12 and reinstalling

Posted by on November 4, 2009 No comments

Step 1:       Stop all Oracle processes and the Distributed Transaction Coordinator service.

Step 2:       Run regedit and delete the following entries:

 HKEY_LOCAL_MACHINESOFTWAREORACLE
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet003ServicesOracle*

Exit regedit, and then reboot.

 Step 3:Delete the Oracle directory (x:oracleVIS12) and C:Program Filesoracle.

 Empty the recycle bin, and then reboot the computer once more.

 Step 4:Clean up the Program Menu for Oracle entries

 Step 5:Run Rapid Wizard to restart the R12 installation.

Metalink Reference:

Doc ID: 567507.1 (How to Remove an Oracle E-Business Suite Release 12.x Windows Environment)


Running AutoConfig on the Application Tier

Posted by on November 3, 2009 No comments 
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12appsapps_stappl
G:oracleVIS12appsapps_stappl>appsinf.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
appsinf.cmd exiting with status 0
ERRORCODE = 0 ERRORCODE_END
G:oracleVIS12appsapps_stappl>APPSVIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
ECHO is off.
ECHO is off.
Setting environment for using Microsoft Visual Studio 2005 x86 tools.
APPSORA.cmd exiting with status 0
G:oracleVIS12appsapps_stappl>cd ..
G:oracleVIS12apps>cd oracleVIS12instappsVIS12_appswindows3adminscripts
G:oracleVIS12instappsVIS12_appswindows3adminscripts>dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12instappsVIS12_appswindows3adminscripts
10/30/2009  05:06 PM    <DIR>          .
10/30/2009  05:06 PM    <DIR>          ..
10/30/2009  05:06 PM             4,504 adalnctl.cmd
10/30/2009  05:06 PM             4,759 adapcctl.cmd
10/30/2009  05:06 PM             2,704 adautocfg.cmd
10/30/2009  05:06 PM             4,831 adcmctl.cmd
10/30/2009  05:06 PM             7,086 adexecsql.pl
10/30/2009  05:06 PM             4,901 adformsctl.cmd
10/30/2009  05:06 PM             4,767 adoacorectl.cmd
10/30/2009  05:06 PM             4,758 adoafmctl.cmd
10/30/2009  05:06 PM             4,467 adopmnctl.cmd
10/30/2009  05:06 PM            15,084 adpreclone.pl
10/30/2009  05:06 PM             5,399 adstpall.cmd
10/30/2009  05:06 PM             5,520 adstrtal.cmd
10/30/2009  05:06 PM             1,695 gsmstart.cmd
10/30/2009  02:20 PM    <DIR>          ieo
10/30/2009  05:06 PM             1,656 java.cmd
10/30/2009  05:07 PM             1,426 jtffmctl.cmd
10/30/2009  05:07 PM             6,535 mwactl.cmd
10/30/2009  05:07 PM             2,415 mwactlwrpr.cmd
17 File(s)         82,507 bytes
3 Dir(s)   1,052,397,568 bytes free
G:oracleVIS12instappsVIS12_appswindows3adminscripts>adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:41 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12instappsVIS12_app
swindows3adminlog11031241adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location     : G:oracleVIS12instappsVIS12_appswin
dows3
Classpath                   : G:oracleVIS12appsapps_stcomnjavalib
appsborg2.zip;G:oracleVIS12appsapps_stcomnjavaclasses
Using Context file          : G:oracleVIS12instappsVIS12_appswindow
s3appladminVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:41 PM
1 file(s) copied.
Script Success, Applications Context update complete.
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed with errors.
Completed execution of AutoConfig
G:oracleVIS12instappsVIS12_appswindows3adminscripts>

Running AutoConfig on the Database Tier

Posted by on November 3, 2009 No comments 
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12dbtech_st10.2.0
G:oracleVIS12dbtech_st10.2.0>VIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:32 PM
VIS12_appswindows3.cmd exiting with status 0
G:oracleVIS12dbtech_st10.2.0>cd appsutilscriptsVIS12_appswindows3
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3
10/30/2009  03:08 PM    <DIR>          .
10/30/2009  03:08 PM    <DIR>          ..
10/30/2009  03:08 PM             2,690 adautocfg.cmd
10/30/2009  03:08 PM             5,262 adchknls.pl
10/30/2009  03:08 PM             3,420 addbctl.cmd
10/30/2009  03:08 PM             3,932 addlnctl.cmd
10/30/2009  03:08 PM             7,089 adexecsql.pl
10/30/2009  03:08 PM             3,441 adlsnodes.cmd
10/30/2009  03:08 PM            14,953 adpreclone.pl
10/30/2009  03:08 PM               837 adstopdb.sql
10/30/2009  03:08 PM             1,251 adstrtdb.sql
9 File(s)         42,875 bytes
2 Dir(s)   1,052,569,600 bytes free
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:34 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12dbtech_st10.2.0a
ppsutillogVIS12_appswindows311031234adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : G:oracleVIS12dbtech_st10.2.0
Classpath                   : ;G:oracleVIS12dbtech_st10.2.0jdbclibojdbc14.jar;G:oracleVIS12dbtech_st10.2.0appsutiljavaxmlparserv2.jar;G:oracleVIS12dbtech_st10.2.0appsutiljava;G:oracleVIS12dbtech_st10.2.0jlibnetcfg.jar;G:oracleVIS12dbtech_st10.2.0jlibldapjclnt10.jar
Using Context file          : G:oracleVIS12dbtech_st10.2.0appsutilVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Completed execution of AutoConfig
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3>

oracle.forms.net.ConnectionException: Forms session failed during startup: no response from runtime process

Posted by on October 21, 2009 No comments

Problem: oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process

Solution: Applications were not linked properly during install. Manually relink applications using adadmin.

Report Manager SuperUser FRS Issue

Posted by on October 7, 2008 No comments

Report Manager SuperUser > Financial Report Submission

1. Submission Parameters

Primary Parameters:

Report Name: Actual/Budget Income Statement
Period: Dec-07
Date: 31-Dec-2007
Currency: USD
Ledger: Vision Operations (USA)
Content Set: <blank>
Display Set: <blank>
Row Order: Account Format
Rounding Option: Calculate Then Round
Flag Exception: <blank>

Additional Parameters:

Segment Override: <blank>

Scheduling Options:

Now Selected

Click Next.

2. Publishing Parameters

Primary Parameters:

Default Template: Actual/Budget Income Statement
Timeframe: Dec-07
Set Auto Archive? No

Security:

No Security Selected

Availability:

Now Selected

Click Next.

3. Storage Location

Location: Use Last

Click Next.

4. Warning

The report and timeframe selected already exists in the selected Publishing Location. Do you wish to overwrite?

Click Yes.

5. Presentation

Create Menu Item for this report? Unchecked

Click Next.

6. Review

Click Submit.

7. Confirmation

Click Monitor Requests

8. Requests

Click Refresh until Actual/Budget Income Statement (Publish and Presentation Program) completes.

Then click Output.

9. Click View Report Now

10. In the Actual/Budget Income Statement, click the hyperlink in any cell.

The following appears:

Error

The following error has occurred
Exception Name: oracle.apps.bne.exception.BneFatalException – You do not have permission to access this functionality.
Action: Please contact your support representative.
Log File Bookmark: 309685

Solution (R12):

1. Navigate to:

System Administrator > Application > Function

The Form Functions form appears. Under the Description tab, search for each of the following functions under User Function Name field:
Account Analysis and Drilldown
FSG Drilldown: Launch Page
FSG Drilldown: Select Content Set Rows
FSG Drilldown: Effective Range Selection Page
FSG Drilldown: Balance Inquiry Page

Ensure that the corresponding User Function Names have the following corresponding functions (which do not end in _G):
Account Analysis and Drilldown                  GL_INQ_SEARCH
FSG Drilldown: Launch Page                      GL_INQ_FSG_DRL_LAUNCH
FSG Drilldown: Select Content Set Rows          GL_INQ_FSG_DRL_CONTENT
FSG Drilldown: Effective Range Selection Page   GL_INQ_FSG_DRL_EFF_RNG
FSG Drilldown: Balance Inquiry Page             GL_INQ_FSG_DRL_BAL_INQ

2. Added Web ADI, Vision University responsibility to user OPERATIONS.

3. Set profile ‘BNE Allow No Security Rule’ to Yes at Responsibility level

4. Turn on Web ADI Debug Info for logging:

Set the profiles under System Administrator – System Profiles
Example:
BNE Server Log Filename : <create name> (make sure name doesn’t exist already and if it does, delete it)
BNE Server Log Level : TRACE
BNE Server Log Path : free to choose, eg. in the IAS_TOP/Apache/Jserv/logs (use the full path)

Current Values:
BNE Server Log Filename : bne.log
BNE Server Log Level : ERROR
BNE Server Log Path : /usr/tmp

New Values:
BNE Server Log Filename : bne.log
BNE Server Log Level : TRACE
BNE Server Log Path : /usr/tmp

Reproduce the issue.

Once the issue was reproduced, turn off Trace by setting BNE Server Log Level back to Detail.

Log file /usr/tmp/bne.log shows the following error:

10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-9 ERROR          BneUIXUtils.createErrorPage() Page: Page[name=]
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-9 ERROR          BneUIXUtils.createErrorPage() Event: PageEvent[name=null,FrmDrillContext=p1001r100002l100002c1002,bne:page=oracle.apps.frm.drilldown.webui.DrillOARedirectPage,FrmDocId=3001]
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          DrillOARedirectPage.renderPage() Failed functionSecurity Check for function: GL_INQ_SEARCH
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          BneUIXUtils.createErrorPage() Error number 522858
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          BneUIXUtils.createErrorPage() Stack Trace:
oracle.apps.bne.exception.BneFatalException: You do not have permission to access this functionality.
        at oracle.apps.frm.drilldown.webui.DrillOARedirectPage.renderPage(DrillOARedirectPage.java:114)
        at oracle.apps.bne.webui.framework.BneBasePageController.createPageBody(BneBasePageController.java:529)
        at oracle.apps.bne.webui.framework.BneBasePageController.handlePage(BneBasePageController.java:287)
        at oracle.apps.bne.webui.BneApplicationService.handleRequest(BneApplicationService.java:157)
        at oracle.apps.bne.framework.BneBajaServlet.doRequest(BneBajaServlet.java:246)
        at oracle.apps.bne.framework.BneBaseServlet.doGet(BneBaseServlet.java:79)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
        at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:595)

Note the error:

Failed functionSecurity Check for function: GL_INQ_SEARCH

5. Add Missing Functions to Report Manager SuperUser menu

Check Security > Responsibility > Define to get menu

Responsibility Name: Report Manager SuperUser
Menu: RptMgr SuperUser

Add the following functions to the Report Manager Superuser menu:
Account Analysis and Drilldown
FSG Drilldown: Launch Page
FSG Drilldown: Select Content Set Rows
FSG Drilldown: Effective Range Selection Page
FSG Drilldown: Balance Inquiry Page

Do not add any prompts or descriptions for the functions.

Reference:

Subject:  Report Manager FSG DrillDown Fails With You Do Not Have Permission
Doc ID:  Note:436502.1

[amazon asin=0071779728&template=iframe image&chan=default]     [amazon asin=1849680620&template=iframe image&chan=default]     [amazon asin=0071622292&template=iframe image&chan=default]

Installing Oracle Applications Release 12 on Demo Laptop (OEL 5.1)

Posted by on January 8, 2008 No comments

Installing Oracle Applications Release 12 on Demo Laptop (OEL 5.1)

1. Installed OEL 5.1 on 160GB hard drive: 100MB /boot; 6GB swap; remaining space /

2. Created user applmgr on initial setup

3. Created group dba, assigned group dba to user applmgr, made dba primary (and only) group for applmgr

4. On appslinux, assigned ip address and hostname (200.65.1.57, demolinux) to /etc/hosts
On demolinux, assigned ip address and hostname (200.65.1.56, appslinux) to /etc/hosts

5. On appslinux, edited /etc/exports (as root user) to include demolinux:
/u4   200.65.1.57(rw,sync)

6. Restart nfs service (as root user) on appslinux:
service nfs restart

7. On demolinux (as root user):
mkdir /mnt/u4
mount -t nfs appslinux:/u4 /mnt/u4

8. On demolinux (as root user):
mkdir /oracle
chown applmgr:dba /oracle

9. Load the /mnt/u4/StageR12/startCD/welcome.html into Firefox
Open the Rapid Install installation PDF

10. On demolinux, ensure that /tmp is accessible by all users (chmod 777 /tmp)

11. On demolinux, ensure that required maintenance tools are present:
which ar
which ld
which gcc
which g++
which ksh
which make

12. Check Metalink Doc ID: 402310.1 to ensure

a. Ensure that OS version is supported:
Minimum: Oracle Enterprise Linux: 4.0 – Update 4 or higher (32-bit)
Current: Oracle Enterprise Linux Release 5 – Update 1 [ok]

b. Ensure that kernel version is supported
Minimum: Oracle Enterprise Linux: 2.6.9-42.0.0.0.1.EL
Current: Oracle Enterprise Linux: 2.6.18-53.elPAE [ok]

13. Manually installed the following RPMs:
compat-libstdc++-296-2.96-138.i386.rpm [CD 2]
openmotif22-2.2.3-18.i386 [CD 3]

pdksh
gnome-libs
sysstat-7.0.0-3.el5.i386 [CD 3]
compat-db-4.2.52-5.1.i386.rpm [CD 3]
xscreensaver
libaio-devel-0.3.106-3.2.i386.rpm [CD 2]