Genealogy Objects
genealogyObjects Based on 26C
Create, change and look up Genealogy Objects, with genealogy transactions.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)
- Record key
GenealogyInstanceId- Required on create
CurrentLocationContextItemIdOperatingOrganizationIdQuantityUOMCode- At a glance
- 52 fields0 finders1 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/genealogyObjects?fields=CurrentLocationCode,CurrentLocationContext,CurrentLocationId,CurrentLocationName,CustomerId&limit=25&onlyData=true
{
"items": [
{
"CurrentLocationCode": "<string>",
"CurrentLocationContext": "<string, max 80>",
"CurrentLocationId": 0,
"CurrentLocationName": "<string, max 255>",
"CustomerId": 0
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 52
| Attribute | Type | Use |
|---|---|---|
CurrentLocationCode | text | Optional on createUpdatableSearchable |
CurrentLocationContext | text · max 80 | Required on createSearchable |
CurrentLocationId | number | Optional on createUpdatableSearchable |
CurrentLocationName | text · max 255 | Read-onlySearchable |
CustomerId | number | Optional on createUpdatableSearchable |
CustomerName | text | Optional on createUpdatableSearchable |
CustomerNumber | text | Optional on createUpdatableSearchable |
CustomerSiteId | number | Optional on createUpdatableSearchable |
CustomerSiteName | text · max 255 | Optional on createUpdatableSearchable |
CustomerSiteNumber | text · max 255 | Optional on createUpdatableSearchable |
CustomerSitePartyId | number | Optional on createUpdatableSearchable |
CustomerSitePartyName | text · max 255 | Optional on createUpdatableSearchable |
CustomerSitePartyNumber | text · max 255 | Optional on createUpdatableSearchable |
ExternalLocation | text · max 240 | Optional on createUpdatableSearchable |
ExternalSystemPackingUnit | text · max 150 | Optional on createUpdatableSearchable |
GenealogyInstanceId | number | Optional on createSearchable |
InventoryLocatorId | number | Optional on createUpdatableSearchable |
ItemId | number | Required on createSearchable |
ItemNumber | text | Optional on createSearchable |
LocationOrganization | text · max 240 | Read-onlySearchable |
LocationOrganizationCode | text · max 255 | Optional on createUpdatableSearchable |
LocationOrganizationCodeNU | text · max 18 | Read-onlySearchable |
LocationOrganizationId | number | Optional on createUpdatableSearchable |
LotNumber | text · max 80 | Optional on createSearchable |
OperatingOrganization | text · max 240 | Read-onlySearchable |
OperatingOrganizationCode | text | Optional on createSearchable |
OperatingOrganizationId | number | Required on createSearchable |
OriginationDate | date-time | Optional on createUpdatableSearchable |
OriginationDocumentNumber | text | Optional on createUpdatableSearchable |
OriginationDocumentType | text | Optional on createUpdatableSearchable |
OriginationQuantity | number | Read-onlySearchable |
Quantity | number | Required on createUpdatableSearchable |
SerialNumber | text · max 80 | Optional on createSearchable |
SourceSystem | text | Optional on createUpdatable |
SourceSystemId | number | Optional on createUpdatableSearchable |
SourceSystemType | text | Optional on createUpdatableSearchable |
SourceSystemTypeCode | text | Optional on createUpdatable |
Subinventory | text · max 30 | Optional on createUpdatableSearchable |
SupplierId | number | Optional on createUpdatableSearchable |
SupplierName | text | Optional on createUpdatableSearchable |
SupplierNumber | text · max 30 | Read-onlySearchable |
SupplierSiteId | number | Optional on createUpdatableSearchable |
SupplierSiteName | text | Optional on createUpdatableSearchable |
UOMCode | text · max 3 | Required on createSearchable |
UnitOfMeasure | text · max 25 | Read-onlySearchable |
WorkCenterCode | text | Optional on createUpdatableSearchable |
WorkCenterId | number | Optional on createUpdatableSearchable |
WorkCenterName | text · max 120 | Read-onlySearchable |
WorkOrderId | number | Optional on createUpdatableSearchable |
WorkOrderNumber | text · max 255 | Optional on createUpdatableSearchable |
WorkOrderOperation | text · max 255 | Optional on createUpdatableSearchable |
WorkOrderOperationId | number | Optional on createUpdatableSearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 1
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/genealogyObjects/{GenealogyInstanceId}/child/<name>. Add them to a GET with expand.
genealogyTransactionsGET · POST Genealogy Transactions · 48 fieldsCustomerIdCustomerNameCustomerNumberCustomerSiteIdCustomerSiteNameCustomerSiteNumberCustomerSitePartyCustomerSitePartyIdCustomerSitePartyNumberDocumentDocumentTypeExternalLocationGenealogyTransactionIdInventoryLocatorIdLocationCodeLocationContextLocationIdLocationNameLocationOrganizationLocationOrganizationCodeLocationOrganizationIdOrganizationOrganizationCodeOrganizationIdQuantitySourceSystemSourceSystemIdSourceSystemTypeSourceSystemTypeCodeSourceTransactionDateSourceTransactionIdSourceTransactionTypeSourceTransactionTypeIdSubinventorySupplierIdSupplierNameSupplierNumberSupplierSiteIdSupplierSiteNameUOMCodeUnitOfMeasureWorkCenterCodeWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderNumberWorkOrderOperationWorkOrderOperationId
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/genealogyObjectsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:CurrentLocationCode, notcurrentlocationcode. - 8 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.