Does BICC query returns live data?
Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source?
select distinct TransactionEntitySourceIdInt1, XlahdrGlTransferDate, XlahdrGlTransferStatusCode
from EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinXlaJrnlEnterJrnlAM.SubledgerJournalDistributionPVO' as t
where TRANSACTIONENTITYTRANSACTIONNUMBER in ('58492574','58481841','58494315','58495789','58473056','58473060','58473061')
order by 1
This query returned no ressult, but business user told me that they have those transactions in the ledger.
Tagged:
0