ODBC Driver for Oracle Fusion Cloud Financials

Build 23.0.8839

Erpintegrations

This view will return maximum of 500 records. The view is deprecated.

Columns

Name Type Description
OperationName [KEY] String The name of the ERP Integration Service operations used to manage inbound and outbound data flows.
DocumentId String The unique identifier of a file associated with the row.
DocumentContent String The content of the file in Base64 encoded format.
FileName String The name of the data file to be processed by the ERP Integration Service.
ContentType String The type of content within a data file to be processed by the ERP Integration Service.
FileType String The file type that determines the execution details to be downloaded. Specify LOG as the file type to download the log and output file. Specify OUT as the file type to download only the output file. If no file type is specified, both the log files and output files are downloaded.
DocumentAccount String The account parameter to search for files corresponding to a specified security account.
Comments String The action that appends the specified comments to a file.
ProcessName String The name of a particular business application's data import process.
LoadRequestId String The unique identifier of the load process that populates data in a product interface table.
JobPackageName String The name of the Enterprise Scheduling Service job package that must be submitted.
JobDefName String The name of the Enterprise Scheduling Service job definition that must be submitted.
ReqstId String The unique identifier of the submitted Enterprise Scheduling Service job request.
RequestStatus String The current status of the Enterprise Scheduling Service job.
JobName String The job name and job package name separated by a comma.
ParameterList String The list of parameters used to run the Enterprise Scheduling Service job. The list determines the order of the parameters. The corresponding entry in the list must be blank when a given parameter is not passed.
NotificationCode String The two-digit code that determines the notification type and when the notification should be sent.
CallbackURL String The callback URL of the service implemented by a customer to receive the job status of an Enterprise Scheduling Service job upon its completion.
JobOptions String A web service operation input parameter. It specifies the inbound bulk data processing variation and the output file type that is generated when the data is processed.
StatusCode String The code representing the current status of the Enterprise Scheduling Service job.
ESSParameters String The list of parameters used to run the Enterprise Scheduling Service job. The list determines the order of the parameters. The corresponding entry in the list should be blank when a given parameter is not passed.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Comment String comment
DocAccount String docAccount
DocId String docId
FilePrefix String filePrefix
Finder String finder
RequestId String requestId

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839