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	File Export Job
Handled by	Bulk Export Version 2

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. Primary Key
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.