My Oracle Support Banner

EBS-DRM Integration (GLDRMLDR: Load Segment Values and Hierarchies program) When Run GL_DRM_IMPORT_PKG.gl_drm_import_process, Log Shows: "ERROR: The value for Account Type cannot be updated." (Doc ID 2972531.1)

Last updated on OCTOBER 24, 2023

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Hyperion Data Relationship Management - Version 11.1.1.0.00 and later
Information in this document applies to any platform.

Symptoms

When running the Hyperion Data Relationship Management (DRM) to General Ledger (GL) integration program, either via the package: GL_DRM_INTEGRATION_PKG.gl_drm_import_process or concurrent request: GLDRMLDR: Load Segment Values and Hierarchies program, the following error is being seen in the concurrent request log file:

>>GL_DRM_INTEGRATION_PKG.gl_drm_import_process
:- Validating segment values and hierarchies...
:- Fetching value_set properties...
:- Validating segment values exported from DRM...
:- account_type differs: Old Value=X, New Value=Y  ***   
:- ===> Error in value=EXAMPLEVALUE
:- ERROR: The value for Account Type cannot be updated. Please reset it to its original value.

:- Number of segment values : ####
:- Number of segment values in error : 1

:- Errors in the exported segment values.
:- The segment values and hierarchies data has errors.
:- >>gl_drm_integration_pkg.gl_drm_import_process
AFTER X_RETCODE = E

Note: These values can be any account type value: R,E,A,L,O. The key issue is that there is a difference from what is being imported to what the current value is in the E-Business Suite (EBS).

 STEPS
----------
1. Export segment value data to Oracle General Ledger from the DRM application.
2. Go to General ledger responsibility.
3. View > Request > Submit a new request.
4. Select the Load Segment Values and Hierarchies program and submit.
5. Note that the program ends in Error status with the above error seen in the generated log file.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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