Import Of Segment Values And Hierarchies Completes In Error For Non-Natural Account Segments
Last updated on NOVEMBER 14, 2014
Applies to:Oracle Fusion General Ledger - Version 188.8.131.52.0 and later
Oracle Fusion General Ledger Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
When attempting to upload segment values for the chart of accounts using the spreadsheet integration, the program Import Segment Values and Hierarchies for a segment different than the account segment ends in error.
The log file of the program shows the following:
Processing Segment Value:<value>
Invalid Account Type null
Validation failed for value:<value>
There were some invalid values found during processing of imported value set values.
Import of values failed for version:<version>, Value Set:<value set name>.
The issue can be reproduced at will with the following steps:
1. Prepare the integration spreadsheet.
2. The spreadsheet has values for multiple segments in the chart of accounts starting with the values for the Natural Account Segment
3. Submit the program Import Segment Values and Hierarchies for the DAS and value set. The program ends with error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms