n8n-nodes-oracle-fusion-cloud-erp

[Velocity BPA Licensing Notice]

This n8n node is licensed under the Business Source License 1.1 (BSL 1.1).

Use of this node by for-profit organizations in production environments requires a commercial license from Velocity BPA.

For licensing information, visit https://velobpa.com/licensing or contact [email protected].

A comprehensive n8n community node for Oracle Fusion Cloud ERP that enables workflow automation for financials, accounts payable, accounts receivable, general ledger, procurement, and project management through Oracle Fusion REST APIs with OAuth 2.0 and Basic authentication.

Features

• 12 Resource Categories - Complete coverage of Oracle Fusion Cloud ERP modules
• 96+ Operations - Comprehensive CRUD and business operations
• OAuth 2.0 & Basic Auth - Flexible authentication options
• Polling Trigger - Event-based automation with 12 event types
• Pagination Support - Automatic handling of large datasets
• OData Query Support - Advanced filtering, sorting, and field selection
• Enterprise-Ready - Production-tested error handling and logging

Installation

Community Nodes (Recommended)

1. Open your n8n instance
2. Go to Settings > Community Nodes
3. Click Install
4. Enter: n8n-nodes-oracle-fusion-cloud-erp
5. Click Install

Manual Installation

# Navigate to your n8n installation directory
cd ~/.n8n

# Install the package
npm install n8n-nodes-oracle-fusion-cloud-erp

Development Installation

# Clone the repository
git clone https://github.com/Velocity-BPA/n8n-nodes-oracle-fusion-cloud-erp.git
cd n8n-nodes-oracle-fusion-cloud-erp

# Install dependencies
npm install

# Build the project
npm run build

# Create symlink to n8n custom nodes directory
mkdir -p ~/.n8n/custom
ln -s $(pwd) ~/.n8n/custom/n8n-nodes-oracle-fusion-cloud-erp

# Restart n8n
n8n start

Credentials Setup

Oracle Fusion Cloud ERP API Credentials

| Field | Description | Required | |-------|-------------|----------| | Instance URL | Oracle Fusion instance URL (e.g., https://efxw.fa.us2.oraclecloud.com) | Yes | | Authentication Type | OAuth2 or Basic | Yes | | IDCS URL | Identity Cloud Service URL (OAuth2 only) | Conditional | | Client ID | OAuth2 Client ID | Conditional | | Client Secret | OAuth2 Client Secret | Conditional | | Username | Basic Auth username | Conditional | | Password | Basic Auth password | Conditional | | API Version | API version (default: 11.13.18.05) | No |

OAuth 2.0 Setup (Recommended)

1. Log in to Oracle Identity Cloud Service (IDCS)
2. Create a new Confidential Application
3. Configure client credentials grant
4. Note the Client ID and Client Secret
5. Add required scopes: urn:opc:resource:consumer::all
6. Enter credentials in n8n

Basic Authentication Setup

1. Create an API-enabled user in Oracle Fusion
2. Grant appropriate roles and privileges
3. Enter username and password in n8n

Resources & Operations

Suppliers (Vendors)

Manage supplier master data and relationships.

| Operation | Description | |-----------|-------------| | create | Create a new supplier | | get | Retrieve supplier by ID | | getAll | List suppliers with filtering | | update | Update supplier information | | getContacts | Get supplier contacts | | createContact | Add supplier contact | | getSites | Get supplier sites/addresses | | createSite | Add supplier site | | getPaymentMethods | Get payment methods | | getBankAccounts | Get bank accounts |

Payables Invoices

Process accounts payable invoices end-to-end.

| Operation | Description | |-----------|-------------| | create | Create AP invoice | | get | Retrieve invoice by ID | | getAll | List invoices with filtering | | update | Update invoice header | | delete | Cancel/delete invoice | | createLine | Add invoice line | | updateLine | Update invoice line | | deleteLine | Remove invoice line | | validate | Validate invoice for payment | | approve | Submit for approval | | hold | Place invoice on hold | | releaseHold | Release from hold | | getPayments | Get payment status | | getDistributions | Get GL distributions |

Payments

Manage payment processing and disbursements.

| Operation | Description | |-----------|-------------| | get | Retrieve payment by ID | | getAll | List payments with filtering | | getPaymentDocuments | Get payment documents | | void | Void a payment | | stop | Stop payment | | getRemittances | Get remittance details |

Receivables Invoices

Handle accounts receivable billing.

| Operation | Description | |-----------|-------------| | create | Create AR invoice | | get | Retrieve invoice by ID | | getAll | List AR invoices | | update | Update invoice | | createLine | Add invoice line | | updateLine | Update invoice line | | deleteLine | Remove invoice line | | complete | Complete the invoice | | getReceipts | Get applied receipts | | getSchedules | Get payment schedules |

Receipts (Cash Receipts)

Process cash receipt applications.

| Operation | Description | |-----------|-------------| | create | Create AR receipt | | get | Retrieve receipt by ID | | getAll | List receipts | | update | Update receipt | | apply | Apply to invoices | | unapply | Unapply from invoices | | reverse | Reverse receipt | | getApplications | Get receipt applications |

General Ledger Journals

Manage journal entries and GL postings.

| Operation | Description | |-----------|-------------| | create | Create journal batch | | get | Retrieve journal by ID | | getAll | List journals | | update | Update journal | | createLine | Add journal line | | updateLine | Update journal line | | deleteLine | Remove journal line | | post | Post journal to GL | | reverse | Reverse posted journal | | getBalances | Get account balances |

Customers

Manage customer master data.

| Operation | Description | |-----------|-------------| | create | Create customer account | | get | Retrieve customer by ID | | getAll | List customers | | update | Update customer | | getSites | Get customer sites | | createSite | Add customer site | | getContacts | Get contacts | | getAccounts | Get customer accounts | | getBalances | Get customer balances |

Purchase Orders

Process procurement orders.

| Operation | Description | |-----------|-------------| | create | Create purchase order | | get | Retrieve PO by ID | | getAll | List purchase orders | | update | Update PO header | | createLine | Add PO line | | updateLine | Update PO line | | deleteLine | Remove PO line | | submit | Submit for approval | | approve | Approve PO | | cancel | Cancel PO | | close | Close PO | | getReceipts | Get related receipts |

Purchase Requisitions

Manage purchase request workflows.

| Operation | Description | |-----------|-------------| | create | Create requisition | | get | Retrieve by ID | | getAll | List requisitions | | update | Update requisition | | createLine | Add requisition line | | submit | Submit for approval | | approve | Approve requisition | | return | Return for resubmission | | cancel | Cancel requisition | | convertToPO | Convert to purchase order |

Projects

Manage project portfolio data.

| Operation | Description | |-----------|-------------| | create | Create project | | get | Retrieve project by ID | | getAll | List projects | | update | Update project | | getTasks | Get project tasks | | createTask | Add project task | | getTeamMembers | Get team members | | addTeamMember | Add team member | | getBudget | Get project budget | | getActuals | Get project actuals | | getExpenditures | Get expenditures |

Ledger Accounts

Access chart of accounts and balances.

| Operation | Description | |-----------|-------------| | get | Retrieve account by ID | | getAll | List GL accounts | | getBalances | Get account balances by period | | getTransactions | Get account transactions | | getCodeCombinations | Get code combinations |

Bank Accounts

Manage bank account information.

| Operation | Description | |-----------|-------------| | get | Retrieve by ID | | getAll | List bank accounts | | getBalances | Get bank balances | | getStatements | Get bank statements | | getTransactions | Get bank transactions | | reconcile | Reconcile transactions |

Trigger Node

The Oracle Fusion Cloud ERP Trigger node enables event-based workflow automation using polling.

Supported Events

| Event | Description | |-------|-------------| | supplier.created | New supplier created | | supplier.updated | Supplier modified | | invoice.created | AP Invoice created | | invoice.validated | AP Invoice validated | | invoice.paid | AP Invoice paid | | payment.created | Payment created | | receipt.applied | AR Receipt applied | | journal.posted | GL Journal posted | | customer.created | Customer created | | purchaseOrder.approved | PO approved | | requisition.approved | Requisition approved | | project.created | Project created |

Configuration

| Field | Description | |-------|-------------| | Event | Select the event type to monitor | | Poll Interval | How frequently to check for new events | | Filters | Optional OData filters to limit results |

Usage Examples

Create an AP Invoice

// Oracle Fusion Cloud ERP Node Configuration
{
  "resource": "payablesInvoice",
  "operation": "create",
  "invoiceNum": "INV-2024-001",
  "vendorId": 300100123456789,
  "vendorSiteId": 300100123456790,
  "invoiceAmount": 1500.00,
  "invoiceDate": "2024-01-15",
  "invoiceType": "Standard",
  "description": "Office Supplies - January"
}

Query Suppliers with Filters

// Get all active suppliers
{
  "resource": "supplier",
  "operation": "getAll",
  "returnAll": true,
  "filters": {
    "Status": "ACTIVE",
    "SupplierType": "VENDOR"
  }
}

Post a Journal Entry

// Create and post a GL journal
{
  "resource": "journal",
  "operation": "create",
  "name": "Month-End Adjustments",
  "journalCategory": "Adjustment",
  "accountingPeriod": "Jan-24",
  "lines": [
    {
      "accountNumber": "01-000-1200-0000-000",
      "debitAmount": 5000.00
    },
    {
      "accountNumber": "01-000-4100-0000-000",
      "creditAmount": 5000.00
    }
  ]
}

Oracle Fusion Cloud ERP Concepts

Instance URL Structure

Oracle Fusion Cloud uses a specific URL pattern:

• Format: https://{pod}.fa.{datacenter}.oraclecloud.com
• Example: https://efxw.fa.us2.oraclecloud.com

API Versioning

• Default version: 11.13.18.05
• Latest version: 11.14.25.01
• Version is part of the API path: /fscmRestApi/resources/{version}/

OData Query Support

Oracle Fusion REST APIs support OData-style querying:

• $filter: Filter results (e.g., Status eq 'ACTIVE')
• $select: Choose fields to return
• $orderby: Sort results
• $expand: Include related resources
• $top / $skip: Pagination

Pagination

• Offset-based pagination with offset and limit parameters
• Maximum 500 records per request
• Response includes hasMore flag and totalResults count

Data Centers

| Region | Data Center Code | Example URL | |--------|------------------|-------------| | US West | us2 | *.fa.us2.oraclecloud.com | | US East | us6 | *.fa.us6.oraclecloud.com | | EMEA | em2 | *.fa.em2.oraclecloud.com | | APAC | ap1 | *.fa.ap1.oraclecloud.com |

Error Handling

The node handles Oracle Fusion error responses automatically:

{
  "type": "http://xmlns.oracle.com/adf/svc/errors/",
  "title": "Bad Request",
  "status": 400,
  "o:errorCode": "APXIIMPT-470108",
  "detail": "The supplier site is not valid for the supplier."
}

Common Error Codes

| Code | Meaning | |------|---------| | 400 | Validation error or malformed request | | 401 | Invalid credentials or expired token | | 403 | Insufficient privileges | | 404 | Resource not found | | 409 | Concurrent update conflict | | 429 | Rate limit exceeded | | 500 | Server-side error |

Security Best Practices

1. Use OAuth 2.0 - Preferred over Basic Authentication for production
2. Limit Scopes - Request only necessary API scopes
3. Rotate Credentials - Regularly rotate OAuth client secrets
4. Use Service Accounts - Create dedicated API users with minimal privileges
5. Enable Audit Logging - Monitor API access in Oracle Fusion
6. Secure Storage - Store credentials in n8n's encrypted credential store

Development

# Install dependencies
npm install

# Build the project
npm run build

# Run linting
npm run lint

# Fix linting issues
npm run lint:fix

# Run tests
npm test

# Run tests with coverage
npm run test:coverage

# Watch mode for development
npm run dev

Testing

# Run all tests
npm test

# Run unit tests only
npm test -- --testPathPattern=unit

# Run integration tests (requires credentials)
npm test -- --testPathPattern=integration

# Generate coverage report
npm run test:coverage

Author

Velocity BPA

• Website: velobpa.com
• GitHub: Velocity-BPA
• Email: [email protected]

Licensing

This n8n community node is licensed under the Business Source License 1.1 (BSL 1.1).

Free Use

Permitted for:

• Personal use
• Educational use
• Research use
• Internal business use

Commercial Use

Commercial or production use by for-profit organizations requires a commercial license from Velocity BPA.

Commercial Use includes:

• Use within any SaaS, PaaS, or hosted application
• Offering as part of a managed services engagement
• Bundling or redistributing with a paid product
• Embedding into any commercial automation platform

For licensing inquiries: [email protected]

See LICENSE, COMMERCIAL_LICENSE.md, and LICENSING_FAQ.md for complete details.

Contributing

1. Fork the repository
2. Create a feature branch (git checkout -b feature/amazing-feature)
3. Commit changes (git commit -m 'Add amazing feature')
4. Push to branch (git push origin feature/amazing-feature)
5. Open a Pull Request

Please ensure all contributions comply with the BSL 1.1 license terms.

Support

• Documentation: GitHub Wiki
• Issues: GitHub Issues
• Oracle Docs: Oracle Fusion Cloud REST API

Acknowledgments

• n8n - Workflow automation platform
• Oracle - Oracle Fusion Cloud ERP platform
• The n8n community for feedback and contributions