My Oracle Support Banner

EAR 9.2: PS Data Archive Abends At Step PSARCHIVE.ROWBASED.Step001 For Archive Templates ARPEND And ARITEM When Using Row-Based Processing (Doc ID 2339963.1)

Last updated on DECEMBER 15, 2017

Applies to:

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

Symptoms

ISSUE:

An issue has been detected with the Data Archiving functionality for the FMS Accounts Receivable module. According to PeopleBooks:

     - Pending Item transactions are stored in delivered Table PS_PENDING_ITEM, and this data gets archived into Record PS_AR_PEND_ITM_H.
     - Posted Item transactions are stored in delivered Table PS_ITEM, and their data gets archived into Record PS_AR_ITEM_H.

However, when using the PSARCHIVE AE Program for these two types of Archive Templates (ARPEND and ARITEM), the process abends in Error Message, should Row-Based Processing be selected.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as User ID VP1
     2.- Navigate to: PeopleTools > Data Archive Manager > Manage Archive Objects
     3.- Open and confirm all the configuration for Archive Object AR_ARCH_PENDING_ITEM
     4.- Navigate to: PeopleTools > Data Archive Manager > Manage Archive Templates
     5.- Open and confirm all the configuration for Archive Template ARPEND
     6.- Navigate to: PeopleTools > Data Archive Manager > Archive Data To History
     7.- Create a brand new Run Control ID with the below settings:
          - Archive Template = ARPEND
          - Process Type = Selection
          - Selective Query = AR_ARCH_PENDING_ITEM
          - Row-Based Processing = Y
          - Commit Frequency = 100
          - Audit Row Control = Y
          - Archive Date = September 30th 2017
     8.- Launch the PSARCHIVE AE Program
     9.- Confirm that the process has ended in Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

     " Begin PSARCHIVE (142,105)
       Archive ID = ARPEND, Archive Process = S, Batch Number = 83, Query = AR_ARCH_PENDING_ITEM, Audit Row = Y, Restart = N (142,104)
       Processing GROUP_CONTROL (142,89)
       816884 row(s) processed. (142,168)
       Processing PENDING_ITEM (142,89)
       SQL.Fetch: 225 items in parameter list, but SQL has 226. (2,293) PSARCHIVE.ROWBASED.GBL.default.1900-01-01.Step001.OnExecute PCPC:2955 Statement:47
       Process 2449298 ABENDED at Step PSARCHIVE.ROWBASED.Step001 (PeopleCode) -- RC = 8 (108,524) "

ACTUAL RESULT:

The PSARCHIVE Application Engine Program is abending when using Archive Template ARPEND and ARITEM, which prevents Users from successfully archive the data needed in the system.

EXPECTED BEHAVIOR:

The PSARCHIVE AE Program should be able to handle any Archive requests, regardless of which feature in Receivables is being used.

 

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.