My Oracle Support Banner

RTLOG Files Are Intermittently Not Generated for Huge Transactions Due To OutOfMemory Errors (Doc ID 1335740.1)

Last updated on JUNE 30, 2018

Applies to:

Oracle Retail Point-of-Service - Version 12.0.9 to 14.0.4 [Release 12.0 to 14.0]
Information in this document applies to any platform.


In Oracle Retail Point of Service (ORPOS), Out Of Memory error occurs while generating RTLOG for transactions with more than 300 line items.

Steps to reproduce:

This issue can only be reproduced with large number of line items in the transaction.

1.  Create transactions with more than 100 items
2.  RTLOG does not get generated for some of the transactions due to OutOfMemoryErrors

In addition RTLog Export failures due to error below occur:

ERROR 2018-06-30 06:43:08,746 24608957  (
    Sql error reading table ST_ASCTN_MRHRC

java.sql.SQLException: ORA-00904: "ID_MRHRC_GP": invalid identifier




To view full details, 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 a vibrant support community of peers and Oracle experts.