Expense Post Liability abends At Insert Into PS_EX_ACCTG_TMP4 In Section EXPENSE.DBRV1

(Doc ID 2202336.1)

Last updated on DECEMBER 07, 2016

Applies to:

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

Symptoms

Expense Post Liability abends at insert into PS_EX_ACCTG_TMP4 in section EXPENSE.DBRV1

Steps:
----------
1) Create an expense report, submit and Approve.

2) Run Post liabilities process with the following conditions:

- ER Business Unit <> Charged Business Unit
- VAT applicable on some lines, not applicable on others

3) Posting Liability fails with Unique Constraint Error.

Error:
---------

Expense Post Liability abends at insert into PS_EX_ACCTG_TMP4 in section EXPENSE.DBRV1.

EX_LIBRARY.CF_INS.CF_INS_3 SQL 805

Please check < Replication_Steps > for more details

Cause

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