procedure voor initial load Gotli  with BI already fully installed.
0) search and replace all 'ABS' in this document with with 'XXX'   where XXX is your customer code.


1) with PL/SQL Developer: disable jobs in Oracle

begin
dbms_scheduler.disable('LOAD_GLOBE4_FACTS_JOB');
dbms_scheduler.disable('LOAD_GLOBE4_DIMS_JOB');
dbms_scheduler.disable('GLOBE4_UPDATE_TIME_JOB');
end;
/


2) with PgAdmin: Install views
Create_Globe_DWH_Views_phase1and2.sql

3) with PgAdmin: check global_company_id
select * from company 
delete duplicates if there are 

4) with PL/SQL Developer: install new view for punches and new globe4_update_time procedure:
globe4_fact_v_time_punches.sql
GLOBE4_UPDATE_TIME.prc

5)create globe4_settings
insert into globe4_database_settings(database_code,database_link_name) values('ABS','GLOBE4');
commit;

select * from globe4_database_settings;

update settings s set s.laundrycode = 'ABS';
commit;

6) script for recreating program + job for facts: 
first drop program LOAD_GLOBE4_FACTS_PROG;
first drop job 

begin
dbms_scheduler.create_program
(
program_name=>'LOAD_GLOBE4_FACTS_PROG',
program_action=>'ABSDATAWAREHOUSE.LOAD_GLOBE4_FACTS.MAIN',
program_type=>'STORED_PROCEDURE',
number_of_arguments=>1, enabled=>FALSE
) ;

dbms_scheduler.DEFINE_PROGRAM_ARGUMENT(
program_name=>'LOAD_GLOBE4_FACTS_PROG',
argument_position=>1,
argument_name=>'databasecode',
argument_type=>'VARCHAR2',
DEFAULT_VALUE=>'ABS');

dbms_scheduler.enable('LOAD_GLOBE4_FACTS_PROG');
end;
/

begin
dbms_scheduler.create_job('LOAD_GLOBE4_FACTS_JOB',program_name=>'LOAD_GLOBE4_FACTS_PROG',start_date =>'16-APR-2020 10:00:00 AM',repeat_interval=>'FREQ=MINUTELY; BYSECOND=10',enabled=>FALSE);
dbms_scheduler.set_job_argument_value('LOAD_GLOBE4_FACTS_JOB','databasecode','ABS');  -- TODO Replace ABS by database code 
END;
/

7) script for setting customer code 
begin
  sys.dbms_scheduler.set_job_argument_value(job_name       => 'ABSDATAWAREHOUSE.GLOBE4_UPDATE_TIME_JOB',
                                            argument_name  => 'databasecode',
                                            argument_value => 'ABS');
end;
/


8) execute:  time generation
begin
  load_globe4_date_and_time_dims.main;
end;

9) run dimension load.
begin
  load_globe4_date_and_time_dims.main;
end;
/


10) check / set timezone offset
select * from business_unit


11) run facts load (when not too many rows) 
begin
    LOAD_GLOBE4_FACTS.MAIN('ABS');
end;
/

12)
begin
  GLOBE4_UPDATE_TIME('ABS');
end;
/

13) enable jobs

begin
dbms_scheduler.enable('LOAD_GLOBE4_FACTS_JOB');
dbms_scheduler.enable('LOAD_GLOBE4_DIMS_JOB');
dbms_scheduler.enable('GLOBE4_UPDATE_TIME_JOB');
end;
/