Please, go back closer to your dev team to get more information. If you don't know what you need to do, how can we know from the other side of the network ?
However, I suspect you need to configure nodes between two different applications, and yes, that has something to do with the IB.
You can find some information in the Peoplebooks available online :
http://download.oracle.com/docs/cd/E13292_01/pt849pbr0/eng/psbooks/tibr/book.htm?File=tibr/htm/tibr03.htm#H3002

Nicolas.

Julie,

What are you trying to achieve ? Messaging between application ? What Peopletools version ? Did you defined nodes ?
Please, give us more details.

Nicolas.

And if you have flashback enabled on the database, if anything catastrophic occurred during the upgrade, you could flash the whole database back to the point where you started to apply this script. 

Of course, you want the script to go right first time, this is another safety net.

 

---

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Nicolas Gasparotto
Sent: Friday, December 04, 2009 12:40 PM
To: psftdba@yahoogroups.com
Subject: Re: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

Forget to say, yes, you should connect as SYSADM to run the script, assuming this is your Peoplesoft objects' owner.

Nicolas.

On Fri, Dec 4, 2009 at 1:36 PM, Nicolas Gasparotto <nicolas.gasparotto@...> wrote:

Julie, nice you posted screenshots, it is very clear about what you did.
Yes, you can go ahead to run the script against your database. The "drop table" statements are very standard in Peoplesoft world, it is how Peoplesoft is modifying table structure : it is first create a "temporary" table (stage table) based on source with all the required modifications, load it from the source table (directly within an INSERT statement or through a PL/SQL script), drop the source table and finally rename the "temporary" table like the source table.
And yes, better to log everything out when running such script.

If you're really afraid, you could add the following on top of the generated script :
WHENEVER SQLERROR EXIT;   
That'll exit if any error are reported, and stop running the script further.
On recent Oracle database you also have the recyclebin to recover a dropped table if problems are issued.

Nicolas.

 

On Fri, Dec 4, 2009 at 12:28 PM, Wynne, Julie <J.Wynne@...> wrote:

 

Hi

 

We’re all new to peoplesoft here (we’ve previously used Oracle E-Business Suite and Campus Solutions is replacing their student system for us.)  Some of the developers have done a bit more with App designer than I have , but they don’t know anything about bundles.  As DBA, I’ve always been responsible for applying patches to the E-business suite environments, and the decision was that I and my 2 fellow DBAs would have similar responsibility for Peoplesoft bundles.    The project team are investigating integration between Campus Solutions and the UCAS central admissions systems, and they need new functionality in bundle 14 for that, so I’ve been tasked with applying it to our CSUCAS test environment.   The previous bundles I’ve worked with didn’t have any recreate table steps, hence this is new to me. 

 

Anyway, I got all brave and loaded up App Designer , set it to my test environment and created a new project as suggested by Nicolas.  I then did the following

Insert ->Definitions Into Project.

 

 

I went through all the records in the list and clicked insert for each one of them.   I then found Build->Settings on the menu and set the options as follows.

 

I then went into Build->Project and saw the following window.   I clicked the Create tables box and build script file.

 

Then I clicked the build button, confirmed that I wanted to go ahead, and it came back with

The script contains lots of drop and create statements.   A little worrying as it doesn’t seem to be backing anything up that might already be in those tables. (we are not using any of the HR functionality, but maybe those tables are shared with Campus Solutions?)

 

So, can I now just load up SQL Plus against my Oracle db and run this script?   Do I log in to the database as SYSADM ?  Or something else ?

 

Sorry for all the newbie questions and thanks for all your help guys – it’s a relief to know there’s someone out there J

 

Thanks

Julie

 

 

 

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Wynne, Julie
Sent: 04 December 2009 10:51
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

 

Thanks Nicolas – however – please see my response to Duncan – I’m a total newbie at this – I’m not sure I know what you mean by ‘insert these records into a project’ ?

 

Julie

 

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Nicolas Gasparotto
Sent: 04 December 2009 10:24
To: psftdba@yahoogroups.com
Subject: Re: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

 

Open AppDesigner, insert these records into a project, build the project following the given settings. Then build the project, run the SQL in SQL*Plus (for Oracle db), then check the step as completed, and restart the upgrade job.

Nicolas.

On Fri, Dec 4, 2009 at 11:01 AM, Wynne, Julie <J.Wynne@...> wrote:

Hi

I’m new to Peoplesoft administration, and have only ever applied bundles with an experienced consultant sitting at my shoulder.  I’ve not yet done the Data Management and upgrade training either.  However, I’ve been asked to apply Campus Solutions Bundle 14 to one of our test environments.  This has a prerequisite of HR Bundle 8.  I managed to configure Change Assistant and the EM Hub , start the necessary agents etc and get the bundle started. It has got part way through and come to a manual stop entitled Recreate Tables, and now I am stuck.  It lists a whole load of tables (listed below) but there no further instructions in the documentation that I can identify, and I don’t know what to do next. 

This is holding up our project so really need advice quickly please.

All suggestions appreciated

Thanks in advance

Julie

Recreate the following tables:

WCB_IWJO_EC

WCB_IWJO_WD

WCB_EDSR_EC

WCB_EDSR_WD

WCB_EERE_EC

WCB_EERE_WD

WCB_ERLC_EC

WCB_ERLC_WD

WCB_ERLO_EC

WCB_ERPT_EC

WCB_IWLE_EC

WCB_IWLE_WD

WCB_WOIN_EC

WCB_WOIN_WD

HS_RPT_HIST_CAN

Build options for Create 'Tables'

- 'Recreate table if it already exists',

- 'Recreate index if it already exists':

 

 

 

 

Julie,
 
With all due respect, you really shouldn't be doing any kind of upgrade if you don't completely know what you're doing; that HOW THINGS GO BAD in an unrecoverable manner (as in no one finds out until it's too late to rollback).
 
At a minimum, you need a class in App Designer I and II (a real class not a CBT) and the install and upgrade class.  (You should get theses before you continue; stress to management how important they are)  You'll find a wealth of knowledge and experience here, but we're not PS instructors.  Additionally, if you want support from PeopleSoft, the person performing the upgrade (aka you) will need to be able to speak clearly and with knowledge to the person on the other end of the phone.
 
The good news is you probably know most of what you will need to know to grow into a competant PS Admin.
 
Good Luck, and may the force be with you.
 
peace,
clark 'the dragon' willis

PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only
you can determine how it will be spent. Be careful lest you let other
people spend it for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo
Religion is regarded by the common people as true, by the wise as false, and
by the rulers as useful. -- Seneca

"I distrust those people who know so well what God wants them to do because
I notice it always coincides with their own desires." - Susan B. Anthony
 
"Does religion calm your fears of death?" "No, but death will calm my fear
of religions."

 
NOTICE:  The information contained in this message is protected under United
States and international copyright laws and is intended for the personal and
confidential use of the addressee.  If you are not the addressee or an agent
of the addressee, you are hereby notified that you have received this
message in error and that any review, dissemination, distribution, taking of
any action in reliance upon or copying of this message without the express
written permission of the sender or his agent is strictly prohibited and in
violation of referenced statutes.  If you have received this message in
error, please notify me (the sender) immediately and you are instructed to
delete this message from any computer it resides on, including mail servers.

SIGNATURE :
Do not meddle in the affairs of dragons, for you are crunchy and taste good
with ketchup.
You've got to be a Spirit; don't need no Ghosts.
Do or Do Not; There is NO Try.
Any clod can have facts, but having an opinion is an art !
A conclusion is simply the place where someone got tired of thinking.
When a continuing state of defiance and disorder can not be checked by the
rules, then new and sometimes drastic rules must be forged to maintain
order; the alternative is anarchy.
M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@...
aolim:ceprn ICQ 6633136

Help stamp out SPAM!! http://www.cauce.org
The senders of unsolicited commercial e-mail to me at any site are liable
for a $500 per message cost under USC 47, which may be found at
http://www.law.cornell.edu/uscode/47

Contents of this message, in it's entirety, (c) 2000 - 2009
M. Clark Willis III / Dragon Enterprises inc.  All rights reserved.

 

Windows Live™ Hotmail is faster and more secure than ever. Learn more.

And if you have flashback enabled on the database, if anything catastrophic occurred during the upgrade, you could flash the whole database back to the point where you started to apply this script. 

Of course, you want the script to go right first time, this is another safety net.

 

---

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Nicolas Gasparotto
Sent: Friday, December 04, 2009 12:40 PM
To: psftdba@yahoogroups.com
Subject: Re: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

Forget to say, yes, you should connect as SYSADM to run the script, assuming this is your Peoplesoft objects' owner.

Nicolas.

On Fri, Dec 4, 2009 at 1:36 PM, Nicolas Gasparotto <nicolas.gasparotto@...> wrote:

Julie, nice you posted screenshots, it is very clear about what you did.
Yes, you can go ahead to run the script against your database. The "drop table" statements are very standard in Peoplesoft world, it is how Peoplesoft is modifying table structure : it is first create a "temporary" table (stage table) based on source with all the required modifications, load it from the source table (directly within an INSERT statement or through a PL/SQL script), drop the source table and finally rename the "temporary" table like the source table.
And yes, better to log everything out when running such script.

If you're really afraid, you could add the following on top of the generated script :
WHENEVER SQLERROR EXIT;   
That'll exit if any error are reported, and stop running the script further.
On recent Oracle database you also have the recyclebin to recover a dropped table if problems are issued.

Nicolas.

 

On Fri, Dec 4, 2009 at 12:28 PM, Wynne, Julie <J.Wynne@...> wrote:

 

Hi

 

We’re all new to peoplesoft here (we’ve previously used Oracle E-Business Suite and Campus Solutions is replacing their student system for us.)  Some of the developers have done a bit more with App designer than I have , but they don’t know anything about bundles.  As DBA, I’ve always been responsible for applying patches to the E-business suite environments, and the decision was that I and my 2 fellow DBAs would have similar responsibility for Peoplesoft bundles.    The project team are investigating integration between Campus Solutions and the UCAS central admissions systems, and they need new functionality in bundle 14 for that, so I’ve been tasked with applying it to our CSUCAS test environment.   The previous bundles I’ve worked with didn’t have any recreate table steps, hence this is new to me. 

 

Anyway, I got all brave and loaded up App Designer , set it to my test environment and created a new project as suggested by Nicolas.  I then did the following

Insert ->Definitions Into Project.

 

 

I went through all the records in the list and clicked insert for each one of them.   I then found Build->Settings on the menu and set the options as follows.

 

I then went into Build->Project and saw the following window.   I clicked the Create tables box and build script file.

 

Then I clicked the build button, confirmed that I wanted to go ahead, and it came back with

The script contains lots of drop and create statements.   A little worrying as it doesn’t seem to be backing anything up that might already be in those tables. (we are not using any of the HR functionality, but maybe those tables are shared with Campus Solutions?)

 

So, can I now just load up SQL Plus against my Oracle db and run this script?   Do I log in to the database as SYSADM ?  Or something else ?

 

Sorry for all the newbie questions and thanks for all your help guys – it’s a relief to know there’s someone out there J

 

Thanks

Julie

 

 

 

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Wynne, Julie
Sent: 04 December 2009 10:51
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

 

Thanks Nicolas – however – please see my response to Duncan – I’m a total newbie at this – I’m not sure I know what you mean by ‘insert these records into a project’ ?

 

Julie

 

From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com] On Behalf Of Nicolas Gasparotto
Sent: 04 December 2009 10:24
To: psftdba@yahoogroups.com
Subject: Re: PeopleSoft DBA Forum Urgent newbie question - Manual stop in HR Bundle 8 - recreate tables?

 

Open AppDesigner, insert these records into a project, build the project following the given settings. Then build the project, run the SQL in SQL*Plus (for Oracle db), then check the step as completed, and restart the upgrade job.

Nicolas.

On Fri, Dec 4, 2009 at 11:01 AM, Wynne, Julie <J.Wynne@...> wrote:

Hi

I’m new to Peoplesoft administration, and have only ever applied bundles with an experienced consultant sitting at my shoulder.  I’ve not yet done the Data Management and upgrade training either.  However, I’ve been asked to apply Campus Solutions Bundle 14 to one of our test environments.  This has a prerequisite of HR Bundle 8.  I managed to configure Change Assistant and the EM Hub , start the necessary agents etc and get the bundle started. It has got part way through and come to a manual stop entitled Recreate Tables, and now I am stuck.  It lists a whole load of tables (listed below) but there no further instructions in the documentation that I can identify, and I don’t know what to do next. 

This is holding up our project so really need advice quickly please.

All suggestions appreciated

Thanks in advance

Julie

Recreate the following tables:

WCB_IWJO_EC

WCB_IWJO_WD

WCB_EDSR_EC

WCB_EDSR_WD

WCB_EERE_EC

WCB_EERE_WD

WCB_ERLC_EC

WCB_ERLC_WD

WCB_ERLO_EC

WCB_ERPT_EC

WCB_IWLE_EC

WCB_IWLE_WD

WCB_WOIN_EC

WCB_WOIN_WD

HS_RPT_HIST_CAN

Build options for Create 'Tables'

- 'Recreate table if it already exists',

- 'Recreate index if it already exists':

 

 

 

 

Open AppDesigner, insert these records into a project, build the project following the given settings. Then build the project, run the SQL in SQL*Plus (for Oracle db), then check the step as completed, and restart the upgrade job.

Nicolas.