/9205753: Journal Entries Report (XLAJELINESRPT) completes with warning. Report Output Is Empty.

(Doc ID 1212327.1)

Last updated on JULY 28, 2016

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.

Symptoms



Journal Entries Report (XLAJELINESRPT) completes with warning.  No output file is printed.  Log file shows the following:
  
  XDO Data Engine Version No: 5.6.3
  Resp: 50523
  Org ID : 83
  Request ID: 22845995
  All Parameters: P_RESP_APPLICATION_ID=222:P_LEDGER_ID=2021:P_LEDGER=CMAV
  Grupo
  Mexicana:P_COA_ID=50294:P_LEGAL_ENTITY_ID=:P_TRX_LEGAL_ENTITY_ID=:P_PERIOD_FR
  OM=SEP-09:P_PERIOD_TO=SEP-09:P_GL_DATE_FROM="2009/09/01
  00:00:00":P_GL_DATE_TO="2009/09/30
  00:00:00":P_CREATION_DATE_FROM=:P_CREATION_DATE_TO=:P_TRANSACTION_DATE_FROM=:
  P_TRANSACTION_DATE_TO=:P_JE_STATUS_CODE=F:P_JE_STATUS=Final:P_POSTING_STATUS_
  CODE=:P_POSTING_STATUS=:P_JE_SOURCE=Receivables:P_JE_SOURCE_NAME=Receivables:
  P_PROCESS_CATEGORY_ROWID=:P_PROCESS_CATEGORY=:P_EVENT_CLASS_ROWID=:P_EVENT_CL
  ASS=:P_ACCT_SEQUENCE_VERSION=:P_ACCT_SEQUENCE_NUM_FROM=:P_ACCT_SEQUENCE_NUM_T
  O=:P_RPT_SEQUENCE_VERSION=:P_RPT_SEQUENCE_NUM_FROM=:P_RPT_SEQUENCE_NUM_TO=:P_
  DOC_SEQUENCE_NUM_FROM=:P_DOC_SEQUENCE_NUM_TO=:P_PARTY_TYPE_CODE=:P_PARTY_TYPE
  =:P_PARTY_ID=:P_PARTY_NAME=:P_PARTY_NUMBER_FROM=:P_PARTY_NUMBER_TO=:P_JE_CATE
  GORY=:P_JE_CATEGORY_NAME=:P_BALANCE_TYPE_CODE=A:P_BUDGET_VERSION_ID=:P_ENCUMB
  RANCE_TYPE_ID=:P_INCLUDE_ZERO_AMOUNT_FLAG=N:P_INCLUDE_ZERO_AMOUNT_LINES=No:P_
  ENTERED_CURRENCY=:P_ACCOUNTED_AMOUNT_FROM=:P_ACCOUNTED_AMOUNT_TO=:P_BALANCING
  _SEGMENT_FROM=:P_BALANCING_SEGMENT_TO=:P_ACCOUNT_SEGMENT_FROM=:P_ACCOUNT_SEGM
  ENT_TO=:P_ACCOUNT_FLEXFIELD_FROM=:P_ACCOUNT_FLEXFIELD_TO=:P_SIDE_CODE=:P_VALU
  ATION_METHOD=:P_SECURITY_ID_INT_1=:P_SECURITY_ID_INT_2=:P_SECURITY_ID_INT_3=:
  P_SECURITY_ID_CHAR_1=:P_SECURITY_ID_CHAR_2=:P_SECURITY_ID_CHAR_3=:P_POST_ACCT
  _PROGRAM_ROWID=:P_POST_ACCOUNTING_PROGRAM=:P_USER_TRX_ID_COLUMN_1=:P_USER_TRX
  _ID_COLUMN_2=:P_USER_TRX_ID_COLUMN_3=:P_USER_TRX_ID_COLUMN_4=:P_USER_TRX_ID_C
  OLUMN_5=:P_USER_TRX_ID_VALUE_1=:P_USER_TRX_ID_VALUE_2=:P_USER_TRX_ID_VALUE_3=
  :P_USER_TRX_ID_VALUE_4=:P_USER_TRX_ID_VALUE_5=:P_GL_BATCH_NAME=:P_INCLUDE_USE
  R_TRX_ID_FLAG=N:P_INCLUDE_USER_TRX_IDENTIFIERS=No:P_INCLUDE_TAX_DETAILS_FLAG=
  N:P_INCLUDE_LE_INFO_FLAG=NONE:P_TRANSACTION_VIEW=:P_FETCH_FROM_GL=Y:P_DOC_SEQ
  _NAME=:P_CUSTOM_PARAMETER_1=:P_CUSTOM_PARAMETER_2=:P_CUSTOM_PARAMETER_3=:P_CU
  STOM_PARAMETER_4=:P_CUSTOM_PARAMETER_5=:DebugFlag=:ScalableFlag=Y
  Data Template Code: XLAJELINESRPT
  Data Template Application Short Name: XLA
  Debug Flag:
  {P_TRANSACTION_VIEW=, P_ACCOUNT_SEGMENT_TO=, P_VALUATION_METHOD=,
  P_POSTING_STATUS_CODE=, P_DOC_SEQUENCE_NUM_TO=, P_PARTY_NUMBER_TO=,
  P_POST_ACCOUNTING_PROGRAM=, P_INCLUDE_ZERO_AMOUNT_LINES=No,
  P_FETCH_FROM_GL=Y, P_COA_ID=50294, P_PROCESS_CATEGORY=,
  P_BUDGET_VERSION_ID=, P_PARTY_TYPE=, P_INCLUDE_LE_INFO_FLAG=NONE,
  P_PARTY_TYPE_CODE=, P_GL_BATCH_NAME=, P_USER_TRX_ID_COLUMN_5=,
  P_USER_TRX_ID_COLUMN_4=, P_ACCT_SEQUENCE_NUM_FROM=, P_USER_TRX_ID_COLUMN_3=,
  P_USER_TRX_ID_COLUMN_2=, P_PARTY_NUMBER_FROM=, P_RPT_SEQUENCE_VERSION=,
  P_USER_TRX_ID_COLUMN_1=, P_DOC_SEQ_NAME=, P_CREATION_DATE_TO=,
  P_JE_STATUS_CODE=F, P_CUSTOM_PARAMETER_5=, P_CUSTOM_PARAMETER_4=,
  P_CUSTOM_PARAMETER_3=, P_ENTERED_CURRENCY=, P_CUSTOM_PARAMETER_2=,
  P_CUSTOM_PARAMETER_1=, P_GL_DATE_FROM=2009/09/01 00:00:00,
  P_USER_TRX_ID_VALUE_5=, P_USER_TRX_ID_VALUE_4=, P_EVENT_CLASS=,
  P_EVENT_CLASS_ROWID=, P_USER_TRX_ID_VALUE_3=, P_USER_TRX_ID_VALUE_2=,
  P_USER_TRX_ID_VALUE_1=, P_JE_STATUS=Final, P_ACCOUNT_SEGMENT_FROM=,
  P_RPT_SEQUENCE_NUM_FROM=, P_JE_SOURCE_NAME=Receivables,
  P_INCLUDE_TAX_DETAILS_FLAG=N, P_JE_SOURCE=Receivables,
  P_RESP_APPLICATION_ID=222, P_INCLUDE_USER_TRX_IDENTIFIERS=No,
  P_ACCOUNT_FLEXFIELD_TO=, P_ACCOUNTED_AMOUNT_FROM=, P_LEGAL_ENTITY_ID=,
  P_INCLUDE_ZERO_AMOUNT_FLAG=N, P_PARTY_ID=, P_PERIOD_TO=SEP-09,
  P_ACCT_SEQUENCE_NUM_TO=, P_ACCT_SEQUENCE_VERSION=, P_DOC_SEQUENCE_NUM_FROM=,
  P_POSTING_STATUS=, P_RPT_SEQUENCE_NUM_TO=, P_POST_ACCT_PROGRAM_ROWID=,
  P_ENCUMBRANCE_TYPE_ID=, P_CREATION_DATE_FROM=, P_BALANCE_TYPE_CODE=A,
  P_PARTY_NAME=, P_TRANSACTION_DATE_FROM=, P_BALANCING_SEGMENT_TO=,
  P_LEDGER_ID=2021, P_SIDE_CODE=, P_JE_CATEGORY=,
  P_INCLUDE_USER_TRX_ID_FLAG=N, P_PERIOD_FROM=SEP-09, P_SECURITY_ID_CHAR_3=,
  P_SECURITY_ID_CHAR_2=, P_SECURITY_ID_CHAR_1=, P_TRANSACTION_DATE_TO=,
  P_JE_CATEGORY_NAME=, P_PROCESS_CATEGORY_ROWID=, P_SECURITY_ID_INT_3=,
  P_SECURITY_ID_INT_2=, P_TRX_LEGAL_ENTITY_ID=, P_SECURITY_ID_INT_1=,
  P_ACCOUNTED_AMOUNT_TO=, P_ACCOUNT_FLEXFIELD_FROM=,
  P_BALANCING_SEGMENT_FROM=, P_LEDGER=CMAV Grupo Mexicana,
  P_GL_DATE_TO=2009/09/30 00:00:00}
  Calling XDO Data Engine...
  Scalable mode on...
  
  . . .
  
  [120709_122524999][][STATEMENT] Executing data triggers...
  [120709_122524999][][EVENT] Data Generation Completed...
  [120709_122524999][][EVENT] Total Data Generation Time 18.993166666666664
  minutes
  +---------------------------------------------------------------------------+
  
  Start of log messages from FND_FILE
  +---------------------------------------------------------------------------+
  
  +---------------------------------------------------------------------------+
  
  End of log messages from FND_FILE
  +---------------------------------------------------------------------------+
  
  
  
  +---------------------------------------------------------------------------+
  
  Executing request completion options...
  
  +------------- 1) PUBLISH -------------+
  Beginning post-processing of request 22845995 on node AUOHSCMAV18 at
  07-DEC-2009 12:25:25.
  Post-processing of request 22845995 failed at 07-DEC-2009 12:29:29 with the
  error message:
  One or more post-processing actions failed. Consult the OPP service log for
  details.
  +--------------------------------------+
  
  OPP log file does not show anything.

Cause

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 hundreds of Community platforms