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
Last updated on MARCH 08, 2017
Applies to:Oracle Property Manager - Version 12.1 and later
Information in this document applies to any platform.
After Running Transfer Normalized Lines to GL followed by Create Accounting, no normalized line JE are created.
Review of the Accounting Program Log shows:
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
The issue can be reproduced at will with the following steps:
1. Transfer Normalized Lines to GL
2. Run Create Accounting
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms