My Oracle Support Banner

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 MARCH 23, 2018

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Oracle Fusion General Ledger - Version and later
Information in this document applies to any platform.


Unable to open a new period in GL


Warning Code:1003040
Msg and Log buffer:
[Tue Sep  5 13:11:14 2017]
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]
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]
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.*,
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 = ':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


To view full details, 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 a vibrant support community of peers and Oracle experts.