You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get the gl account segment 'description' from BICC PVO extracts?

Received Response
72
Views
2
Comments
edited Apr 16, 2021 7:41PM in Reporting and Analytics for ERP 2 comments

Summary

How do we get the gl account segment 'description' from BICC PVO extracts?

Content

How do we get the gl account segment 'description' from BICC PVO extracts?  We are extracting journal entry line data using the following PVO's and need to put them back together outside of Oracle and include the segment descriptions from code combination segments.  How do we get the journal entry segment value 'description'.  Do we have to hardcode the valuesetid in our sql when combining the data from these VO's?  

FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalHeaderExtractPVO
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalBatchExtractPVO
FscmTopModelAM.AnalyticsServiceAM.ValueSetValuesPVO

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!