ERE:RE_TXN_INTFC ERROR ORA-01407 Audit Operation Expenses Interfaced to AP (Doc ID 2293521.1)

Last updated on AUGUST 03, 2017

Applies to:

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

Symptoms

Impossible to interfaced the Payment create from the audit operating expenses screen from Lease Administration to AP, the payment is "Approved" but the process finish in No Success.

ERROR:  File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 29 Return: 14 07 - ORA-01407: cannot update ("SYSADM"."PS_RE_INTFAP_TAO4"."CAPITALIZE_SW") to NULL Failed SQL stmt: UPDATE PS_RE_INTFAP_TAO4 SET CAPITALIZE_SW = ( SELECT A.CAPITALIZE_SW FROM PS_RE_LS A_TRM A , PS_RE_LS_TRM_SCHED B WHERE A.LS_KEY = PS_RE_INTFAP_TAO4.LS_KEY AND A.TERM_ID = PS_RE_INTFA P_TAO4.TERM_ID AND A.LS_KEY = B.LS_KEY AND A.TERM_ID = B.TERM_ID AND A.AMND_NBR = B.AMND_NBR AND B.T ERM_SCHED_ID = PS_RE_INTFAP_TAO4.LS_TXN_SRC_ID) WHERE PROCESS_INSTANCE = 101969 AND TERM_ID <> 0

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- Create a lease which have at least one line as operating expenses financial terms To help for this test, create a lease in the past (could begin at the 1st of January, 2016)
2- Activate the lease,
3- Run the transaction generator for this lease
4- Once the transaction are approved (if necessary), run the interface to AP
5- Once your transaction are “processed” in the processing payments page, you can manage the “audit operating expenses”. Put an actual amount different than the paid amount for the period and create the payment.
6- The transaction is now Approved and ready to be sent to AP, but when I run the interface to AP, I have an error message and the process finish in “No success”

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