Where does STAT get the schema password for the non-APPS schemas in the Generation Schema dropdown list? I have different passwords for non-prod and prod schemas but don't see anywhere to specify these different passwords.
Passwords are stored in Oracle.
This is the sql that we call:
SELECT DECODE(a.application_short_name,
'SQLAP', 'AP', 'SQLGL', 'GL', 'OFA', 'FA', a.application_short_name),
fnd_web_sec.get_op_value(o.oracle_username, 'appsapps') oracle_password
FROM fnd_application a,
fnd_application_tl t,
fnd_product_installations p,
fnd_oracle_userid o
WHERE a.application_id = p.application_id
AND a.application_id = t.application_id
AND p.oracle_id = o.oracle_id
AND t.language = 'US'
AND p.status IN ('I','L','S')
AND a.application_short_name NOT IN ('SYSADMIN')
Where ‘appsapps’ is the APPS password.
