Run Crediting or Classification Resulting In Error : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded (Doc ID 2019786.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

The child request / process Generate Direct and Indirect Incentive Credits which gets submitted from process Run Crediting and Rollup is resulting in error status.

OR

The child request / process GetWinners which gets submitted from process Run Crediting or Classify Credits resulted in error status.

ERROR
-10260 : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded

STEPS
Navigator > Credits and Earnings > Run Crediting and Rollup  or Run Crediting or Classify Credits

Debug Messages
Start of the procedure CN_RS_ASSIGN_BULK_PUB.get_winners
Usage: -1001
Worker : 42
Percent analyzed: 20
Call procedure CN_RS_ASSIGN_BULK_PUB.process_match
Start of the procedure CN_RS_ASSIGN_BULK_PUB.process_match
Executing matching SQL for attribute combination 4051511450672408297 : 1
End of the procedure CN_RS_ASSIGN_BULK_PUB.process_match: Unexpected exception
-10260 : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded
CN_RS_ASSIGN_BULK_PUB.process_match API has failed
End of the procedure CN_RS_ASSIGN_BULK_PUB.get_winners: FND_API.G_EXC_ERROR exception
-10260 : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded

Changes

System Parameter settings are :   (Navigator > Setup and Maintenance > Task: Manage Parameters )
   Enable Direct Crediting = Yes
   Enable Rollup Crediting = Yes
   Rollup Hierarchy to Use = Credit hierarchy
   Classification and Crediting Batch Processing = Use batch size determined by application
   Number of Batches = 5

Sample Direct Credit Rules:    (Navigator > Participants Assignments > Manage Direct Credit Rules)
NA Region (VP1, no qualifier)
   NR-NO (Regional1, no qualifier)
     NR-NO-PGS-02 (Manager1, no qualifier)
        NR-NO-PGS-02-02 (Salesrep1, 7 qualifiers)
              Qualifier Name  Operator    Value
              Zip Code          Equal to     32828
              State Name      Equal to     FL
              Sales Channel   Equal to     Internal
              Account Type     Equal to     Corporate
              Country Name    Equal to     US
              Account Name    Equal to     My Company
              City Name         Equal to     Orlando

Cause

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