Projects Rest API giving duplicates

Radhika Sharma

Below is a Rest API we are using to get Projects data with filters but the response is giving duplicate records. Please let me know what is wrong here.

Rest API below:

/fscmRestApi/resources/11.13.18.05/projects?expand=ProjectDFF&q=ProjectStatusCode NOT IN ('300000006959687','CLOSED') and BusinessUnitId=300000006931006 and (OwningOrganizationName='1025 21200 Memphis, TN' OR OwningOrganizationName='1025 20280 Philadelphia, PA' OR OwningOrganizationName='1025 20200 New York, NY' OR OwningOrganizationName='1025 20140 Providence, RI' OR OwningOrganizationName='1025 20080 Buffalo, NY') and ProjectManagerResourceId=300000009438039&orderBy=ProjectNumber&onlyData=true&offset=0&limit=25

Sumanth V -Oracle

@Radhika Sharma - You have posted this question in FDI(FAW) community. Please post your question in FA-OTBI community as this is specific to FusionApps-OTBI.
For your reference - Following is link to FA-OTBI Community

Oracle Fusion Cloud Customer Connect:

https://community.oracle.com/customerconnect

Radhika Sharma

Sure, thanks, will ask my question there.