Posts Tagged ‘Oracle Apps’

Retrieve Forgotten Apps Password in Oracle EBS R12

February 20th, 2023, posted in Oracle Queries

I am going to share steps to retrieve the password in Oracle Apps.
But no guarantee that it will work on all EBS version. It was tested on R12.2.3.

Steps:

1: log in to the database server with sys user

sqlplus / as sysdba

2: Create Function to decrypt the encrypted password

SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2 AS LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String)
return java.lang.String’; /

3 : Query for Encrypted password

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

Output

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————– ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A

4: Past the Encrypted password from the above query output into the below query and execute

SELECT apps.decrypt_pin_func
(‘GUEST/ORACLE’,’ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A’)
from dual;

Output

APPS.DECRYPT_PIN_FUNC
(‘GUEST/ORACLE’,’ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A’)
——————————————————————————–
oracle123

5: Test apps password is working or not

SQL> conn apps/oralce123;
Connected.

read more no comments

What Is The Difference Between 11i And R12 In Oracle Apps

September 25th, 2022, posted in Oracle

11i
1) Consist of 3C
2) No concept of MOAC.
3) Major table changes like po_vendors.
4) Banks are created in Account Payables.
5) Ap_Invoices_lines_all table in finance is not there.

R12
1) Consist of 4C
2) Introduction of MOAC( Multi org access control)
3) Major table changes (Ap_suppliers)
4) Banks are created in Cash Management.
5) Subledger Accounting is not there.
5) Ap_invoices_lines_all is there.
6) Subledger Accounting is there.

read more no comments

PLSQL Error when trying to Log In ORA-12154 while TNS Is At Right Path

February 27th, 2022, posted in Oracle, Windows

PLSQL Error when trying to Log In ORA-12154 while TNS Is At Right Path,PLSQL Error,PLSQL Developer Error,TNS Error,Oracle APPS, APPS DBA

I’ve installed oracle server in my windows 11. The installation was successful and able to connect to server using PL SQL Developer client. I was getting the error ‘ORA 12154 TNS could not resolve the connect identifier specified’

The TNS entries are perfect and oracle home is set properly, but I couldn’t login. I’ve googled it and couldn’t find a solution. Finally I found the solution and it has worked for me. Thanks a lot to them.

There are sometimes two program files folder in Windows 11. one is ‘Program files‘ and other one is ‘Program Files(x86)‘.

While installing oracle I’ve selected ‘Program Files(x86)‘ as destination. That’ the reason for the error.

I’ve copied the ‘PLSQL Developer’ folder to the ‘Program Files’ folder and it has worked for me.

read more no comments

Workflow Notification Mailer Setup in Oracle Apps R12/12i

May 16th, 2021, posted in Oracle EBS Application

On popular demand from readers, I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i.
Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer)
* Previous version of Notification Mailer in 11i was based on C also called as C Mailer

Things To Note :
1. You use Oracle Application Manager (OAM) to configure Workflow Notification Mailer.
2. There are two kind of Notification (Outbound & Inbound) in Workflow Mailer
3. For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
4. For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
5. Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/FNDC*.txt
6. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)
7. If you don’t wish to send mail notification to end user (from Dev/Test instance) then configure Test Address in configuration screen.

Step to configure Workflow Notification Mailer :
1. Login to Apps R12 with System Administrator Reponsibility
2. under Workflow : Oracle Applications Manager click on Workflow Manager