Unable To Open A New Period In GL - Error(1003007) Data Value [0] Encountered Before All Dimensions Selected [2] Records Completed (Doc ID 2319538.1)

Last updated on MAY 31, 2023

Applies to:

Goal

Unable to open a new period in GL

===================================================================================================

Warning Code:1003040
Msg and Log buffer:
[Tue Sep  5 13:11:14 2017]bi.oracleoutsourcing.com/XXXXXLedger/db/FUSION_APPS_GL_ESSBASE_APPID/Info(1003040)
Parallel dataload enabled: [1] block prepare threads, [1] block write threads.
Error Code:1003062
Msg and Log buffer:
[Tue Sep  5 13:11:14 2017]bi.oracleoutsourcing.com/XXXXXLedger/db/FUSION_APPS_GL_ESSBASE_APPID/Error(1003062)
The Dimension Information not found for column [0]. Cannot load data
GL_SHRD0180: ESS_Inc_Import_std() - Performing action: Error in  ESS_Inc_Import-EssImportASO.

<x ESS_Inc_Import_std() 05-SEP-2017 13:11:14

<< ESS_Inc_Import_std() 05-SEP-2017 13:11:14

Error code: 1003062
Error buffer:
Error in ESS_Inc_Import_std call

===================================================================================================

Error Code:1003007
Msg and Log buffer:
[Mon Sep 25 09:40:50 2017]bi.oracleoutsourcing.com/XXXXXLedger/db/FUSION_APPS_GL_ESSBASE_APPID/Error(1003007)
Data Value [0] Encountered Before All Dimensions Selected, [2] Records Completed
GL_SHRD0180: ESS_Inc_Import_std() - Réalisation de l'action : Error in  ESS_Inc_Import-EssImportASO.

<x ESS_Inc_Import_std() 25-SEP-2017 09:40:50

<< ESS_Inc_Import_std() 25-SEP-2017 09:40:50

Error code: 1003007
Error buffer:
Error in ESS_Inc_Import_std call

===================================================================================================

Q1. Select /*SR*/*  from GL_CODE_COMBINATIONS where CODE_COMBINATION_ID like '1%'

Q2. Select /*SR*/ t1.*, t2.*, t3.*,t4.*, t5.*,
      t4.column_name,
      t3.name,
      t4.enabled_flag,
      t2.value_set_id,
      t5.value_set_code,
      t5.validation_type,
      t5.security_enabled_flag,
      t5.data_security_object_name
FROM   fnd_kf_str_instances_b t1,
      fnd_kf_segment_instances t2,
      fnd_kf_segments_tl t3,
      fnd_kf_segments_b t4,
      fnd_vs_value_sets t5
WHERE  t1.structure_instance_number = (select CHART_OF_ACCOUNTS_ID from gl_ledgers l where l.name = ':bind_ledger_name' )
      AND t1.key_flexfield_code = 'GL#'
      AND t1.structure_instance_id = t2.structure_instance_id
      AND t2.display_flag = 'Y'
      AND t1.structure_id = t3.structure_id
      AND t3.LANGUAGE = Userenv('LANG')
      AND t2.segment_code = t3.segment_code
      AND t4.structure_id = t1.structure_id
      AND t4.segment_code = t3.segment_code
      AND t4.enabled_flag = 'Y'
      AND t2.value_set_id = t5.value_set_id
ORDER  BY t4.sequence_number

Solution

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