Create Accounting OPM GMF Completes with Error

Create Accounting Completes with Error - GMF 

Error :

GMFAACCP module: Create Accounting

+---------------------------------------------------------------------------+

Current system time is 21-SEP-2013 09:31:21

+---------------------------------------------------------------------------+

XDO Data Engine Version No: 5.6.3

Resp: 21591

Org ID : 82

Request ID: 21699798

All Parameters: P_SOURCE_APPLICATION_ID=555:P_APPLICATION_ID=555:P_DUMMY=Y:P_LEDGER_ID=1:P_PROCESS_CATEGORY_CODE=:P_END_DATE="2013/09/21 00:00:00":P_CREATE_ACCOUNTING_FLAG=Y:P_DUMMY_PARAM_1=Y:P_ACCOUNTING_MODE=D:P_DUMMY_PARAM_2=:P_ERRORS_ONLY_FLAG=N:P_REPORT_STYLE=S:P_TRANSFER_TO_GL_FLAG=:P_DUMMY_PARAM_3=:P_POST_IN_GL_FLAG=:P_GL_BATCH_NAME=:P_MIN_PRECISION=:P_INCLUDE_ZERO_AMOUNT_LINES=N:P_REQUEST_ID=:P_ENTITY_ID=:P_SOURCE_APPLICATION_NAME=Process Manufacturing Financials:P_APPLICATION_NAME=Process Manufacturing Financials:P_LEDGER_NAME=PepsiCo_VN:P_PROCESS_CATEGORY_NAME=:P_CREATE_ACCOUNTING=Yes:P_ACCOUNTING_MODE_NAME=Draft:P_ERRORS_ONLY=No:P_ACCOUNTING_REPORT_LEVEL=Summary:P_TRANSFER_TO_GL=:P_POST_IN_GL=:P_INCLUDE_ZERO_AMT_LINES=No:P_VALUATION_METHOD_CODE=:P_SECURITY_INT_1=:P_SECURITY_INT_2=:P_SECURITY_INT_3=:P_SECURITY_CHAR_1=:P_SECURITY_CHAR_2=:P_SECURITY_CHAR_3=:P_CONC_REQUEST_ID=:P_INCLUDE_USER_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:P_USER_ID=5497:DebugFlag=N

Data Template Code: GMFAACCP

Data Template Application Short Name: GMF

Debug Flag: N

{P_ACCOUNTING_REPORT_LEVEL=Summary, P_DUMMY=Y, P_ACCOUNTING_MODE_NAME=Draft, P_ERRORS_ONLY_FLAG=N, P_REPORT_STYLE=S, P_GL_BATCH_NAME=, P_END_DATE=2013/09/21 00:00:00, P_SECURITY_INT_3=, P_SECURITY_INT_2=, P_SECURITY_INT_1=, P_VALUATION_METHOD_CODE=, P_POST_IN_GL=, P_TRANSFER_TO_GL=, P_TRANSFER_TO_GL_FLAG=, P_INCLUDE_USER_TRX_IDENTIFIERS=No, P_USER_ID=5497, P_PROCESS_CATEGORY_NAME=, P_ERRORS_ONLY=No, P_DUMMY_PARAM_3=, P_SECURITY_CHAR_3=, P_DUMMY_PARAM_2=, P_SECURITY_CHAR_2=, P_DUMMY_PARAM_1=Y, P_SECURITY_CHAR_1=, P_ENTITY_ID=, P_PROCESS_CATEGORY_CODE=, P_INCLUDE_ZERO_AMT_LINES=No, P_LEDGER_ID=1, P_POST_IN_GL_FLAG=, P_APPLICATION_ID=555, P_INCLUDE_USER_TRX_ID_FLAG=N, P_APPLICATION_NAME=Process Manufacturing Financials, P_REQUEST_ID=, P_CONC_REQUEST_ID=, P_LEDGER_NAME=PepsiCo_VN, P_SOURCE_APPLICATION_ID=555, P_CREATE_ACCOUNTING=Yes, P_CREATE_ACCOUNTING_FLAG=Y, P_MIN_PRECISION=, P_SOURCE_APPLICATION_NAME=Process Manufacturing Financials, P_INCLUDE_ZERO_AMOUNT_LINES=N, P_ACCOUNTING_MODE=D}

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...***

Solution:

1) Add a new parameter called Scalable Flag as follows -

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)

2) Re-run the Create Accounting.

Note that the parameter - P_SCALABLE_FLAG - has a Default Value of 'Y'.