Wednesday, 24 August 2016

FNDLOAD Download And Upload Commands

1. Lookups 
-- -------------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"


FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 2. Concurrent Program 
-- -----------------------------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"



FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


3. Profile 
-- ---------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"



$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 4. Request Set and Link 
-- ------------------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'



FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUSTOM_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


5. FND Message 
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_NAME%"



FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE



6. D2K FORMS 
-- ------------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt FORM FORM_NAME="FORM_NAME"
     
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 7. Form Function 
-- ---------------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt FUNCTION FUNCTION_NAME="FORM_FUNCTION_NAME"



$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FUNC.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

 8. Alerts 
-- --------- 
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"



FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

 9. Value Set 
-- --------------
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"



$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


10. Data Definition and Associated Template 
--- ----------------------------------------------------------
FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXCUST' DATA_SOURCE_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXCUST' TEMPLATE_CODE='XX_SOURCE_CODE'



FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt


11. DATA_TEMPLATE (Data Source .xml file) 
--- ----------------------------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME



java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

12. RTF TEMPLATE (Report Layout .rtf file) 
--- -------------------------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME



java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME

How to Use FNDLOAD?

Create same setup data on each instance separately. Hence to migrate setup data from one instance to other (Eg. From DEV to PROD), ldt & lct files are used.

LDT (Data Loader Files)- This files are Used to upload & download setup data on different instances.

LCT (Data Config Files)- This files are used to create LDT Files. There are difference lct files for different sets of data.

Eg: Request Set- afcpreqg.lct, Concurrent Program- afcpprog.lct, Value Set- afffload.lct..etc..

Now lets take a simple example where you want to migrate 1 concurrent program from Development (DEV) instance to Production (PROD).

Step 1:
Login to Unix Development server and change the directory using following Command where you can store your LDT files:
cd $CUST_TOP/ patch/115/import/US/ (where CUST_TOP is your custom top on server)

Step 2:
Run the following command by supplying the parameters given in {} as per your need
FNDLOAD {userid/password@connect_string} O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct {file_name.ldt} PROGRAM APPLICATION_SHORT_NAME="{your_application_short_name}" CONCURRENT_PROGRAM_NAME="{your_concurrent_name}"
The above command will generate ldt file in your custom top directory ($CUST_TOP/ patch/115/import/US/ )

Step 3:
Copy the LDT file from Development Server to your local desktop

Step 4:
Login to Unix Production Server and copy the LDT files from local desktop to Production Server on following path:
$CUST_TOP/ patch/115/import/US/ {file_name.ldt}

Step 5:
Finally Run the following command by supplying all parameters in {} to upload concurrent program definition on production application server.
$ FNDLOAD {userid/password@connect_string} 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $CUST_TOP/patch/115/import/US/{file_name}.ldt

Note: 
1) All above FNDLOAD commands are single line commands.
2) All above steps will remain exactly same for all kind of setup data (Eg: Value Set, CP, Req.group, DFF…etc) except the name of LCT file (.lct). LCT file will be different for every different component because the setup data is different.


AOL Commands

Commands to download LDT files.

1. To download Ldt file for a Concurent Program
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' CONCURRENT_PROGRAM_NAME='[Concurrent program Short Name]'

Above command downloads the executable information and Value Sets associated to the program.

2. To download Ldt file for a Data Definition
FNDLOAD [username]/[password] O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DATA_SOURCE_CODE='[Data Definition Short Name]'

      Above command downloads the template definition too.

3. To download Ldt file for a Request Set
FNDLOAD [username]/[password] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET REQUEST_SET_NAME='[REQUEST_SET_SHORT_NAME]'

      Make sure we run the below command too.

4. To download Ldt file for a Request Set Links
FNDLOAD [username]/[password] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET_LINKS REQUEST_SET_NAME='[REQUEST_SET_SHORT_NAME]'

5. To download Ldt file for a Lookup Up
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' LOOKUP_TYPE='[LOOKUP_TYPE]'

6. To download Ldt file for a request group for a Concurrent Program
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='P' UNIT_NAME='[Concurrent program Short Name]'

7. To download Ldt file for a request group for a Request Set
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='S' UNIT_NAME='[Request Set Name]'

8. To download Ldt file for a Value Set
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'

9. To download Ldt file for a Value Set with values
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'

10. To download Ldt file for a DFF
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' P_CONTEXT_CODE='[Context Code]'

11. To download Ldt file for a DFF for a particular attribute column
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' DESCRIPTIVE_FLEX_CONTEXT_CODE='[Context Code]' END_USER_COLUMN_NAME='[Attribute Column Name]' APPLICATION_COLUMN_NAME='[attribute column number]'

12. To download Ldt file for a profile Option
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME='[PROFILE_OPTION_NAME]' APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'

13. To download Ldt file for a Audit Group
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt FND_AUDIT_GROUPS APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' GROUP_NAME = '[Audit Group Name]'

14. To download Ldt file for a Audit Schema
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt FND_AUDIT_SCHEMAS ORACLE_USERNAME='ORACLE_USERNAME' APPLICATION_SHORT_NAME='APPLICATION_SHORT_NAME'

15. To download Ldt file for a Responsibility
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="[Responsibility Name]"


Tuesday, 23 August 2016

how to create dba directory in oracle 11g

Directories let database code interact with the file-system.
SQL> create or replace directory EXPORT_DIR as '/var/local/instance0/export';
SQL> create or replace directory IMPORT_DIR as '/var/local/instance0/import';
SQL> grant READ on directory IMPORT_DIR to APPlmgr;
SQL> grant WRITE on directory EXPORT_DIR to APPlmgr;

set linesize 200
col grantee format a7
col table_schema format a12
col table_name format a10
col privilege format a9
select grantee,table_schema,table_name,privilege
from all_tab_privs
where table_name = 'EXPORT_DIR' or table_name = 'IMPORT_DIR';

Directories must be created if external tables are used. 
Created directories are shown in either dba_directories or all_directories. 
There is no user_directories. When a directory has been created, 
the read and write object privileges can be granted on it

Related Data Dictionary Objects

dir$    all_directories         ku$_directory_t
        dba_directories         ku$_directory_view

The ALL_DIRECTORIES data dictionary view will have information about all the directories that you have access to.
 That includes the operating system path

SQL> SELECT owner, directory_name, directory_path
  FROM all_directories

SQL> select * from all_objects where object_type ='DIRECTORY';
SQL> SELECT * FROM dba_directories;


System Privileges

SQL> GRANT create any directory TO <user_name>;

SQL> GRANT drop any directory TO <user_name>;

Syntax: CREATE OR REPLACE DIRECTORY <directory_name> AS '<operating_system_path>';

SQL Code:
create or replace directory attachment_dir as '/u02';

SQL> Select * from  all_directories
Where directory_name = 'ATTACHMENT_DIR'

Granting Privileges to a Directory

SQL> grant read, write on directory attachment_dir to cpdb;

SQL> SELECT grantor, grantee, table_schema, table_name, privilege
FROM all_tab_privs
WHERE table_name = 'ATTACHMENT_DIR';

SQL> Set UTL_FILE_DIR using ALTER SYSTEM command

SQL> alter system set UTL_FILE_DIR = '/u02/attachment_dir' scope=spfile;

OS Commend to create a directory

[oracle@vasdbsrv u02]$ mkdir /u02/attachment_dir
[oracle@vasdbsrv u02]$ ll

drwxr-xr-x   2 oracle oinstall  4096 Dec  8 13:08 attachment_dir

PLSQL Code to read or write a file to the directory
Source: {ORACLE_HOME}/rdbms/admin/utlfile.sql
declare
  f utl_file.file_type;
begin
  f := utl_file.fopen('ATTACHMENT_DIRmmyfile.txt', 'w');
  utl_file.put_line(f, 'line test 1: text-1');
  utl_file.put_line(f, 'line test 2: text-2');
  utl_file.fclose(f);
end;
/

Drop Directory

Syntax: DROP DIRECTORY <directory_name>;

SQL> SELECT * FROM dba_directories;

SQL> DROP DIRECTORY 'ATTACHMENT_DIR;

Monday, 22 August 2016

Function not Available to this Responsibility

Custom Form: Function not Available to this Responsibility (Doc ID 1079951.1)

"Function not available to this responsibility, change responsibility or contact your system administrator"



APPLIES TO:

Oracle Application Object Library - Version 11.5.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

SYMPTOMS

Navigation steps:
  Select Custom Responsibility, Navigate to Custom Form

When selecting custom form following error occurs:
   Function not available to this responsibility

CAUSE

The CUSTOM_TOP value is not defined correctly in the environment.

SOLUTION

1)  Login to applications and try to open the custom Form.

2)  Navigate to Help --> Diagnostics --> Examine.  Click the "Examine Fields and variable values"

3) Populate the field with the next values:

BLOCK --> $ENVIRONMENT$
FIELD --> (For example XXCUS1_TOP)

4)  Push tab key and check that the variable is defined and that the VALUE is correct.

If the variable is not correctly defined, then:

1)  Review application environment file to check and correct variable definition.

2)  If using servlet mode, then check the definition in the file

$IAS_CONFIG_HOME/Apache/Jserv/etc/formservlet.ini .

Wednesday, 17 August 2016

How to Set and Verify CLASSPATH

How to Set and Verify CLASSPATH Settings for the Concurrent Manager in R12.1.3


This document is describing how to change the CLASSPATH variable so that Concurrent Requests will use it properly and also how to verify what is the value of CLASSPATH for a particular concurrent request.

 Where is the java classpath?
To see the current value of the CLASSPATH environment variable, open a terminal and type:
[appsqa@sujeet ~]$ echo $CLASSPATH
[appsqa@sujeet ~]$ echo $PATH

The JVM class loader will only find and use JAR archives that are listed in the classpath. 
There are several ways to add a JAR to the classpath:
Copy the JAR to one of the directories listed in the CLASSPATH environment variable. 
Another way of viewing the classpath is to run this Java code:
String classpath = System.getProperty("java.class.path");
System.out.println(classpath);
Modify the CLASSPATH environment variable to also include the directory containing the JAR archive.
In csh, the CLASSPATH environment variable is modified with the setenv command. 
The format is:
setenv CLASSPATH path1:path2:...
In sh, the CLASSPATH environment variable can be modified with these commands:
CLASSPATH = path1:path2:...
export CLASSPATH
Set the classpath at runtime. There are several possible ways of doing this:
Use the -classpath option:
javac -classpath ".:/chilkatJava/chilkat.jar" Test.java
java -classpath ".:/chilkatJava/chilkat.jar" Test
Use the -Djava.class.path system property:
javac -Djava.class.path=.:/chilkatJava/chilkat.jar Test.java
java -Djava.class.path=.:/chilkatJava/chilkat.jar Test
IMPORTANT :- On Windows systems, the semicolon character should be used for the path separator.
 However, on Linux systems, the colon character should be used.

1. Description of the CLASSPATH environment variable and the ways it can be used.

The CLASSPATH, being an environment variable, will differ depending on the environment, meaning the runtime environment of a particular process.

For example, if the CLASSPATH was set directly in a UNIX shell, then that would be the CLASSPATH echo'ed back within that shell and within any shell forked from that shell.

However, if CLASSPATH is set in a shell script file, then only processes running from within the context of that script will have that CLASSPATH.

In the Oracle Apps, there are a number of different runtime contexts.
One is the Apache - JServ - JSP engine which has it's CLASSPATH set in a file (usually jservctl, sometimes jserv.properties)

Another context is the Concurrent Manager where all Concurrent Processes are run. There is a separate script for running these, being as they are "concurrent" to the HTML stack. The script that starts up the Concurrent Manager is either adovars.env or some other file that calls adovars.env. 
The adovars.env file has a separate setting of the CLASSPATH, since there may be different runtime requirements for Java classes for Concurrent Programs than for JSP pages.

The basic point is that the CLASSPATH is only valid within the runtime context for which it is set. Running the command "echo $CLASSPATH" only serves to tell you what the CLASSPATH is within the context from which you run the command.


2. Setting the CLASSPATH variable in the context of Concurrent Manager.

There are many places a CLASSPATH can be set. For Concurrent Programs, the important thing is that the file called adovars.env has the proper JDBC driver included in it's CLASSPATH.

For example: when using jdk1.1.8, this should be jdbc 8.0.6, for jdk1.2.2 or greater, it should be jdbc 8.1.6.2 or greater.

Since the Concurrent Manager uses adovars.env when running concurrent requests, this is the place where the CLASSPATH (and other environment variables) should be set correctly.

In case the CLASSPATH is not set correctly, the concurrent requests will end up with the following error: java.lang.NoClassDefFoundError.

It is crucially important that the entire Concurrent Manager be shutdown and restarted after changes were made to file adovars.env.

3. Verifying the value of CLASSPATH variable for a specific request.

To verify that the CLASSPATH change was successful, please follow the next steps:
1. Start a new concurrent request
2. Note the request id
3. Run the following query using the request id

select variable_name, 
value
from fnd_env_context e,
fnd_concurrent_processes p,
fnd_concurrent_requests r
where p.concurrent_process_id = e.concurrent_process_id
and p.concurrent_process_id = r.controlling_manager
and e.variable_name='CLASSPATH'
and r.request_id = &REQUEST_ID

This will return the CLASSPATH being used by the concurrent request.
Reference id [ID 178766.1]

Friday, 12 August 2016

Oracle.Apps.Fnd.Framework.Oaexception

Oracle.Apps.Fnd.Framework.Oaexception: Could Not Create Java Class Error
When External Candidate Customizes Account (Doc ID 1384247.1)

APPLIES TO:

Oracle iRecruitment - Version 12.1.3 and later
Information in this document applies to any platform.

SYMPTOMS

On Applications 12.1.3
When attempting to customize account as an external candidate, the following error occurs:

Error
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Could not create Java class:
(oracle.apps.per.irc.candidateSelfService.webui.IrcCandidatePerPhonesCO) associated with region: (PhoneNumbers).
This is probably because the class name is wrong or not included in project.
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getController(OAWebBeanHelper.java:1896)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:572)
at oracle.apps.fnd

Steps
The issue can be reproduced at will with the following steps.
1. Go to IrcVisitor.jsp.
2. Log in as an external candidate.
3. Click My Account > Customize My Account.

CAUSE

The issue is caused by the following setup: missing function personalization at site level

Class path in the error message is incorrect(oracle.apps.per.irc..... ),
in R12 it is changed to oracle.apps.irc......

SOLUTION

As a workaround Personalize the Customize My Account button.
Go to my account page and then click on personalize page.
Personalize "Customize my Account" Button. The destination function is IRC_APL_PERSONAL_ACC_DETS_PAGE.
Replace it with IRC_APL_ACCOUNT_DETAILS_PAGE function at site level.


Tuesday, 9 August 2016

How to uninstall oracle11g from win10

OS- Windows10 64-bits

steps:-1

Uninstall all Oracle components using the Oracle Universal Installer (OUI).
Go to deinstall scripts location
C:\app\oracle\product\11.2.0\dbhome_1\deinstall



double click on deinstall symble.

open new command prompt.

Steps-2

Press window key with R-key
Open window than Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/Oracle key.

This contains registry entries for all Oracle products.



If you are running 64-bit Windows, 
you should also delete the HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Oracle key if it exists.
Delete any references to Oracle services left behind in the following part of the registry
(HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*).

It should be pretty obvious which ones relate to Oracle.


Steps-3
Reboot your machine.

Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.

Delete the "C:\Program Files\Oracle" directory.

If you are running 64-bit Wiindows, you should also delete the "C:\Program Files (x86)\Oracle" directory.

Remove any Oracle-related subdirectories from the "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\" directory.

Empty the contents of your "C:\temp" directory.

Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.

Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.

If some DLLs can't be deleted, try renaming them, the after a reboot delete them.


********************************************************************

OS:- OEL6.5

Uninstalling all products from OEL is a lot more consistent.
If you do need to resort to a manual uninstall you should do something like:

Uninstall all Oracle components using the Oracle Universal Installer (OUI).
Stop any outstanding processes using the appropriate utilities.

# oemctl stop oms user/password
# agentctl stop
# lsnrctl stop

Alternatively you can kill them using the kill -9 pid command as the root user.
Delete the files and directories below the $ORACLE_HOME.

# cd $ORACLE_HOME
# rm -Rf *

With the exception of the product directory, delete directories below the $ORACLE_BASE.

# cd $ORACLE_BASE
# rm -Rf admin doc jre o*

Delete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.

# rm /etc/oratab /etc/emtab

Monday, 8 August 2016

How to install toad for oracle 11g


What is TOAD?

TOAD - Tools for Oracle Application Development
TOAD is a set of development tools used for application development, 
database development, or business intelligence and assist developers 
in deploying Oracle-based applications and Web services on the Windows
platform. Developers use the applications for defining business logic, 
creating user interfaces, applications as Web services, and more.

Toad is a application development tool built around an advanced SQL and PL/SQL editor.
 Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions.
 You can create and edit database tables, views, indexes, constraints, and users. 
The Schema Browser and Project Manager provides quick access to database objects.
Toad’s SQL Editor provides an easy and efficient way to write and test scripts and queries, 
and its powerful data grids provide an easy way to view and edit Oracle data.
With Toad you can:
View the Oracle Dictionary
Create, browse, or alter objects
Graphically build, execute, and tune queries
Edit PL/SQL and profile stored procedures
Manage your common DB tasks from one central window
Find and fix database problems with constraints, triggers, extents, indexes,and grants
Create code from shortcuts and templates
Create custom code templates
Control code access and development (with or without a third party version control product) 

using Toad's cooperative source control feature.

Hardware Requirement for Toad.

75 MB disk space required to run Toad
1GM RAM 32bits required, 2 GB for 64-bits recommended.
VGA monitor, 1024x768 resolution, small fonts Mouse pointing device

Software Requirement for Toad.

Client - Windows 2000/XP/2003/Vista/7 (64-bit support for Windows 2003/XP/Vista/7 with 32-bit Oracle Client)
Oracle SQL Net, Net 8 (32-bit only) Net 9, Net 10, Net 11 or Instant Client
Server - Oracle versions 7.3.4; 8.0.6; 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11g


Once you have verified that your system meets the requirements listed above, paying special attention to the need for the 64 bit Oracle client, Toad for Oracle should work in your environment without any issues.

Steps for the installation of toad in a 64 bit environment after the installation of database:

1.     Install Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit).
2.     Install Toad.
3.     Configure TNS

1. Install Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit).

Download and install oracle database 11g release 2 client (11.2.0.1.0) for windows (64) bit. you can download the same from the below mentioned link.

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (64-bit)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) 
Downloadwin64_11gR2_client.zip (615,698,264 bytes) (cksum - 2947608743)

  • Extract win64_11gR2_client.zip
  • Run setup.exe
  • following screen will appear.
  • Select Installation type as Administrator and click next
  • Select your desired language and click next.
  • Provide the base location of Oracle product and click next.
  • Wait for the installation
  • This screen will be displayed when the installation is completed.

2.    Toad setup installation steps.

  • Click Toad DBA Suite for Oracle 10.6.1 Commercial.exe
  • Following screen will appear.
  • Click Next.
  • Accept the agreement and click next.
  • Change the location from C:\Program Files (x86)\Quest Software to C:\Quest Software and click next.
  • Select your desired products.
  • Click Install.
  • Installation is completed.
3.     Configure TNS


Configure your newly installed oracle client's TNS.