My Oracle Support Banner

Columns In BICC Extract Not Following Alphabetical Order (Doc ID 2686305.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Goal

Columns from BICC extracts do not following alphabetic order. For example, on the FscmTopModelAM.InvOrgPublicViewAM.InventoryOrgParametersPVO VO the extracted data in .csv file shows columns in this format:

BUSINESSUNITPEOBUSINESSUNITID
BUSINESSUNITPEOLASTUPDATEDATE
BUSINESSUNITPEONAME
INVORGHRATTRIBUTESPEOEFFECTIVEENDDATE
INVORGHRATTRIBUTESPEOEFFECTIVESTARTDATE
INVORGHRATTRIBUTESPEOINTERNALADDRESSLINE
INVORGHRATTRIBUTESPEOINTERNALEXTERNALFLAG
INVORGHRATTRIBUTESPEOLASTUPDATEDATE
INVORGHRATTRIBUTESPEOTYPE
INVORGNAMEPEOEFFECTIVESTARTDATE
INVORGNAMEPEOLANGUAGE
INVORGNAMEPEOLASTUPDATEDATE
INVORGNAMEPEONAME
LEGALENTITYPEOLASTUPDATEDATE
LEGALENTITYPEONAME
MASTERORGBULASTUPDATEDATE
MASTERORGPARAMLASTUPDATEDATE
MASTERORGPARAMORGANIZATIONCODE
ORGORGANIZATIONDEFINITIONSPBUSINESSUNITID
ORGORGANIZATIONDEFINITIONSPCURRENCYCODE
ORGORGANIZATIONDEFINITIONSPLEGALENTITY
ORGORGANIZATIONDEFINITIONSPORGANIZATIONCODE
ORGORGANIZATIONDEFINITIONSPORGANIZATIONID
ORGORGANIZATIONDEFINITIONSPORGANIZATIONNAME
ORGORGANIZATIONDEFINITIONSPSETOFBOOKSID
ORGANIZATIONID
ORGANIZATIONPARAMETERPEOALLOWNEGONHANDCCTXNS
ORGANIZATIONPARAMETERPEOBUSINESSUNITID


As seen from the list of columns they are not following alphabetic order.
 

Solution

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
Goal
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.