OCI function (python) to write data to Oracle EBS database
We are working on a high priority project that requires OCI function (python) to write data to Oracle EBS database. However, we are currently blocked by an error – "DPY-3015: password verifier type 0x939 is not supported by python-oracledb in thin mode"
Upon investigating, we found that the password version for the user is 10g and the parameter (sec_case_sensitive_logon) is set to FALSE which is why oracledb python module is throwing the above error.
Is it possible to set OCI_RW user password version to 12c even though the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER is set as 10 as a prerequisite for EBS 12.2