My Oracle Support Banner

DBI: FII_AR_FACTS_AGING_INIT ORA-04031: unable to allocate shared memory (Doc ID 412503.1)

Last updated on FEBRUARY 03, 2020

Applies to:

Oracle Financials Intelligence - Version 7.1 to 7.3 [Release 7]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 11.5.10.2 in Production:
When attempting to run the request Load Accounts Receivable Base Summaries
the following error occurs.

ERROR
Error occured while Populating FII_AR_AGING_RECEIVABLES
-1:ORA-04031: unable to allocate 171240 bytes of shared memory ("shared
pool","INSERT /*+ append parallel(F...","sql area","kxfqf : qerpxAllocate")

STEPS
The issue can be reproduced at will with the following steps:
1. Run request Load Accounts Receivable Base Summaries


.

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
Cause
Solution


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