**Starts**24-JAN-2013 19:00:50The error indicates that you have locks in the database.
ORACLE error 4021 in FDPSTP
Cause: FDPSTP failed due to ORA-04021: timeout occurred while waiting to lock object
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HR_MULTI_TENANT_INSTALL"
ORA-06512: at line 1
I tried the same concurrent request again,its completed successfully and All child processes getting normal completion status.Because there were no locks at this time.
My query is, this is the process of enabling mullti-tenancy,so can i conclude enabling multitenancy process is in sucesses way.Yes -- Assuming that is the only step you need to follow/implement.
900076 wrote:Correct -- Oracle HRMS Multi-Tenant Functionality - An Oracle White Paper [ID 760500.1]
Thanks for your prompt responce and advising me.
and one more is in the reference document,they mentioned script $PER_TOP/patch/115/sql/ peupdlbl.sql need to run as post requisite.
But in that location script is not there, is it comes with any patch ?What is your application release?
Any idea,really appreciate
900076 wrote:Please see (Bug 9955377 : NEED $PER_TOP/PATCH/115/SQL/PEUPDLBL.SQL FILE FOR 12.1.1) -- As per the bug, this script appears to only be available on 12.1.2 (and above). So, please log a SR and ask Oracle support for a patch that would deliver this script and can be applied on top of 12.1.1
Applicaton Release : 12.1.1 with 220.127.116.11 DB
OS : RHEL 5.3 x86_64