Reset Password for Application User

DECLARE

v_user_name varchar2(30):=UPPER('VMALLAREDDY');

v_new_password varchar2(30):='welcome';

v_status BOOLEAN;

BEGIN

v_status:= fnd_user_pkg.ChangePassword (

    username => v_user_name,

    newpassword => v_new_password

);

IF v_status =TRUE THEN

dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);

commit;

ELSE

DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

ROLLBACK;

END IF;

END;

Add Responsibility to Oracle FND User

-- ----------------------------------------------------------
-- Add Responsibility to Oracle FND User
-- -----------------------------------------------------------
DECLARE
    lc_user_name                        VARCHAR2(100)    := 'VMALLAREDDY';
    lc_resp_appl_short_name   VARCHAR2(100)    := 'CE';
    lc_responsibility_key          VARCHAR2(100)    := 'CASH_MANAGEMENT';
    lc_security_group_key        VARCHAR2(100)    := 'STANDARD';
    ld_resp_start_date                DATE                        := sysdate;
    ld_resp_end_date                 DATE                        := NULL;

BEGIN
     fnd_user_pkg.addresp
     (   username           => lc_user_name,
        resp_app             => lc_resp_appl_short_name,
        resp_key             => lc_responsibility_key,
        security_group  => lc_security_group_key,
        description         => NULL,
        start_date           => ld_resp_start_date,
        end_date            => ld_resp_end_date
    );

 COMMIT;

EXCEPTION
            WHEN OTHERS THEN
                        ROLLBACK;
                        DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/

FNDLOAD

For Menu:

------------------

Download All:

--------------------

$FND_TOP/bin/FNDLOAD apps/<> O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU.ldt MENU MENU_NAME=%

Upload All:

---------------

$FND_TOP/bin/FNDLOAD apps/<> O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_MENU.ldt

Responsibility:

-------------------------

Download:

---------------

$FND_TOP/bin/FNDLOAD apps/<> O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct $XX_TOP/staging/XX_RESPONSIBILTY.ldt FND_RESPONSIBILITY RESP_KEY="XX%"

Upload:

-----------

$FND_TOP/bin/FNDLOAD apps/<> O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_RESPONSIBILTY.ldt

Accounting Flexfields:

-------------------------------

Download

-------------

$FND_TOP/bin/FNDLOAD apps/<> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_ACCOUNTING_FLEXFIELD.ldt KEY_FLEX P_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:S HA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="SQLGL" ID_FLEX_CODE="GL#" P_STRUCTURE_CODE="XX_ACCOUNTING_FLEXFIELD"

Upload:

------------

$FND_TOP/bin/FNDLOAD apps/<> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_ACCOUNTING_FLEXFIELD.ldt

Reset ORACLE_HOME in Windows

From command prompt: echo %ORACLE_HOME%
This should return %ORACLE_HOME%, meaning it's just echoing what you typed in and there is not set value for ORACLE_HOME. If there is a value for ORACLE_HOME, then: setx ORACLE_HOME ""
That will set ORACLE_HOME to nothing. Remember you need to close the command prompt and open a new one to have it read the change you just made.

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [

sqlplus
/ as sysdba
shutdown abort
startup mount;
recover database;
alter database open;
connect scott/tiger

Getting mailer service available in the instance

SELECT b.component_name,
       c.parameter_name,
       a.parameter_value
FROM fnd_svc_comp_param_vals a,
     fnd_svc_components b,
     fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
     AND b.component_type = c.component_type
     AND c.parameter_id = a.parameter_id
     AND c.encrypted_flag = 'N'
     AND b.component_name like '%Mailer%'
     AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;

select component_status
    from apps.fnd_svc_components
   where component_id =
        (select component_id
           From Apps.Fnd_Svc_Components
          where component_name = 'Workflow Notification Mailer');
         
select running_processes
    from apps.fnd_concurrent_queues
   Where Concurrent_Queue_Name = 'WFMLRSVC';



select message_type, mail_status, count(*) from wf_notifications
where status = 'OPEN'
Group By Message_Type, Mail_Status

Getting Trace File

SELECT 'Trace Name: '||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'File Name: '||execname.execution_file_name|| execname.subroutine_name
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = :Request_Id
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id