Create a gist now

Instantly share code, notes, and snippets.

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