Home » Applications » Oracle Fusion Apps & E-Business Suite » R12: Copy a business group with org structures, setups, metadata & data in same OA instance (Oracle E-Business Suite, R12.1.x, Any platform)
R12: Copy a business group with org structures, setups, metadata & data in same OA instance [message #538524] Fri, 06 January 2012 12:29 Go to next message
soudhara
Messages: 7
Registered: November 2005
Location: Kolkata, India
Junior Member

The idea was born out of a very common requirement across IT companies. Pre-Sales and pro-sales groups do various tasks including RPF/RFI response, PoC building, Solution architecting, customer demo etc. Ususally they don't have dedicated Apps instances, or rather they don't find adequate number of dedicated Apps instances for deep drive study. Every alternate day one group shouts out for an Apps instance and the same gets escalated to higher management in short time. It gives much pain to infrastructure/DBA groups as they fail to cater to people like them, because of limited availability of free nodes, resources, networks, disk space etc.

Say I have a full-fledged R12.1.3 Vision (say SID=VIS1213) installed in a Linux box. The box is quite occupied with limited cores, showing low free memory and the attached SAN has insufficient free space remaining. A group of Oracle Apps Pre-Sales consultants, say 'Group-1', is using this.

Now 3 different other groups ask for a R12.1.3 Vision instance separately for below reasons. Each of them wants the instance afresh, and not to be shared with others.

Group-2 for deep drive study against a critical RFP response
Group-3 for developing a PoC for a customer demo
Group-4 for making UPK recording materials on few business processes

In this scenario, I should either install 3 distinct R12.1.3 Vision (using CDs or downloaded zips) or clone VIS1213 to 3 different places with different SIDs, possibly on one or more separate nodes (as above Linux node doesn't have sufficient free resources). In that case, the need for available server resources and disk space get multiplied by 3, whereas DBA maintenance for these 3 new instances is added.

Hope I sound clear up to this stage.

Then I was thinking if we can have 'virtual instances' within an existing Apps instance, by copying from a certain org level. Initially I thought of taking from LE level, but that will not work if a group demands instance to work with HRMS. So we need to take from business group level. After that we will create appropriate role, responsibility, profile options and user so that the new user can see and work on new BG and downward data area only. It will be like a separate instance for use.
Benefits of my desired task will be

- no separate server, resource, network required
- no extra DBA maintenance involved
- no separate backup plan required

So here it is to create 3 new 'virtual instances' right within the same VIS1213 instance. New groups will be given same existing access URL and same existing TNS details but 3 different user credentials. Each of them would be confined in such a way so that they cannot see each other's data and cannot harm each other's changes.

This can be achieved if we can copy an existing entire business group with org structures, metadata and data, within same instance. Oralce iSetup cannot copy setups within same instance.

What I did so far was I manually created a new BG, attached an existing SoB (CoA, Calendar & Currency), created a new LE, copied and modified accounting structure flexfields before attachment, created new OU and then a new master InvOrg and a new chlild InvOrg, set MO profile, few GL and HR profiles. Then I extracted Item master and Item Category assignment master data against an existing master/child InvOrg, updated the data for newly created InvOrgs, inserted into insterface tables and ran item import seeded conc program. Except few, all data were loaded in base tables against new InvOrgs.

Next I tried with Supplier master (with sites and contacts). Few AP setups were required and then Supplier (+site+contact) data were loaded in base tables against newly created OU (under new BG).

I did not proceed after that. I am currently looking for OA experts' ideas on how to proceed further and what will be other easier ways to achieve that.

Am I clear at this stage? Pl revert back.

Thanks & Regards,
Souvik.
Email: souvik.dhara@tcs.com
Re: R12: Copy a business group with org structures, setups, metadata & data in same OA instance [message #538563 is a reply to message #538524] Sat, 07 January 2012 02:53 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that your message fits better into Oracle Apps. forum than Marketplace one (as you don't sell, buy, hire or similar). Would you want it to be moved there? If so, either reply here or report this message to a moderator and it'll be done.
Re: R12: Copy a business group with org structures, setups, metadata & data in same OA instance [message #538571 is a reply to message #538524] Sat, 07 January 2012 04:22 Go to previous messageGo to next message
John Watson
Messages: 4693
Registered: January 2010
Location: Global Village
Senior Member
Have you looked at using Amazon EC2 cloud servers instead of trying to run your own hardware? They cost only a few cents per hour of use, cost nothing when you aren't actually using them. Install and configure EBS once, save the image, and then spin up as many copies as you want. It's good technology.
Re: R12: Copy a business group with org structures, setups, metadata & data in same OA instance [message #538682 is a reply to message #538563] Sun, 08 January 2012 23:56 Go to previous messageGo to next message
soudhara
Messages: 7
Registered: November 2005
Location: Kolkata, India
Junior Member

I have already reported to Moderator, as you asvised.

Thanks,
Souvik
Re: R12: Copy a business group with org structures, setups, metadata & data in same OA instance [message #538683 is a reply to message #538571] Sun, 08 January 2012 23:58 Go to previous message
soudhara
Messages: 7
Registered: November 2005
Location: Kolkata, India
Junior Member

I will explore what you advised. Thanks.

But for now I need experts' views on whether my idea sounds good and practical and if so what may be ideal path to achieve.

Thanks,
Souvik
Previous Topic: Disable the Delete Button
Next Topic: Shared Status in Oracle License Manager
Goto Forum:
  


Current Time: Fri Oct 24 20:55:27 CDT 2014

Total time taken to generate the page: 0.13657 seconds