1. REST API for Oracle Fusion Cloud Project Management
  2. Tasks
  3. Project Contract Invoices

Get a project contract invoice

get

/fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}

Request

Path Parameters
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : projectContractInvoices-item-response
Type: object
Show Source
  • Title: Accepted Date
    Read Only: true
    The date and time when the invoice was accepted.
  • Title: Accounting Date
    Read Only: true
    The date within a General Ledger (GL) accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice process and it is the date of the first future or open GL period in Oracle Receivables for the invoice date.
  • Title: Accounting Period
    Read Only: true
    Maximum Length: 15
    Name of the General Ledger (GL) period for the GL Date attribute.
  • Title: Approved By
    Read Only: true
    Name of the person who approved the invoice.
  • Title: Approved by Person ID
    Read Only: true
    Unique identifier of the person who approved the invoice.
  • Title: Approved Date
    Read Only: true
    The date on which the invoice is approved.
  • Title: Invoice Transfer Status to Payables
    Read Only: true
    Maximum Length: 1
    Indicates the status of the transfer of the invoice to Accounts Payable (AP). Valid values are P - Pending, A - Accepted, and R - Rejected.
  • Project Contract Invoices Attachments
    Title: Project Contract Invoices Attachments
    The attachments resource is used to view, create, update and delete attachments for project contract invoices.
  • Title: Bill from Date
    Read Only: true
    The date through which to invoice the project. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill through date may be included on an invoice.
  • Title: Billing Type
    Read Only: true
    Maximum Length: 30
    Indicates the code used to classify the type of billing. Valid values are EX - External, IP - Interproject, and IC - Intercompany.
  • Title: Bill Set
    Read Only: true
    Identifier of a set of invoices created together in the same run which must be released at the same time.
  • Title: Bill-to Account Number
    Read Only: true
    Maximum Length: 30
    Account number of the bill-to customer.
  • Title: Bill-to Address
    Read Only: true
    Address of the bill-to customer.
  • Title: Bill-to Contact ID
    Read Only: true
    Unique identifier of the contact who is a representative for the bill-to customer on the bill plan.
  • Title: Bill-to Contact
    Read Only: true
    Maximum Length: 255
    Name of the contact who is a representative for the bill-to customer on the bill plan.
  • Title: Bill-to Customer ID
    Read Only: true
    Unique identifier of the bill-to customer on the invoice.
  • Title: Bill-to Customer
    Read Only: true
    Maximum Length: 240
    Name of the bill-to customer on the invoice.
  • Title: Bill-Through Date
    Read Only: true
    The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill through date may be included on an invoice.
  • Title: Bill-to Site
    Read Only: true
    Maximum Length: 150
    Address of the bill-to customer.
  • Title: Bill-to Site ID
    Read Only: true
    Unique identifier of the customer address.
  • Title: Canceled
    Read Only: true
    Maximum Length: 1
    Indicates that the invoice was cancelled.
  • Title: Contract ID
    Read Only: true
    Unique identifier of the contract for the invoice.
  • Title: Contract Number
    Read Only: true
    Maximum Length: 120
    Number that uniquely identifies the contract for the invoice.
  • Title: Contract Type ID
    Read Only: true
    Unique identifier for the contract type.
  • Title: Contract Type
    Read Only: true
    Maximum Length: 150
    Name of the contract type for the contract on the invoice.
  • Title: Credited Invoice ID
    Read Only: true
    Unique identifier of the invoice that is credited by this invoice.
  • Title: Credited Invoice Number
    Read Only: true
    Number of the credited Invoice.
  • Title: Credit Memo Reason Code
    Maximum Length: 30
    Indicates the code for the reason to create a credit memo.
  • Title: Credit Memo Reason
    Read Only: true
    Maximum Length: 80
    Indicates the reason for creating the credit memo.
  • Title: Document Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a document on the bill plan of a grants contract.
  • Title: Document Subtype
    Maximum Length: 240
    A classification that is assigned to documents such as an invoice or a credit memo. Example subtypes are Domestic Invoice and Foreign Invoice.
  • Title: Exception
    Maximum Length: 1
    Indicates that exceptions have occurred for the invoice or for lines on the invoice. Valid values are E - Error, W - Warning, and N - No error.
  • Title: Export Process ID
    Read Only: true
    Unique identifier of the Export Invoice Details job used to export invoice attributes to a CSV file.
  • Title: Amount in Invoice Currency
    Read Only: true
    Amount in the invoice currency.
  • Title: Invoice Comment
    Maximum Length: 240
    Free text field for comments that can be printed on an invoice. The default value is the invoice comment defined for the project.
  • Title: Invoice Currency
    Read Only: true
    Maximum Length: 30
    Indicates the currency code for the invoice that is transferred to Oracle Receivables.
  • Title: Date
    The invoice date passed to Oracle Receivables, which is used to calculate the invoice due date. Upon release of the invoice, the default value is the released date. You can override the invoice date at the time of release.
  • Invoice Header Descriptive Flexfields
    Title: Invoice Header Descriptive Flexfields
    A listing of all the descriptive flexfields available for project contract invoices.
  • Title: Invoice ID
    Read Only: true
    Unique identifier of the invoice.
  • Title: Billing Instructions
    Maximum Length: 240
    Free text field to enter instructions for invoice billing.
  • Invoice Lines
    Title: Invoice Lines
    The Invoice Lines resource is used to view the details of the invoice lines.
  • Title: Number
    Read Only: true
    The sequential number that identifies the invoice within a project contract.
  • Title: Invoice Status Code
    Maximum Length: 30
    Default Value: DRAFT
    Indicates the code for the status of the invoice. Valid values are SUBMITTED, APPROVAL_REJECTED, RELEASED, DRAFT, REJECTED, TRANSFERRED, ACCEPTED, and APPROVED.
  • Title: Status
    Read Only: true
    Maximum Length: 80
    Indicates the meaning of the value in the Invoice Status Code attribute. A list of valid values is defined in the lookup type PJB_INVOICE_STATUS_TYPE. Valid values are Accepted, Rejected, Approved, Draft, Transfer rejected, Released, Submitted, or Transferred. You can either enter this attribute or Invoice Status Code.
  • Title: Invoice Type Code
    Read Only: true
    Maximum Length: 30
    Indicates the code for the type of the invoice. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.
  • Title: Invoice Type
    Read Only: true
    Maximum Length: 80
    The meaning of the value of the Invoice Type Code attribute. Valid values are Standard, Credit Memo, Write-Off, Net Invoice, or Canceled.
  • Title: Last Unreleased by Person
    Read Only: true
    Name of the person who last unreleased the invoice.
  • Title: Last Unreleased by Person ID
    Unique identifier of the person who last unreleased the invoice.
  • Title: Last Unreleased Date
    The date and time when the invoice was last unreleased.
  • Links
  • Title: LOC Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a letter of credit on the bill plan of a grants contract.
  • Title: Contract Version
    Read Only: true
    Indicates the version number of the contract.
  • Title: Migration Invoice
    Read Only: true
    Maximum Length: 1
    Indicates a migration type of invoice.
  • Title: Net Credit
    Read Only: true
    Maximum Length: 1
    Indicator of net credit on the invoice. Valid values are Y - True and N - False.
  • Title: Net Invoice
    Read Only: true
    Maximum Length: 1
    Indicator of net invoice on the invoice. Valid values are Y - True and N - False.
  • Title: Organization ID
    Read Only: true
    Unique identifier of the business unit associated with the invoice.
  • Title: Business Unit
    Read Only: true
    Maximum Length: 240
    Name of the business unit associated with the invoice.
  • Title: Project Accounting Date
    Read Only: true
    The end date of the Project Accounting (PA) period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice.
  • Title: Project Accounting Period
    Read Only: true
    Maximum Length: 15
    Name of the Project Accounting (PA) period for the invoice.
  • Title: Project ID
    Read Only: true
    Unique identifier of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • Title: Project Name
    Read Only: true
    Name of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • Title: Project Number
    Read Only: true
    Number of the project associated to the invoice.This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • Title: Receivables Number
    Maximum Length: 20
    The Oracle Receivables invoice number that is determined upon release of the invoice and passed to Oracle Receivables upon transfer. This number can be user-entered in the application or system-generated as defined in the implementation options.
  • Title: Receiver Setup Code
    Read Only: true
    Maximum Length: 30
    Indicates if the invoice is for global projects of a receiver business unit. The value is IC_NON_GLOBAL for non global projects and blank for all other scenarios.
  • Title: Rejected By
    Read Only: true
    Name of the person who rejected the invoice.
  • Title: Rejected by Person ID
    Read Only: true
    Unique identifier of the person who rejected the invoice.
  • Title: Rejected Date
    Read Only: true
    The date on which the invoice is rejected.
  • Title: Released By
    Read Only: true
    Name of the person who released the invoice.
  • Title: Released by Person ID
    Unique identifier of the person who released the invoice.
  • Title: Released Date
    The date on which the invoice was released for transfer.
  • Title: Report Type Code
    Read Only: true
    Maximum Length: 30
    Indicates the code of the Federal report type specified in the bill plan.
  • Title: Submitted by Person
    Read Only: true
    Name of the person who submitted the invoice for approval.
  • Title: Submitted by Person ID
    Unique identifier of the person who submitted the invoice for approval.
  • Title: Submitted Date
    The date and time when the invoice was submitted for approval.
  • Title: System Reference
    Read Only: true
    Indicates the reference to the invoice created in Oracle Receivables from the draft invoice. The Confirm Invoice Acceptance Status in Receivables process populates the value and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID.
  • Title: Tax Amount in Invoice Currency
    Read Only: true
    The total tax amount in the invoice currency.
  • Title: Taxation Country
    Maximum Length: 2
    The country of taxation for calculating tax.
  • Title: Transfer Date
    Indicates the date on which the invoice is transferred to the Oracle Receivables interface tables.
  • Title: Unrelease Comments
    Maximum Length: 240
    Comments entered by the person who unreleased the invoice.
Nested Schema : Project Contract Invoices Attachments
Type: array
Title: Project Contract Invoices Attachments
The attachments resource is used to view, create, update and delete attachments for project contract invoices.
Show Source
Nested Schema : Invoice Header Descriptive Flexfields
Type: array
Title: Invoice Header Descriptive Flexfields
A listing of all the descriptive flexfields available for project contract invoices.
Show Source
Nested Schema : Invoice Lines
Type: array
Title: Invoice Lines
The Invoice Lines resource is used to view the details of the invoice lines.
Show Source
Nested Schema : projectContractInvoices-Attachments-item-response
Type: object
Show Source
Nested Schema : projectContractInvoices-InvoiceHeaderDff-item-response
Type: object
Show Source
Nested Schema : projectContractInvoices-InvoiceLines-item-response
Type: object
Show Source
  • Title: Invoice AP Transfer Error Code
    Read Only: true
    Maximum Length: 80
    Indicates the code related to transfer errors between project billing and Accounts Payable (AP). The Invoice Transfer Error Message attribute contains a description of the error.
  • Title: Invoice Transfer Status to Payables
    Read Only: true
    Maximum Length: 1
    Indicates the status of the transfer of the invoice to Accounts Payable (AP). Valid values are P - Pending, A - Accepted, and R - Rejected.
  • Title: Assessable Value
    An optional value for an assessable value for the transaction line for estimated tax purposes.
  • Title: Bill Plan ID
    Read Only: true
    Unique identifier of the bill plan related to the line.
  • Title: Bill Set
    Read Only: true
    Identifier of a set of invoices created together in the same run which must be released at the same time.
  • Title: Contract Currency
    Read Only: true
    Maximum Length: 30
    Indicates the code of the currency for the contract related to the invoice line.
  • Title: Invoice Amount in Contract Currency
    Read Only: true
    Amount in contract currency.
  • Title: Contract Line ID
    Read Only: true
    Unique identifier of the contract line related to the invoice line.
  • Title: Contract Line Number
    Read Only: true
    Maximum Length: 150
    Number that identifies the contract line related to the invoice line if the line represents a single contract line.
  • Title: Credited Invoice Line ID
    Read Only: true
    Unique identifier of the invoice line credited by this invoice line.
  • Title: Document Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a document on the bill plan of a grants contract.
  • Title: Exception
    Read Only: true
    Maximum Length: 1
    Indicates that exceptions have occurred for the invoice line. Valid values are E - Error, W - Warning, and N - No error.
  • Title: Expenditure Organization ID
    Read Only: true
    Unique identifier of the expenditure organization related to the line.
  • Title: Expenditure Type ID
    Read Only: true
    Unique identifier of the expenditure type for the invoice line.
  • Title: Intended Use
    Maximum Length: 240
    A classification of the products by tax authority for tax purposes.
  • Title: Intended Use Classification ID
    Unique identifier of the intended use classification.
  • Title: Invoice Currency
    Read Only: true
    Maximum Length: 30
    Indicates the currency code for the invoice that is transferred to Oracle Receivables.
  • Title: Amount in Invoice Currency
    Read Only: true
    Default Value: 0
    Amount of the invoice line in the invoice currency.
  • Title: Invoice Format ID
    Read Only: true
    Unique identifier of the invoice format.
  • Title: Invoice Format Name
    Read Only: true
    Maximum Length: 30
    Name of the invoice format.
  • Invoice Line Descriptive Flexfields
    Title: Invoice Line Descriptive Flexfields
    A listing of all the descriptive flexfields available for invoice lines.
  • Invoice Line Distributions
    Title: Invoice Line Distributions
    The Invoice Line Distributions resource is used to view the details of invoice line distributions.
  • Title: Invoice Line ID
    Unique identifier of the invoice line.
  • Title: Invoice Line Number
    Number that identifies an invoice line.
  • Title: Invoice Line Type
    Read Only: true
    Maximum Length: 30
    Default Value: STANDARD
    A classification of invoice credit that is assigned to an invoice line. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.
  • Title: Invoice Line Type Meaning
    Read Only: true
    Maximum Length: 80
    Meaning of the invoice line type.
  • Title: Ledger Currency
    Read Only: true
    Maximum Length: 30
    The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency.
  • Title: Invoice Amount in Ledger Currency
    Read Only: true
    Amount of the invoice line in the ledger currency.
  • Title: Invoice Line Description
    Maximum Length: 240
    Description of the invoice line.
  • Title: Associated Project ID
    Read Only: true
    Unique identifier of the project associated to the related contract line or contract lines. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
  • Title: Associated Project Name
    Read Only: true
    Maximum Length: 240
    Name of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
  • Title: Associated Project Number
    Read Only: true
    Maximum Length: 25
    Number of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
  • Title: Associated Task ID
    Read Only: true
    Unique identifier of the project task associated to the related contract line or contract lines. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Task Name or Number.
  • Title: Associated Task Name
    Read Only: true
    Maximum Length: 255
    Name of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
  • Title: Associated Task Number
    Read Only: true
    Maximum Length: 100
    Number of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
  • Links
  • Title: LOC Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a letter of credit on the bill plan of a grants contract.
  • Title: Tax Amount in Invoice Currency
    Read Only: true
    The total tax amount in the invoice currency.
  • Title: Output Tax Classification
    Maximum Length: 150
    A classification of output tax for the invoice line.
  • Title: Output tax exempt
    Maximum Length: 1
    Indicates the use of Standard Exemption rules. Options include Standard, Exempt, or Required. The default is based on user tax setup.
  • Title: Tax Exemption Certificate Number
    Maximum Length: 80
    Identifier of the exemption certificate for item lines that have the Output tax Exempt attribute set to E-exempt.
  • Title: Tax Exemption Reason
    Maximum Length: 30
    Indicates the code for the reason for tax exemption on lines that have the Output tax Exempt attribute set to E-exempt.
  • Title: Payment Term ID
    Read Only: true
    Unique identifier of the payment term for the receipt from Accounts Receivable (AR) which is applied against the agreement.
  • Title: Payment Term
    Read Only: true
    Maximum Length: 15
    Name of the payment term.
  • Title: Product Category
    Maximum Length: 240
    A classification of products used for tax purposes.
  • Title: Product FC Category ID
    Unique identifier of the product fiscal classification category.
  • Title: Product Fiscal Classification
    Maximum Length: 240
    A classification of the products based on the inventory item category by the tax authority for tax purposes.
  • Title: Product Type
    Maximum Length: 240
    This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
  • Title: Receiver Project ID
    Read Only: true
    Unique identifier of the receiver project.
  • Title: Receiver Task ID
    Read Only: true
    Unique identifier of the receiver task.
  • Title: Ship-to Account Description
    Read Only: true
    Account description of the ship-to customer on the invoice line.
  • Title: Ship-to Account Number
    Account number of the ship-to customer on the invoice line.
  • Title: Ship-to Address
    Read Only: true
    Address of the ship-to customer on the invoice line.
  • Title: Ship-to Contact ID
    Read Only: true
    Unique identifier of the ship-to contact. A representative for the ship to customer of the project.
  • Title: Ship-to Customer
    Unique identifier of the customer account ship-to address that is the project customer's default work site for the project.
  • Title: Ship-to Customer
    Read Only: true
    Name of the ship-to customer on the invoice line.
  • Title: Ship-to Site Use ID
    Unique identifier of the ship-to address used for taxation. This attribute is populated only if the invoice formats groups by work site and for events using the work site of the event task.
  • Title: Ship-to Site
    Unique identifier of the ship-to site on the invoice line.
  • Title: Transaction Business Category
    Maximum Length: 240
    A classification or categorization of an invoice line for tax purposes as required by a tax authority.
  • Title: Translated Description
    Maximum Length: 1000
    The translated text of the invoice line. This text is in the language defined in invoice header.
  • Title: User-Defined Fiscal Classification
    Maximum Length: 30
    Indicates the default taxation country.
  • Title: Work Type ID
    Read Only: true
    Unique identifier of the work type.
  • Title: Work Type
    Read Only: true
    Maximum Length: 240
    Name of the work type.
Nested Schema : Invoice Line Descriptive Flexfields
Type: array
Title: Invoice Line Descriptive Flexfields
A listing of all the descriptive flexfields available for invoice lines.
Show Source
Nested Schema : Invoice Line Distributions
Type: array
Title: Invoice Line Distributions
The Invoice Line Distributions resource is used to view the details of invoice line distributions.
Show Source
Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response
Type: object
Show Source
Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response
Type: object
Show Source
  • Title: Billing Extension ID
    Read Only: true
    Unique identifier of billing extension used for the transaction.
  • Title: Billing Job Title
    Read Only: true
    Maximum Length: 80
    Indicates the title for the billing job.
  • Title: Billing Resource ID
    Read Only: true
    Unique identifier of resource breakdown structure element.
  • Title: Bill Job ID
    Read Only: true
    Unique identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced.
  • Title: Bill Plan ID
    Read Only: true
    Unique identifier of the bill plan for the invoice distribution.
  • Title: Bill Rate
    Read Only: true
    Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule.
  • Title: Bill Set
    Read Only: true
    Number of the bill set which is defined in bill plan related to the invoice distribution.
  • Title: Billing Transaction Type Code
    Read Only: true
    Maximum Length: 30
    Indicates the code used to classify the type of bill transaction. Valid values are EI - Expenditure Item or EVT - Billing Event and defined in the lookup PJB_BILL_TRANSACTION_TYPE.
  • Title: Invoice Amount in Contract Currency
    Read Only: true
    Amount billed in currency of the contract.
  • Title: Contract Currency
    Read Only: true
    Maximum Length: 30
    Indicates the code of the currency for the contract related to the distribution.
  • Title: Contract Currency Invoice Date Type
    Read Only: true
    Maximum Length: 30
    Indicates the currency conversion date type used to convert the contract to the invoice currency.
  • Title: Contract Currency Invoice Conversion Date
    Read Only: true
    Indicates the date used for the conversion of the rates on the contract for the invoice.
  • Title: Contract Currency Invoice Conversion Rate
    Read Only: true
    Indicates the rate used to convert the invoice amounts from the transaction currency to the contract currency.
  • Title: Contract Currency Rate Type Code
    Read Only: true
    Maximum Length: 30
    Indicates the code for the contract currency rate type.
  • Title: Contract Line ID
    Read Only: true
    Unique Identifier of the contract line for the invoice distribution.
  • Title: Contract Line Number
    Read Only: true
    Maximum Length: 150
    Number of the contract line for the invoice distribution.
  • Title: Origin of Adjustment
    Read Only: true
    Unique identifier of distribution credited by this distribution.
  • Title: Credited Invoice ID
    Read Only: true
    Unique identifier of invoice that is credited by this distribution.
  • Title: Credited Invoice Line ID
    Read Only: true
    Unique identifier of invoice line that is credited by this distribution.
  • Title: Document Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a document on the bill plan of a grants contract.
  • Title: Employee Billing Title
    Read Only: true
    Maximum Length: 80
    Employee billing title.
  • Title: Intercompany Transfer Price Amount Type
    Read Only: true
    Maximum Length: 30
    Amount type code used for an inter company price amount.
  • Title: Intercompany Transfer Price Base
    Read Only: true
    Maximum Length: 30
    Indicates the intercompany transfer price base code of an intercompany transfer invoice.
  • Title: Intended Use
    Read Only: true
    Maximum Length: 240
    A classification of the products by tax authority for tax purposes.
  • Title: Intended Use Classification ID
    Read Only: true
    Unique identifier of the intended use classification.
  • Title: Invoice Burden Compile Set
    Read Only: true
    Unique identifier of the compiled set used to calculate a burden schedule. This only applies to invoice distributions based on billing event detail.
  • Title: Rate Change Reason
    Read Only: true
    Maximum Length: 30
    Reason code for discount override or rate override.
  • Title: Invoice Distribution Type
    Read Only: true
    Maximum Length: 30
    Indicates the code of the type used to classify invoice distribution. Valid values are WRITE_OFF, CONCESSION, CANCEL, STANDARD, and CREDIT_MEMO.
  • Title: Invoice Distribution Number
    Read Only: true
    Number that identifies the invoice distribution.
  • Title: Invoice Amount Calculation Code
    Read Only: true
    Maximum Length: 30
    Indicates the code for the invoice amount calculation. Valid values are I - Indirect, O - Overrides, E - Extension, B - Bill rates, L - Labor Multiplier.
  • Title: Invoice Amount in Invoice Currency
    Read Only: true
    Amount billed in the Invoice currency amount.
  • Title: Invoice Currency
    Read Only: true
    Maximum Length: 30
    Indicates the currency code for the invoice that is transferred to Oracle Receivables.
  • Title: Invoice Currency Credit Amount
    Read Only: true
    Credit amount in the invoice currency.
  • Title: Credit Percentage in Invoice Currency
    Read Only: true
    Indicates the percent of credit in the invoice currency.
  • Title: Invoice Currency Conversion Date Type
    Read Only: true
    Maximum Length: 30
    Date type of the invoice currency.
  • Title: Invoice Currency Conversion Date
    Read Only: true
    Indicates the exchange date for the conversion of the invoice currency.
  • Title: Invoice Currency Conversion Rate
    Read Only: true
    Exchange rate used for the invoice currency.
  • Title: Invoice Currency Conversion Rate Type
    Read Only: true
    Maximum Length: 30
    Rate type of the invoice currency.
  • Title: Date
    Read Only: true
    The invoice date passed to Oracle Receivables, which is used to calculate the invoice due date. Upon release of the invoice, the default value is the released date. You can override the invoice date at the time of release.
  • Title: Discount Percentage
    Read Only: true
    Indicates a discount percentage, expressed as a proportion multiplied by 100, that is used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.
  • Title: Invoice Distribution ID
    Unique identifier of the invoice distribution.
  • Title: Labor Multiplier
    Read Only: true
    A multiplier that is assigned to the contract line, and is used to calculate the invoice amount for labor items by applying the multipler to the raw cost of the labor items.
  • Title: Markup Percentage
    Read Only: true
    Indicates the markup percentage used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.
  • Title: Invoice Amount in Ledger Currency
    Read Only: true
    Amount billed in the currency of the ledger.
  • Title: Ledger Currency
    Read Only: true
    Maximum Length: 30
    Ledger currency code.
  • Title: Ledger Currency Invoice Date Type
    Read Only: true
    Maximum Length: 30
    Date type of the ledger currency.
  • Title: Ledger Currency Conversion Date
    Read Only: true
    Indicates the conversion date used to convert the invoice to the ledger currency.
  • Title: Ledger Currency Conversion Rate
    Read Only: true
    Indicates the conversion currency rate used to convert the invoice to the ledger currency.
  • Title: Ledger Currency Invoice Rate Type
    Read Only: true
    Maximum Length: 30
    Indicates the conversion currency rate type used to convert the invoice to the ledger currency.
  • Title: Associated Project ID
    Read Only: true
    Unique identifier of project that is linked to the contract line associated to the invoice distribution.
  • Title: Associated Project Name
    Read Only: true
    Maximum Length: 240
    Name of the project that is linked to the contract line associated to the invoice distribution.
  • Title: Associated Project Number
    Read Only: true
    Maximum Length: 25
    Number of the project that is linked to the contract line associated to the invoice distribution.
  • Title: Associated Task ID
    Read Only: true
    Unique identifier of the task that is linked to the contract line associated to the invoice distribution.
  • Title: Associated Task Name
    Read Only: true
    Maximum Length: 255
    Name of the task that is linked to the contract line associated to the invoice distribution.
  • Title: Associated Task Number
    Read Only: true
    Maximum Length: 100
    Number of the project task that is linked to the contract line associated to the invoice distribution.
  • Links
  • Title: LOC Number
    Read Only: true
    Maximum Length: 240
    Number that identifies a letter of credit on the bill plan of a grants contract.
  • Title: Product Category
    Read Only: true
    Maximum Length: 240
    A classification of products used for tax purposes.
  • Title: Product FC Category ID
    Read Only: true
    Unique identifier of the product fiscal classification category.
  • Title: Product Fiscal Classification
    Read Only: true
    Maximum Length: 240
    A classification of the products based on the inventory item category by the tax authority for tax purposes.
  • Title: Product Type
    Read Only: true
    Maximum Length: 240
    This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
  • Title: Invoice Amount in Project Currency
    Read Only: true
    Amount billed in the currency of the project.
  • Title: Project Currency
    Read Only: true
    Maximum Length: 30
    Indicates the currency code of the project.
  • Title: Project Currency Invoice Date Type
    Read Only: true
    Maximum Length: 30
    Date type used for conversion to the project currency.
  • Title: Project Currency Conversion Date
    Read Only: true
    Indicates the currency conversion date used to convert the invoice distribution to the project currency.
  • Title: Project Currency Conversion Rate
    Read Only: true
    Indicates the currency conversion rate used to convert the invoice currency to the project currency.
  • Title: Project Currency Invoice Rate Type
    Read Only: true
    Maximum Length: 30
    Indicates the currency conversion rate type used to convert the invoice to the project currency.
  • Title: Provider Legal Entity ID
    Read Only: true
    Unique identifier of the provider legal entity.
  • Title: Quantity
    Read Only: true
    Indicates the quantity of the source expenditure item for invoice transactions created from expenditure items.
  • Title: Receiver Legal Entity ID
    Read Only: true
    Unique identifier of the receiver legal entity.
  • Title: Transfer Price Invoice Rule Percentage
    Read Only: true
    Indicates the applied percentage value from the transfer price rule used to create an intercompany invoice.
  • Title: Transfer Price Invoice Schedule Line Percentage
    Read Only: true
    The applied percentage value from the transfer price schedule line used to create an intercompany invoice.
  • Title: Transaction Business Category
    Read Only: true
    Maximum Length: 240
    A classification or categorization of a transaction for tax purposes as required by a tax authority.
  • Title: Billed Amount in Transaction Currency
    Read Only: true
    Billed amount in the transaction currency.
  • Title: Transaction Currency
    Read Only: true
    Maximum Length: 30
    Transaction currency for the expenditure or events.
  • Title: Transaction Date
    Read Only: true
    Date when transaction occurs.
  • Title: Transaction ID
    Read Only: true
    Unique identifier of the expenditure item or event related to the invoice distribution.
  • Title: Transaction Project ID
    Read Only: true
    Unique identifier of the project related to the invoice distribution transaction.
  • Title: Transaction Project Name
    Read Only: true
    Maximum Length: 240
    Name of the project related to the invoice distribution transaction.
  • Title: Transaction Project Number
    Read Only: true
    Maximum Length: 25
    Number of the project related to the invoice distribution transaction.
  • Title: Transaction Task ID
    Read Only: true
    Unique identifier of the project task related to the invoice distribution transaction.
  • Title: Transaction Task Name
    Read Only: true
    Maximum Length: 255
    Name of the project task related to the invoice distribution transaction.
  • Title: Transaction Task Number
    Read Only: true
    Maximum Length: 100
    Number of the project task related to the invoice distribution transaction.
  • Title: Transaction Type ID
    Read Only: true
    Unique identifier of the Event Type or Expenditure Item Type related to the invoice distribution.
  • Title: User-Defined Fiscal Classification
    Read Only: true
    Maximum Length: 240
    Indicates the default taxation country.
Links
Attachments
Parameters:
  • InvoiceId: $request.path.InvoiceId
The attachments resource is used to view, create, update and delete attachments for project contract invoices.
InvoiceHeaderDff
Parameters:
  • InvoiceId: $request.path.InvoiceId
A listing of all the descriptive flexfields available for project contract invoices.
InvoiceLines
Parameters:
  • InvoiceId: $request.path.InvoiceId
The Invoice Lines resource is used to view the details of the invoice lines.
approveProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to approve a submitted invoice.
cancelProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to cancel single or multiple standard invoices in Released, Transferred, or Accepted statuses to create credit invoices in Draft, Submitted, Approved, or Released statuses.
rejectProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to reject a submitted invoice.
releaseProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to release invoices that have been approved and are ready to be released.
returnToDraftProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to return an approved or approval rejected invoice to draft status.
submitProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to submit invoices for approval.
unreleaseProjectContractInvoice
Parameters:
  • InvoiceId: $request.path.InvoiceId
Use this action to unrelease invoices that are either in Released or Transfer Rejected status. Invoices that are in Transferred or Accepted status can't be unreleased. To unrelease an invoice in any order for a project contract, you must enable the Allow Invoice Processing in Any Sequence predefined profile using the Manage Administrator Profile Values setup page. Also, you can't unrelease an invoice in any order if the transactions associated with the invoice being unreleased have been invoiced subsequently on different invoices of the project contract. When the Allow Invoice Processing in Any Sequence predefined profile is disabled, you can only unrelease the last invoice for the project contract.
Back to Top

Examples

The following example shows how to get a project contract invoices by submitting a GET request on the REST resource using cURL.

curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectContractInvoices/100100055358196

Example of Response Body

The following shows an example of the response body in JSON format.

{ "items": [ { "BillFromDate": "1952-01-01", "BillSet": 1, "BillToContactId": 4840, "BillToCustomerId": 1005, "BillToDate": "2017-07-27", "BillToSiteId": 300100038711498, "BillingTypeCode": "EX", "Canceled": null, "ContractId": 300100121123900, "CreditMemoReasonCode": null, "CreditedInvoiceId": null, "DocumentNumber": null, "DocumentSubType": null, "Exception": "N", "ExportProcessId": null, "AccountingDate": "2016-12-31", "AccountingPeriodName": "Dec-16", "ApTransferStatusCode": null, "InvoiceComment": null, "InvoiceCurrencyCode": "USD", "InvoiceDate": "2016-12-31", "InvoiceId": 100100055358196, "InvoiceInstructions": null, "InvoiceNumber": 1, "InvoiceStatusCode": "TRANSFERRED", "InvoiceTypeCode": "STANDARD", "LocNumber": null, "MajorVersion": 1, "OrganizationId": 458, "PaDate": "2016-12-31", "PaPeriodName": "52-16", "ReceivablesNumber": "ARAttchVS1", "ReceiverSetupCode": null, "ReleasedByPersonId": 100010032550827, "ReleasedDate": "2017-07-27", "ReportTypeCode": null, "SystemReference": null, "TaxationCountry": "US", "TransferredDate": "2017-07-27", "ContractNumber": "CDRMPJB_AR AttachVS", "ContractTypeName": "Dummy4", "ContractTypeId": 2004, "BillToCustomerName": "ATnT Universal Card", "CreditedInvoiceNumber": null, "InvoiceAmount": 200, "TaxAmount": 0, "Migrated": "N", "NetCredit": null, "OrganizationName": "Vision Services", "InvoiceStatusMeaning": "Transferred", "InvoiceTypeMeaning": "Standard invoice", "ApprovedbyPersonId": 100010032550827, "RejectedbyPersonId": null, "ApprovedDate": "2017-07-27", "RejectedDate": null, "ApprovedbyPerson": "Abraham Mason", "RejectedbyPerson": null, "ReleasedbyPerson": "Abraham Mason", "BillToContactName": "Paula Springer", "CreditMemoReasonMeaning": null, "BillToSite": "CDRM_6185", "UnreleaseComments": null, "LastUnreleasedByPersonId": null, "LastUnreleasedDate": null, "LastUnreleasedByPerson": null }
Back to Top