Oracle Fusion Cloud ERP
App · 25 actions
Read financial records and manage payables invoices in Oracle Fusion Cloud ERP.
Actions
| Action | What it does |
|---|---|
| Create payables invoice | Create a payables invoice and its lines. |
| Delete payables invoice | Delete an eligible, unvalidated payables invoice. |
| Get bank | Get bank. |
| Get bank account | Get bank account. |
| Get bank branch | Get bank branch. |
| Get expense report | Get expense report. |
| Get invoice line | Get invoice line. |
| Get journal batch | Get journal batch. |
| Get payables invoice | Get payables invoice. |
| Get payables payment | Get payables payment. |
| Get receivables invoice | Get receivables invoice. |
| Get standard receipt | Get standard receipt. |
| List bank accounts | List bank accounts. |
| List bank branches | List bank branches. |
| List banks | List banks. |
| List business units | List business units. |
| List expense reports | List expense reports. |
| List invoice lines | List invoice lines. |
| List journal batches | List journal batches. |
| List ledger balances | List ledger balances. |
| List payables invoices | List payables invoices. |
| List payables payments | List payables payments. |
| List receivables invoices | List receivables invoices. |
| List standard receipts | List standard receipts. |
| Update payables invoice | Update payables invoice. |
Create payables invoice
Create a payables invoice and its lines. Use a test environment for QA; submitting an invoice can start financial approval processes.
Inputs
- Invoice number
invoice_numbertextRequired - The unique number for supplier invoice.
- Invoice date
invoice_datedateRequired - The date on the supplier invoice. The value can either be provided while creating an invoice or populated by default to the system date.
- Accounting date
accounting_datedateRequired - The accounting date captured on the invoice that is finally used to default to invoice lines and distributions. The value can either be provided while creating the invoice or derived based on the Accounting Date Basis option on the Manage Invoice Options for the invoicing business unit.
- Terms date
terms_datedateRequired - The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Invoice amount
invoice_amountnumberRequired - The invoice amount in transaction currency. The value must be provided while creating an invoice.
- Invoice currency
invoice_currencytextRequired - The currency code used on the invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Payment currency
payment_currencytextRequired - The currency used to make a payment. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Payment method code
payment_method_codetextRequired - The user-entered payment method code that helps to uniquely identify a payment method.
- Business unit
business_unittextRequired - Indicates the business unit name for the invoice. The value can either be provided while creating an invoice or populated by default from the profile option DEFAULT_ORG_ID. It cannot be updated once the invoice is created.
- Supplier
suppliertextRequired - The supplier name on the invoice. The value must be provided while creating the invoice. It cannot be updated once the invoice is created.
- Supplier site
supplier_sitetextRequired - The name of the physical location of the supplier from where the goods and services are rendered. The value must be provided during creation action. It cannot be updated once the invoice is created.
- Description
descriptiontext - The statement that describes the invoice.
- Payment terms
payment_termstext - The payment terms used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Invoice lines
invoice_lineslistRequired - Invoice lines.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"InvoiceAmount": 1.0,
"InvoiceCurrency": "example",
"InvoiceDate": "example",
"InvoiceId": 1,
"InvoiceNumber": "example",
"LastUpdateDate": "example",
"Supplier": "example",
"SupplierSite": "example",
"resource_key": "example"
}
}Delete payables invoice
Delete an eligible, unvalidated payables invoice. Oracle refuses deletion for invoices that have progressed beyond the allowed state.
Inputs
- Payables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List payables invoices.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {}
}Get bank
Get bank.
Inputs
- bank
resource_keytextRequired - Opaque key from the resource_key field returned by List banks.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BankName": "example",
"BankPartyId": 1,
"CreationDate": "example",
"LastUpdateDate": "example",
"resource_key": "example"
}
}Get bank account
Get bank account.
Inputs
- bank account
resource_keytextRequired - Opaque key from the resource_key field returned by List bank accounts.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BankAccountId": 1,
"BankAccountName": "example",
"CreationDate": "example",
"LastUpdateDate": "example",
"resource_key": "example"
}
}Get bank branch
Get bank branch.
Inputs
- bank branch
resource_keytextRequired - Opaque key from the resource_key field returned by List bank branches.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BankBranchName": "example",
"BranchPartyId": 1,
"CreationDate": "example",
"LastUpdateDate": "example",
"resource_key": "example"
}
}Get expense report
Get expense report.
Inputs
- expense report
resource_keytextRequired - Opaque key from the resource_key field returned by List expense reports.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"ExpenseReportId": 1,
"ExpenseReportNumber": "example",
"LastUpdateDate": "example",
"resource_key": "example"
}
}Get invoice line
Get invoice line.
Inputs
- Payables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List payables invoices.
- Invoice line
line_keytextRequired - Opaque key from List invoice lines.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"Description": "example",
"LineAmount": 1.0,
"LineNumber": 1,
"LineType": "example",
"resource_key": "example"
}
}Get journal batch
Get journal batch.
Inputs
- journal batch
resource_keytextRequired - Opaque key from the resource_key field returned by List journal batches.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"CreationDate": "example",
"JeBatchId": 1,
"LastUpdateDate": "example",
"Status": "example",
"resource_key": "example"
}
}Get payables invoice
Get payables invoice.
Inputs
- Payables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List payables invoices.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"InvoiceAmount": 1.0,
"InvoiceCurrency": "example",
"InvoiceDate": "example",
"InvoiceId": 1,
"InvoiceNumber": "example",
"LastUpdateDate": "example",
"Supplier": "example",
"SupplierSite": "example",
"resource_key": "example"
}
}Get payables payment
Get payables payment.
Inputs
- payables payment
resource_keytextRequired - Opaque key from the resource_key field returned by List payables payments.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CheckId": 1,
"CreationDate": "example",
"InvoiceAmount": 1.0,
"InvoiceCurrency": "example",
"LastUpdateDate": "example",
"PaymentNumber": 1,
"resource_key": "example"
}
}Get receivables invoice
Get receivables invoice.
Inputs
- receivables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List receivables invoices.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"CustomerTransactionId": 1,
"LastUpdateDate": "example",
"TransactionNumber": "example",
"resource_key": "example"
}
}Get standard receipt
Get standard receipt.
Inputs
- standard receipt
resource_keytextRequired - Opaque key from the resource_key field returned by List standard receipts.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"LastUpdateDate": "example",
"ReceiptNumber": "example",
"StandardReceiptId": 1,
"Status": "example",
"resource_key": "example"
}
}List bank accounts
List bank accounts. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List bank branches
List bank branches. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List banks
List banks. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List business units
List business units. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List expense reports
List expense reports. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List invoice lines
List invoice lines. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Payables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List payables invoices.
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": []
}
}List journal batches
List journal batches. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List ledger balances
List ledger balances. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List payables invoices
List payables invoices. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
- Business unit
business_unittext - Filter to this business unit.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List payables payments
List payables payments. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List receivables invoices
List receivables invoices. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}List standard receipts
List standard receipts. Gets one page; to see more, run it again with the next page it gives.
Inputs
- Limit
limitnumber - Limit.From 1 to 500.
- Offset
offsetnumber - Offset.At least 0.
- Query
querytext - Oracle filter expression, for example InvoiceNumber="INV-100". Leave empty to list all records.
- Order by
order_bytext - Oracle attribute and direction, for example LastUpdateDate:desc.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"count": 1,
"hasMore": false,
"items": [],
"limit": 1,
"offset": 1,
"totalResults": 1
}
}Update payables invoice
Update payables invoice.
Inputs
- Payables invoice
resource_keytextRequired - Opaque key from the resource_key field returned by List payables invoices.
- Terms date
terms_datedate - The date used with payment terms to calculate installment along with due date and discount dates. The value can either be provided while creating an invoice or derived based on the Terms Date Basis option from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
- Description
descriptiontext - The statement that describes the invoice.
- Payment terms
payment_termstext - The payment terms used to calculate installments and to calculate due dates, discount dates, and discount amounts for each invoice. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit.
Outputs
dataobject- Oracle Fusion Cloud ERP response data.
Example output
{
"data": {
"BusinessUnit": "example",
"CreationDate": "example",
"InvoiceAmount": 1.0,
"InvoiceCurrency": "example",
"InvoiceDate": "example",
"InvoiceId": 1,
"InvoiceNumber": "example",
"LastUpdateDate": "example",
"Supplier": "example",
"SupplierSite": "example",
"resource_key": "example"
}
}