Skip to main content

Posts

Showing posts from January, 2014

API to reset R12 passwords

DECLARE    v_code   NUMBER;    v_errm   VARCHAR2 (500); BEGIN    fnd_user_pkg.updateuserparty (x_user_name    => 'XYZ',                                  x_owner        => 'XYZ',                      x_unencrypted_password => 'xyz1234',                      x_password_date          => SYSDATE + 500);    DBMS_OUTPUT.put_line ('Password Changed !!!! ');    COMMIT; EXCEPTION    WHEN OTHERS    THEN       v_code := SQLCODE;       v_errm := SUBSTR (SQLERRM, 1, 500);       DBMS_OUTPUT.put_line ('Error code ' || v_code || ': ' || v_errm);       DBMS_OUTPUT.put_line ...
Post a Comment
Read more

Retrieve R12 Application username passwords

------------------------------------------------------------ CREATE OR REPLACE PACKAGE APPS.get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / ------------------------------------------------------------ CREATE OR REPLACE  PACKAGE BODY  APPS.get_pwd AS    FUNCTION decrypt (       KEY     IN VARCHAR2,       VALUE   IN VARCHAR2)       RETURN VARCHAR2    AS       LANGUAGE JAVA       NAME ' oracle .apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java .lang.String'; END get_pwd; / --------------------------------------------------------------- SELECT usr.user_name,        get_pwd.         decrypt (           (SELECT (SELECT get_pwd.                 ...
Post a Comment
Read more

Steps to change R12 application port.

Steps to be done on Application Server 1- Take backup of your Context XML file. 2. Open your  Context XML file for edit  through OAM 3- Change the value from 8001 to be 8002 on the following lines:       <web_port oa_var=" s_webport " oa_type="PORT" base="8000" step="1" range="-1" label="Web Listener Port">8001</web_port>        <activewebport oa_var=" s_active_webport " oa_type="DUP_PORT"  base="8000" step="1" range="-1" label="Active Web Port">8001</activewebport>     <login_page oa_var=" s_login_page ">http://myhost.oracle.com:8001/OA_HTML/AppsLogin</login_page>     <chronosURL oa_var=" s_chronosURL ">http://myhost.oracle.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</chronosURL>  <oa_var=" s_endUserMonitoringURL ">http://myhost.oracle.com:8001/oracle_smp_...
Post a Comment
Read more

Responsibilities not visible in Oracle R12

Issue : Some responsibilities are not visible in oracle R12. Solution : 1.  Login as R12 application using sysadmin username. 2. Select System Administrator (Responsibilities) 3. Submit Concurrent Program ""Workflow Directory Services User/Role Validation' with parameters 10000, yes, yes After following the solution, check your issue again after re-login.
Post a Comment
Read more

Cloning 11g RAC ASM to NON ASM

Steps to clone 11g RAC ASM database to single node NON ASM Database: -------------------------------------------------------------- Pre-Requistive: Archive Log Mode Enabled. (Source Node) Control File AutoBackup should be ON (Source Node) Steps on Source Node: 1. On source node (Any node of RAC database) perform the following commands for taking database backup 2. cd $ORACLE_HOME/bin     ./rman target /      c rosscheck backup;      crosscheck archivelog all;      delete force obsolete;      delete expired backup;      crosscheck backup;      crosscheck archivelog all; 3. Specify same location of control file and spfile backup of your RMAN backup location. (keep location of local mount points) RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '<BACKUP_LOCATION>/%F_%T'; 4. Connect to RMAN for taking database backup along with archivelo...
Post a Comment
Read more

R12 Login Page not coming/blank.

Issue: 500 Internal Server Error java.lang.NoClassDefFoundError at Solution 1: 1. adopmnctl.sh stopall — to shutdown opmn managed services 2. cd $COMMON_TOP/_pages 3. mv _pages _pages_old 4. cd $FND_TOP/patch/115/bin or export PATH=$FND_TOP/patch/115/bin:$PATH 5. Compile all jsps. perl ojspCompile.pl –compile –flush -p 2 After all these steps, again start service and retry. ------------------------------------------------------------- Solution 2: 1. Stop all the services using adstpall.sh 2. cd $INST_TOP/appl/admin 3. Edit the context file parameter "s_java_object_cache_port" from 12345 to 12349 4. Run autoconfig on application tier. 5. Start the application and retest the issue.
Post a Comment
Read more

FNDLOAD DOWNLOAD & UPLOAD COMMANDS

---------------------------------------------------------------- 1 - Printer Styles ------------------ DOWNLOAD Command: FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name” UPLOAD Command: Move the .ldt file to the target instance FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt ---------------------------------------------------------------- 2 - Lookups ------------- DOWNLOAD Command: FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name” UPLOAD Command: Move the .ldt file to the target instance FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt ---------------------------------------------------------------- 3 - Descriptive Flexfield with all of specif...
Post a Comment
Read more

FRM-92050 on Solaris 11 SPARC

FRM-92050 : Failed to connect to the server:/forms/lservlet-1 java.io.IOException: Negative content-length. Solution : 1. Open Internet Explorer => Go to "Tools" => Click on "Internet Options" => Click on "Security" Tab. Select "Internet" under {{ Select a zone to view and change security settings.}} => Set "Security level for this zone" to "Medium". Select "Local intranet" under {{ Select a zone to view and change security settings.}} => Set "Security level for this zone" to "Medium-low" => Click on "Sites" for "Local intranet" => Click on "Advanced" => Add the Instance URL. => Click on "Close" => Click on "Ok". Click on Apply => Click on Ok.
Post a Comment
Read more