How to add system administrator responsibility from backend || How to add system administrator responsibility to user from backend

 How to add system administrator responsibility from backend || How to add system administrator responsibility to user from backend

BEGIN

  

   FND_USER_PKG.ADDRESP(

      USERNAME        =>  'MMANOHAR',              -- Add your User Name Here

      RESP_APP        =>  'SYSADMIN',             -- Apps Short Name

      RESP_KEY        =>  'SYSTEM_ADMINISTRATOR', -- Responsibility Key

      SECURITY_GROUP  =>  'STANDARD',

      DESCRIPTION     =>  NULL,

      START_DATE      =>  SYSDATE,

      END_DATE        =>  NULL);

  

   COMMIT;

  

   DBMS_OUTPUT.PUT_LINE('SYSADMIN Responsibility successfully added');

    

EXCEPTION

   WHEN OTHERS THEN

      DBMS_OUTPUT.PUT_LINE('SYSADMIN responsibility not added due to ' || SQLERRM);

      ROLLBACK;

END;

Concurrent Request Status Codes and Meaning Of Status Code's

Concurrent Request Status Codes and Meaning Of Status Code's:

Use below query to cancel all scheduled concurrent programs.

===================================================

UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'X'

WHERE status_code IN ('Q','I')

AND requested_start_date > SYSDATE

AND hold_flag = 'N';

COMMIT;

=====================================================

TO cancel all running concurrent programs.

UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'X'

WHERE status_code IN ('R','I');

Commit;

=====================================================

Concurrent Request Phase Codes:-

SELECT LOOKUP_CODE, MEANING

  FROM FND_LOOKUP_VALUES

 WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND LANGUAGE = 'US'

       AND ENABLED_FLAG = 'Y';

To Cancel Specific request:

=====================================================

update fnd_concurrent_requests

set status_code='D', phase_code='C'

where request_id=:request_id;

LOOKUP_CODE MEANING

C             Completed

I               Inactive

P             Pending

R             Running

Concurrent Request Status Codes:-

SELECT LOOKUP_CODE, MEANING

  FROM FND_LOOKUP_VALUES

 WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LANGUAGE = 'US'

       AND ENABLED_FLAG = 'Y';

LOOKUP_CODE	MEANING
R	Normal
I	Normal
Z	Waiting
D	Cancelled
U	Disabled
E	Error
M	No Manager
C	Normal
H	On Hold
W	Paused
B	Resuming
P	Scheduled
Q	Standby
S	Suspended
X	Terminated
T	Terminating
A	Waiting
G	Warning

Normally a concurrent request proceeds through three, possibly four, life cycle stages or phases,

Phase Code	Meaning with Description
Pending	Request is waiting to be run
Running	Request is running
Completed	Request has finished
Inactive	Request cannot be run

                                               

                               

Within each phase, a request's condition or status may change. Below appears a listing of each phase and the various states that a concurrent request can go through.

The status and the description of each meaning given below:

PENDING	Normal	Request is waiting for the next available manager.
	Standby	Program to run request is incompatible with other program(s) currently running.
	Scheduled	Request is scheduled to start at a future time or date.
	Waiting	A child request is waiting for its Parent request to mark it ready to run. For example, a report in a report set that runs sequentially must wait for a prior report to complete.
RUNNING	Normal	Request is running normally.
	Paused	Parent request pauses for all its child requests to complete. For example, a report set pauses for all reports in the set to complete.
	Resuming	All requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted.
	Terminating	Running request is terminated, by selecting Terminate in the Status field of   the Request Details zone.
COMPLETED	Normal	Request completes normally.
	Error	Request failed to complete successfully.
	Warning	Request completes with warnings. For example, a report is generated successfully but fails to print.
	Cancelled	Pending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details zone.
	Terminated	Running request is terminated, by selecting Terminate in the Status field of   the Request Details zone.
INACTIVE	Disabled	Program to run request is not enabled. Contact your system administrator.
	On Hold	Pending request is placed on hold, by selecting Hold in the Status field of the Request Details zone.
	No Manager	No manager is defined to run the request. Check with your system administrator.

Create User In Oracle Apps Through Back End

Create User In Oracle Apps Through Back End


declare
l_user_name varchar2(30):='TESTUSER';
l_owner varchar2(30):='xxxxx'; -- Any existing user
l_unencrypted_password varchar2(240) :='welcome123';
l_session_number number :=userenv('sessionid');
l_start_date date :=sysdate-1;
l_end_date date := null;
l_last_logon_date date := null;
l_description varchar2(240) := 'FirstName, Lastname';
l_password_date date := SYSDATE;
l_password_accesses_left number := null;
l_password_lifespan_accesses number := null;
l_password_lifespan_days number := 90;
l_employee_id number := null;
l_email_address varchar2(240) := 'existing@email.com';
l_fax varchar2(30) := null;
l_customer_id number := null;
l_supplier_id number := null;


begin

fnd_user_pkg.CreateUser(
x_user_name => l_user_name,
x_owner => l_owner,
x_unencrypted_password => l_unencrypted_password,
x_session_number => l_session_number,
x_start_date => l_start_date,
x_end_date => l_end_date,
x_last_logon_date => l_last_logon_date,
x_description => l_description,
x_password_date => l_password_date,
x_password_accesses_left => l_password_accesses_left,
x_password_lifespan_accesses => l_password_lifespan_accesses,
x_password_lifespan_days => l_password_lifespan_days,
x_employee_id => l_employee_id,
x_email_address => l_email_address,
x_fax => l_fax,
x_customer_id => l_customer_id,
x_supplier_id => l_supplier_id);



fnd_user_pkg.addresp(l_user_name,'SYSADMIN','SYSTEM_ADMINISTRATOR','STANDARD',null,sysdate-1,sysdate+90);

DBMS_OUTPUT.PUT_LINE('User Created SuccessFully');

COMMIT;
end;

how to initialize sequrity profile from back end in R12

query to fine security profile information

select psp.security_profile_name, psp.security_profile_id, hou.name, hou.organization_id            
from per_security_profiles psp, per_security_organizations pso, hr_operating_units hou        
where pso.security_profile_id = psp.security_profile_id  and pso.organization_id = hou.organization_id
order by psp.security_profile_name,hou.name;
how to initialize sequrity profile from back end

begin
mo_global.set_org_access(null,3068 /*security_profile_id */,'ar' /*module shortname*/);
end;

How to know user password from Back End in Oracle apps R12

1.

CREATE OR REPLACE PACKAGE get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;
END get_pwd;
2.

CREATE OR REPLACE PACKAGE BODY 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;
/
3. run below select query you will get user_name and password.

select usr.user_name,
       get_pwd.decrypt
          ((select (select get_pwd.decrypt
                              (fnd_web_sec.get_guest_username_pwd,
                               usertable.encrypted_foundation_password
                              )
                      from dual) as apps_password
              from fnd_user usertable
             where usertable.user_name =
                      (select substr
                                  (fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     instr
                                          (fnd_web_sec.get_guest_username_pwd,
                                           '/'
                                          )
                                   - 1
                                  )
                         from dual)),
           usr.encrypted_user_password
          ) password
  from fnd_user usr
 where upper(usr.user_name) = upper('&user_name');

fnd load details

how to copy the fnd tables data from one instance to another instance using fndload

fndload apps/apps@devdb 0 y download testcfg.lct out.ldt fnd_application_tl appsname=fnd

how to insert the data into fnd_territories from back end

using the below package we can insert / update the data into fnd_territories_tl and fnd_territories.

   fnd_territories_pkg.load_row (
      x_territory_code=> :territory_code,
      x_eu_code=> :eu_code,
      x_iso_numeric_code=> :iso_numeric_code,
      x_alternate_territory_code=> :alternate_territory_code,
      x_nls_territory=> :nls_territory,
      x_address_style=> :address_style,
      x_address_validation=> :address_validation,
      x_bank_info_style=> :bank_info_style,
      x_bank_info_validation=> :bank_info_validation,
      x_territory_short_name=> :territory_short_name,
      x_description=> :description,
      x_owner=> :owner,
      x_last_update_date=> :last_update_date,
      x_custom_mode=> :custom_mode,
      x_obsolete_flag=> :obsolete_flag,
      x_iso_territory_code=> :iso_territory_code
   );

apart from the above package we need to use the below package to insert the data into fnd_currencies

fnd_currencies_pkg.load_row (  x_currency_code in varchar2,
  x_derive_effective in date,
  x_derive_type in varchar2,
  x_global_attribute1 in varchar2,
  x_global_attribute2 in varchar2,
  x_global_attribute3 in varchar2,
  x_global_attribute4 in varchar2,
  x_global_attribute5 in varchar2,
  x_global_attribute6 in varchar2,
  x_global_attribute7 in varchar2,
  x_global_attribute8 in varchar2,
  x_global_attribute9 in varchar2,
  x_global_attribute10 in varchar2,
  x_global_attribute11 in varchar2,
  x_global_attribute12 in varchar2,
  x_global_attribute13 in varchar2,
  x_global_attribute14 in varchar2,
  x_global_attribute15 in varchar2,
  x_global_attribute16 in varchar2,
  x_global_attribute17 in varchar2,
  x_global_attribute18 in varchar2,
  x_global_attribute19 in varchar2,
  x_global_attribute20 in varchar2,
  x_derive_factor in number,
  x_enabled_flag in varchar2,
  x_currency_flag in varchar2,
  x_issuing_territory_code in varchar2,
  x_precision in number,
  x_extended_precision in number,
  x_symbol in varchar2,
  x_start_date_active in date,
  x_end_date_active in date,
  x_minimum_accountable_unit in number,
  x_context in varchar2,
  x_attribute1 in varchar2,
  x_attribute2 in varchar2,
  x_attribute3 in varchar2,
  x_attribute4 in varchar2,
  x_attribute5 in varchar2,
  x_attribute6 in varchar2,
  x_attribute7 in varchar2,
  x_attribute8 in varchar2,
  x_attribute9 in varchar2,
  x_attribute10 in varchar2,
  x_attribute11 in varchar2,
  x_attribute12 in varchar2,
  x_attribute13 in varchar2,
  x_attribute14 in varchar2,
  x_attribute15 in varchar2,
  x_iso_flag in varchar2,
  x_global_attribute_category in varchar2,
  x_name in varchar2,
  x_description in varchar2,
  x_owner in varchar2)

how to reset user password from back end in oracle apps

BEGIN
FND_USER_PKG.UPDATEUSER(x_user_name       => 'EXUSTUBGYSER'
                                                        ,x_owner                => 'APPS'
                                                        ,x_unencrypted_password => 'oracle1234'
                                                        ,x_password_date        => SYSDATE );

END;

Oracle R12 – How To Turn Off Low-Level Diagnostic Logging

“Low-level Diagnostic Logging is turned on. This may temporarily reduce performance”

How can this be disabled / turned off?

Disable diagnostic logging with the following steps:
1. Login as a user with System Administrator responsibility and then navigate to:  Profile > System.
Set the following profile option at the User level:

FND: Debug Log Enabled = No

2. Logout of the application. You may also want to clear the browser’s cache.

3. Login again and confirm that the message no longer appears.

how to find values set values

select * from fnd_flex_value_sets where flex_value_set_name='p_conv_opt'--flex_value_set_id=1015234

 select flex_value          ,
  flex_value_meaning        ,
  description               ,
  enabled_flag              ,
  start_date_active         ,
  end_date_active           ,
  summary_flag              ,
  hierarchy_level           ,
  flex_value_set_id         ,
  parent_flex_value_low     ,
  parent_flex_value_high    ,
  flex_value_id             ,
  last_update_date          ,
  last_updated_by           ,
  structured_hierarchy_level,
  compiled_value_attributes ,
  value_category            ,
  attribute1                ,
  attribute2                ,
  attribute3                ,
  attribute4                ,
  attribute5                ,
  attribute6                ,
  attribute7                ,
  attribute8                ,
  attribute9                ,
  attribute10               ,
  created_by                ,
  creation_date             ,
  last_update_login         ,
  attribute11               ,
  attribute12               ,
  attribute13               ,
  attribute14               ,
  attribute15               ,
  attribute16               ,
  attribute17               ,
  attribute18               ,
  attribute19               ,
  attribute20               ,
  attribute21               ,
  attribute22               ,
  attribute23               ,
  attribute24               ,
  attribute25               ,
  attribute26               ,
  attribute27               ,
  attribute28               ,
  attribute29               ,
  attribute30               ,
  attribute31               ,
  attribute32               ,
  attribute33               ,
  attribute34               ,
  attribute35               ,
  attribute36               ,
  attribute37               ,
  attribute38               ,
  attribute39               ,
  attribute40               ,
  attribute41               ,
  attribute42               ,
  attribute43               ,
  attribute44               ,
  attribute45               ,
  attribute46               ,
  attribute47               ,
  attribute48               ,
  attribute49               ,
  attribute50               ,
  attribute_sort_order      ,
  row_id
   from fnd_flex_values_vl
  where ((''                   is null)
or (structured_hierarchy_level in
  (select hierarchy_id
     from fnd_flex_hierarchies_vl h
    where h.flex_value_set_id = 1015234
  and h.hierarchy_name like ''
  )))
and (flex_value_set_id=1015234)
rder by flex_value

Enable or Disable Help Diagnostics Examine

Profile Option:
Utilities:Diagnostics - Yes (if you set to YES at site level the Help -> Diagnostics -> Examine can access without passwork asking)
Utilities:Diagnostics - No (If you set to NO at site level no one can access the Help -> Diagnostics -> Examine and other optoins)

Go to System Administrator Responsibility=>profile=>system=>on which level you want to set =>Utilities:Diagnostics - Yes