ARUPDATE/ARPOST abend - AR data validation SQL?
Hi,
ARUPDATE abended in the ARPOST step. I'm trying to validate that nothing got half-posted before we try the "reset" button.
Does anyone have any SQL they use to validate AR Balances?
The following tables all have rows with the failed Process Instance:
Thanks so much
Jennifer
ARUPDATE abended in the ARPOST step. I'm trying to validate that nothing got half-posted before we try the "reset" button.
Does anyone have any SQL they use to validate AR Balances?
The following tables all have rows with the failed Process Instance:
PS_PENDING_ITEM
PS_PAYMENT
PS_ITEM
PS_GROUP_CONTROL
PS_PENDING_DST
PS_CUST_DATA
PS_RP_PARALLEL
PS_WS_CONTROL
PS_RP_PNDDST_TAO4Thanks so much
Jennifer
0