Skip to main content
ERP Integration
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE E-Invoicing
  • Subject: Integration

Embedded integration for Oracle Fusion

Product overview

ONESOURCE Pagero Embedded Integration for Oracle ERP Cloud helps multinational corporations comply with e-invoicing requirements across different countries. It works directly within Oracle ERP, using Oracle B2B platform and ONESOURCE Pagero API connections. This helps simplify country-specific mandates and grant data exchange.

Benefits of integration

Embedded E-Invoicing within Oracle Cloud
Integrates directly within the Oracle ERP system, providing a streamlined and cohesive user experience. Utilizes Oracle B2B platform and ONESOURCE Pagero API connections for efficient data exchange.
Up-to-Date Regulatory Compliance
Supports compliance with complex e-invoicing mandates by automating processes and ensuring data integrity. Facilitates live reporting and clearance of e-invoices, as required by specific country mandates.
Simplified Implementation
Reduces complexity through pre-configured connections and invoice exchange workflows, and delivers a quick experience backed by ONESOURCE Pagero's e-invoicing expertise.
Advanced Data Handling
Supports AP and AR workflows with a new API strategy to handle e-invoice documents. Utilizes UBL JSON format for data exchange, ensuring compatibility and standardization.
Real-Time Synchronization
We use a webhook notification for live data synchronization between ONESOURCE and Oracle platforms. Ensures timely communication of success or failure in e-invoice processing.
If a webhook ever failed, ONESOURCE Pagero will have a retry mechanism to handle it. Missing notifications will be sent once the maintenance is completed.
Supported countries (Non-Clearance Model only)
  • Australia
  • Belgium
  • Denmark
  • Finland
  • the Netherlands
  • Norway
  • Sweden
  • the United Kingdom
  • Germany

Prerequisites

  • Customers need to obtain access to the ONESOURCE API Product covering E-Invoicing, API Administration, and Pagero.
    • The PS Team needs to email the DB Provisioning Team to request
      • Product setup
      • Tenant creation
      • The required access for onboarding including API administrator access, API products, and database addition
  • The following products need to be enabled for API Administration and product permissions under Administration:
    • ONESOURCE E-invoicing
    • Oracle E-invoicing Integration
  • ONESOURCE Pagero account credentials need to be shared with Oracle for authorization and authentication purposes.
  • Oracle needs to provide a webhook URL for invoice exchange between the systems.
  • The customer needs to be on the latest Oracle B2B platform. Or, they can use a version specified in the Oracle integration with Thomson Reuters documentation.
  • When redirected from Oracle Fusion to the ONESOURCE Platform, users sign in with their ONESOURCE credentials. After users sign in, they need to go to the
    API Administration
     section and turn on
    Edit
     access for E-Invoicing.
important
Thomson Reuters customer support will assist with account creation and onboarding. Once the ONESOURCE account is created, the sysadmin credentials will be shared with Oracle/Customer and need never to be shared externally.

Onboarding workflow

To onboard a user, an ONESOURCE Pagero account needs to be created and permissions assigned for a secure data exchange. Users logged into Oracle Fusion are redirected to the ONESOURCE Pagero platform. They sign in to authorize the connection and data exchange between the systems.
After sign in, users need to go to the
API Administration
 section and turn on
Edit
 access for E-Invoicing. This single step is required to authorize and authenticate the user and invoice transactions, where consent is registered.
Once consent is given, a client ID and secret key are generated. Oracle is then notified of both the authorization and the user's consent status. The user is then redirected back to the Oracle platform. This process grants a smooth onboarding experience and secure integration between the systems.
Platform Access
The support team needs to raise a request to the DB Provisioning Team at dbprovision.corporates@thomsonreuters.com for the following:
  • API Products:
     ONESOURCE E-invoicing, ONESOURCE E-invoicing Integration
  • API Administration access
  • Addition to the customer database
If you need help, contact customer support for more assistance on the ONESOURCE Onboarding documentation.

AP process workflow overview

Invoices are generated within the ONESOURCE Pagero system. This involves capturing transaction details and creating invoice documents that are ready for processing by Oracle.
In this integration, supplier invoices are first made available through the Pagero network. ONESOURCE E-Invoicing regularly retrieves available AP invoices and prepares them for processing as part of the embedded Oracle integration.
Once the invoices are ready, they are sent to Oracle for further processing. Oracle receives the invoices, validates them, and continues with standard AP invoice processing within the Oracle system.
If Oracle encounters any issues while processing an invoice, it sends a notification indicating the error. Based on this notification, ONESOURCE E-Invoicing automatically attempts to reprocess the affected invoice according to the defined retry rules. This ensures that temporary issues are handled smoothly and that invoices are processed reliably without intervening manually.

AR process workflow overview

In the AR integration, outbound sales invoices are generated in Oracle and made available for electronic invoicing processing. When AR invoices are ready, Oracle sends a notification indicating that one or more invoice files are available for processing.
When notified, ONESOURCE Pagero E-Invoicing retrieves AR invoice documents from Oracle and validates the information needed for processing. Each invoice is then submitted for compliance and transmission based on each country mandate and e-invoicing rules.
After submission, ONESOURCE Pagero E-Invoicing tracks the processing outcome and prepares a status response for Oracle. This response reflects whether the invoice is added for processing, still in progress, or failed because of an error. The status information enables Oracle to maintain visibility into the lifecycle of each AR invoice sent for e-invoicing.
If any issues arise during invoice retrieval or processing, ONESOURCE Pagero E-Invoicing reports them clearly. Exceptions and errors can then be identified and resolved through standard Oracle Fusion business processes.

Additional resources

To view the customer onboarding from the Oracle platform point of view and for further details, refer to the following documents published on the Oracle website: