Oracle Fusion FSCM endpoint reference

Auto Invoice Interface Lines REST API

Get all AutoInvoice interface lines

GET https://your-pod.oraclecloud.com/fscmRestApi/resources/11.13.18.05/autoInvoiceInterfaceLines

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud FSCM: 20 queryable q fields, and 3 child resources. Unsure how q works? See the Oracle Fusion API guide.

Supported operations

GET /autoInvoiceInterfaceLines
GET /autoInvoiceInterfaceLines/{id}
PATCH /autoInvoiceInterfaceLines/{id}

Queryable q fields (20)

Only these fields can appear in a q filter expression on /autoInvoiceInterfaceLines. Filtering on any other field returns 400 Bad Request.

Example q request

GET /fscmRestApi/resources/11.13.18.05/autoInvoiceInterfaceLines?q=BusinessUnit='<value>'&onlyData=true&limit=25
Field Type Operators
Amount number = !=
BusinessUnit string = !=
CurrencyCode string = !=
Description string = !=
InterfaceLineGUID string = !=
InterfaceLineStatus string = !=
InternalNotes string = !=
LastUpdateLogin string = !=
LineType string = !=
OrgId integer = !=
PaymentTerms string = !=
PaymentTermsId integer = !=
Quantity number = !=
TaxCode string = !=
TransactionBatchSource string = !=
TransactionDate string = !=
TransactionNumber string = !=
TransactionType string = !=
TransactionTypeSequenceId integer = !=
UnitSellingPrice number = !=

Child resources (3)

Each child is reachable at /autoInvoiceInterfaceLines/{id}/child/<name> and most can also be inlined with expand.

autoInvoiceHeaderInformationDFFautoInvoiceInterfaceLineTransactionDFFautoInvoiceLineInformationDFF

Response fields (24)

Top-level attributes returned for each row. Use fields= to request a subset and shrink the payload.

AmountAuthorizationNumberBusinessUnitCurrencyCodeDescriptionInterfaceLineGUIDInterfaceLineStatusInternalNotesLastUpdateLoginLineTypeOrgIdPaymentTermsPaymentTermsIdQuantityTaxCodeTransactionBatchSourceTransactionDateTransactionNumberTransactionTypeTransactionTypeSequenceIdUnitSellingPriceautoInvoiceHeaderInformationDFFautoInvoiceInterfaceLineTransactionDFFautoInvoiceLineInformationDFF

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