Wanted

1. How to create new subproject
2. how to setup Tool in application

First DB of Oracle

DB creation completed. see C:\oracle\admin\test\create\createdb.log for details.

DB Info:
global db name:test
db system identifier(SID): test
INTERNAL account password:
SYS account password: change_on_install
SYStem account password:manager

WO- New Main Menu on the top(ToyotaNet)

CMS:
1. New role for Trainingnet (SIBUser and SIBRole)
2. Dynamic Menu -- SIBDynMenuType ---- TrainingNet
3. Primary Section --- TrainingNet
4. Story type ---- TrainingNet, SIBStory – nameForTrainingNetNews setup the welcome story first.
5. TrainingNet title image SIBPCImagetype
6. From All main Page:
TrainingNet link - >TrainingNetMain - >Story Editor and DynMenu Editor

ToyotaNet:

0. P_NavBar, Application event
1. TechTrainingAuthorisedComponent
2. TechTrainingNetDA( secondary,mainmenu, sub, tertiary, story,storyList)
3. TechTrainingNavBar
4. TechTrainingMain(Home)
5. TrainingNetNewsDisplay and TrainingNetTertiaryMenuList

WO -SIBDB-BrainsDealer changed SQL

For some reason they (re)create new dealer, need run this sql for some data

select sibid, dealerid from csifile where dealerid=38168672570002 or dealerid=36427939879009;
update csifile set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, dealerid from RingAroundReportData where dealerid=38168672570002 or dealerid=36427939879009;
update RingAroundReportData set dealerid=38275357190830 where dealerid=38168672570002 or dealerid=36427939879009;

select sibid, brainsDealerCode, fullName, usercode from SIBUser where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update SIBUser set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;




select sibid, brainsDealerCode from DealerWiseLocation where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
update DealerWiseLocation set brainsDealerCode=38275357190830 where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;

select sibid, brainsDealerCode from LexusDealer where brainsDealerCode=38168672570002 or brainsDealerCode=36427939879009;
no change

Oracle INSERT data

damy PK for ID and EntityCode:

create procedure ba_dealerreportinitialdata is
ecnum number; yyy number; uniqueIDVar VARCHAR2(16);
BEGIN
select identifier into ecnum from private_entity_identifier where name='SIBDealerReportType'; yyy := 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'CSI Results');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'KPI Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'TCR Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'Benchmark Reports');
END;

begin ba_dealerreportinitialdata;
end;

drop procedure ba_dealerreportinitialdata;

WebObjects Blog

It took me age to fix this problem, so REMEMBER it.
In the EOModel, the PK in dealer table is Double number which is different from Integer Number.
So becarefully create FK, the best way is copy the PK and past to new table.