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.