Here are some important questions and queries for oracle EBS password expiration, password complexity, profiles options How to Stop the Force Password Reset on Creation of User Account in Oracle EBS When a new EBS user is created, the User is supposed to change the password of the account upon the first login. There are […]
Useful Queries on oracle EBS password expiration/Policy/Settings Read More »
In this post, we will be checking, How to change the TDE Keystore Password in Oracle, How to validate the TDE wallet password How to change TDE Keystore Password in Oracle Here are the steps to change TDE Keystore Password Rename the auto-login wallet file cwallet.sso in the wallet location $ mv cwallet.sso cwallet.sso_old Close
How to change/validate TDE Keystore Password Read More »
In this post, we will check about Query to check character set in oracle, What is Database Character set What is Database Character set? Oracle Database uses character sets for the following: Data stored in SQL character data types (CHAR, VARCHAR2, CLOB, and LONG). Identifiers include table names, column names, and PL/SQL variables. Stored SQL
Query to check character set in oracle Read More »
Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see how to check the Package version in EBS R12 Sometimes, we
How to check Package version in EBS R12 Read More »
R12.2 is the latest Release of Oracle E-business Suite Products. Here, we will be discussing the Login flow in R12.2 and how to troubleshoot login issues in R12.2 Login flow in R12.2 Here is the processing in terms of URL(Login HTTP headers) When the EBS login works OK, the browser will be redirected to various
Login flow in R12.2 and basic troubleshooting Read More »
Here are a few troubleshooting tips for ADOP failures in R12.2 How to set service ebs_patch in R12.2 While running the adop phase=prepare, we receive the below error [ERROR] Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) Need to check for service in the listener
Troubleshooting ADOP failures in R12.2 Read More »
