My Oracle Support Banner

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 FEBRUARY 27, 2020

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



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


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