April 2019 CPU, the WLS connection filter is turned on by default.

As of the April 2019 CPU, the WLS connection filter is turned on by default. You will not be able to access the Oracle WebLogic Admin Server ports if you do not perform the instructions in "Managing Configuration of Web Application Services" of the Oracle E-Business Suite Setup Guideand the supplemental information in Document 2542826.1, Alternative Methods to Allow Access to Oracle WebLogic Server Administration Ports from Trusted Hosts for Oracle E-Business Suite Release 12.2.

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';