My Oracle Support Banner

PSARCHIVAL Long Running (Doc ID 2376582.1)

Last updated on MARCH 21, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Query AP_ARCHIVE_PYMNT_ALL is wrong, contain triple quota.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to PeopleTools > Data Archive Manager > Archive Data To History
2. Select Active Template = AP_PYMNT
3. Select the Query: AP_ARCHIVE_PYMNT_ALL
4. Define Binds : Reset Query Bind Variable and select current date.
5. View Details / View SQL on PAYABLES_PAYMENTS


ERROR
-----------------------
Query AP_ARCHIVE_PYMNT_ALL is wrong, contain triple quota.

Changes

 Query AP_ARCHIVE_PYMNT_ALL contain triple quota. Has been modified so that this query contains only one quota for content.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.