Friday, June 28, 2024

Query To Get Apps User Password From Backend In EBS R12

Query To Get Apps User Password From Backend In EBS R12

ALTER SESSION SET current_schema = apps;

Select ( Select XX_ Get_User_Pwd.Decrypt (Fnd_Web_Sec.Get_Guest_Username_Pwd, Usertable.Encrypted_Foundation_Password) From Dual) As Apps_Password From Fnd_User Usertable Where Usertable.User_Name Like ( Select Substr (Fnd_Web_Sec.Get_Guest_Username_Pwd ,1, Instr (Fnd_Web_Sec.Get_Guest_Username_Pwd, '/') - 1) From Dual);

No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...