Financial Management - PSFT (MOSC)

MOSC Banner

AP voucher archive related vouchers/journal vouchers not archiving issue

edited Aug 4, 2017 5:04AM in Financial Management - PSFT (MOSC) 1 commentAnswered

Hello, we are using the delivered AP Voucher Archive query AP_ARCHIVE_VOUCHER_BU in PS 9.1.

We have several vouchers not archiving that did not fall into any of the known archive exceptions, and a big chunk of them are Journal vouchers. We found that at least some of them have related vouchers, and this is how they are not getting picked up by the query:

SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, TO_CHAR(A.INVOICE_DT,'YYYY-MM-DD'), A.IN_PROCESS_FLG, A.MATCH_ACTION, A.MATCH_STATUS_VCHR
  FROM PS_VOUCHER A, PS_AP_ARCH_VCH_VW M

Tagged:

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