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

Bi Cloud Extract is returning different amount of lines with same parameters

Summary:

BICC Extract Difference in amount of lines using same parameters

Content (please ensure you mask any confidential information):

I'm using BI Cloud Connector, data extract "FscmTopModelAM.FinXlaJrnlEnterJrnlAM.JournalEntryLinePVO" to extract XLA Lines.With Option "Use UNION ALL for incremental extract" uncheked and query filter "(TIMESTAMPDIFF(SQL_TSI_DAY, DATASTORE.XlalinesLastUpdateDate,CURRENT_DATE) <= 5)" to extract lines from 5 days before.

However, executing one after another manually, shown very different amount of lines. In an example the first run show 858301 (resetting the data store), and 5 minutes later, executing the same datastore with same parameters show 214052. I'm expecting a similar number of lines as there has not been recent lines in that time frame.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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