Create Accounting (XLAACCPB) Program in one of our instances gave below error in log file:
Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***
Oracle Support recommended below action plan in a SR. That fixed the issue.
Action Plan:
==================
1. In Profile, please change following setting at ALL levels in System option:
FND: Debug Log Enabled => NO
AR: Enable Debug Message Output => NO
SLA: Enable Diagnostics => No
2. Doc ID 1350719.1
Access the "System Administrator" responsibility.
Navigate to Concurrent > Program > Define.
Search for the report (e.g., Create Accounting)
Click on Parameters button.
Move to the last parameter.
Add the Scalable Flag as follows -
Parameter- P_SCALABLE_FLAG
Description - ScalableFlag
Enabled - Check
Value Set - XLA_SRS_NO_VALIDATION
Default Type - Constant
Default Value - Y
Prompt - P_SCALABLE_FLAG
Token - ScalableFlag (Case sensitive. Give this exact value)
P_SCALABLE_FLAG - has a Default Value of 'Y'
3.
A> Increase the memory for Java used by the concurrent program.
Query the concurrent program in
System Administrator> Concurrent> Program> Define >
Query for the Create Accounting concurrent program >
Enter value for Options field with : -Xmx2048M (Note: Don't miss the dash before the X) .
B> Time out parameters (Profile)
Concurrent:OPP Response Timeout : 240
Concurrent:OPP Process Timeout : 10800 sec (3 hours)
Additional Notes: Oracle Doc ID 838810.1 provides a similar solution to fix below error and it worked in my instance.
Subledger Accounting: Version : 12.0.0
XLAPEXRPT module: Subledger Period Close Exceptions Report
Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***
Set the following parameters in the concurrent program definition:
Under Concurrent > Program > Define, query for concurrent program
short name = XLAPEXRPT and application = Subledger Accounting.
1. In the 'Options' field enter -Xmx2048M
2. Add a parameter to the concurrent token = ScalableFlag, default value set to 'Y'. Same way
you add DebugFlag
In the application developer responsibility
-> Concurrent -> Program -> Define
-> Query for short name= XLAPEXRPT
-> Click on Parameters
->define a new parameter (if not existing)
parameter name=P_DEBUG_FLAG, attach any valueset that is YES_NO valueset.
Give Default value=Y
Token=DebugFlag
Save
3. Submit the request with scalable mode Yes.
No comments:
Post a Comment