File Export Job Version 2
The jobs that define what object and mapping will be exported.
QName: {http://xmlns.oracle.com/apps/crmCommon/bulkExport/bulkExportServiceV2/}BulkExportJobs
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Previous version is |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
ActiveFlag |
boolean |
Indicates whether the task is active (registered within ESS). |
Compression |
string |
The compression options available. G=gzip individual files, Z=create single zip of all files, J=create single zip of all files. |
CreatedBy |
string |
The user who created the record. |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
DateFormat |
string |
The date format to be used in job record. |
DecimalSeparator |
string |
The decimal separator used. |
Delimiter |
string |
The delimiter to use such as comma, tab. |
DescriptionText |
string |
The job description. |
EmailAddress |
string |
Email Address to be used for sending notification email on export activity completion. |
EndDateTm |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The end date time. |
EndOfLine |
string |
The End of Line character used. Lookup to be CR, LF, or CRLF. Default: LF. |
ErrorThreshold |
int |
The number of errors to allow before aborting. A value of Null indicates that there is no limit. |
ExportJobId |
long |
The primary key for the export job.
|
ExportJobNumber |
string |
This identifies the export job. |
ExportMapId |
long |
Identifies the export mapping used for field mappings. |
FileCharset |
string |
The character set to use. For example, UTF-8, UTF-16, etc. Lookup to FND_LOOKUPS. |
FileType |
string |
The file export type, e.g. CSV (for future use XML). |
HeaderRowIncluded |
string |
Indicates whether or not to include the header row in the output. |
LastBatchId |
long |
The most recently run batch. |
LastBatchStartTm |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The last time a batch for this job was started. |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
LastUpdateLogin |
string |
The login of the user who last updated the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
Name |
string |
The export job name. |
NextScheduleTm |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The next scheduled date. |
NullValue |
string |
The value used to represent a null value. If null itself no value is output. Default: null. |
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
ParentRequestId |
long |
The parent scheduler request in case of repeating exports. |
QuoteChar |
string |
The character(s) used to encapsulate value if it contains the delimiter (e.g. double quote, single quote, null for nothing). |
RepeatFrequency |
long |
The number of repeat frequency. |
RepeatUnitCd |
string |
The repeat unit code. Options are hours, days, weeks, and months. |
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
ScheduleModeCd |
string |
The schedule mode. The options are repeating, one time (manually), and one time (scheduled). |
ScheduleStatusCd |
string |
The schedule status. The options are scheduled, not scheduled, running, complete, and error. |
ScheduleTypeCd |
string |
The code defining the type of schedule. Options are Immediate and Scheduled. |
StartTm |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The start date for schedule. |
TimestampFormat |
string |
The timestamp format to be used in job record. |