ELA: Lease Administration Audit Logging Errors When Running AP/Billing Interface For Cap Lease
(Doc ID 2586591.1)
Last updated on JULY 21, 2020
Applies to:
PeopleSoft Enterprise FIN Lease Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
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 |