After Migrating to AIX using TDB, Fnd_security_pkg.fnd_encrypted_pwd Takes 31 Seconds
(Doc ID 3077388.1)
Last updated on MARCH 23, 2025
Applies to:
Oracle Application Object Library - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, AOL function/data security
EBS 12.1.3 on HP-UX has migrated to AIX 7.2 using Transportable Database.
While logging in, elapse time of fnd_security_pkg.fnd_encrypted_pwd took 31.21 seconds on average.
Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text
------------------- ------------- ----------------------------- -------- ------ ---------- ----------------- ------------------------------------- -----------------------------------------------------
80,208.41 2,570 31.21 25.91 25.24 0.00. gj1mbaw0hyzru JDBC Thin Client BEGIN fnd_security_pkg.fnd_enc...
13,152.16 337 39.03 4.25 26.17 0.01 01ctp57ttdg62 frmweb@LGDAERP3 (TNS V1-V3) begin FND_SECURITY_PKG.FND_ENC...
5,653.70 566 9.99 1.83 26.80 0.00 dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida.. .
.....
Changes
EBS 12.1.3 on HP-UX has migrated to AIX 7.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |