Financial Management - PSFT (MOSC)

MOSC Banner

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:
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_TAO4

Thanks so much
Jennifer


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center