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 14, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms