select count(*) should equal the # of rows select *

gbacskai

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Deloitte Touche Tohmatsu (Deloitte Australia)

Description (Required):

When using OTBI the Following quieries should give back consitent results:

select count(*) from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t

Result: Count = 565

select * from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t

Result: 4 rows

Use Case and Business Need (Required):

• Simple reconciliation
• When I extracted rows via BICC should check it in the source system the extract is correct

Enhancement Request / Service Request:

OTBI

User_VDCKG

Hey gbacskai did you ever figure out how to reconcile this? :D