Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.