My Oracle Support Banner

EAR 9.2: Users Are Unable To Access And View In FSCM 9.2 Version The Attachments Present In Receivables Payments That Were Created In FSCM 9.1 Application Release And Later Migrated Into 9.2 (Doc ID 2223254.1)

Last updated on JANUARY 15, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

QUESTION:

Recently upgraded to PeopleSoft Enterprise FSCM 9.2 Application Release. The Accounts Receivable Functional Team has detected an anomaly when trying to access the attachment files from Payment transactions created in FSCM 9.1 systems. It seems that the Records used for Payment Attachments may have changed, from PS_PAYMENT_ATT (FSCM 9.1) to PS_PAYMENT_WS_ATT (FSCM 9.2) in the below navigation page:

     - Accounts Receivable > Payments > Review Payments > All Payments

Payments created in FSCM 9.2, that have attachments uploaded, do not present this behavior. This is only affecting Payments and their attachments as long as they were created in FSCM 9.1. There is no workaround.

Please provide as script to merge the FSCM 9.1 table PS_PAYMENT_ATT to FSCM 9.2 table PS_PAYMENT_WS_ATT.

REPLICATION STEPS:

     1.- Log into the FSCM 9.1 Online Application as User ID VP1
     2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     3.- Create a new Deposit Group, with at least one new Payment
     4.- Upload a file as an attachment into that Payment
     5.- Upgrade the systems from FSCM 9.1 to FSCM 9.2
     6.- Log into the FSCM 9.1 Online Application as User ID VP1
     7.- Navigate to: Accounts Receivable > Payments > Review Payments > All Payments
     8.- Open the existing Payment ID
     9.- Try to retrieve the Payment's attachment

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.