Financial Management - PSFT (MOSC)

MOSC Banner

Open Item Account is not populated for Stale Payments in VCHR_ACCTG_LINE

edited Dec 4, 2018 4:00AM in Financial Management - PSFT (MOSC) 2 commentsAnswered

On : 9.2 version, Payment

ACTUAL BEHAVIOR
---------------
Open Item Key is not populated for Stale Payments in VCHR_ACCTG_LINE

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Account with OIK .
2. Identify Unclaimed check
SELECT PYMNT_ID, PYMNT_ID_REF, REMIT_VENDOR, PYMNT_DT, PYMNT_AMT, PYMNT_STATUS, RECON_STATUS FROM PS_PAYMENT_TBL
AND RECON_STATUS <> 'REC' .
3. Run Mass Cancellation Process .
4. Verify Payment Status is updated from ‘P’ (Paid) to ‘L’ (Stale) .
SELECT PYMNT_ID, PYMNT_ID_REF, REMIT_VENDOR, PYMNT_DT, PYMNT_AMT, PYMNT_STATUS, RECON_STATUS FROM PS_PAYMENT_TBL
WHERE PYMNT_ID_REF in ('Mention Payment ID Reference').

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