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 Distribution with Project Information for an Existing Invoice

Create an Invoice Distribution with Project Information for an Existing Invoice

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

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/{LineNumber}/child/invoiceDistributions

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//00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions

Example Request

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

{
	"DistributionLineNumber": 1,
	"DistributionLineType": "Item",
	"DistributionAmount": 112.75,
	"DistributionCombination": "01-420-7110-0000-000",
	"invoiceDistributionProjectDff": [
	{
		"_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:

{
	"InvoiceDistributionId": 300100211650532,
	"DistributionLineNumber": 1,
	"DistributionLineType": "Item",
	"IncomeTaxType": "INDE/P",
	"AccountingStatus": null,
	"MatchedStatus": null,
	"ValidationStatus": "Not validated",
	"AccountingDate": "2020-09-15",
	"DistributionAmount": 112.75,
	"AssetBook": null,
	"DistributionCombination": "01-420-7110-0000-000",
	"TrackAsAssetFlag": false,
	"BaseAmount": null,
	"CanceledFlag": false,
	"Description": null,
	"IncomeTaxRegion": null,
	"ReversedFlag": false,
	"InvoicedQuantity": null,
	"UOM": null,
	"UnitPrice": null,
	"PurchaseOrderDistributionLineNumber": null,
	"PurchaseOrderNumber": null,
	"PurchaseOrderLineNumber": null,
	"PurchaseOrderScheduleLineNumber": null,
	"ReceiptNumber": null,
	"ReceiptLineNumber": null,
	"ConsumptionAdviceNumber": null,
	"ConsumptionAdviceLineNumber": null,
	"AssociatedItemDistributionLineNumber": null,
	"FinalMatchFlag": null,
	"MultiperiodAccountingStartDate": null,
	"MultiperiodAccountingEndDate": null,
	"MultiperiodAccountingAccrualAccount": "",
	"TaxRegimeName": null,
	"TaxName": null,
	"TaxRecoverable": null,
	"TaxRate": null,
	"TaxRateName": null,
	"TaxType": null,
	"IntendedUse": null,
	"IntendedUseCode": null,
	"CreatedBy": "FINUSER1",
	"CreationDate": "2020-09-15T06:17:10.527+00:00",
	"LastUpdatedBy": "FINUSER1",
	"LastUpdateDate": "2020-09-15T06:17:10.526+00:00",
	"LastUpdateLogin": "AE666F70BF2C1A59E0538C96F40A44BE",
	"PrepaymentNumber": null,
	"PrepaymentLineNumber": null,
	"PrepaymentDistributionLineNumber": null,
	"PrepaymentAvailableAmount": null,
	"ChargeApplicableToDistId": null,
	"AllocationLineNumber": null,
	"AllocationDistributionLineNumber": null,
	"invoiceDistributionProjectDff": [
		{
			"InvoiceDistributionId": 300100211650532,
			"__FLEX_Context": "AP_Invoice_Distribution",
			"__FLEX_Context_DisplayValue": "AP: Invoice Distribution",
			"_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/invoiceDistributions/300100211650532/child/invoiceDistributionProjectDff/300100211650532",
			"name": "invoiceDistributionProjectDff",
			"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/invoiceDistributions/300100211650532/child/invoiceDistributionProjectDff/300100211650532",
			"name": "invoiceDistributionProjectDff",
			"kind": "item"
		},
		{
			"rel": "parent",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions/300100211650532",
			"name": "invoiceDistributions",
			"kind": "item"
		}
		]
	  }
	],
	"links": [
			{
			"rel": "self",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions/300100211650532",
			"name": "invoiceDistributions",
			"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/invoiceDistributions/300100211650532",
			"name": "invoiceDistributions",
			"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"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions/300100211650532/child/invoiceDistributionDff",
			"name": "invoiceDistributionDff",
			"kind": "collection"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions/300100211650532/child/invoiceDistributionGdf",
			"name": "invoiceDistributionGdf",
			"kind": "collection"
		},
		{
			"rel": "child",
			"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100211649460/child/invoiceLines/00020000000EACED00057708000110F086832BB40000000AACED0005770400000002/child/invoiceDistributions/300100211650532/child/invoiceDistributionProjectDff",
			"name": "invoiceDistributionProjectDff",
			"kind": "collection"
		}
	]
}