How To Run The Workflow Directory Services Concurrent Program From The SQLplus Prompt (Doc ID 1213304.1)

E-Business Suite Workflow Suggested Parameters For "Workflow Directory Services User/Role Validation" Program To Synchronize The Roles Assigned To Users (Doc ID 418765.1)

Oracle Performance

https://blogs.oracle.com/ebstech/advanced-compression

Performance Diagnosis with Automatic Workload Repository (AWR) (Doc ID 1674086.1)

Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 Advanced Row Compression (Doc ID 2458161.1)

Using Database Partitioning with Oracle E-Business Suite (Doc ID 554539.1)

EBS 12.2.9

https://blogs.oracle.com/ebstech/oracle-e-business-suite-1229-now-available

Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)

Statement Generation Program (ARXSGP): Known Issues, Patches and Enhancement Requests (Doc ID 1352529.1)

ARXSGP

ORA-1422 exact fetch returns more than requested number of rows

Please follow the doc. 

OPTIMIZER_SECURE_VIEW_MERGING. If this is set to TRUE and you are encountering this error, try setting it to FALSE and re-test.


After Make it FALSE. ORA-1422 went away.

Script to Diagnose adop

Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1)

12.2 E-Business Suite Applications DBA Online ADOP Utility Fs_clone Fails With "ERROR: Number of servers are not in sync

Oracle doc  between Run and Patch Context" (Doc ID 1582473.1)


SELECT  extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='run'
and CTX_TYPE = 'A';


SELECT  extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='patch'
and CTX_TYPE = 'A';

Mitigate the SSLv3 Vulnerability ("POODLE Attack") in Oracle E-Business Suite

For Release 12.2.X, you do not add the configuration to a customized AutoConfig template. Instead, 12.2.X customers must modify the ssl.conf file using the Oracle Fusion Middleware console using the steps below:

Log in to the Oracle Fusion Middleware Control Console (http://.:/em). For example, http://ebs122.example.com:7001/em.
Select the web tier target under the EBS domain.
Select Administration > Advanced Configuration.
Select the ssl.conf file for edit.
Update the SSLProtocol entry to match the following:
SSLProtocol all -SSLv2 -SSLv3
SSLCipherSuite HIGH:MEDIUM:!aNULL:!RC4:!3DES:+HIGH:+MEDIUM
Click Apply.

1. Edit the admin.conf file (for Oracle E-Business Suite Release 12.2 only).
   Change:
   
   SSLCipherSuite SSL_RSA_WITH_RC4_128_SHA
SSLProtocol nzos_Version_1_0 nzos_Version_3_0
    to
   
   SSLCipherSuite :
SSLProtocol nzos_Version_1_0
   
   For example:
   
   SSLCipherSuite SSL_RSA_WITH_AES_128_CBC_SHA
SSLProtocol nzos_Version_1_0
    

AS per oracle document  Doc ID 1937646.1