Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bi Cloud Extract is returning different amount of lines with same parameters
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.
Answers
-
Hi @User_SS8G8,
Welcome to the Oracle Analytics Community!
Please note this community is for Oracle Analytics tools like FDI, OAC, OTBI, BIP etc.
Your query is about BICC and BICC is a Fusion product. Please raise your question in the below community which will be the best suited and someone will be able to help you.
Thank you.
0
