ELA: Lease Administration Audit Logging Errors When Running AP/Billing Interface For Cap Lease (Doc ID 2586591.1)

Last updated on JANUARY 25, 2021

Applies to:

Symptoms

On :  9.2 version, 2.4 Lease Maintenance, PUM 29

When running Manage Interface to AP/Billing process for Capital Leases in PI29 non prod environment, a unique constraint error on table RE_LS_AUD_TBL was returned due to an additional row for the same LS_TXN_ID. The audit for Process Lease Transaction had to be disabled to continue processing Leases.



ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725  Error Position: 0  Return: 805 - 
ORA-00001: unique constraint (SYSADM.PS_RE_LS_AUD_TBL) violated
Failed SQL stmt: INSERT INTO PS_RE_LS_AUD_TBL (BUSINESS_UNIT, LS_NBR, LS_TXN_SRC_ID,
FS_EVENT_CODE, AUDLOG_DTTM, USERID, PROCESS_INSTANCE, MESSAGE_SET_NBR,
MESSAGE_NBR, MESSAGE_TEXT_254, MESSAGE_PARM, BATCH_ACTION, PURGE_OPTN)
SELECT A.BUSINESS_UNIT, A.LS_NBR, A.LS_TXN_ID, 'TXN_PROCESS', CAST(SYSTIMESTAMP AS 
TIMESTAMP), 'VP1', 165455, 18157, 622, 'RE_LS_TXN' || '.' || 'TXN_GRP' || '.' || A.TXN_GRP || ',' || 
TO_CHAR(C.FROM_DATE,'YYYY-MM-DD') || ',' || TO_CHAR(C.TO_DATE,'YYYY-MM-DD') || ',' ||
TO_CHAR(SUM(A.MERCHANDISE_AMT)) || ',' || A.CURRENCY_CD, 'RE_LS_TXN' || '.' || 'TXN_GRP' ||
'.' || A.TXN_GRP, 'Y', 'N' FROM PS_RE_INTFAP_TAO4 A, PS_RE_LS_TXN C WHERE A.LS_TXN_ID = 
C.LS_TXN_ID AND A.PROCESS_INSTANCE = 165455 GROUP BY A.LS_TXN_ID, A.BUSINESS_UNIT,
A.LS_NBR, A.TXN_GRP, C.FROM_DATE, C.TO_DATE, A.CURRENCY_CD


Process 165455 ABENDED at Step AUDIT_LOG.RETXNAP.AUDITLOG (SQL) -- RC = 805 (108,524)


Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %sPSAESRV completed service request at 18.38.08 2019-04-23



STEPS
-----------------------
1. Enable audit logging for 'Process Lease Transactions' Setup Financials > Common Definition > Audit Logging > Enable Audit Logging for
No other Event Names are selected for Lease Administration.  
2. Create a lease with Base Rent.
3. Run transaction generator.

4. Run Manage Interfaces to AP/Billing RE_TXN_INTFC.  

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.