Leases Normalized Lines Not Transfered To GL: Accounting Program Errors ORA-01403: no data found and The following events are present in the line extract but MISSING in the header extract

(Doc ID 1986538.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Property Manager - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

After Running Transfer Normalized Lines to GL followed by Create Accounting, no normalized line JE are created.

Review of the Accounting Program Log shows:

ERROR
-----------------------
Accounting Program Log shows:
An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_00240_AAD_S_000018_PKG.EventType_8. ORA-01403: no data found.

EVENT CLASS CODE = LEASE_EXPENSE
The following events are present in the line extract but MISSING in the header extract:
Event_id = 123456
Event_id = 789111
Event_id = 111222


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Transfer Normalized Lines to GL
2. Run Create Accounting



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