CreateERPIntegrationsJob
Initializes bulk inbound or outbound data transfers, automating import and export tasks for ERP processes.
Stored Procedure Specific Information
Oracle Fusion Cloud Financials allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only the = comparison.
You can upload the attachment in one of the following ways.
- You can provide FileLocation to upload an attachment:
exec CreateERPIntegrationsJob JobOperationName='uploadFileToUCM', DocumentAccount='fin$/payables$/import$', FileLocation='D:\\abc.zip'
- You can provide FileName and FileContents (Base64 format) to upload an attachment:
exec CreateERPIntegrationsJob JobOperationName='uploadFileToUCM', DocumentAccount='fin$/payables$/import$', FileName='abc.zip', DocumentContent='UEsDBBQAAAAIABDvv73vv71ICBzvv73vv70KAAAACAAAAAgAAAB0ZXN0LnR4dHNMSlYISS0uAQBQSwECHwAUAAAACAAQ77+977+9SAgc77+977+9CgAAAAgAAAAIACQAAAAAAAAAIAAAAAAAAAB0ZXN0LnR4dAoAIAAAAAAAAQAYAFvvv71RYEHvv73vv70BASBPYEHvv73vv70B77+9HglgQe+/ve+/vQFQSwUGAAAAAAEAAQBaAAAAMAAAAAAA'
Input
| Name | Type | Description |
| JobOperationName | String | The name of the specific ERP Integration Service operation to manage the flow of inbound and outbound data, allowing the system to execute corresponding data processing tasks. |
| DocumentId | String | The unique identifier of a file associated with the current operation, used to track and reference the document within the system. |
| DocumentContent | String | The actual content of the file, encoded in Base64 format, allowing for transmission of binary or text data within the system. |
| FileName | String | The name of the data file that is being processed by the ERP Integration Service, typically representing the file’s role in the operation. |
| FileType | String | The type of file being processed, which determines the execution flow. For example, specifying 'LOG' downloads the log file, while 'OUT' only downloads the output file. |
| DocumentAccount | String | The security account parameter used to filter and search for files, ensuring that only those associated with the specified account are processed. |
| Comments | String | Text comments added to a file to provide additional context or instructions related to its processing or status. |
| ProcessName | String | The name of a specific data import process within a business application, which controls the flow of data into the system. |
| LoadRequestId | String | The unique identifier associated with the data load process that populates records in an interface table for subsequent processing. |
| JobPackageName | String | The name of the job package within the Enterprise Scheduling Service that contains multiple job definitions to be executed together. |
| JobDefName | String | The name of the job definition within the Enterprise Scheduling Service that specifies the exact tasks and operations to be performed. |
| ReqstId | String | The unique identifier of a job request submitted to the Enterprise Scheduling Service for execution, used to track and manage job progress. |
| RequestStatus | String | The current status of an Enterprise Scheduling Service job, such as pending, running, or completed, to provide visibility into the job's execution state. |
| JobName | String | The name of the job being executed, typically in combination with the job package name, to clearly identify the task in the scheduling system. |
| ParameterList | String | A list of input parameters used when executing a job within the Enterprise Scheduling Service job. The list controls job execution, and parameters not passed are left blank. |
| NotificationCode | String | A two-digit code indicating the type and timing of notifications, such as bell or email notifications, triggered by specific operations like load, import, or export. |
| CallbackURL | String | The URL where job status updates are sent once the Enterprise Scheduling Service job has completed, allowing for external monitoring of job results. |
| JobOptions | String | An input parameter for web services specifying the data processing variation and the output file type generated after bulk data processing is completed. |
| StatusCode | String | The status code representing the current state of the Enterprise Scheduling Service job, used for internal tracking and determining next actions. |
| ESSParameters | String | A list of parameters for job execution within the Enterprise Scheduling Service job. Parameters control job behavior and should be filled based on the requirements of the task. |
| FileLocation | String | The file path or URL indicating where the file that needs to be uploaded is stored, enabling the system to access and process the file. |
Result Set Columns
| Name | Type | Description |
| OperationName | String | The name of the ERP Integration Service operation executed, reflecting the task performed during the data integration process. |
| DocumentId | String | The unique identifier for the document associated with the current operation, allowing for subsequent reference or tracking within the system. |
| DocumentContent | String | The content of the document, encoded in Base64 format, representing the data returned from the operation for further processing or storage. |
| FileName | String | The name of the file that was processed or generated by the ERP Integration Service during the operation, useful for identifying the data file. |
| ContentType | String | The type of content (such as JSON or XML) within the processed file, guiding the system in how to interpret and handle the file contents. |
| FileType | String | The type of file processed, indicating whether the file contains logs, output data, or other content, and determining what files are downloaded during the operation. |
| DocumentAccount | String | The security account associated with the file, allowing the system to filter or process files based on account-related permissions or specifications. |
| Comments | String | Text comments that were appended to a file during the operation, providing context, updates, or notes related to the file's processing. |
| ProcessName | String | The name of the specific data import process executed by the business application, indicating the type of data being handled. |
| LoadRequestId | String | The unique identifier of the load process that populated data into the interface table, allowing for tracking and auditing of data loads. |
| JobPackageName | String | The name of the Enterprise Scheduling Service job package that was executed, containing multiple tasks performed as part of the process. |
| JobDefName | String | The name of the Enterprise Scheduling Service job definition executed, indicating the specific job or task completed within the scheduling system. |
| ReqstId | String | The unique identifier of the Enterprise Scheduling Service job request, used to track the request’s execution and status within the system. |
| RequestStatus | String | The current status of the Enterprise Scheduling Service job, reflecting whether it has been completed, is in progress, or has encountered an error. |
| JobName | String | The name of the job executed, combined with the job package name, providing clear identification of the task performed within the Scheduling Service job. |
| ParameterList | String | The list of parameters passed during job execution, providing insight into the specific inputs used to drive the job's behavior and results. |
| NotificationCode | String | A two-digit code determining the type and timing of notifications sent for the job, used to trigger actions like sending alerts or emails. |
| CallbackURL | String | The URL to which job status updates are sent upon completion, allowing external systems or services to track the progress of the job. |
| JobOptions | String | A parameter for web services that defines the inbound data processing variation and the type of output file generated, guiding subsequent actions based on the file type. |
| StatusCode | String | The code representing the current status of the job, helping to monitor and track the progress and completion state of the Enterprise Scheduling Service job. |
| ESSParameters | String | The list of parameters used during job execution, detailing the sequence and presence of each parameter, ensuring correct job processing. |