My Oracle Support Banner

EEX 9.2: Post Payments Process Abends at Step EX_LIBRARY.CF_INS.CF_INS_2 for Cash Advance With Multiple Lines and ChartField Inheritance Being Used (Doc ID 2821724.1)

Last updated on NOVEMBER 19, 2021

Applies to:

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

Symptoms


A problem has been detected with the Post Payments program when processing the payment of a Cash Advance with multiple lines. The program abends at Step EX_LIBRARY.CF_INS.CF_INS_2 with a duplicate insert violation into Record PS_EX_ACCTG_TMP14.

The system is configured for ChartField Inheritance.

REPLICATION STEPS:

  1.- Create a new Cash Advance with 2 Lines, and define the Accounting details
  2.- Submit the Cash Advance for approval
  3.- Approve the submitted Cash Advance
  4.- Launch Post Liabilities for the Cash Advance
  5.- Stage the Cash Advance for Payment
  6.- Run Pay Cycle to completion to generate a new Payment for the Cash Advance
  7.- Run Update Paid Statuses against the Cash Advance
  8.- Run Post Payments for the Cash Advance
  9.- The process abends in Error Message

ERROR MESSAGE:

 

The abend prevents the system from properly generating the expected Post Payment Accounting Entries for this multi line Cash Advance. Month end tasks are halted due to this issue, as Accounting Entries missing will also be lacking in General Ledger module.

The Post Payment process should be able to successfully generate the needed Accounting Entries for the paid Cash Advance, without such Error Message.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
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.