Verificar si una venta se cargo en RMS cuando el JOB POSUPLD queda en status ABORTED
-- To verify if a POSU file was successfully loaded even though the job "POSUPLD.PC" culminates in ABORTED, without errors or rejected items, verify the following query at the time it aborts: | |
select * from tran_data | |
where location=&idstore -- Store | |
and tran_date='&salesdate' -- Sales date | |
and pgm_name='posupld'; | |
-- To verify the day after the batch | |
select * from if_tran_data | |
where location=&idstore -- Store | |
and tran_date='&salesdate' -- Sales date | |
and pgm_name='posupld'; | |
-- To check in the historical: | |
select * from tran_data_history | |
where location=&idstore -- Store | |
and tran_date='&salesdate' -- Sales date | |
and pgm_name='posupld'; | |
-- The STG_FIF_GL_DATA table, is the integration table with EBS-GL; and DAILY_DATA table is the STOCK LEDGER table day trading. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment