Batch Administration in UI

[sasq]

dear all,

i already run ifb automatically using  jobs in batch admin (UI). but not all data sucessfully.
here i describe the table ilustration (based on jobs running):

------------------------------------------
Staging Table        |    Interface Table      |
------------------------------------------
M_ACCOUNT          |  EIM_ACCOUNT         |
M_ACCNT_CUT       |  EIM_ACCNT_CUT      |
M_ASSET_1           |  EIM_ASSET             |
M_ASSET_2           |  EIM_ASSET1           |
-------------------------------------------

in first run (i forget to change batch num in IFB file):
- interface table null,
- m_account, m_accnt_cut, --> imported
- m_asset_1 imported but there are 3 column is not get value
- m_asset_2 null

in second run (after change batch num in IFB):
- only eim_asset filled (but still FOR_IMPORT)
- only m_asset_2 filled (but still FOR_IMPORT and there are 3 column is not get value)

it possible to delete data manually using TOAD (because data is connect to server)? or what should i do?


Thank you

[sridhar]

why do you want to delete?
why not just run the missing ones? looks like second run failed. check why it failed and try to run.

regards,
Sridhar

[sasq]

it's okay if data duplicate? iam worried if there any error caused that. because i want to retry run and hope it's full succesful not half. and data will insert into server not in local (it make me scare).

[sridhar]

where are you running this EIM job? in prod server?
have u tested enough before you implement in prod? if you are doing anywhere other than production environment I think that is okay..because there are always problems.
you cant get perfect the first time.

[sasq]

iam running in development server. if it's okay, how can i know my job sucessfull? from date and time?

[sridhar]

check the if_row_stat of the eim table for that particular batch number. the value of that column if says imported, then the records were imported. then query the destincation tables, for newly created record and look at the created date.
good luck

Sridhar