1. REST API Get Started V4REST API for Oracle Fusion Cloud Financials
  2. Use Cases
  3. Manage Payables Invoices
  4. Update and Create Payables Invoices
  5. Create an Invoice Line with Project Information for an Existing Invoice

Create an Invoice Line with Project Information for an Existing Invoice

An invoice with a line already exists in Payables. You want to create an invoice line with project information for this existing invoice.

The supported media type for this operation is:
  • Content-Type: application/vnd.oracle.adf.resourceitem+json

Example URL

Here's an example of the resource URL:

POST

fscmRestApi/resources/11.13.18.05/invoices/{InvoiceId}/child/invoiceLines

cURL Command

curl -i -u "<username>:<password>" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -X POST -d <payload> https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines

Example Request

Here's an example of the request body in JSON format:

{
    "LineNumber": 2,
    "LineAmount": 112.75,
    "DistributionCombination": "01-000-7640-0000-000",
    "invoiceLineProjectDff": [
        {
            "_PROJECT_ID_Display": "BAT-PJCBAT-Proj-02",
            "_TASK_ID_Display": "1.2",
            "_EXPENDITURE_ITEM_DATE": "2020-09-01",
            "_EXPENDITURE_TYPE_ID_Display": "Airfare",
            "_ORGANIZATION_ID_Display": "Vision Operations"
        }
    ]
}

Example Response

Here's an example of the response body in JSON format:

{
	"LineNumber": 2,
	"LineAmount": 112.75,
	"AccountingDate": "2020-09-15",
	"UOM": null,
	"TaxRateName": null,
	"LineType": null,
	"AssetBook": null,
	"TrackAsAssetFlag": false,
	"BaseAmount": null,
	"Description": null,
	"IncomeTaxRegion": null,
	"Item": null,
	"ItemDescription": null,
	"LineSource": null,
	"Quantity": null,
	"DistributionCombination": "01-000-7640-0000-000",
	"AssetCategory": "",
	"UnitPrice": null,
	"ProrateAcrossAllItemsFlag": null,
	"LandedCostEnabled": null,
	"DiscardedFlag": false,
	"CanceledFlag": false,
	"IncomeTaxType": "INDE/P",
	"TaxRateCode": null,
	"TaxRate": null,
	"TaxClassification": null,
	"GenerateDistributions": "Y",
	"BudgetDate": "2020-09-15",
	"FundsStatus": null,
	"ApprovalStatus": null,
	"DistributionSet": null,
	"Withholding": null,
	"ShipToLocationCode": null,
	"ShipToLocation": null,
	"ShipToCustomerLocation": null,
	"TaxControlAmount": null,
	"AssessableValue": 112.75,
	"ProductType": null,
	"ProductCategory": null,
	"ProductCategoryCodePath": null,
	"UserDefinedFiscalClassification": null,
	"UserDefinedFiscalClassificationCode": null,
	"IntendedUse": null,
	"IntendedUseCode": null,
	"ProductFiscalClassification": null,
	"ProductFiscalClassificationCode": null,
	"ProductFiscalClassificationType": null,
	"TransactionBusinessCategory": null,
	"TransactionBusinessCategoryCodePath": "PURCHASE_TRANSACTION",
	"Requester": null,
	"PurchasingCategory": null,
	"MatchType": "NOT_MATCHED",
	"MatchOption": null,
	"MatchBasis": null,
	"PurchaseOrderNumber": null,
	"PurchaseOrderLineNumber": null,
	"PurchaseOrderScheduleLineNumber": null,
	"ReceiptNumber": null,
	"ReceiptLineNumber": null,
	"ConsumptionAdviceNumber": null,
	"ConsumptionAdviceLineNumber": null,
	"FinalMatchFlag": null,
	"MultiperiodAccountingStartDate": null,
	"MultiperiodAccountingEndDate": null,
	"MultiperiodAccountingAccrualAccount": "",
	"CreatedBy": "FINUSER1",
	"CreationDate": "2020-09-15T05:34:20.145+00:00",
	"LastUpdateDate": "2020-09-15T05:34:20.146+00:00",
	"LastUpdatedBy": "FINUSER1",
	"LastUpdateLogin": "AE666F70BF2C1A59E0538C96F40A44BE",
	"RequesterId": null,
	"PrepaymentNumber": null,
	"PrepaymentLineNumber": null,
	"PrepaymentIncludedonInvoiceFlag": null,
	"invoiceLineProjectDff": [
		{
		"InvoiceId": 300100211649460,
		"LineNumber": 2,
		"__FLEX_Context": "AP_Invoice_Line",
		"__FLEX_Context_DisplayValue": "AP: Invoice Line",
		"_PROJECT_ID": 100000019394078,
		"_PROJECT_ID_Display": "BAT-PJCBAT-Proj-02",
		"_TASK_ID": 100000019394095,
		"_TASK_ID_Display": "1.2",
		"_EXPENDITURE_ITEM_DATE": "2020-09-01",
		"_EXPENDITURE_TYPE_ID": 10001,
		"_EXPENDITURE_TYPE_ID_Display": "Airfare",
		"_ORGANIZATION_ID": 204,
		"_ORGANIZATION_ID_Display": "Vision Operations",
		"_CONTRACT_ID": null,
		"_CONTRACT_ID_Display": null,
		"_RESERVED_ATTRIBUTE1": null,
		"_RESERVED_ATTRIBUTE1_Display": null,
		"_BILLABLE_FLAG": null,
		"_BILLABLE_FLAG_Display": null,
		"_CAPITALIZABLE_FLAG": null,
		"_CAPITALIZABLE_FLAG_Display": null,
		"_WORK_TYPE_ID": null,
		"_WORK_TYPE_ID_Display": null,
		"links": [
		{
			"rel": "self",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceLineProjectDff/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002",
			"name": "invoiceLineProjectDff",
			"kind": "item",
			"properties": {
			"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
		}
		},
		{
			"rel": "canonical",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceLineProjectDff/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002",
			"name": "invoiceLineProjectDff",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002",
			"name": "invoiceLines",
			"kind": "item"
		}
		]
	}
	],
		"links": [
			{
			"rel": "self",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002",
			"name": "invoiceLines",
			"kind": "item",
			"properties": {
			"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
			}
		},
		{
			"rel": "canonical",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002",
			"name": "invoiceLines",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460",
			"name": "invoices",
			"kind": "item"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions",
			"name": "invoiceDistributions",
			"kind": "collection"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceLineDff",
			"name": "invoiceLineDff",
			"kind": "collection"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceLineGdf",
			"name": "invoiceLineGdf",
			"kind": "collection"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceLineProjectDff",
			"name": "invoiceLineProjectDff",
			"kind": "collection"
		}
	]
}