File Export Job

The jobs that define what object and mapping will be exported. WARNING: This SDO has been deprecated and is being replaced with File Export Job V 2 (oracle.apps.crmCommon.bulkExport.bulkExportServiceV2.BulkExportJobs).

QName: {http://xmlns.oracle.com/apps/crmCommon/bulkExport/publicModel/}CrmCommonExportJobsSvcSDO

Logical Business Objects

• CRM : Common CRM : Bulk Export

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

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.
Delimiter	string	The delimiter to use. For example, comma, tab.
DescText	string	The job description.
EndDateTm	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The end date time.
EndOfLine	string	The End of Line character to use. 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	The unique number to identify a job.
ExportMapId	long	Identifies the export mapping used for field mappings.
FileCharset	string	The charset to use. For example, UTF-8, UTF-16, etc. Lookup to FND_LOOKUPS.
FileType	string	The file export type such as CSV (for future use XML).
HeaderRowIncluded	string	Indicates whether to include the header row in the output.
InitialExtractFilterTm	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	Saves the initial date time of the interval between which the data export has to happen.
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.
MassUpdateDtlId	long	Contains the mass update detail ID.
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) to use 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.
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.