Supported operations
| GET /dataSecurities |
| GET /dataSecurities/{id} |
| PATCH /dataSecurities/{id} |
| POST /dataSecurities |
Finders (2)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| ManageDataAccessRF | — |
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/dataSecurities?finder=ManageDataAccessRF Queryable q fields (16)
Only these fields can appear in a q filter expression on
/dataSecurities. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/dataSecurities?q=CreatedBy='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| ActiveFlag | boolean | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| RoleCommonName | string | = != |
| RoleNameCr | string | = != |
| Rolerf | string | = != |
| SecurityContext | string | = != |
| SecurityContextValue | string | = != |
| SecurityContextValue2 | string | = != |
| SecurityContextValue3 | string | = != |
| UserName | string | = != |
| UserRoleDataAssignmentId | integer | = != |
| Userrf | string | = != |
Response fields (16)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
ActiveFlagCreatedByCreationDateLastUpdateDateLastUpdateLoginLastUpdatedByRoleCommonNameRoleNameCrRolerfSecurityContextSecurityContextValueSecurityContextValue2SecurityContextValue3UserNameUserRoleDataAssignmentIdUserrf Build this query visually in OPAL
OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.
Related reference & reading
- /localizationDocumentSequenceDerivations Get all document sequence derivation records
- /jointVentureContributionRequests Get all joint venture partner contribution requests
- /buyerInitiatedEarlyPaymentOffers Get all standing early payment offer
- /fedBudgetExecutionControls Get all budget execution controls
- /jointVentureOperationalMeasures Get all operational measures for the joint venture journal
- Oracle Fusion API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages