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