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