Can DFF VO's be used as a source for Data Augmentation

Question

Summary:

It seems that the requirement to whitelist VO's in order to use them as a source in data augmentations is not there anymore. Does any one know which release onwards this option is available.

Also, does that mean we can  access any of the DFF related VO's through data augmentation? Currently, the list of DFF VO's are limited, and, the one i am looking for(FscmTopModelAM.POHeaderDFFPublicBIAM.FLEX_BI_POHeaderDFFPublic_VI) is not available.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Venkat Koduvayur-Oracle · Answer

Hi

In such cases, when there is missing last update date/create date in the PVO, do a full data extract of the PVO and do a comparison with last extract with current extract to identify the delta changes (MINUS operation) in the target system/extraction process.

The PK of this PVO is Fullfilllineid

Other method is to use BIPublisher to extract on the base table DOO_FULFILL_LINES_EFF_B  of the PVO and do the incremental extract by referring the last update columns.  Will recommend this method if there are many missing columns in the PVO along with the need for last update/creation date for incremental data extraction..

Hope this helps

Regards

Venkat

Ram Bolisetty · Answer

@Venkat Koduvayur-Oracle what do to if the view object does not have either last updated or creation dates to define extract and incremental keys? for example "FscmTopModelAM.DooTopAM.FulfillLineBIEffEFFBIFlattened" view object? how do we solve this issue?

thanks,

Ram

Amrita Gupta-Oracle · Answer

Hi Venkat,

My query was in relation with FAW. The VO is available in OTBI, however was not coming up in the list of System Provided PVO's while created a Data Augmentation.

Figured out that it is available when we select Customer Provided as an option, and, type the PVO name in.