Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

Erpintegrations

Automates bulk data import/export with configurable callbacks and error notifications, streamlining integration tasks.

Columns

Name Type Description
OperationName [KEY] String The name of the specific ERP Integration Service operation that is responsible for managing the inbound and outbound data flows, defining the type of interaction between the system and external sources.
DocumentId String A unique identifier for a file associated with a specific row in the system, used to track the document throughout its lifecycle in the ERP system.
DocumentContent String The actual content of the document, encoded in Base64 format for efficient transmission and storage within the system.
FileName String The name of the data file that is to be processed by the ERP Integration Service operation, typically indicating its contents or source.
ContentType String Specifies the type of content contained within the data file, providing context for the ERP Integration Service operation to determine how to process the file.
FileType String Defines the file type for determining which specific data or logs to download. Options include 'LOG' for log files, 'OUT' for output files, or no type specified to download both.
DocumentAccount String The account parameter used to search for files related to a particular security account within the ERP system, facilitating targeted searches for relevant data.
Comments String A field for appending additional comments to a file, used for documentation or providing context during processing.
ProcessName String The name of a specific business application’s data import process, which orchestrates the import of data from external sources into the system.
LoadRequestId String The unique identifier assigned to the load request that populates data into the product interface table, ensuring traceability of the data import process.
JobPackageName String The name of the job package within the Enterprise Scheduling Service that needs to be submitted to execute the scheduled job or task.
JobDefName String The name of the job definition in the Enterprise Scheduling Service job, detailing the specific job to be executed based on predefined parameters.
ReqstId String The unique identifier for the submitted job request within the Enterprise Scheduling Service, used to track the job throughout its lifecycle.
RequestStatus String Represents the current status of the Enterprise Scheduling Service job, such as 'pending', 'running', or 'completed', providing visibility into job progress.
JobName String The name of the job and the associated job package, separated by a comma, used to identify both the job and the package it belongs to.
ParameterList String A list of parameters required to execute the Enterprise Scheduling Service job. This list determines the order of the parameters, with blank entries for any parameters that are not passed.
NotificationCode String A two-digit code that defines the notification type and its timing, used to trigger notifications for specific operations like loadAndImportData or ExportBulkData.
CallbackURL String The URL where the ERP system sends job status updates upon completion, allowing external systems or services to track the job's outcome.
JobOptions String An input parameter for web service operations, specifying the variation of inbound bulk data processing and the type of output file generated after data processing.
StatusCode String A code representing the current status of the Enterprise Scheduling Service job, offering an indication of success, failure, or pending status.
ESSParameters String A list of parameters used to run the Enterprise Scheduling Service job, with each entry corresponding to a specific job parameter. Blank entries are used for parameters that are not provided.
Comment String A field for adding comments or notes related to the ERP integration, providing additional context for operations or troubleshooting.
DocAccount String An account identifier used in ERP integrations, associated with the specific document, facilitating searches and categorization of documents.
DocId String A unique identifier for a document in the ERP integration system, ensuring that the correct document is processed and tracked across operations.
FilePrefix String A prefix used to identify the file during integration operations, typically representing the type or source of the file for easier identification.
Finder String A field used to identify the search criteria or mechanism for locating specific ERP integrations, aiding in efficient querying and data retrieval.
RequestId String A unique identifier for the integration request, ensuring that the request is tracked and processed within the system for proper handling and completion.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454