Multiple (SYSADM) Schemas in a Peoplesoft Database
Date: Wed, 20 May 2009 22:12:10 +0800
I believe that Peoplesoft does allow multiple schemas (the default is
SYSADM, so the multiples could be SYSADM_1, SYSADM_2 etc) in a
single Oracle Database.
This could support seperate business units in one Oracle instance.
Has anyone implemented this in Production ? Particularly for Financials modules -- (GL, Payables, Assets)
(Currently, we do have multiple BUs in the single SYSADM schema but I
am asked to explore two options :
a. Seperate Database Instances
b. Seperate schemas in one Database Instance )
Hemant K ChitaleReceived on Wed May 20 2009 - 09:12:10 CDT