Find Invoices that are Canceled
You created a large number of invoices while migrating from your legacy application to Payables. You canceled invoices that were created by mistake. Now you want to view all canceled invoices to confirm that the invoices are properly reflected in Payables.
Example URL
Here's an example of the resource URL:
GETfscmRestApi/resources/11.13.18.05/invoices?q=ValidationStatus=CanceledcURL Command
curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?q=ValidationStatus=Canceled
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"InvoiceId": 300100119154009,
"InvoiceNumber": "WHT_P1_01",
"InvoiceCurrency": "INR",
"PaymentCurrency": "INR",
"InvoiceAmount": 0,
"InvoiceDate": "2017-07-26",
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 001",
"SupplierNumber": "1449703140",
"ProcurementBU": null,
"SupplierSite": "Gall P1 001 B01",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2017-07-26",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Manual invoice entry",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Immediate",
"TermsDate": "2017-07-26",
"GoodsReceivedDate": null,
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": "ABCD50001A",
"LegalEntity": "Vision India - LE01",
"LegalEntityIdentifier": "Vision India - LE01",
"LiabilityDistribution": "01.000.2225.0000.0000",
"DocumentCategory": null,
"DocumentSequence": null,
"VoucherNumber": null,
"ValidationStatus": "Canceled",
"ApprovalStatus": "Not required",
"PaidStatus": "Unpaid",
"AccountingStatus": "Unaccounted",
"ApplyAfterDate": null,
"CanceledFlag": true,
"AmountPaid": null,
"BaseAmount": null,
"PurchaseOrderNumber": null,
"Party": "Gallant P1 001",
"PartySite": "Hyderabad Address",
"ControlAmount": null,
"DocumentFiscalClassificationCodePath": null,
"TaxationCountry": "India",
"RoutingAttribute1": null,
"RoutingAttribute2": null,
"RoutingAttribute3": null,
"RoutingAttribute4": null,
"RoutingAttribute5": null,
"AccountCodingStatus": null,
"BudgetDate": "2017-07-26",
"FundsStatus": null,
"CanceledDate": "2017-07-26",
"CanceledBy": "AP_SUPV_OPERATIONS",
"CreationDate": "2017-07-26T07:01:03.001+00:00",
"CreatedBy": "AP_SUPV_OPERATIONS",
"LastUpdatedBy": "AP_SUPV_OPERATIONS",
"LastUpdateDate": "2017-07-26T10:16:53.666+00:00",
"LastUpdateLogin": "553584C262930BE1E0534180F50AE2BF",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009",
"name": "invoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000001778"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009",
"name": "invoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/SupplierVVO1",
"name": "SupplierVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/SupplierSiteWithAssignmentVVO1",
"name": "SupplierSiteWithAssignmentVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/PayGroupPVO1",
"name": "PayGroupPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/ValidationStatusLookupPVO1",
"name": "ValidationStatusLookupPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/TerritoryVVO1",
"name": "TerritoryVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/PersonNameVO1",
"name": "PersonNameVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/PaymentTermsVVO1",
"name": "PaymentTermsVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/BusinessUnitVVO1",
"name": "BusinessUnitVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/DisbursementPaymentMethodPVO1",
"name": "DisbursementPaymentMethodPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/MatchPONumberTempVA",
"name": "MatchPONumberTempVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/ThirdPtyTaxRegNumPVO1",
"name": "ThirdPtyTaxRegNumPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/DeliveryChannelVVO1",
"name": "DeliveryChannelVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/ApDocumentSequenceCategoriesVO1",
"name": "ApDocumentSequenceCategoriesVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/FirstPtyTaxRegNumPVO1",
"name": "FirstPtyTaxRegNumPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/DailyConversionTypePVO1",
"name": "DailyConversionTypePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/LegalEntityPVO1",
"name": "LegalEntityPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/SourcePVO1",
"name": "SourcePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/PaymentReasonVVO1",
"name": "PaymentReasonVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/lov/InvoiceTypeLookupPVO1",
"name": "InvoiceTypeLookupPVO1",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/child/invoiceDff",
"name": "invoiceDff",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/child/invoiceGdf",
"name": "invoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/child/invoiceInstallments",
"name": "invoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154009/child/invoiceLines",
"name": "invoiceLines",
"kind": "collection"
}
]
},
{
"InvoiceId": 300100119154019,
"InvoiceNumber": "WHT_SC_TOT_01",
"InvoiceCurrency": "USD",
"PaymentCurrency": "USD",
"InvoiceAmount": 0,
"InvoiceDate": "2017-07-26",
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 004",
"SupplierNumber": "1449703143",
"ProcurementBU": null,
"SupplierSite": "Gall P1 004BU01",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": "Corporate",
"ConversionDate": "2017-07-26",
"ConversionRate": 64.34568,
"AccountingDate": "2017-07-26",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Manual invoice entry",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Immediate",
"TermsDate": "2017-07-26",
"GoodsReceivedDate": null,
"PaymentMethodCode": "WIRE",
"PaymentMethod": "Wire",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": "ABCD50001A",
"LegalEntity": "Vision India - LE01",
"LegalEntityIdentifier": "Vision India - LE01",
"LiabilityDistribution": "01.000.2225.0000.0000",
"DocumentCategory": null,
"DocumentSequence": null,
"VoucherNumber": null,
"ValidationStatus": "Canceled",
"ApprovalStatus": "Not required",
"PaidStatus": "Unpaid",
"AccountingStatus": "Unaccounted",
"ApplyAfterDate": null,
"CanceledFlag": true,
"AmountPaid": null,
"BaseAmount": 0,
"PurchaseOrderNumber": null,
"Party": "Gallant P1 004",
"PartySite": "Gallant P1 004",
"ControlAmount": null,
"DocumentFiscalClassificationCodePath": null,
"TaxationCountry": "India",
"RoutingAttribute1": null,
"RoutingAttribute2": null,
"RoutingAttribute3": null,
"RoutingAttribute4": null,
"RoutingAttribute5": null,
"AccountCodingStatus": null,
"BudgetDate": "2017-07-26",
"FundsStatus": null,
"CanceledDate": "2017-07-26",
"CanceledBy": "AP_SUPV_OPERATIONS",
"CreationDate": "2017-07-26T07:19:16.745+00:00",
"CreatedBy": "AP_SUPV_OPERATIONS",
"LastUpdatedBy": "AP_SUPV_OPERATIONS",
"LastUpdateDate": "2017-07-26T08:02:37.500+00:00",
"LastUpdateLogin": "5533B6121CA70CA7E0534280F50AD309",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019",
"name": "invoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000D78"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019",
"name": "invoices",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/SupplierVVO1",
"name": "SupplierVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/SupplierSiteWithAssignmentVVO1",
"name": "SupplierSiteWithAssignmentVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/PayGroupPVO1",
"name": "PayGroupPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/ValidationStatusLookupPVO1",
"name": "ValidationStatusLookupPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/TerritoryVVO1",
"name": "TerritoryVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/PersonNameVO1",
"name": "PersonNameVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/PaymentTermsVVO1",
"name": "PaymentTermsVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/BusinessUnitVVO1",
"name": "BusinessUnitVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/DisbursementPaymentMethodPVO1",
"name": "DisbursementPaymentMethodPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/MatchPONumberTempVA",
"name": "MatchPONumberTempVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/ThirdPtyTaxRegNumPVO1",
"name": "ThirdPtyTaxRegNumPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/DeliveryChannelVVO1",
"name": "DeliveryChannelVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/ApDocumentSequenceCategoriesVO1",
"name": "ApDocumentSequenceCategoriesVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/FirstPtyTaxRegNumPVO1",
"name": "FirstPtyTaxRegNumPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/DailyConversionTypePVO1",
"name": "DailyConversionTypePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/LegalEntityPVO1",
"name": "LegalEntityPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/SourcePVO1",
"name": "SourcePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/PaymentReasonVVO1",
"name": "PaymentReasonVVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/lov/InvoiceTypeLookupPVO1",
"name": "InvoiceTypeLookupPVO1",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/child/invoiceDff",
"name": "invoiceDff",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/child/invoiceGdf",
"name": "invoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/child/invoiceInstallments",
"name": "invoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100119154019/child/invoiceLines",
"name": "invoiceLines",
"kind": "collection"
}
]
},
...
]
}