// fusionrest agent · project management

Project Contract Bill Transactions

projectContractBillTransactions Based on 26C

Look up Project Contract Bill Transactions, with action history. Actions include bulk change status to non billable and bulk change status to on hold. Changes only through its actions.

The record key projectContractBillTransactionsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/fscmRestApi/resources/11.13.18.05/projectContractBillTransactions
Operations
GET (list)GET (one)9 actions
Record key
projectContractBillTransactionsUniqID
Required on create
no create on this resource
At a glance
194 fields0 finders1 children
Extra parameters
?effectiveDate=Effective-Of:
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/projectContractBillTransactions?fields=AmountToBillInContractCurrency,AmountToBillInInvoiceCurrency,AmountToBillInTransactionCurrency,ApplicableProcessCode,BillPlanId&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AmountToBillInContractCurrency": 0,
      "AmountToBillInInvoiceCurrency": 0,
      "AmountToBillInTransactionCurrency": 0,
      "ApplicableProcessCode": "<string, max 1>",
      "BillPlanId": 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 194

AttributeTypeUse
AmountToBillInContractCurrencynumber
AmountToBillInInvoiceCurrencynumber
AmountToBillInTransactionCurrencynumberSearchable
ApplicableProcessCodetext · max 1Searchable
BillPlanIdnumberRead-onlySearchable
BillPlanNametext · max 30Read-onlySearchable
BillRatenumberSearchable
BillToCustomertext · max 360Read-onlySearchable
BillTransactionIdnumberSearchable
BillingEventIdnumberRead-onlySearchable
BillingJobCodetext · max 30Read-onlySearchable
BillingJobIdnumberRead-onlySearchable
BillingJobNametext · max 240Read-onlySearchable
BillingJobTitleOverridetext · max 80Searchable
BillingPersonIdnumberRead-onlySearchable
BillingPersonNametext · max 255Read-onlySearchable
BillingPersonTitleOverridetext · max 80Searchable
BillingResourceNametext · max 240Read-onlySearchable
BillingStatustext · max 80Read-onlySearchable
BillingStatusCodetext · max 30Searchable
BillingTypetext · max 80Read-onlySearchable
BillingTypeCodetext · max 30Searchable
ConcessionPercentagenumberSearchable
ContractBusinessUnitIdnumberRead-onlySearchable
ContractBusinessUnitNametext · max 240Read-onlySearchable
ContractContributionPercentagenumberSearchable
ContractCurrencyCodetext · max 30Searchable
ContractCurrencyConcessionAmountnumberSearchable
ContractCurrencyInvoiceAmountnumberSearchable
ContractCurrencyInvoiceCreditAmountnumberSearchable
ContractCurrencyInvoiceEligibleAmountnumberSearchable
ContractCurrencyInvoiceExchangeDatedateSearchable
ContractCurrencyInvoiceExchangeRatenumberSearchable
ContractCurrencyInvoiceQualifiedAmountnumberSearchable
ContractCurrencyInvoiceRateTypetext · max 30Read-onlySearchable
ContractCurrencyInvoiceRateTypeCodetext · max 30Searchable
ContractCurrencyInvoicedAmountnumberSearchable
ContractCurrencyRevenueAmountnumberSearchable
ContractCurrencyRevenueCreditedAmountnumberSearchable
ContractCurrencyRevenueEligibleAmountnumberSearchable
ContractCurrencyRevenueExchangeDatedateSearchable
ContractCurrencyRevenueExchangeRatenumberSearchable
ContractCurrencyRevenueQualifiedAmountnumberSearchable
ContractCurrencyRevenueRateTypetext · max 30Read-onlySearchable
ContractCurrencyRevenueRateTypeCodetext · max 30Searchable
ContractCurrencyRevenueRecognizedAmountnumberSearchable
ContractCurrencyWriteoffAmountnumberSearchable
ContractIdnumberRead-onlySearchable
ContractLineIdnumberRead-onlySearchable
ContractLineNametext · max 1995Read-onlySearchable
ContractLineNumbertext · max 150Read-onlySearchable
ContractMajorVersionnumberSearchable
ContractNametext · max 300Read-onlySearchable
ContractNumbertext · max 120Read-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CustomerPONumbertext · max 50Read-onlySearchable
EventTypeIdnumberRead-onlySearchable
EventTypeNametext · max 240Read-onlySearchable
ExpenditureCategoryIdnumberRead-onlySearchable
ExpenditureCategoryNametext · max 240Read-onlySearchable
ExpenditureTypeIdnumberRead-onlySearchable
ExpenditureTypeNametext · max 240Read-onlySearchable
InventoryItemtext · max 300Read-onlySearchable
InventoryItemIdnumberSearchable
InvoiceBilledPercentagenumberSearchable
InvoiceCreditedQuantitynumberSearchable
InvoiceCurrencyAmountnumberSearchable
InvoiceCurrencyBilledAmountnumberSearchable
InvoiceCurrencyCodetext · max 30Searchable
InvoiceCurrencyConcessionAmountnumberSearchable
InvoiceCurrencyCreditedAmountnumberSearchable
InvoiceCurrencyEligibleAmountnumberSearchable
InvoiceCurrencyExchangeDatedateSearchable
InvoiceCurrencyExchangeDateTypeCodetext · max 30Searchable
InvoiceCurrencyExchangeRatenumberSearchable
InvoiceCurrencyQualifiedAmountnumberSearchable
InvoiceCurrencyRateTypetext · max 30Read-onlySearchable
InvoiceCurrencyRateTypeCodetext · max 30Searchable
InvoiceCurrencyWriteoffAmountnumberSearchable
InvoiceDatedateSearchable
InvoiceDiscountPercentagenumberSearchable
InvoiceDiscountReasontext · max 80Read-onlySearchable
InvoiceDiscountReasonCodetext · max 30Searchable
InvoiceDistributedCodetext · max 1Searchable
InvoiceLaborMultipliernumberSearchable
InvoiceMarkupPercentagenumberSearchable
InvoiceMethodClassificationCodetext · max 30Read-onlySearchable
InvoiceMethodIdnumberRead-onlySearchable
InvoiceNetZeroFlagyes/no
InvoiceQualifiedQuantitynumberSearchable
InvoiceQuantitynumberSearchable
InvoiceRateSourceIdnumberSearchable
InvoiceRateSourceTypetext · max 80Read-onlySearchable
InvoiceRateSourceTypeCodetext · max 30Searchable
InvoiceTransferPriceRulePercentagenumberSearchable
InvoiceTransferPriceScheduleLinePercentagenumberSearchable
InvoiceWriteoffPercentagenumberSearchable
InvoicedQuantitynumberSearchable
ItemOrganizationIdnumberSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LinkedProjectIdnumberSearchable
LinkedProjectNametext · max 240Read-onlySearchable
LinkedProjectNumbertext · max 25Read-onlySearchable
LinkedTaskIdnumberSearchable
LinkedTaskNametext · max 255Read-onlySearchable
LinkedTaskNumbertext · max 100Read-onlySearchable
MigrationFlagyes/no
NetCreditFlagyes/noSearchable
NonlaborResourcetext · max 240Read-onlySearchable
NonlaborResourceIdnumberRead-onlySearchable
Organizationtext · max 255Read-only
OrganizationIdnumberSearchable
PendingInvoiceAdjustmentFlagyes/noSearchable
PendingRevenueAdjustmentFlagyes/no
ProjectIdnumberSearchable
ProjectNametext · max 240Read-onlySearchable
ProjectNumbertext · max 25Read-onlySearchable
ProviderLegalEntitytext · max 240Read-onlySearchable
ProviderLegalEntityIdnumberRead-onlySearchable
ProviderLegalEntityIdentifiertext · max 30Read-onlySearchable
RBSElementIdnumberSearchable
RecalculateInvoiceFlagyes/noSearchable
RecalculateRevenueFlagyes/noSearchable
ReceiverLegalEntitytext · max 240Read-onlySearchable
ReceiverLegalEntityIdnumberRead-onlySearchable
ReceiverLegalEntityIdentifiertext · max 30Read-onlySearchable
RevenueCategorytext · max 80Read-onlySearchable
RevenueCategoryCodetext · max 30Searchable
RevenueCurrencyAmountnumberSearchable
RevenueCurrencyCreditedAmounttextSearchable
RevenueCurrencyEligibleAmountnumberSearchable
RevenueCurrencyQualifiedAmountnumberSearchable
RevenueCurrencyRecognizedAmountnumberSearchable
RevenueDiscountPercentagenumberSearchable
RevenueDiscountReasontext · max 80Read-onlySearchable
RevenueDiscountReasonCodetext · max 30Searchable
RevenueLaborMultipliernumberSearchable
RevenueMarkupPercentagenumberSearchable
RevenueMethodClassificationCodetext · max 30Read-onlySearchable
RevenueMethodIdnumberRead-onlySearchable
RevenueNetZeroFlagyes/no
RevenuePlanIdnumberRead-onlySearchable
RevenuePlanNametext · max 30Read-onlySearchable
RevenueQualifiedQuantitynumberSearchable
RevenueQuantitynumberSearchable
RevenueRateSourceIdnumberSearchable
RevenueRateSourceTypetext · max 80Read-onlySearchable
RevenueRateSourceTypeCodetext · max 30Searchable
RevenueRecognizedtext · max 80Read-onlySearchable
RevenueRecognizedCodetext · max 1Searchable
RevenueRecognizedDatedateSearchable
RevenueRecognizedPercentagenumberSearchable
RevenueRecognizedQuantitynumberSearchable
RevenueTransferPriceRulePercentagenumberSearchable
RevenueTransferPriceScheduleLinePercentagenumberSearchable
SourceTransactionIdnumberSearchable
SourceTransactionNumbernumberRead-only
SourceTransactionTypetext · max 80Read-onlySearchable
SourceTransactionTypeCodetext · max 30Searchable
StatusReasontext · max 255Read-onlySearchable
StatusReasonCodetext · max 30Searchable
StatusReasonTypetext · max 255Read-onlySearchable
TaskIdnumberSearchable
TaskNametext · max 255Read-onlySearchable
TaskNumbertext · max 100Read-onlySearchable
TransactionCurrencyBilledAmountnumberSearchable
TransactionCurrencyCodetext · max 30Searchable
TransactionCurrencyConcessionAmountnumberSearchable
TransactionCurrencyInvoiceCreditAmountnumberSearchable
TransactionCurrencyInvoiceEligibleAmountnumberSearchable
TransactionCurrencyInvoiceQualifiedAmountnumberSearchable
TransactionCurrencyInvoiceTransactionAmountnumberSearchable
TransactionCurrencyInvoiceUnitPricenumberSearchable
TransactionCurrencyRevenueAmountnumberSearchable
TransactionCurrencyRevenueCreditedAmountnumberSearchable
TransactionCurrencyRevenueEligibleAmountnumberSearchable
TransactionCurrencyRevenueQualifiedAmountnumberSearchable
TransactionCurrencyRevenueRecognizedAmountnumberSearchable
TransactionCurrencyRevenueUnitPricenumberSearchable
TransactionCurrencyWriteoffAmountnumberSearchable
TransactionDatedateSearchable
TransferPriceBaseAmountnumberSearchable
TransferPriceRuleBasistext · max 80Read-onlySearchable
TransferPriceRuleBasisCodetext · max 30Searchable
TransferPriceScheduleAmountTypetext · max 80Read-onlySearchable
TransferPriceScheduleAmountTypeCodetext · max 30Searchable
UnitOfMeasuretext · max 80Read-onlySearchable
UnitOfMeasureCodetext · max 30Searchable
UnitPriceInContractCurrencynumber
UnitPriceInInvoiceCurrencynumber
WorkTypetext · max 240Read-onlySearchable
WorkTypeIdnumberRead-onlySearchable

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/projectContractBillTransactions/{projectContractBillTransactionsUniqID}/child/<name>. Add them to a GET with expand.

Actions 9

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls