ORA-12838: cannot read/modify an object after modifying it in parallel

User try to open PO period, users got the error ORA-12838: cannot read/modify an object after modifying it
in parallel.

system error : Bug 28039754 : OPEN PERIOD ERROR ORA-12838

PROBLEM STATEMENT
=================
Open period first period of 2018 Error :
gl_summary_account_types_pkg.update_account_types() 
SHRD0114: Executing Pro*C statement Update acct type...

SHRD0043: ERROR: ORA-12838: cannot read/modify an object after modifying it
in parallel

Solution:  

1. make sure gl.gl_code_combinations is not parallel.

2.  Make sure your GL period is open.

3. finally open the PO period.

Workflow diagram unable to view

Please make sure your Java certificate up to date.
$OA_JRE_TOP

How to check the cluster Verification

./crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

OACore ORacle Doc

12.2 E-Business Suite Slow Performance Navigating Through (OA Framework) Web Pages (Doc ID 1967444.1)

Oracle E-Business Suite (12.2) AccessGate Sizing and Performance Guidelines (Doc ID 1963114.1)

Oracle E-Business Suite (12.1.3) AccessGate Sizing and Performance Guidelines (Doc ID 2091889.1)

EBS 12.2 Oacore JVMs Getting Into Warning State Because Of STUCK Threads (Doc ID 2061045.1)

12.2: OACore Process Consuming High CPU With Leaked Connections (Doc ID 2331647.1)

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

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

Safe repair/reinstall of the JVM Component in 11.2 and up (Doc ID 2314363.1)

Latest Java SE Patch Updates on MOS (Doc ID 1414485.1)

Cloud update

Getting Started with Oracle E-Business Suite on Oracle Cloud (Doc ID 2066260.1)

Resolves Very Long Time to Apply Patches (WLS)

Enhancement for WLS BSU (Smart Update): Resolves Very Long Time to Apply Patches - Especially When Checking for Patch Conflicts (Doc ID 2271366.1)

Java.lang.OutOfMemoryError: GC

Weblogic 10.3.6 Patching Error Using BSU - "java.lang.OutOfMemoryError: GC overhead limit exceeded" (Doc ID 2007492.1)

Online Patching Enablement Patch 13543062 Fails With Error ORA-44305: Service Ebs_patch Is Running (Doc ID 1917886.1)

How to resolve ADOP error  ORA-44305 error.

sqlplus '/as sysdba'
exec dbms_service.STOP_SERVICE('ebs_patch');

TNS-12546,TNS-12560,TNS-00516 Solaris Error: 13: Permission denied

TNS-12546: TNS:permission denied

TNS-12560: TNS:protocol adapter error

  TNS-00516: Permission denied

   Solaris Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

Go to this hidden directory /var/tmp/.oracle

touch a

touch: cannot create a: Permission denied. After read and write permission to this directory to /var/tmp/.oracle

Then listener able to start...

LSNRCTL>  start SID

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "SID" has 1 instance(s).

  Instance "SID", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully