Category Archives: ERP - Page 8

Function Not Available To This Responsibility

Posted by on August 23, 2011 No comments

Problem: When examining an EBS form using Help > Diagnostics > Examine, the following error occurs:

Function Not Available To This Responsibility.
Change responsibilities or contact your System Administrator.

Solution: This is standard functionality. The EBS instance was upgraded to R12.1.3.

To allow access to the submenu items under the Help menu > Diagnostics, please perform the following steps:

Choose System Administrator, navigate to System > Profiles, and query the profile “Utilities : Diagnostics”. At the appropriate level (user/responsibility), change the value to Yes.

Logout and then login (you may need to bounce iAS (Apache) to clear cache).

Retest the issue.

Reference:

“Function Not Available To This Responsibility” After Upgrading To Release 12.1.3 [ID 1200743.1]

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

ORA-01400: cannot insert NULL into (“HR”.”PAY_ELE_TMPLT_CLASS_USAGES”.”CLASSIFICATION_ID”)

Posted by on August 22, 2011 No comments

Problem: When running International HRMS Setup from the UK HRMS Super User responsibility, the following error occurs:

Inserting Balance Attribute Definition : ONLINE_SOE_BALANCE_ATTRIBUTE
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-01400: cannot insert NULL into ("HR"."PAY_ELE_TMPLT_CLASS_USAGES"."CLASSIFICATION_ID")

Solution: Ensure that the Human Resources product (PER) is licensed.

Read more »

R12 Diagnostics Notes

Posted by on August 19, 2011 No comments

My Oracle Support Community is located at:

https://communities.oracle.com/portal/server.pt/community/support/219

My Oracle Support Community – Diagnostic Tools is located at:

https://communities.oracle.com/portal/server.pt/community/Diagnosibility/242

Overview of EBS Diagnostics Video:

https://support.oracle.com/CSP/main/article?cmd=show&type=ATT&id=232116.1:OVERVIEW&inline=1

How to run Oracle DBS Diagnostics:

Log on as a user with access to the Application Diagnostics responsibility. Then click:

Application Diagnostics > Diagnose > Select Application

Check checkbox to left of the test you wish to run.

Scroll to bottom of page and click Execute button.

Enter parameters, then click Submit.

Diagnostic Tests Catalog:

Release 12: MOS Doc ID: 421245.1

Other Diagnostics documents:
* Overview
* Installation Guide
* Frequently Asked Questions (FAQ)
* Training

Also My Oracle Support (MOS) Community

Installing FSCM 9.0 PeopleBooks for SQL Server on Windows

Posted by on July 29, 2011 No comments

Problem: Procedure for installing PeopleBooks for Financials/Supply Chain Management (FSCM) 9.0 unclear.

Solution:

The documentation for installing PeopleBooks is available in the PeopleTools Installation guide. In this case, FSCM 9.0 was installed on PeopleTools 8.49 on the Microsoft SQL Server database.

Read more »

Installing PeopleTools PeopleBooks 8.49

Posted by on July 29, 2011 No comments

Problem: When user clicks on PeopleTools > Web Profile > Web Profile Configuration, clicks Search > Dev, and then clicks the Help link, the following message appears:

Help cannot be displayed because no help topic was found for the help context ID "WEB_PROF_GENERAL". 
To view the PeopleSoft Online Library, click here.

Solution: The PeopleTools PeopleBooks CD was not installed.

Read more »

ORA-12913: Cannot create dictionary managed tablespace

Posted by on May 25, 2011 No comments

Problem: While creating a dictionary managed tablespace in Oracle 9i, the following error appears:

SQL> r
 1  CREATE TABLESPACE data01
 2  DATAFILE '$HOME/oradata/ORCL/data01.dbf' SIZE 2M
 3* EXTENT MANAGEMENT DICTIONARY
 CREATE TABLESPACE data01
 *
 ERROR at line 1:
 ORA-12913: Cannot create dictionary managed tablespace
 Solution:

Consulting the Oracle 9i online documentation, the following cause and action is found:

Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

Action: Create a locally managed tablespace.

As a result, the dictionary managed tablespace cannot be created in this Oracle 9i database.

Reference:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/e12700.htm

Script To Export 11i Database

Posted by on December 15, 2009 No comments 
# expprod.sh
#
# Exports the Oracle E-Business Suite HRMS Production database
# which will then be copied over to the backup server
#
# source the environment
. /u0/oracle/proddb/9.2.0/PROD_ebusiness.env
# stop, then restart the production instance
# to overcome 'snapshot too old' error
# (commented out, as users on the system at 6:00 P.M. will be kicked off)
# cd /u0/oracle/proddb/9.2.0/appsutil/scripts/PROD_ebusiness/
# ./addbctl.sh stop immediate
# ./addbctl.sh start
# get name of log file and dump file
export LOGFILE=expprod_`date +%F_%k-%M-%S`.log
export DUMPFILE=expprod.dmp
export BACKUPDIR=/mnt/prodbkup
export EXPORTDIR=/u0/prodbkup
export ZIPFILE=expprod.tar.gz
export ZIPFILE2=expprod_`date +%F_%k-%M-%S`.tar.gz
# remove existing dump file
rm $EXPORTDIR/$DUMPFILE
rm $EXPORTDIR/$ZIPFILE
# export the ONT schema (for testing purposes)
# exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE owner=ONT
# export the database
exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE full=y consistent=y
# tar and gzip export file
tar -czvf $EXPORTDIR/$ZIPFILE $EXPORTDIR/$DUMPFILE
# remove the previous export dump from the test server, then copy the new one
# rm $BACKUPDIR/$DUMPFILE
# rm $BACKUPDIR/$ZIPFILE (Commented out by VS 10-Sep-09)
# copy the zip file and log file to the backup directory (remote NFS directory on ebusinesstest)
cp $EXPORTDIR/$ZIPFILE $BACKUPDIR/
cp $EXPORTDIR/$LOGFILE $BACKUPDIR/
# rename the zip file in the remote directory to reflect today's date
mv $BACKUPDIR/$ZIPFILE $BACKUPDIR/$ZIPFILE2
# rename the zip file in the local directory to reflect today's date (as an archive copy)
mv $EXPORTDIR/$ZIPFILE $EXPORTDIR/$ZIPFILE2

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)