EAR 9.0+: How to Prevent the Original PS_ITEM Values from being Overridden by New Activity?

(Doc ID 1615635.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

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

Goal

Scenario:

When we manually load the item activity tables (PENDING_ITEM, GROUP_CONTROL, PENDING_DST) and run the ARUPDATE to offset the item, the PS_ITEM table is being updated with the latest item activity.

When we manually load the offset item (with an ENTRY_AMT = 10 to close out the item) to the PENDING_ITEM, GROUP_CONTROL, PENDING_DST tables and run the ARUPDATE, the values are changed on the PS_ITEM table.

So the values on the PS_ITEM table are being overridden by the latest item activity.  How to prevent the original PS_ITEM values from being overridden?

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