Steps to Load RCS Data manually in PPE
Step 1
Create a backup copy of “ GL_GMARGIN” table
create table gl_gmargin_250418 as
select * from gl_gmargin;
Step 2
Pull the RCS file from the RCS system and store it in BI4 in the path “exploit/arrive/tmp”
isis@solax025:/home/isis > su exploit
exploit's Password:
isis@solax025:/home/isis > eval $(ICleEnvService Premier_Economique@DW2_APP)
isis@solax025:/home/isis > cd /exploit/arrivee/tmp
isis@solax025:/exploit/arrivee/tmp > sftp wp1app07.ibm.be.solvay.com
exploit@wp1app07.ibm.be.solvay.com's password:
Connected to wp1app07.ibm.be.solvay.com.
sftp> cd /exploit/FA/data or /exploit/FA/archive
sftp> ls -ltr
Step 3
Modify the files (Rename the RCS files pulled in the “exploit/arrive/tmp by adding “.txt”)
As the files which are pulled from RCS does not have an extension ,
the file cannot be loaded through sql loader Without extension .
so we need to add an extension to the files.
Example
From the above example the highlighted one is the once we receive from RCS sytem,
And the one which is un marked is the modified one.
Step 4
, Start the load the integrate data:
Login UX4 and set up Environment :
Login isis
su exploit
eval $(ICleEnvService Premier_Economique@DEV3_APP)
*** in UNX7 the parameter will be different ****
Run the below loader scripts one by one to load all the files
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_3865.txt log=./load_W158001_3865.log bad=./bad_W158001_3865.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_3944.txt log=./load_W158001_3944.log bad=./bad_W158001_3944.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6059.txt log=./load_W158001_6059.log bad=./bad_W158001_6059.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6062.txt log=./load_W158001_6062.log bad=./bad_W158001_6062.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6068.txt log=./load_W158001_6068.log bad=./bad_W158001_6068.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6110.txt log=./load_W158001_6110.log bad=./bad_W158001_6110.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6111.txt log=./load_W158001_6111.log bad=./bad_W158001_6111.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6268.txt log=./load_W158001_6268.log bad=./bad_W158001_6268.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6297.txt log=./load_W158001_6297.log bad=./bad_W158001_6297.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6301.txt log=./load_W158001_6301.log bad=./bad_W158001_6301.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6322.txt log=./load_W158001_6322.log bad=./bad_W158001_6322.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6346.txt log=./load_W158001_6346.log bad=./bad_W158001_6346.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6348.txt log=./load_W158001_6348.log bad=./bad_W158001_6348.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6526.txt log=./load_W158001_6526.log bad=./bad_W158001_6526.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6577.txt log=./load_W158001_6577.log bad=./bad_W158001_6577.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6746.txt log=./load_W158001_6746.log bad=./bad_W158001_6746.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6811.txt log=./load_W158001_6811.log bad=./bad_W158001_6811.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6857.txt log=./load_W158001_6857.log bad=./bad_W158001_6857.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6859.txt log=./load_W158001_6859.log bad=./bad_W158001_6859.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6875.txt log=./load_W158001_6875.log bad=./bad_W158001_6875.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_6975.txt log=./load_W158001_6975.log bad=./bad_W158001_6975.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7008.txt log=./load_W158001_7008.log bad=./bad_W158001_7008.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7154.txt log=./load_W158001_7154.log bad=./bad_W158001_7154.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7405.txt log=./load_W158001_7405.log bad=./bad_W158001_7405.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7418.txt log=./load_W158001_7418.log bad=./bad_W158001_7418.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7424.txt log=./load_W158001_7424.log bad=./bad_W158001_7424.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7427.txt log=./load_W158001_7427.log bad=./bad_W158001_7427.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7523.txt log=./load_W158001_7523.log bad=./bad_W158001_7523.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7525.txt log=./load_W158001_7525.log bad=./bad_W158001_7525.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7531.txt log=./load_W158001_7531.log bad=./bad_W158001_7531.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7580.txt log=./load_W158001_7580.log bad=./bad_W158001_7580.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7621.txt log=./load_W158001_7621.log bad=./bad_W158001_7621.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7651.txt log=./load_W158001_7651.log bad=./bad_W158001_7651.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7722.txt log=./load_W158001_7722.log bad=./bad_W158001_7722.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7723.txt log=./load_W158001_7723.log bad=./bad_W158001_7723.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7725.txt log=./load_W158001_7725.log bad=./bad_W158001_7725.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7728.txt log=./load_W158001_7728.log bad=./bad_W158001_7728.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7734.txt log=./load_W158001_7734.log bad=./bad_W158001_7734.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7735.txt log=./load_W158001_7735.log bad=./bad_W158001_7735.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7752.txt log=./load_W158001_7752.log bad=./bad_W158001_7752.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7774.txt log=./load_W158001_7774.log bad=./bad_W158001_7774.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7776.txt log=./load_W158001_7776.log bad=./bad_W158001_7776.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7786.txt log=./load_W158001_7786.log bad=./bad_W158001_7786.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7788.txt log=./load_W158001_7788.log bad=./bad_W158001_7788.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7794.txt log=./load_W158001_7794.log bad=./bad_W158001_7794.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7797.txt log=./load_W158001_7797.log bad=./bad_W158001_7797.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7810.txt log=./load_W158001_7810.log bad=./bad_W158001_7810.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7811.txt log=./load_W158001_7811.log bad=./bad_W158001_7811.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_7988.txt log=./load_W158001_7988.log bad=./bad_W158001_7988.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_8090.txt log=./load_W158001_8090.log bad=./bad_W158001_8090.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_8485.txt log=./load_W158001_8485.log bad=./bad_W158001_8485.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_ZBR1.txt log=./load_W158001_ZBR1.log bad=./bad_W158001_ZBR1.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_ZFR3.txt log=./load_W158001_ZFR3.log bad=./bad_W158001_ZFR3.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_ZFR9.txt log=./load_W158001_ZFR9.log bad=./bad_W158001_ZFR9.log
sqlldr pe_dc/pe control=/home/isis/ICles/PR_ECO/V1/INTEGRATION/ctl/gl_gmargin.ctl data=./W158001_ZVE1.txt log=./load_W158001_ZVE1.log bad=./bad_W158001_ZVE1.log
Step 6
Run “GL_GMARGIN.PL/SQL” script in sql developer or TOAD
Step 7
Run “PURGE_RECYCLAGE_P2 “ in sql developer or TOAD after “GL_GMARGIN.PL/SQL” script is completed