Concurrent request output and log opens like form and not in text/word - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/concurrent-request-output-and-log-opens.html

Concurrent request output and log opens like form and not in text/word

Concurrent request output and log opens like form and not in text/word. We have to Navigate to Tools>Copy
set the profile, "Viewer: Text" to Browser. This will open the output / log in browser

FSG Report Last run date - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/fsg-report-last-run-date.html

FSG Report Last run date

select * from  fnd_concurrent_requests bb, fnd_concurrent_programs_vl jj, RG_REPORTS_V cc
where bb.CONCURRENT_PROGRAM_ID = jj.CONCURRENT_PROGRAM_ID
and cc.REPORT_ID = bb.ARGUMENT7
and jj.USER_CONCURRENT_PROGRAM_NAME = 'HUBCO Program - Publish FSG Report'
order by bb.REQUEST_ID desc

Convert number to character in PLSQL - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/12/convert-number-to-character-in-oracle.html

Convert number to character in PLSQL

select spell_number (50000) from dual

User, Responsibility, Request Group, Concurrent Program Joining Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/11/user-responsibility-request-group.html

User, Responsibility, Request Group, Concurrent Program Joining Query

  select jj.USER_NAME , kk.REQUEST_GROUP_NAME, mm.RESPONSIBILITY_NAME , jj.FAX , cpt.USER_CONCURRENT_PROGRAM_NAME
  from fnd_request_groups kk, FND_RESPONSIBILITY_VL  mm, FND_USER_RESP_GROUPS_DIRECT hh, fnd_user jj,
  fnd_request_group_units tt ,FND_CONCURRENT_PROGRAMS_TL CPT
  where kk.REQUEST_GROUP_ID = mm.REQUEST_GROUP_ID
  and hh.RESPONSIBILITY_ID=mm.RESPONSIBILITY_ID
  and tt.REQUEST_GROUP_ID= kk.REQUEST_GROUP_ID
  and tt.REQUEST_GROUP_ID=mm.REQUEST_GROUP_ID
  and kk.REQUEST_GROUP_ID=mm.REQUEST_GROUP_ID
  and cpt.CONCURRENT_PROGRAM_ID =tt.REQUEST_UNIT_ID
  and hh.user_id= jj.USER_ID
  and mm.END_DATE is null
  and jj.END_DATE is null

  --and kk.REQUEST_GROUP_NAME = '?'
  and cpt.USER_CONCURRENT_PROGRAM_NAME =  '?'

Query to find the Request Group of a Concurrent Program - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/11/query-to-find-request-group-of.html

Query to find the Request Group of a Concurrent Program

SELECT
  RG.APPLICATION_ID "Request Group Application ID",
  RG.REQUEST_GROUP_ID "Request Group - Group ID",
  RG.REQUEST_GROUP_NAME,
  RG.DESCRIPTION,
  rgu.unit_application_id,
  rgu.request_group_id "Request Group Unit - Group ID",
  rgu.request_unit_id,cp.concurrent_program_id,
  cp.concurrent_program_name,
  cpt.user_concurrent_program_name,
  DECODE(rgu.request_unit_type,'P','Program','S','Set',rgu.request_unit_type) "Unit Type"
FROM
  fnd_request_groups rg,
  fnd_request_group_units rgu,
  fnd_concurrent_programs cp,
  FND_CONCURRENT_PROGRAMS_TL CPT
WHERE rg.request_group_id = rgu.request_group_id
  AND rgu.request_unit_id = cp.concurrent_program_id
  AND cp.concurrent_program_id = cpt.concurrent_program_id

Reports Assigned to Responsibility Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/10/reports-assigned-to-responsibility-query.html

Reports Assigned to Responsibility Query 

SELECT fcpl.user_concurrent_program_name "REPORT NAME",
                fnrtl.responsibility_name, frg.request_group_name,
                fcp.concurrent_program_name "CONCURRENT PROGRAM SHORT NAME"
           FROM apps.fnd_request_groups frg,
                apps.fnd_request_group_units frgu,
                apps.fnd_concurrent_programs fcp,
                apps.fnd_concurrent_programs_tl fcpl,
                apps.fnd_executables fe,
                apps.fnd_responsibility fnr,
                apps.fnd_responsibility_tl fnrtl
          WHERE frg.application_id = frgu.application_id
            AND frg.request_group_id = frgu.request_group_id
            AND frg.request_group_id = fnr.request_group_id
            AND frg.application_id = fnr.application_id
            AND fnr.responsibility_id = fnrtl.responsibility_id
            AND frgu.request_unit_id = fcp.concurrent_program_id
            AND frgu.unit_application_id = fcp.application_id
            AND fcp.concurrent_program_id = fcpl.concurrent_program_id
            AND fe.execution_method_code LIKE 'P' --'Oracle Reports'
            AND fcp.executable_id = fe.executable_id
            AND fe.application_id = fcp.executable_application_id
            AND fnrtl.responsibility_name LIKE '&Responsibility_Name'
            -- Example Resp. Name : Oracle Inventory or put '%' to get the list of all the responsibilities
          --  AND fnrtl.LANGUAGE = 'US'
          --  AND fcpl.LANGUAGE = 'US';

There are no Active Responsibilities available for this User - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/08/there-are-no-active-responsibilities.html

There are no Active Responsibilities available for this User

1. Navigate to the define user form (FNDSCAUS).

2. Query up the user (that is having the issue) and ensure responsibilities not showing up are NOT end dated. 

3. END DATE the USER (not the responsibility) and save the record. 

4. UN-END DATE the USER and save the record.

5 Request Name = Workflow Directory Services User/Role Validation
Batch Size = 10000
User name = MAR.KO907
Fix dangling users = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No
Click "OK" and "Submit".

6. Clear the Cache

7. Missing responsibilities now appear.

How to Enable Functional Administrator @ SYSADMIN - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/08/how-to-enable-functional-administrator.html

How to Enable Functional Administrator @ SYSADMIN

Attach the following Program to ones request Set

Fix Dangling Users: Yes

Add missing User/Role Assignments: Yes

Concurrent Program:Workflow Directory Services User/Role Validation

Run the above Program to Enable "Functional Administrator" Responsibility

Bounce Apache and Retest the Issue

How to Default RTF on Report when Multiple RTF's are Registered to same Report - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/08/how-to-default-rtf-on-report-when.html

How to Default RTF on Report when Multiple RTF's are Registered to same Report

Please Copy Paste the Below URL in your Browser

http://www.oracle.com/technetwork/middleware/bi-publisher/overview/xmlebsrep-132947.pdf

How to enable Oracle apps Diagnostics-> Examine, for certain users? - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/07/how-to-enable-oracle-apps-diagnostics.html

How to enable Oracle apps Diagnostics-> Examine, for certain users?

Please Copy Paste the Below URL in Your Browser

https://blogs.oracle.com/prajkumar/entry/enable_oracle_apps_diagnostics_examine

Where the Output of the Concurrent Program "OR" Report Output is saved in Database - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/07/where-output-of-concurrent-program-or.html

Where the Output of the Concurrent Program "OR" Report Output is saved in Database

select fnd.REQUEST_ID,fnd.LOGFILE_NAME, fnd.OUTFILE_NAME
from fnd_concurrent_requests fnd
where fnd.REQUEST_ID=1628756

Profile Options PLSQL Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/07/profile-options-query.html

Profile Options PLSQL Query

SELECT --fpo.profile_option_name SHORT_NAME,
 fpot.user_profile_option_name NAME,
 DECODE(fpov.level_id,
        10001,
        'Site',
        10002,
        'Application',
        10003,
        'Responsibility',
        10004,
        'User',
        10005,
        'Server',
        'UnDef') LEVEL_SET,
 DECODE(TO_CHAR(fpov.level_id),
        '10001',
        '',
        '10002',
        fap.application_short_name,
        '10003',
        frsp.RESPONSIBILITY_NAME,
        '10005',
        fnod.node_name,
        '10006',
        hou.name,
        '10004',
        fu.user_name,
        'UnDef') "CONTEXT",
 fpov.profile_option_value VALUE
  FROM /*fnd_profile_options fpo,*/ fnd_profile_option_values fpov,
       fnd_profile_options_vl    fpot,
       fnd_user                  fu,
       fnd_application           fap,
       fnd_responsibility_tl     frsp,
       fnd_nodes                 fnod,
       hr_operating_units        hou
 WHERE fpov.profile_option_id(+) = fpot.PROFILE_OPTION_ID
   and fpov.APPLICATION_ID(+) = fpot.APPLICATION_ID
      -- AND fpov.profile_option_name = fpot.profile_option_name(+)
   AND fu.user_id(+) = fpov.level_value
   AND frsp.application_id(+) = fpov.level_value_application_id
   AND frsp.responsibility_id(+) = fpov.level_value
   AND fap.application_id(+) = fpov.level_value
   AND fnod.node_id(+) = fpov.level_value
   AND hou.organization_id(+) = fpov.level_value
--  AND fpot.user_profile_option_name IN ('&User_Profile_Option_Name')
--ORDER BY short_name;

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

select   a.user_profile_option_name NAME

,  DECODE (c.LEVEL_ID,

                 10001, 'Site',

                 10002, 'Application',

                 10003, 'Responsibility',

                 10004, 'User',

                 10005, 'Server',

                 c.LEVEL_ID) LEVEL_SET

                 

              ,   DECODE (TO_CHAR (c.level_id),

                 '10001', '',

                 '10002', fap.application_short_name,

                 '10003', frsp.RESPONSIBILITY_NAME,

                 '10005', fnod.node_name,

                 '10006', hou.name,

                 '10004', d.user_name,

                 TO_CHAR (c.level_id)) CONTEXT,

                 c.profile_option_value VALUE

                   from FND_PROFILE_OPTIONS_VL a/*, fnd_profile_options b*/, fnd_profile_option_values c, fnd_user d,

            hr_operating_units hou, fnd_responsibility_tl frsp , fnd_application fap, fnd_nodes fnod

where a.PROFILE_OPTION_ID = c.PROFILE_OPTION_ID(+)

and a.APPLICATION_ID = c.APPLICATION_ID(+)

and  d.user_id(+) = c.LEVEL_VALUE

and  hou.organization_id(+) = c.level_value

AND frsp.application_id(+) = c.level_value_application_id

AND frsp.responsibility_id(+) = c.level_value

AND fap.application_id(+) = c.level_value

 AND fnod.node_id(+) = c.level_value

/*and c.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID

and c.APPLICATION_ID=a.APPLICATION_ID

and a.PROFILE_OPTION_ID = c.PROFILE_OPTION_ID

and a.APPLICATION_ID=b.APPLICATION_ID*/

User & Responsibility PLSQL Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/06/user-responsibility-menu-request-group.html

User & Responsibility PLSQL Query

select jj.user_id, tt.USER_NAME, kk.RESPONSIBILITY_NAME, hh.MENU_NAME , ll.REQUEST_GROUP_NAME
from  FND_USER_RESP_GROUPS_DIRECT jj,
FND_USER tt, fnd_responsibility_vl kk, fnd_menus_vl hh, fnd_request_groups ll
where 1=1
and tt.USER_ID=jj.user_id
and jj.RESPONSIBILITY_ID=kk.RESPONSIBILITY_ID
and kk.MENU_ID=hh.MENU_ID
and ll.REQUEST_GROUP_ID(+)=kk.REQUEST_GROUP_ID
and tt.USER_NAME in ('Virat')
and jj.END_DATE is null
order by tt.USER_NAME

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

select tt.USER_NAME,
       tt.DESCRIPTION,
       hh.APPLICATION_NAME,
       kk.RESPONSIBILITY_NAME,
       jj.START_DATE,
       jj.END_DATE
     
  from FND_USER                    tt,
       FND_USER_RESP_GROUPS_DIRECT jj,
       fnd_responsibility_vl       kk,
       fnd_application_vl          hh
 where 1 = 1
   and kk.APPLICATION_ID = hh.APPLICATION_ID
   and tt.USER_ID = jj.user_id
   and jj.RESPONSIBILITY_ID = kk.RESPONSIBILITY_ID
   and tt.END_DATE <= '30-JUN-2016'
  --- and tt.USER_NAME like 'Vir%'
   order by tt.USER_name, hh.APPLICATION_NAME, kk.RESPONSIBILITY_NAME