How to Disable Close Other Forms Function from any Responsibility - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2017/05/how-to-disable-close-other-forms.html

How to Disable Close Other Forms Function from any Responsibility

Navigate to Menu of the Responsibility and add in Function "Navigator: Disable Multiform".

If Menu is Shared to Multiple Users then add in Menu Exclusions of that Responsibility to Enable it for that Particular Responsibility

How to insert image in RTF Template - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2017/01/how-to-insert-image-in-rtf-template.html

How to insert image in RTF Template

Image Must be in .gif Format

Make a table of single row and Column and insert image in it through insert>Pictures in RTF Template.

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