My Oracle Support Banner

Pull From DRM Does Not Update Segment Value Description In Fusion (Doc ID 1963124.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

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

Symptoms

On : 11.1.8.0.0 version

Changed the description property for a segment value in DRM and when doing the upload to Fusion, the description is not pulling through into Fusion.
Due to this issue, the reports may be affected as there's a discrepancy in the segment value descriptions.

Expect the description change to go through to Fusion without having to do other changes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a. Before load run the query to check the initial value for the description:
select f.FLEX_VALUE, f.DESCRIPTION
from fnd_flex_values_vl f
where f.FLEX_VALUE = '&segment_value'
and f.flex_value_set_id = &value_set_id;

description: <Curent_Value>
b. In DRM change the value of the description to <New value>
d. Run the Load Account Values and Hierarchies job for the appropriate value set.
e. Run Maintain Value Sets, Tree Flattening and Maintain Chart of Account Hierarchies and Publish to Cube successfully.
f. Run Inherit Segment Value Attributes job successfully.
g. When running the same query run initially, the description is still Central.


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.