Retry Errored Workflow Activities

 https://systemadministratorsys.blogspot.com/2025/07/retry-errored-workflow-activities.html

One of our workflow was malfunctioning, and upon a retry from status monitor it was moving successfully. so, we scheduled the below program 

Retry Errored Workflow Activities

Output Post Processor is Down - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/07/output-post-processor-is-down.html

Output Post Processor is Down with Actual Process is 0 And Target Process is 1

SOLUTION:

If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following

1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name>

2. To ensure concurrent manager down; check there is no FNDLIBR process running.

ps -ef | grep applmgr | grep FNDLIBR

3. Run adadmin to relink FNDSVC executable.
a. Invoke adadmin from command prompt
b. Choose option 2 (2. Maintain Applications Files menu)
c. Choose option 1 (1. Relink Applications programs )
d. Then type “FND” When prompted; ( Enter list of products to link (‘all’ for all products) [all] : FND )
e. Ensure adrelink is exiting with status 0

4. Start Concurrent Managers using adcmctl.sh

PLSQL Query to find Journal Line Types (JLT) for Event Classes - Oracle RBS R12

https://systemadministratorsys.blogspot.com/2018/07/plsql-query-to-find-journal-line-types.html

PLSQL Query to find Journal Line Types (JLT) for Event Classes

SELECT accounting_line_code,
name,
l.meaning accounting_line_type,
event_class_name,
event_class_code,
entity_code
FROM xla_acct_line_types_fvl s,
xla_lookups l
WHERE s.amb_context_code = 'DEFAULT'
AND s.application_id = '222' -- Receivables
AND s.accounting_line_type_code = 'S'
AND s.accounting_line_type_code = l.lookup_code
AND l.lookup_type = 'XLA_OWNER_TYPE'
ORDER BY accounting_line_code,
name,
event_class_name,
accounting_line_type

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/adding-responsibility-to-sysadmin-user.html

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

ERROR

Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE
(USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has
been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

SOLUTION

This Issue exists in default R12 installation

Step 1. Run the concurrent program “Workflow Directory Services User/Role Validation” with parameters : 100000, Yes, Yes, No

Step 2. Bounce all services under oacore or bounce opmnctl .

Reference Oracle Note id : 454988.1

ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/processorexception-unable-to-determine.html

ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST 

ERROR

Outpost Processot has encoutered the below error.

This error can be found in OPP logs:
—————————————-
[GC 14000K->8604K(32459K), 0.0068459 secs]
ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST
at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)
at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
—————————————-

SOLUTION

Step 1. Log into System Administrator responsibility.

Step 2. Navigate to Profile > System.

Step 3. Query up the %smtp% profiles.

Step 4. Set the following profile values to the defined host and port:

FND:smtp Host

FND:smtp Port

Responsibility (Menu & Functions) LEVEL-1 - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/responsibility-menu-functions.html

Responsibility (Menu & Functions) LEVEL-1

SELECT   distinct a.RESPONSIBILITY_NAME, menu.DESCRIPTION MENU_DESCRIPTION,
/*LPAD(' ', 6*((LEVEL-1))) ||*/ menu_entry.entry_sequence "SEQUENCE (LEVEL-1)"
,menu_entry.PROMPT "PROMPT (LEVEL-1)"
, /*LPAD(' ', 6*((LEVEL-1))) ||*/ menu.user_menu_name "SUBMENU DESCRIPTION (LEVEL-1)"
,/* LPAD(' ', 6*((LEVEL-1))) ||*/ func.user_function_name "FUNCTION DESCRIPTION (LEVEL-1)"
,menu_entry.DESCRIPTION "DESCRIPTION (LEVEL-1)"
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM FND_MENU_ENTRIES_VL menu_entry,
fnd_menus_tl menu,--FND_USER_RESP_GROUPS_DIRECT c,
fnd_form_functions_tl func , Fnd_Responsibility_Vl a
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
and a.MENU_ID =  menu_entry.MENU_ID
--and c.RESPONSIBILITY_ID(+)=a.RESPONSIBILITY_ID
--and a.RESPONSIBILITY_NAME =  'AP ADMINISTRATOR'
AND grant_flag = 'Y'
--and LPAD(' ', 6*((LEVEL-1))) || menu_entry.entry_sequence = 5

CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence

ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/02/ora-08004-sequence-fndconcurrentprocess.html

ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE

ERROR

Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID
Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.
TheCall to establish_icm failed
The Internal Concurrent Manager has encountered an error.

SOLUTION

The max value for the sequence FND_CONCURRENT_PROCESSES_S has been reached and we need to increase the max value.

For Checking Run the below query



SQL> select FND_CONCURRENT_PROCESSES_S.nextval from dual;

select FND_CONCURRENT_PROCESSES_S.nextval from dual
*
ERROR at line 1:
ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and
cannot be instantiated



Increase max value Of APPLSYS.FND_CONCURRENT_PROCESSES_S

SQL> ALTER SEQUENCE APPLSYS.FND_CONCURRENT_PROCESSES_S MAXVALUE 99999999;

Sequence altered.

How to check online FND_USERS - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/08/how-to-check-online-fndusers-in-oracle.html

How to check online FND_USERS

SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != ‘Y’
AND icx.pseudo_flag = ‘N’
AND ( last_connect
+ DECODE (fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’),
NULL, limit_time,
0, limit_time,
fnd_profile.VALUE (‘ICX_SESSION_TIMEOUT’) / 60
)
/ 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-make-your-user-and-sysadmin-to.html

How to make your USER and SYSADMIN to view all Concurrent Requests. Other Users can see only their Requests

Suggested you enable those standard grants for fnd_concurrent_requests and create a new role and then assign to your USER and SYSADMIN. Please check below steps for details.


Using the Functional Developer Responsibility, type Code as "FND_CONCURRENT_REQUESTS"

1. End_dating the following grants

DEFAULT_ACCESS_VIEWREQ
ECO Implementation Concurrent Request Grant
XDO Concurrent Request Security
IPM System Administration Concurrent Requests Grant

2. Create a new roles and assign to your USER and SYSADMIN

1. As SYSADMIN user with “Functional Developer” responsibility, update object "Concurrent Requests".

Search for object Concurrent Requests.
Click on Concurrent Requests.
Click on Object Instance Sets tab.
Click on Create Instance Set button.
Enter Name, Code and Description for new instance set.
- Enter the following for predicate:
1=1


2.As the SYSADMIN user with “User Management”, go to Roles and Role Inheritance tab.

Click Create Role button
Input value for the following column
Application,Role Code.Display Name,Description
Click Apply button

then query the role you created just now,,click update icon.
click Create Grant button,Input value for the following column
Name,Description

For the Data Security Object enter “Concurrent Requests”.
Click Next and provide the Data Content Type of “Instance Set”.
for Instance Set choose instance set created in step #1
Click Next
The permission Set is “Request Operations”.
Click next and finish button

3. As the SYSADMIN user with “User Management”, go to Users

Under Search region,query user name your USER
click update icon,click Assign Roles button
Query the role which you created in step 2
click apply

Same steps for user SYSADMIN

4.Wait some mins (10-15mins) to make workflow Angent listener to proceed it
then retest your issue.

How to stop users to see specific Requests of any other user - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2017/07/how-to-stop-users-to-see-specific.html

How to stop users to see specific Requests of any other user

Navigation: View>Requests>Find>Find Requests>Specific Requests> (Now here I can see any user Request. How can I stop User to access this)

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

1- Login as sysadmin ->functional developer.
2- Search for object Concurrent Requests.
3- Click on Concurrent Requests (link in the left cell)
4- Select the grants tab, click update.
5- Select the grants tab (again)
6- Update the "valid to " with the same date of the "valid from" for all records.
7- Click apply and retest the issue.

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

For My Case:

1. Login as functional administrator.
2. Search for object Concurrent Requests.
3. For both XDO Concurrent Request Security click on Update and in Grantee Type select Specific User and select one user you want to allow to see all Users Requests (for my case it was Administrator User). one should be given access to view all requests of Users.

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

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