Présentation

Cloud HCM permet d'extraire des données de HCM à l'aide d'une plate-forme de nouvelle génération avec un magasin de données optimisé pour la lecture.

Objectifs

À la fin de ce tutoriel, vous comprendrez comment :

• Vues d'extraction d'interrogation et leur hiérarchie d'objets
• Soumettre et suivre de manière asynchrone les demandes de tâche d'extraction pour l'extraction des données sélectionnées
• Télécharger les fichiers de sortie d'extraction

Préalables

Avant de commencer :

1. Communiquez avec le service d'excellence d'Oracle pour vous assurer que le magasin de données optimisé pour la lecture est provisionné dans votre pod et que vos données sont en cours de réplication
2. Effectuer la configuration de sécurité requise, notamment :
   • Configuration de la sécurité des données
   • Configuration de l'application client OAuth

Consultez le tutoriel Configurer la sécurité pour l'extraction de données à partir du magasin de données optimisé en lecture HCM.

Cas d'utilisation

Cette fonctionnalité vous permet de traiter les cas d'utilisation suivants.

Extraction complète des données

L'extraction complète des données sélectionnées peut être ponctuelle ou périodique.

Vous pouvez extraire toute la hiérarchie d'objets ou simplement un sous-ensemble de celle-ci.

L'extraction complète des données extrait tous les enregistrements qui correspondent aux critères de filtrage et les fichiers de sortie peuvent être très volumineux.

Les objets avec date en vigueur seront extraits à la date en vigueur demandée, où la date d'extraction courante est la valeur par défaut.

Extraction incrémentielle des données

L'extraction incrémentielle des données sélectionnées est généralement une activité programmée périodique.

Vous pouvez extraire toute la hiérarchie d'objets ou simplement un sous-ensemble de celle-ci.

Dans ce cas d'utilisation, vous souhaitez extraire uniquement les objets qui ont été modifiés depuis l'exécution d'extraction précédente, où la première exécution d'extraction est la ligne de base. Pour ce faire, les filtres d'attributs timeUpdated doivent être appliqués à tous les niveaux pouvant faire l'objet d'une détection de modification.

L'interrogation d'extraction de données incrémentielle peut appliquer des critères de filtrage supplémentaires. Les fichiers de sortie sont généralement plus petits par rapport à l'extraction complète, car ils ne contiennent que des delta.

Seules les valeurs courantes des attributs seront extraites.

Les objets avec date en vigueur seront extraits à la date en vigueur demandée, où la date d'extraction courante est la valeur par défaut.

Attention :

Les enregistrements physiquement supprimés ne seront pas retournés à l'aide du filtrage par timeUpdated.

Tâche 1 : Choisir une vue d'extraction

Sélectionnez la vue d'extraction à utiliser, en fonction des objets et des attributs requis. Les vues disponibles à partir de la version 26B sont listées ci-dessous, ainsi que les objets et les attributs qui peuvent être extraits, regroupés par module.

Pour les objets avec date en vigueur, vous trouverez généralement une vue régulière qui retourne les données en vigueur à la date indiquée et, en outre, une vue historique qui retourne tous les enregistrements avec date en vigueur.

Plusieurs langues :

Les attributs traduisibles ne sont disponibles qu'en anglais à ce stade.

Global HR - Emploi

Nom du module	oraHcmHrCoreEmployment
Chemin du contexte du module	hcmHrCore/employment

Nom de vue	Attributs
actionExtracts	id code startDate endDate nom description timeCreated timeUpdated createdBy updatedBy
actionOccurrenceExtraits	id actionDate actionTypeCode categoryCode createdBy entityType freezeStartDate freezeUntilDate howToProcess parentEntityType proposedActionType proposedStartDate proposedWorkerType submittedBy timeCreated timeUpdated updatedBy actionReason.id actionReason.code actionReason.name action.id action.code action.name
actionMotifExtraits	id code nom créépar description endDate startDate timeCreated timeUpdated updatedBy
assignmentStatusTypeExtracts	id userStatus assignmentStatusCode activeFlag defaultFlag fromDate toDate timeCreated timeUpdated createdBy updatedBy
contractExtracts	id endDate contractNumber contractualJobTitle description documentStatus documentStatusChangeDate duration durationUnits effectiveEndDate effectiveStartDate endReason extensionPeriod extensionPeriodUnits extensionReason numberOfExtensions parties reference startReason statusReason createdBy timeCreated timeUpdated updatedBy type.lookupCode type.lookupType type.meaning country.territoryCode country.territoryShortName workRelationship.id workRelationship.startDate workRelationship.workerType personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentType assignment.businessTitle assignment.assignmentNumber assignment.primaryFlag assignment.assignmentStatusType
documentOfRecordExtraits	id comments createdBy creationSource dateFrom dateTo documentCode documentName documentNumber issuedDate issuingAuthority issuingCountry issuingLocation publish publishDate relatedObjectName status tagList timeCreated timeUpdated updatedBy verifiedBy verifiedDate personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentType assignment.businessTitle assignment.assignmentNumber assignment.primaryFlag assignment.assignmentStatusType
DocumentOfRecordTypeExtraits	id activeInactiveFlag archiveCriteriaBasis archiveCriteriaDays authorizationRequired biReportPath categoryCode commentsLabel commentsRequired createdBy dateFromLabel dateFromRequired dateToLabel dateToRequired description documentNameLabel documentNameRequired documentNumberLabel documentNumberRequired documentType documentTypeLevel hierarchyCode issuedDateLabel issuedDateRequired issuingAuthorityLabel issuingAuthorityRequired issuingCountryLabel issuingCountryRequired issuingLocationLabel issuingLocationRequired legislationCode lockCreate lockCreateRoleList lockDelete lockDeleteRoleList lockUpdate lockUpdateRoleList minimumAttachmentsCount multipleOccurencesFlag publishRequired purgeArchiveCriteriaDays subCategoryCode systemDocumentType tagList timeCreated timeUpdated updatedBy warningPeriod
emailExtracts	id fromDate toDate type emailAddress primaryFlag createdBy timeCreated updatedBy timeUpdated personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
legislativeInformationExtracts	id effectiveStartDate effectiveEndDate gender maritalStatus maritalStatusChangeDate highestEducationLevel createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
legislativeInformationHistoryExtracts	id effectiveStartDate effectiveEndDate gender maritalStatus maritalStatusChangeDate highestEducationLevel createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber
managerHierarchyExtracts	effectiveStartDate effectiveEndDate personId assignmentId managerType managerLevel managerId managerAssignmentId primaryAssignmentFlag primaryManagerFlag createdBy timeCreated updatedBy timeUpdated personAssignment.id personAssignment.effectiveStartDate personAssignment.effectiveEndDate personAssignment.effectiveSequence personAssignment.effectiveLatestChange personAssignment.assignmentType personAssignment.assignmentNumber personAssignment.primaryFlag personAssignment.businessTitle personAssignment.workAtHomeFlag personAssignment.officeBuilding personAssignment.officeFloor personAssignment.officeMailStop personAssignment.officeNumber personAssignment.primaryAssignmentFlag personAssignment.primaryWorkRelationshipFlag personAssignment.timeUpdated personAssignment.updatedBy personAssignment.timeCreated personAssignment.createdBy personAssignment.systemPersonType personAssignment.labourUnionMemberFlag personAssignment.managerFlag personAssignment.probationEndDate personAssignment.probationPeriod personAssignment.probationPeriodUnit personAssignment.normalHours personAssignment.frequency personAssignment.endTime personAssignment.startTime personAssignment.noticePeriod personAssignment.noticePeriodUOM personAssignment.workerCategory personAssignment.assignmentCategory personAssignment.hourlyPaidOrSalaried personAssignment.projectedEndDate personAssignment.projectedStartDate personAssignment.assignmentStatusType personAssignment.retirementAge personAssignment.retirementDate personAssignment.synchronizeFromPositionFlag personAssignment.fullTimeOrPartTime personAssignment.permanentAssignmentFlag personAssignment.seniorityBasis personAssignment.overtimePeriod personAssignment.adjustedFullTimeEquivalent personAssignment.annualWorkingDuration personAssignment.annualWorkingDurationUnit personAssignment.annualWorkingRatio personAssignment.standardFrequency personAssignment.standardWorkingHours personAssignment.standardAnnualWorkingDuration personAssignment.sequence personAssignment.department.id personAssignment.department.name personAssignment.department.title personAssignment.department.effectiveStartDate personAssignment.department.effectiveEndDate personAssignment.legalEmployer.id personAssignment.legalEmployer.name personAssignment.legalEmployer.effectiveStartDate personAssignment.legalEmployer.effectiveEndDate personAssignment.legislation.territoryCode personAssignment.legislation.territoryShortName personAssignment.position.id personAssignment.position.effectiveStartDate personAssignment.position.effectiveEndDate personAssignment.position.name personAssignment.position.code personAssignment.grade.id personAssignment.grade.effectiveStartDate personAssignment.grade.effectiveEndDate personAssignment.grade.name personAssignment.grade.code personAssignment.location.id personAssignment.location.effectiveStartDate personAssignment.location.effectiveEndDate personAssignment.location.name personAssignment.location.code personAssignment.location.mainAddress.id personAssignment.location.mainAddress.effectiveStartDate personAssignment.location.mainAddress.effectiveEndDate personAssignment.location.mainAddress.county personAssignment.location.mainAddress.state personAssignment.location.mainAddress.province personAssignment.location.mainAddress.townOrCity personAssignment.location.mainAddress.postalCode personAssignment.location.mainAddress.longPostalCode personAssignment.location.mainAddress.addressLine1 personAssignment.location.mainAddress.addressLine2 personAssignment.location.mainAddress.addressLine3 personAssignment.location.mainAddress.addressLine4 personAssignment.location.mainAddress.country.territoryCode personAssignment.location.mainAddress.country.territoryShortName personAssignment.job.id personAssignment.job.effectiveStartDate personAssignment.job.effectiveEndDate personAssignment.job.name personAssignment.job.code personAssignment.job.jobFunctionCode personAssignment.job.managerLevel personAssignment.job.jobFamily.id personAssignment.job.jobFamily.effectiveStartDate personAssignment.job.jobFamily.effectiveEndDate personAssignment.job.jobFamily.code personAssignment.job.jobFamily.name personAssignment.collectiveAgreement.id personAssignment.collectiveAgreement.effectiveStartDate personAssignment.collectiveAgreement.effectiveEndDate personAssignment.collectiveAgreement.name personAssignment.personType.id personAssignment.personType.userPersonType personAssignment.workerUnion.id personAssignment.workerUnion.effectiveStartDate personAssignment.workerUnion.effectiveEndDate personAssignment.workerUnion.name personAssignment.assignmentUserStatus.id personAssignment.assignmentUserStatus.userStatus personAssignment.businessUnit.id personAssignment.businessUnit.effectiveStartDate personAssignment.businessUnit.effectiveEndDate personAssignment.businessUnit.name personAssignment.account.codeCombinationId personAssignment.account.concatenatedSegments personAssignment.account.chartOfAccountsId personAssignment.ledger.ledgerId personAssignment.ledger.name personAssignment.workRelationship.id personAssignment.workRelationship.startDate personAssignment.workRelationship.workerType personAssignment.workRelationship.timeCreated personAssignment.workRelationship.timeUpdated personAssignment.localName.id personAssignment.localName.effectiveStartDate personAssignment.localName.effectiveEndDate personAssignment.localName.lastName personAssignment.localName.firstName personAssignment.localName.displayName personAssignment.localName.listName personAssignment.localName.timeCreated personAssignment.localName.timeUpdated personAssignment.globalName.id personAssignment.globalName.effectiveStartDate personAssignment.globalName.effectiveEndDate personAssignment.globalName.lastName personAssignment.globalName.firstName personAssignment.globalName.displayName personAssignment.globalName.listName personAssignment.globalName.timeCreated personAssignment.globalName.timeUpdated personAssignment.personDetail.id personAssignment.personDetail.personNumber personAssignment.personDetail.effectiveStartDate personAssignment.personDetail.effectiveEndDate personAssignment.personDetail.timeCreated personAssignment.personDetail.timeUpdated personAssignment.actionOccurrence.id personAssignment.peopleGroup.id
nameExtracts	id effectiveStartDate effectiveEndDate type lastName firstName middleNames title prefix suffix knownAs previousLastName honors militaryRank displayName fullName listName orderName createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
nationalIdentifierExtracts	id createdBy expirationDate issueDate identifierNumber placeOfIssue timeCreated timeUpdated updatedBy country.territoryCode country.territoryShortName type.lookupCode type.lookupType type.meaning personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
personnesGroupeExtraits	id createdBy enabledFlag endDateActive groupName startDateActive summaryFlag timeCreated timeUpdated updatedBy
personAddressExtracts	effectiveStartDate effectiveEndDate id type createdBy timeCreated timeUpdated updatedBy building floorNumber townOrCity postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province primaryFlag personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate country.territoryCode country.territoryShortName
personAddressHistoryExtracts	effectiveStartDate effectiveEndDate id type createdBy timeCreated timeUpdated updatedBy building floorNumber townOrCity postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province primaryFlag personDetail.id personDetail.personNumber country.territoryCode country.territoryShortName
personTypeExtracts	id userPersonType systemPersonType activeFlag defaultFlag timeCreated timeUpdated createdBy updatedBy
phoneExtracts	id fromDate toDate phoneNumber areaCode countryCodeNumber extension primaryFlag validity createdBy timeCreated updatedBy timeUpdated legislation.territoryCode legislation.territoryShortName type.lookupCode type.lookupType type.meaning personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
workerAssignmentExtracts	id effectiveStartDate effectiveEndDate effectiveSequence effectiveLatestChange assignmentType assignmentNumber primaryFlag businessTitle workAtHomeFlag officeBuilding officeFloor officeMailStop officeNumber primaryAssignmentFlag primaryWorkRelationshipFlag timeUpdated updatedBy timeCreated createdBy systemPersonType labourUnionMemberFlag managerFlag probationEndDate probationPeriod probationPeriodUnit normalHours frequency endTime startTime noticePeriod noticePeriodUOM workerCategory assignmentCategory hourlyPaidOrSalaried projectedEndDate projectedStartDate assignmentStatusType expenseCheckSendToAddress retirementAge retirementDate synchronizeFromPositionFlag fullTimeOrPartTime permanentAssignmentFlag seniorityBasis overtimePeriod adjustedFullTimeEquivalent annualWorkingDuration annualWorkingDurationUnit annualWorkingRatio standardFrequency standardWorkingHours standardAnnualWorkingDuration sequence department.id department.name department.title department.effectiveStartDate department.effectiveEndDate legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate legislation.territoryCode legislation.territoryShortName position.id position.effectiveStartDate position.effectiveEndDate position.name position.code grade.id grade.effectiveStartDate grade.effectiveEndDate grade.name grade.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code location.mainAddress.id location.mainAddress.effectiveStartDate location.mainAddress.effectiveEndDate location.mainAddress.county location.mainAddress.state location.mainAddress.province location.mainAddress.townOrCity location.mainAddress.postalCode location.mainAddress.longPostalCode location.mainAddress.addressLine1 location.mainAddress.addressLine2 location.mainAddress.addressLine3 location.mainAddress.addressLine4 location.mainAddress.country.territoryCode location.mainAddress.country.territoryShortName job.id job.effectiveStartDate job.effectiveEndDate job.name job.code job.jobFunctionCode job.managerLevel job.jobFamily.id job.jobFamily.effectiveStartDate job.jobFamily.effectiveEndDate job.jobFamily.code job.jobFamily.name collectiveAgreement.id collectiveAgreement.effectiveStartDate collectiveAgreement.effectiveEndDate collectiveAgreement.name personType.id personType.userPersonType workerUnion.id workerUnion.effectiveStartDate workerUnion.effectiveEndDate workerUnion.name assignmentUserStatus.id assignmentUserStatus.userStatus businessUnit.id businessUnit.effectiveStartDate businessUnit.effectiveEndDate businessUnit.name account.codeCombinationId account.concatenatedSegments account.chartOfAccountsId ledger.ledgerId ledger.name workRelationship.id workRelationship.startDate workRelationship.workerType workRelationship.timeCreated workRelationship.timeUpdated localName.id localName.effectiveStartDate localName.effectiveEndDate localName.lastName localName.firstName localName.displayName localName.listName localName.timeCreated localName.timeUpdated globalName.id globalName.effectiveStartDate globalName.effectiveEndDate globalName.lastName globalName.firstName globalName.displayName globalName.listName globalName.timeCreated globalName.timeUpdated personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate personDetail.timeCreated personDetail.timeUpdated actionOccurrence.id peopleGroup.id
workerAssignmentHistoryExtracts	id effectiveStartDate effectiveEndDate effectiveSequence effectiveLatestChange assignmentType assignmentNumber primaryFlag businessTitle workAtHomeFlag officeBuilding officeFloor officeMailStop officeNumber primaryAssignmentFlag primaryWorkRelationshipFlag timeUpdated updatedBy timeCreated createdBy systemPersonType labourUnionMemberFlag managerFlag probationEndDate probationPeriod probationPeriodUnit normalHours frequency endTime startTime noticePeriod noticePeriodUOM workerCategory assignmentCategory hourlyPaidOrSalaried projectedEndDate projectedStartDate assignmentStatusType expenseCheckSendToAddress retirementAge retirementDate synchronizeFromPositionFlag fullTimeOrPartTime permanentAssignmentFlag seniorityBasis overtimePeriod adjustedFullTimeEquivalent annualWorkingDuration annualWorkingDurationUnit annualWorkingRatio standardFrequency standardWorkingHours standardAnnualWorkingDuration sequence department.id legalEmployer.id legislation.territoryCode legislation.territoryShortName position.id grade.id location.id location.mainAddress.id location.mainAddress.country.territoryCode location.mainAddress.country.territoryShortName job.id job.jobFamily.id collectiveAgreement.id personType.id personType.userPersonType workerUnion.id assignmentUserStatus.id assignmentUserStatus.userStatus businessUnit.id account.codeCombinationId account.concatenatedSegments account.chartOfAccountsId ledger.ledgerId ledger.name workRelationship.id localName.id globalName.id personDetail.id personDetail.personNumber actionOccurrence.id peopleGroup.id
travailleursExtraits	id personDetail.id personDetail.effectiveStartDate personDetail.effectiveEndDate personDetail.personNumber personDetail.primaryNationalIdentifier.id personDetail.primaryNationalIdentifier.identifierNumber personDetail.primaryEmail.id personDetail.primaryEmail.emailAddress personDetail.primaryPhone.id personDetail.primaryPhone.phoneNumber personDetail.primaryPhone.areaCode personDetail.primaryPhone.countryCodeNumber personDetail.primaryPhone.extension personDetail.mailingAddress.id personDetail.mailingAddress.effectiveStartDate personDetail.mailingAddress.effectiveEndDate personDetail.mailingAddress.addressLine1 personDetail.mailingAddress.addressLine2 personDetail.mailingAddress.addressLine3 personDetail.mailingAddress.addressLine4 personDetail.mailingAddress.building personDetail.mailingAddress.floorNumber personDetail.mailingAddress.townOrCity personDetail.mailingAddress.county personDetail.mailingAddress.state personDetail.mailingAddress.province personDetail.mailingAddress.postalCode personDetail.mailingAddress.longPostalCode personDetail.mailingAddress.country.territoryCode personDetail.mailingAddress.country.territoryShortName personDetail.localName.id personDetail.localName.effectiveStartDate personDetail.localName.effectiveEndDate personDetail.localName.lastName personDetail.localName.firstName personDetail.localName.displayName personDetail.localName.listName personDetail.globalName.id personDetail.globalName.effectiveStartDate personDetail.globalName.effectiveEndDate personDetail.globalName.lastName personDetail.globalName.firstName personDetail.globalName.displayName personDetail.globalName.listName
workRelationshipExtracts	id startDate workerType timeCreated timeUpdated workerNumber primaryFlag createdBy updatedBy readyToConvertFlag enterpriseSeniorityDate legalEmployerSeniorityDate onMilitaryServiceFlag lastWorkingDate terminationDate notificationDate projectedTerminationDate legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate

Global HR - Structures de travail

Nom du module	oraHcmHrCoreWorkStructures
Chemin du contexte du module	hcmHrCore/workStructures

Nom de vue	Attributs
gradeExtracts	id code effectiveStartDate effectiveEndDate status timeUpdated updatedBy timeCreated createdBy name actionOccurrence.id
gradeHistoryExtracts	id code effectiveStartDate effectiveEndDate status timeUpdated updatedBy timeCreated createdBy name actionOccurrence.id
GradeLadderExtraits	id effectiveStartDate effectiveEndDate activeStatus allowProgressionOverrideFlag allowSalaryOverrideFlag autoProgressionCode autoSalaryChangeCode createdBy groupCode gradeType name progressionDateCode progressionStyleCode rateChangeDateCode salaryAdjustmentTypeCode salaryCalculationMethodCode salaryChangeDateCode salaryUpdateMethodCode stepDeterminationCode timeCreated timeUpdated updateSalaryFlag updatedBy actionOccurrence.id
jobExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobFamilyExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobFamilyHistoryExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
jobHistoryExtracts	id effectiveStartDate effectiveEndDate code status createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
legislativeDataGroupExtracts	id name createdBy timeCreated timeUpdated updatedBy country.territoryCode country.territoryShortName
localisationAdresseExtraits	id effectiveStartDate effectiveEndDate type building floorNumber townOrCity countryCode postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province createdBy updatedBy timeCreated timeUpdated addressCreatedBy addressTimeCreated addressTimeUpdated addressUpdatedBy
locationExtracts	id code createdBy timeCreated updatedBy timeUpdated employeeLocationFlag effectiveStartDate effectiveEndDate countryCode status shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdated timezoneCode description name actionOccurrence.id mainAddress.id mainAddress.effectiveStartDate mainAddress.effectiveEndDate
locationHistoryExtracts	id code createdBy timeCreated updatedBy timeUpdated employeeLocationFlag effectiveStartDate effectiveEndDate countryCode status shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdated timezoneCode description name actionOccurrence.id
organizationExtracts	id effectiveStartDate effectiveEndDate name title createdBy updatedBy timeCreated timeUpdated classifications.id classifications.effectiveStartDate classifications.effectiveEndDate classifications.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code
organizationHistoryExtracts	id effectiveStartDate effectiveEndDate name title createdBy updatedBy timeCreated timeUpdated classifications.id classifications.effectiveStartDate classifications.effectiveEndDate classifications.code location.id location.effectiveStartDate location.effectiveEndDate location.name location.code
positionExtracts	id effectiveStartDate effectiveEndDate code status hiringStatus createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id
positionHistoryExtracts	id effectiveStartDate effectiveEndDate code status hiringStatus createdBy timeCreated updatedBy timeUpdated name actionOccurrence.id

Éléments communs HCM - Événements

Nom du module	oraHcmHrCoreEvents
Chemin du contexte du module	hcmHrCore/events

Nom de vue

Attributs

objectChangeExtracts

id sourceObjectName groupSequence operationType dateEffectiveMode effectiveDate keyAttribute1Name keyAttribute1DataType keyAttribute1StringValue keyAttribute1NumberValue keyAttribute1DateValue keyAttribute2Name keyAttribute2DataType keyAttribute2StringValue keyAttribute2NumberValue keyAttribute2DateValue keyAttribute3Name keyAttribute3DataType keyAttribute3StringValue keyAttribute3NumberValue keyAttribute3DateValue purgeDate createdBy timeCreated updatedBy timeUpdated changeComponents.id changeComponents.physicalType changeComponents.logicalType changeComponents.oldEffectiveStartDate changeComponents.newEffectiveStartDate changeComponents.oldEffectiveEndDate changeComponents.newEffectiveEndDate changeComponents.oldEffectiveSequence changeComponents.newEffectiveSequence changeComponents.createdBy changeComponents.timeCreated changeComponents.updatedBy changeComponents.timeUpdated changeComponents.changedAttributes.changedAttributesXml

Paie - Définitions de solde

Nom du module	oraHcmPayrollBalanceDefinitions
Chemin du contexte du module	hcmPayroll/balanceDefinitions

Nom de vue	Attributs
SoldeAttributExtraits par défaut	id createdBy legislationCode timeCreated timeUpdated updatedBy legislativeDataGroup.id balanceDimension.id attributeExclusion.id
SoldeAttributExtraits	id createdBy legislationCode timeCreated timeUpdated updatedBy legislativeDataGroup.id definedBalance.id attributeExclusion.id
soldesDimensionExtraits	id code legislationCode dimensionLevel dimensionType periodType baseDatabaseItemSuffix description paymentsFlag expiryCheckingLevel feedCheckingType initialDate timeUpdated timeCreated timePeriod.id timePeriod.name initialTimeDefinition.id initialTimeDefinition.name expiryTimeDefinition.id expiryTimeDefinition.name startTimeDefinition.id startTimeDefinition.name endTimeDefinition.id endTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name assignmentActionBalanceDimension.id
extractions de soldes	id code currencyCode description name remunerationFlag reportingName timeCreated timeUpdated uomCode legislationCode createdBy updatedBy comments baseBalanceType.id baseBalanceType.name inputValue.id inputValue.effectiveStartDate inputValue.effectiveEndDate legislativeDataGroup.id
balanceGroupeAttributExclusionExtraits	id code altérable législationCode groupLevelFlag timeCreated timeUpdated createdBy updatedBy balanceDimension.id legislativeDataGroup.id legislativeDataGroup.name
balanceGroupeAttributInclusionExtraits	id legislationCode timeCreated timeUpdated balanceGroup.id attributeExclusion.id legislativeDataGroup.id legislativeDataGroup.name
soldesGroupesExtractions	id code législationCode balanceCategoryAttributeFlag balanceDimensionAttributeFlag groupLevelFlag timeCreated timeUpdated legislativeDataGroup.id
BalanceGroupUsageExtraits	id balanceReportType createdBy description formatType legislationCode timeCreated timeUpdated updatedBy code nom balanceGroup.id legialtiveDataGroup.id
BalanceReportSortItemExtracts	id createdBy legislationCode timeCreated timeUpdated updatedBy sequenceNumber legialtiveDataGroup.id
Extractions de solde définies	id legislationCode grossupAllowedFlag grossupExcludeByDefault saveRunBalance timeCreated timeUpdated balanceType.id balanceType.name balanceDimension.id legislativeDataGroup.id
dimensionUsageExtraits	id name databaseItemSuffix legislationCode useInExceptionReportingFlag timeCreated timeUpdated balanceDimension.id legislativeDataGroup.id

Paie - Définitions d'élément

Nom du module	oraHcmPayrollElementDefinitions
Chemin du contexte du module	hcmPayroll/elementDefinitions

Nom de vue	Attributs
élémentClassificationExtraits	id code costableFlag costingDebitOrCredit createByDefaultFlag createdBy dateFrom dateTo defaultHighPriority defaultLowPriority defaultPriority description distributableOverFlag frequencyRuleEnabledFlag legislationCode name nonPaymentsFlag processWhenEarningFlag secondaryClassificationFlag timeCreated timeUpdated updatedBy baseClassification.id baseClassification.name parentClassification.id parentClassification.name legislativeDataGroup.id legislativeDataGroup.name
élémentHistoriqueExtraits	id code effectiveStartDate effectiveEndDate grossupFlag indirectOnlyFlag inputCurrencyCode outputCurrencyCode iterativeFlag iterativePriority creatorType deductionOrExemption legislationCode multipleEntriesAllowedFlag onceEachPeriodFlag processInRunFlag processMode processingPriority processingType standardLinkFlag timeDefinitionType validationOverrideMessage closedForEntryFlag additionalEntryAllowedFlag timeUpdated updatedBy timeCreated createdBy category description expeditedMode name parentBaseElementName reportingName primaryClassification.id primaryClassification.name secondaryClassification.id secondaryClassification.name endingTimeDefinition.id endingTimeDefinition.name frequencyTimeDefinition.id frequencyTimeDefinition.name startingTimeDefinition.id startingTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
inputValueHistoryExtracts	id code createdBy defaultValue displaySequence effectiveEndDate effectiveStartDate forceRunResultValueFlag generateDatabaseItemsFlag hotDefaultFlag lookupType mandatoryFlag maximumValue minimumValue name reservedInputValue retroActiveStaticFlag timeCreated timeUpdated unitOfMeasure updatedBy userDisplayFlag userEnterableFlag validationOverrideMessage valueSetCode viewObjectName warningOrError element.id element.name

Paie - Définitions de paie

Nom du module	oraHcmPayrollDefinitions
Chemin du contexte du module	hcmPayroll/definitions

Nom de vue	Attributs
consolidationGroupesExtractions	id code name timeCreated timeUpdated description createdBy updatedBy legislativeDataGroup.id legislativeDataGroup.name
historique de la paieExtraits	id effectiveStartDate effectiveEndDate name periodType firstPeriodEndDate numberOfYears periodResetYears cutoffDateOffset regularEarnDateOffset regularProcessDateOffset payslipViewDateOffset negativePayAllowedFlag timeCreated timeUpdated baseOffsets paymentDayType payslipAvailabilityDayType cutoffDayType payrollRunDayType earningsDayType payslipAvailabilityBaseDate cutoffBaseDate payrollRunBaseDate earningsBaseDate paymentBaseDate earningsOffsetDays paymentOffsetDays payslipAvailabilityOffsetDays cutoffOffsetDays payslipOffset earningsOffset processOffset cutoffOffset defaultPaydateOffset earningsFixedDate payslipAvailabilityFixedDate cutoffFixedDate payrollRunFixedDate paymentFixedDate reportingName processSubDateOffset plannedSubmissionDayType plannedSubmissionBaseDate processSubOffset plannedSubmissionFixedDate consolidationGroup.id consolidationGroup.name ledger.ledgerId timeDefinition.id timeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
timeDefinitionExtracts	id shortName name definitionType periodType periodUnit dayAdjustment legislationCode numberOfYears startDate creatorType dynamicCode timeCreated timeUpdated createdBy updatedBy baseTimeDefinition.id baseTimeDefinition.name periodTimeDefinition.id periodTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
TimePeriodExtraits	id legislationCode endDate name periodNumber periodType startDate cutOffDate description periodSetName periodYear quarterNumber quickpayDisplayNumber runDisplayNumber status defaultPaydate regularProcessDate plannedSubmissionDate regularEarnDate yearNumber periodCategory payslipViewDate timeCreated timeUpdated createdBy updatedBy payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name timeDefinition.id timeDefinition.name legislativeDataGroup.id legislativeDataGroup.name

Paie - Liens avec la paie

Nom du module	oraHcmPayrollRelationships
Chemin du contexte du module	hcmPayroll/relationships

Nom de vue	Attributs
extraction de l'historique détaillé de la paie affectée	id effectiveStartDate effectiveEndDate timeCardRequiredFlag primaryFlag timeCreated timeUpdated updatedBy createdBy overtimePeriod.id overtimePeriod.name elementCriteria.id assignedPayroll.id assignedPayroll.payroll.id assignedPayroll.payroll.name assignedPayroll.legislativeDataGroup.id assignedPayroll.legislativeDataGroup.name assignedPayroll.payrollAssignment.id assignedPayroll.payrollAssignment.assignmentNumber assignedPayroll.payrollAssignment.startDate assignedPayroll.payrollAssignment.endDate assignedPayroll.payrollAssignment.payrollRelationship.id assignedPayroll.payrollAssignment.payrollRelationship.payrollRelationshipNumber assignedPayroll.payrollAssignment.payrollRelationship.person.id assignedPayroll.payrollAssignment.payrollRelationship.person.personNumber assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.id assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.lastName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.firstName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.displayName assignedPayroll.payrollAssignment.payrollRelationship.person.globalName.listName assignedPayroll.payrollAssignment.payrollRelationship.payrollStatutoryUnit.id assignedPayroll.payrollAssignment.payrollRelationship.payrollStatutoryUnit.name assignedPayroll.payrollAssignment.assignment.id assignedPayroll.payrollAssignment.assignment.effectiveSequence assignedPayroll.payrollAssignment.assignment.effectiveLatestChange assignedPayroll.payrollAssignment.assignment.assignmentNumber assignedPayroll.payrollAssignment.assignment.businessTitle assignedPayroll.payrollAssignment.assignment.assignmentType assignedPayroll.payrollAssignment.assignment.assignmentStatusType assignedPayroll.payrollAssignment.assignment.systemPersonType assignedPayroll.payrollAssignment.assignment.primaryAssignmentFlag assignedPayroll.payrollAssignment.assignment.primaryWorkRelationshipFlag assignedPayroll.payrollAssignment.assignment.primaryFlag assignedPayroll.payrollAssignment.assignment.workerCategory assignedPayroll.payrollAssignment.assignment.assignmentCategory assignedPayroll.payrollAssignment.assignment.frequency assignedPayroll.payrollAssignment.assignment.timeUpdated assignedPayroll.payrollAssignment.assignment.timeCreated assignedPayroll.payrollAssignment.assignment.department.id assignedPayroll.payrollAssignment.assignment.department.name assignedPayroll.payrollAssignment.assignment.department.title assignedPayroll.payrollAssignment.assignment.legalEmployer.id assignedPayroll.payrollAssignment.assignment.legalEmployer.name assignedPayroll.payrollAssignment.assignment.legislation.territoryCode assignedPayroll.payrollAssignment.assignment.legislation.territoryShortName assignedPayroll.payrollAssignment.assignment.position.id assignedPayroll.payrollAssignment.assignment.position.name assignedPayroll.payrollAssignment.assignment.position.code assignedPayroll.payrollAssignment.assignment.grade.id assignedPayroll.payrollAssignment.assignment.grade.name assignedPayroll.payrollAssignment.assignment.grade.code assignedPayroll.payrollAssignment.assignment.location.id assignedPayroll.payrollAssignment.assignment.location.name assignedPayroll.payrollAssignment.assignment.location.code assignedPayroll.payrollAssignment.assignment.job.id assignedPayroll.payrollAssignment.assignment.job.name assignedPayroll.payrollAssignment.assignment.job.code assignedPayroll.payrollAssignment.assignment.businessUnit.id assignedPayroll.payrollAssignment.assignment.businessUnit.name assignedPayroll.payrollAssignment.assignment.workRelationship.id assignedPayroll.payrollAssignment.assignment.workRelationship.startDate assignedPayroll.payrollAssignment.assignment.workRelationship.enterpriseSeniorityDate assignedPayroll.payrollAssignment.assignment.workRelationship.primaryFlag assignedPayroll.payrollAssignment.assignment.workRelationship.workerNumber assignedPayroll.payrollAssignment.assignment.workRelationship.terminationDate assignedPayroll.payrollAssignment.assignment.workRelationship.legalEmployerSeniorityDate
Extractions de paie affectées	id createdBy endDate finalCloseDate firstStandardEarningDate lastStandardEarningDate lastStandardProcessDate startDate timeCreated timeUpdated updatedBy payroll.id payroll.name payroll.effectiveStartDate payroll.effectiveEndDate payrollTerm.id payrollAssignment.id payrollAssignment.assignmentNumber payrollAssignment.startDate payrollAssignment.endDate payrollAssignment.payrollRelationship.id payrollAssignment.payrollRelationship.payrollRelationshipNumber payrollAssignment.payrollRelationship.person.id payrollAssignment.payrollRelationship.person.personNumber payrollAssignment.payrollRelationship.person.effectiveStartDate payrollAssignment.payrollRelationship.person.effectiveEndDate payrollAssignment.payrollRelationship.person.globalName.id payrollAssignment.payrollRelationship.person.globalName.effectiveStartDate payrollAssignment.payrollRelationship.person.globalName.effectiveEndDate payrollAssignment.payrollRelationship.person.globalName.lastName payrollAssignment.payrollRelationship.person.globalName.firstName payrollAssignment.payrollRelationship.person.globalName.displayName payrollAssignment.payrollRelationship.person.globalName.listName payrollAssignment.payrollRelationship.payrollStatutoryUnit.id payrollAssignment.payrollRelationship.payrollStatutoryUnit.name payrollAssignment.payrollRelationship.payrollStatutoryUnit.effectiveStartDate payrollAssignment.payrollRelationship.payrollStatutoryUnit.effectiveEndDate payrollAssignment.assignment.id payrollAssignment.assignment.effectiveStartDate payrollAssignment.assignment.effectiveEndDate payrollAssignment.assignment.effectiveSequence payrollAssignment.assignment.effectiveLatestChange payrollAssignment.assignment.assignmentNumber payrollAssignment.assignment.businessTitle payrollAssignment.assignment.assignmentType payrollAssignment.assignment.assignmentStatusType payrollAssignment.assignment.systemPersonType payrollAssignment.assignment.primaryAssignmentFlag payrollAssignment.assignment.primaryWorkRelationshipFlag payrollAssignment.assignment.primaryFlag payrollAssignment.assignment.workerCategory payrollAssignment.assignment.assignmentCategory payrollAssignment.assignment.frequency payrollAssignment.assignment.timeUpdated payrollAssignment.assignment.timeCreated payrollAssignment.assignment.department.id payrollAssignment.assignment.department.name payrollAssignment.assignment.department.title payrollAssignment.assignment.department.effectiveStartDate payrollAssignment.assignment.department.effectiveEndDate payrollAssignment.assignment.legalEmployer.id payrollAssignment.assignment.legalEmployer.name payrollAssignment.assignment.legalEmployer.effectiveStartDate payrollAssignment.assignment.legalEmployer.effectiveEndDate payrollAssignment.assignment.legislation.territoryCode payrollAssignment.assignment.legislation.territoryShortName payrollAssignment.assignment.position.id payrollAssignment.assignment.position.effectiveStartDate payrollAssignment.assignment.position.effectiveEndDate payrollAssignment.assignment.position.name payrollAssignment.assignment.position.code payrollAssignment.assignment.grade.id payrollAssignment.assignment.grade.effectiveStartDate payrollAssignment.assignment.grade.effectiveEndDate payrollAssignment.assignment.grade.name payrollAssignment.assignment.grade.code payrollAssignment.assignment.location.id payrollAssignment.assignment.location.effectiveStartDate payrollAssignment.assignment.location.effectiveEndDate payrollAssignment.assignment.location.name payrollAssignment.assignment.location.code payrollAssignment.assignment.job.id payrollAssignment.assignment.job.effectiveStartDate payrollAssignment.assignment.job.effectiveEndDate payrollAssignment.assignment.job.name payrollAssignment.assignment.job.code payrollAssignment.assignment.businessUnit.id payrollAssignment.assignment.businessUnit.effectiveStartDate payrollAssignment.assignment.businessUnit.effectiveEndDate payrollAssignment.assignment.businessUnit.name payrollAssignment.assignment.workRelationship.id payrollAssignment.assignment.workRelationship.startDate payrollAssignment.assignment.workRelationship.enterpriseSeniorityDate payrollAssignment.assignment.workRelationship.primaryFlag payrollAssignment.assignment.workRelationship.workerNumber payrollAssignment.assignment.workRelationship.terminationDate payrollAssignment.assignment.workRelationship.legalEmployerSeniorityDate legislativeDataGroup.id legislativeDataGroup.name
paieEmploiDateExtraits	id createdBy dateValue sourceType timeCreated timeUpdated updatedBy assignedPayroll.id payrollTerm.id payrollTerm.assignmentNumber payrollAssignment.id payrollAssignment.assignmentNumber payrollRelationship.id payrollRelationship.payrollRelationshipNumber timeDefintion.id timeDefintion.name
PayrollRelationshipDetailHistoryExtracts	id effectiveStartDate effectiveEndDate timeCreated timeUpdated updatedBy createdBy payrollRelationship.id payrollRelationship.createdBy payrollRelationship.endDate payrollRelationship.payrollRelationshipNumber payrollRelationship.startDate payrollRelationship.timeCreated payrollRelationship.timeUpdated payrollRelationship.updatedBy payrollRelationship.payrollStatutoryUnit.id payrollRelationship.payrollStatutoryUnit.name payrollRelationship.legislativeDataGroup.id payrollRelationship.legislativeDataGroup.name payrollRelationship.relationshipType.id payrollRelationship.relationshipType.name payrollRelationship.person.id payrollRelationship.person.personNumber payrollRelationship.person.globalName.id payrollRelationship.person.globalName.lastName payrollRelationship.person.globalName.firstName payrollRelationship.person.globalName.displayName payrollRelationship.person.globalName.listName overtimePeriod.id overtimePeriod.name elementCriteria.id
PayrollRelationshipExtracts	id createdBy endDate payrollRelationshipNumber startDate timeCreated timeUpdated updatedBy payrollStatutoryUnit.id payrollStatutoryUnit.name payrollStatutoryUnit.effectiveStartDate payrollStatutoryUnit.effectiveEndDate person.id person.personNumber person.effectiveStartDate person.effectiveEndDate person.globalName.id person.globalName.effectiveStartDate person.globalName.effectiveEndDate person.globalName.lastName person.globalName.firstName person.globalName.displayName person.globalName.listName legislativeDataGroup.id legislativeDataGroup.name relationshipType.id relationshipType.name
relationGroupDetailHistoryExtracts	id effectiveStartDate effectiveEndDate timeCardRequiredFlag timeCreated timeUpdated updatedBy createdBy overtimePeriod.id overtimePeriod.name assignmentStatusType.id assignmentStatusType.assignmentStatusCode elementCriteria.id
relationGroupeExtractions	id assignmentNumber createdBy endDate groupType startDate timeCreated timeUpdated updatedBy payrollRelationship.id payrollRelationship.payrollRelationshipNumber payrollTerm.id assignment.id assignment.effectiveStartDate assignment.effectiveEndDate assignment.effectiveSequence assignment.effectiveLatestChange assignment.assignmentNumber legalEmployer.id legalEmployer.name legalEmployer.effectiveStartDate legalEmployer.effectiveEndDate taxReportingUnit.id taxReportingUnit.name taxReportingUnit.effectiveStartDate taxReportingUnit.effectiveEndDate legislativeDataGroup.id legislativeDataGroup.name

Paie - Modes de paiement personnels

Nom du module	oraHcmPayrollPersonalPaymentMethods
Chemin du contexte du module	hcmPayroll/personalPaymentMethods

Nom de vue	Attributs
PersonalPaymentMethodHistoryExtracts	id effectiveStartDate effectiveEndDate amount createdBy name paymentAmountType percentage priority remainingAmountFlag timeCreated timeUpdated updatedBy legislativeDataGroup.id legislativeDataGroup.name payrollRelationship.id payrollRelationship.payrollRelationshipNumber

Paie - Tâches de flux de processus

Nom du module	oraHcmPayrollProcessFlowTasks
Chemin du contexte du module	hcmPayroll/processFlowTasks

Nom de vue	Attributs
taskActionExtracts	id activeIndicator code createdBy defaultActionFlag description executionMode legislationCode method name parentActionFlag actionSequence timeCreated timeUpdated type updatedBy baseTaskAction.id legislativeDataGroup.id legislativeDataGroup.name
tâchesExtractions	id automaticFlag code createdBy defaultCategoryType defaultChecklistName defaultSubCategoryType description destinationUiUrl hideIncompleteActionFlag legislationCode name requestCategory submittingUserIndicator timeCreated timeUpdated type updatedBy baseTask.id baseTask.name legislativeDataGroup.id legislativeDataGroup.name

Paie - Résultats du processus

Nom du module	oraHcmPayrollProcessResults
Chemin du contexte du module	hcmPayroll/processResults

Nom de vue	Attributs
PayrollActionExtraits	id actionPopulationStatus actionSequence actionStatus actionTypeCode batchProcessMode chequeProcedure costingProcessMode currentChunkNumber currentTask dateEarned displayRunNumber effectiveDate eftExpiryDate eftFileReference endChequeNumber endDate expediteFlag fileName futureProcessMode legislationCode legislativeParameters overrideDate overridingDdDate payPayeeType paymentReason processPhase startChequeNumber startDate timeCreated timeUpdated updatedBy payroll.id payroll.effectiveStartDate payroll.effectiveEndDate consolidationSet.id deductionTimePeriod.id earnTimePeriod.id legislativeDataGroup.id payrollAction.id
PayrollRelationActionExtracts	id actionSequence actionStatusCode chunkNumber endDate serialNumber startDate parentObject processPath payrollAction.id payrollRelationship.id prepayment.id
personneRésultatsMessageExtraits	id lineSequence lineText messageLevel name sourceType payrollRelationshipAction.id payrollRelationshipAction.payrollAction.id payrollRelationshipAction.payrollAction.effectiveDate payrollRelationshipAction.payrollAction.dateEarned payrollRelationshipAction.payrollAction.startDate payrollRelationshipAction.payrollAction.endDate payrollRelationshipAction.payrollAction.payroll.id payrollRelationshipAction.payrollAction.payroll.effectiveStartDate payrollRelationshipAction.payrollAction.payroll.effectiveEndDate payrollRelationshipAction.payrollAction.payroll.name payrollRelationshipAction.payrollAction.actionType.lookupCode payrollRelationshipAction.payrollAction.actionType.lookupType payrollRelationshipAction.payrollAction.actionType.meaning payrollRelationshipAction.payrollAction.legislativeDataGroup.id payrollRelationshipAction.payrollAction.legislativeDataGroup.name payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.id payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.flowName payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.timeCreated payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.id payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.name payrollRelationshipAction.payrollAction.payrollFlowActionStatistic.task.code payrollRelationshipAction.payrollRelationship.id payrollRelationshipAction.payrollRelationship.payrollRelationshipNumber payrollRelationshipAction.payrollRelationship.person.id payrollRelationshipAction.payrollRelationship.person.personNumber payrollRelationshipAction.payrollRelationship.person.effectiveStartDate payrollRelationshipAction.payrollRelationship.person.effectiveEndDate payrollRelationshipAction.payrollRelationship.person.globalName.id payrollRelationshipAction.payrollRelationship.person.globalName.effectiveStartDate payrollRelationshipAction.payrollRelationship.person.globalName.effectiveEndDate payrollRelationshipAction.payrollRelationship.person.globalName.lastName payrollRelationshipAction.payrollRelationship.person.globalName.firstName payrollRelationshipAction.payrollRelationship.person.globalName.displayName payrollRelationshipAction.payrollRelationship.person.globalName.listName payrollRelationshipAction.actionStatus.lookupCode payrollRelationshipAction.actionStatus.lookupType payrollRelationshipAction.actionStatus.meaning payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name
processResultsMessageExtraits	id lineSequence lineText messageLevel name sourceType payrollAction.id payrollAction.effectiveDate payrollAction.dateEarned payrollAction.payroll.id payrollAction.payroll.effectiveStartDate payrollAction.payroll.effectiveEndDate payrollAction.payroll.name payrollAction.actionType.lookupCode payrollAction.actionType.lookupType payrollAction.actionType.meaning payrollAction.legislativeDataGroup.id payrollAction.legislativeDataGroup.name payrollAction.payrollFlowActionStatistic.id payrollAction.payrollFlowActionStatistic.flowName payrollAction.payrollFlowActionStatistic.timeCreated payrollAction.payrollFlowActionStatistic.task.id payrollAction.payrollFlowActionStatistic.task.name payrollAction.payrollFlowActionStatistic.task.code payroll.id payroll.effectiveStartDate payroll.effectiveEndDate payroll.name

Tâche 2 : Préparer et tester une interrogation d'extraction

Chaque vue d'extraction dispose d'une API d'interrogation qui permet de créer et de tester des interrogations d'extraction.

URL	/api/boss/data/objects/ora/{{moduleContextPath}}/v1/{{viewName}}/$query
Méthode HTTP	POST
Modèle de demande	{ "collection": { "limit": {{limit}}, "offset": {{offset}}, "sortBy": [ {{sortAttributes}} ], "filter": "{{topLevelFilter}}" }, "fields": [ {{topLevelAttributes}} ], "accessors": { "{{childObject}}": { "collection": { "filter": "{{childLevelFilter}}" }, "fields": [ {{childLevelAttributes}} ], "accessors": { {{nestedChildAccessors}} } }, ... } }
Modèle de réponse	200 OK { "items": [ {{items}} ], "hasMore": {{hasMore}} }

Objets et attributs

Définir les données à extraire, c'est-à-dire les objets et les attributs de la vue à inclure. L'inclusion d'objets enfants nécessite l'ajout de accessors alors que l'inclusion de champs spécifiques nécessite leur inscription dans le tableau fields. Voir l'exemple complet.

Attention :

Si vous ne spécifiez pas explicitement les éléments enfants accessors et fields, vous obtiendrez la forme par défaut de la vue. Gardez à l'esprit que la forme par défaut peut ne pas inclure tous les objets et attributs disponibles de la vue.

Filtrage

Sert à définir le mode de filtrage des données. Vous pouvez utiliser les expressions suivantes pour créer des filtres pour votre interrogation.

Objet	Expression	Exemple
Test d'égalité	field = value	ename = 'KING'
Test d'inégalité	field != value	activeFlag != true
Test supérieur à Test inférieur à	field > value field < value	sal > 1999.99 hireDate < '2000-01-01' timeUpdated> '1900-01-01T13:51:54Z'
Supérieur ou égal à test Inférieur ou égal à test	field >= value field <= value< code>	sal >= 1999.99 hireDate <= '2000-01-01' timeUpdated >= '1900-01-01T13:51:54Z'
Mise en correspondance de motifs	field LIKE 'pattern'	job LIKE 'SALES%'
Test d'appartenance	field IN (value1, ..., valueN)	deptno IN (10, 20, 40)
Comparaison cas-insensibilité	field ~= value field ~!= value field ~> value field ~< value field ~>= value field ~<= value field ~LIKE 'pattern' field ~IN (value1, ..., valueN)	ename ~= 'king'
Test d'existence (pour les relations un-à-plusieurs)	child[expression]	assignments[startDate = null]
Conjonction logique	expression AND expression
Disjonction logique	expression OR expression
Négation logique	!(expression)

Filtrage par objets enfants dans une relation un-à-un :

Dans le cas de relations un à un, vous pouvez faire référence aux objets enfants et à leurs attributs dans la clause de filtre, tout comme aux attributs des autres objets parents, par exemple legalEmployer.id in (1001, 1002).

Filtrage des objets enfants dans une relation un-à-plusieurs :

Dans de rares cas de relations un à plusieurs indiquées par un nom d'accesseur pluriel, le test d'existence dans le tableau ci-dessus filtre les parents qui ont au moins un enfant répondant aux critères. Toutefois, cela ne signifie pas que les enregistrements enfants, s'ils sont extraits, seront filtrés automatiquement. Si vous voulez vous assurer que vous obtenez uniquement des enregistrements enfants répondant aux critères, vous devez répéter le filtre au niveau enfant.

Par exemple, si vous voulez extraire uniquement des composants de modification de type physique UPDATE, vous devez appliquer les filtres suivants à l'interrogation de modifications d'objet :

{
    "collection": {
        "filter": "changeComponents[physicalType = 'UPDATE']"
    },
    "accessors": {
        "changeComponents": {
            "collection": {
                "filter": "physicalType = 'UPDATE'"
            },
...
                

Filtrage par date en vigueur :

Dans le cas d'objets avec date en vigueur, vous obtiendrez les données en vigueur à la date courante par défaut. Pour extraire les données en vigueur à une date spécifique, utilisez le paramètre d'interrogation HTTP $effectiveDate.

Par exemple, si vous voulez extraire les données en vigueur à partir de 2023-01-01, utilisez l'URL suivante pour votre interrogation :

/api/boss/data/objects/ora/hcmHrCore/employment/v1/{{viewPath}}/$query?$effectiveDate=2023-01-01

Tri

Définissez le mode de tri des données. Le tri est exprimé par un tableau d'attributs de tri, y compris la direction de tri (asc ou desc). Par exemple :

"sortBy": [
    {
        "totalAmount": "desc"
    },
    {
        "paidAmount": "asc"
    }
]

Pagination

Définir la façon dont les données doivent être paginées. Le client peut contrôler la pagination en fournissant des paramètres de limite et de décalage. Par exemple :

"limit": 200,
"offset": 400

La limite par défaut est 25 et la limite maximale est 1000.

Le décalage par défaut est 0 et indique le début des résultats.

L'attribut de niveau supérieur hasMore dans la réponse indique s'il y a d'autres résultats à extraire.

La pagination ne doit pas être utilisée comme un autre moyen d'extraire des données. Lors de l'interrogation de cette API, il n'y a aucune garantie que les données ne changeront pas entre les demandes. Utilisez l'API asynchrone pour l'extraction de données.

Exemple

L'exemple d'interrogation d'extraction ci-dessous est conçu pour extraire les informations sur les affectations, ainsi que les détails de l'employeur légal et du service, qui :

• Sont des affectations principales
• Sont de type Employé
• N'appartient pas aux employeurs légaux ayant les ID 10001 et 10002
• sont en vigueur à la date d'extraction
• Mise à jour (ou création) depuis l'exécution précédente

Exemple de demande

Notez la condition du paramètre limit et de l'attribut timeUpdated avec l'horodatage de l'exécution d'extraction précédente.

POST /api/boss/data/objects/ora/hcmHrCore/employment/v1/workerAssignmentExtracts/$query
 
{
    "collection": {
        "limit": 10,
        "filter": "primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))"
    },
    "fields": [ "id", "assignmentType", "assignmentStatusType", "effectiveStartDate", "effectiveEndDate", "businessTitle", "workAtHomeFlag", "assignmentNumber", "timeUpdated" ],
    "accessors": {
        "personDetail": {
            "fields": [ "personNumber" ]
        },
        "globalName": {
            "fields": [ "firstName", "lastName" ]
        },
        "department": {
            "fields": [ "id", "name", "title" ]
        },
        "legalEmployer": {
            "fields": [ "id", "name" ]
        },
        "workRelationship": {
            "fields": [ "id" ]
        }
    }
}
				

Exemple de réponse

200 OK
 
{
    "items": [
        {
            "id": "300000795682243",
            "assignmentType": "E",
            "assignmentStatusType": "ACTIVE",
            "effectiveStartDate": "2018-06-14",
            "effectiveEndDate": "4712-12-31",
            "businessTitle": "Aeronautical Engineer Level-9352",
            "workAtHomeFlag": false,
            "assignmentNumber": "EHDLWorker_190903_1637",
            "timeUpdated": "2025-05-06T11:42:17.821Z",
            "$id": "300000795682243",
            "$context": {
                "etag": "89"
            },
            "personDetail": {
                "personNumber": "HDLWorker_190903_1637",
                "$id": "100000329366771",
                "$context": {
                    "etag": ""
                }
            },
            "globalName": {
                "firstName": "Raymond-Olivier",
                "lastName": "Beer-Tröst",
                "$id": "300000795668871",
                "$context": {
                    "etag": ""
                }
            },
            "department": {
                "id": "300000044556980",
                "name": "South - Venaria DC-GROUP/SFIELESOIT74155",
                "title": null,
                "$id": "300000044556980",
                "$context": {
                    "etag": "13",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/departments/300000044556980?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "legalEmployer": {
                "id": "300000046740247",
                "name": "PSR_US_LE_1",
                "$id": "300000046740247",
                "$context": {
                    "etag": "15",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/legalEmployers/300000046740247?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "workRelationship": {
                "id": "100000329414679",
                "$id": "100000329414679",
                "$context": {
                    "etag": "1"
                }
            }
        },
        {
            "id": "300000795670049",
            "assignmentType": "E",
            "assignmentStatusType": "ACTIVE",
            "effectiveStartDate": "2018-05-28",
            "effectiveEndDate": "4712-12-31",
            "businessTitle": "Civil Engineer-6864",
            "workAtHomeFlag": false,
            "assignmentNumber": "EHDLWorker_190903_11128",
            "timeUpdated": "2025-05-06T11:42:25.787Z",
            "$id": "300000795670049",
            "$context": {
                "etag": "89"
            },
            "personDetail": {
                "personNumber": "HDLWorker_190903_11128",
                "$id": "100000329383875",
                "$context": {
                    "etag": ""
                }
            },
            "globalName": {
                "firstName": "Charlotte-Pénélope",
                "lastName": "Beer-Tröst",
                "$id": "300000795669677",
                "$context": {
                    "etag": ""
                }
            },
            "department": {
                "id": "300000044582197",
                "name": "Human Resources-GROUP/AT081000101",
                "title": null,
                "$id": "300000044582197",
                "$context": {
                    "etag": "13",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/departments/300000044582197?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "legalEmployer": {
                "id": "300000046740247",
                "name": "PSR_US_LE_1",
                "$id": "300000046740247",
                "$context": {
                    "etag": "15",
                    "links": {
                        "$self": {
                            "href": "https://example.com/api/boss/data/objects/ora/hcmHrCore/workStructures/v1/legalEmployers/300000046740247?$effectiveDate=2025-05-13"
                        }
                    }
                }
            },
            "workRelationship": {
                "id": "100000329453488",
                "$id": "100000329453488",
                "$context": {
                    "etag": "1"
                }
            }
        },
        ...
    ],
    "hasMore": true
}

Tâche 3 : Soumettre une demande de tâche d'extraction

Une fois l'interrogation définie, une demande de tâche d'extraction peut être soumise à l'aide de l'API du programmateur de tâches.

URL	/api/saas-batch/jobscheduler/v1/jobRequests
Méthode HTTP	POST
Modèle de demande	{ "jobDefinitionName": "AsyncDataExtraction", "serviceName": "boss", "requestParameters": { "boss.module": "{{moduleName}}", "boss.resource.name": "{{viewName}}", "boss.resource.version": "v1", "boss.outputFormat": "json", "boss.request.system.param.effectiveDate": "{{effectiveDate}}", "boss.advancedQuery": "{{query}}" } } boss.request.system.param.effectiveDate est un paramètre facultatif qui ne doit être fourni que si vous voulez extraire des données dont la date en vigueur est différente de la date courante.
Modèle de réponse	Lors de la soumission réussie, le code de réponse 202 sera retourné, ainsi que l'en-tête Location avec l'URL pointant vers l'instance de demande de tâche particulière. 202 Accepted Location: {{jobRequestUrl}}

Pagination lors de l'extraction des données :

Bien que vous ayez utilisé des contrôles de pagination, c'est-à-dire des paramètres limit et offset, lors de la création et du test de l'interrogation, vous ne voulez pas que les résultats d'extraction soient limités par ceux-ci. Supprimez toute utilisation des paramètres limit et offset lors de la soumission d'une interrogation.

Transmission de l'interrogation :

L'interrogation transmise lors de la soumission de la demande de tâche d'extraction doit se présenter sous la forme d'une chaîne JSON standard. Préparez et testez l'interrogation à l'aide du point d'extrémité de l'API $query et :

• Échapper à toutes les guillemets (" → \")
• Supprimer les nouveaux caractères de ligne (\n)
• Réduire potentiellement d'autres espaces blancs (p. ex. indentations)

Dans l'ensemble, vous voulez aller, par exemple, de :

{
    "collection": {
        "limit": 100,
        "filter": "totalAmount > 10000"
    },
    "fields": [ "id", "totalAmount" ]
}

Vers :

{\"collection\": {\"filter\": \"totalAmount > 10000\"},\"fields\": [ \"id\", \"totalAmount\" ]}

Exemple

Exemple de demande

POST /api/saas-batch/jobscheduler/v1/jobRequests
 
{
    "jobDefinitionName": "AsyncDataExtraction",
    "serviceName": "boss",
    "requestParameters": {
        "boss.module": "oraHcmHrCoreEmployment",
        "boss.resource.name": "workerAssignmentExtracts",
        "boss.resource.version": "v1",
        "boss.outputFormat": "json",
        "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
    }
}

Exemple de réponse

202 Accepted
 
Location: https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075

Tâche 4 : Vérification de l'achèvement de la tâche

La vérification de l'achèvement implique l'utilisation de l'API du programmateur de tâches pour scruter périodiquement les détails de la demande de tâche, jusqu'à ce qu'elle soit terminée avec succès ou en échec.

URL	/api/saas-batch/jobscheduler/v1/jobRequests/{{jobRequestId}}
Méthode HTTP	GET

Réussite :

Une demande de travail est considérée comme terminée lorsque les conditions suivantes sont remplies :

Attribué	Valeur prévue
jobDetails.jobProgress.completed	true
jobDetails.jobProgress.status	SUCCEEDED

Échec de l'achèvement :

Une demande de tâche est considérée comme ayant échoué lorsque la condition suivante est satisfaite. Dans ce cas, l'attribut jobDetails.jobProgress.message contiendra le message d'erreur.

Attribué	Valeur prévue
jobDetails.jobProgress.status	FAILED

Exemple

Exemple de demande

GET /api/saas-batch/jobscheduler/v1/jobRequests/42075

Exemples de réponse

Les réponses ci-dessous présentent les différentes étapes d'un travail soumis. Voir les attributs jobProgress.status et jobProgress.completed en particulier.

Accepté/En file d'attente

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "ENQUEUED",
        "jobProgress": {
            "status": "ACCEPTED",
            "message": "Job is submitted",
            "startTime": "2025-05-25T13:39:01Z",
            "endTime": "2025-05-25T13:39:15Z",
            "completedPercentage": "0",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

En cours d'exécution

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "RUNNING",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "RUNNING",
            "message": "Job status is changed to RUNNING",
            "startTime": "2025-05-25T13:39:27Z",
            "endTime": "2025-05-25T13:40:25Z",
            "completedPercentage": "50",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "RUNNING",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "RUNNING",
            "message": "Publishing BOSS job progress: JobProgress(jobRequestId=42075, resourcePath=oraHcmHrCoreEmployment/v1/workers, dataDocName=null, deploymentId=null, jobStatus=RUNNING, startTime=2025-05-25T13:40:18Z, endTime=2025-05-25T13:40:38Z, completedPercentage=30, completed=false, error=null)",
            "startTime": "2025-05-25T13:40:40Z",
            "endTime": "2025-05-25T13:40:40Z",
            "completedPercentage": "30",
            "completed": false
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

Opération réussie

200 OK
 
{
    "jobDetails": {
        "jobRequestId": 42075,
        "jobRequest": {
            "jobDefinitionName": "AsyncDataExtraction",
            "serviceName": "boss",
            "systemDerivedVersion": "90",
            "jobSubmitter": "TM-MFITZIMMONS",
            "requestParameters": {
                "boss.module": "oraHcmHrCoreEmployment",
                "boss.resource.name": "workerAssignmentExtracts",
                "boss.resource.version": "v1",
                "boss.outputFormat": "json",
                "boss.advancedQuery": "{\"collection\": {\"filter\": \"primaryFlag = true and timeUpdated > '2025-05-01T00:00:00Z' and assignmentType = 'E' and !(legalEmployer.id in (10001, 10002))\"},\"fields\": [ \"id\", \"assignmentType\", \"assignmentStatusType\", \"effectiveStartDate\", \"effectiveEndDate\", \"businessTitle\", \"workAtHomeFlag\", \"assignmentNumber\", \"timeUpdated\" ],\"accessors\": {\"personDetail\": {\"fields\": [ \"personNumber\" ]},\"globalName\": {\"fields\": [ \"firstName\", \"lastName\" ]},\"department\": {\"fields\": [ \"id\", \"name\", \"title\" ]},\"legalEmployer\": {\"fields\": [ \"id\", \"name\" ]},\"workRelationship\": {\"fields\": [ \"id\" ]}}}"
            },
            "jobRetryNumber": 0,
            "timeoutThreshold": 14400
        },
        "jobStatus": "SUCCEEDED",
        "jobProgress": {
            "jobRequestId": 42075,
            "status": "SUCCEEDED",
            "message": "Job status is changed to SUCCEEDED",
            "startTime": "2025-05-25T13:39:27Z",
            "endTime": "2025-05-25T13:41:26Z",
            "completedPercentage": "100",
            "completed": true
        }
    },
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobscheduler/v1/jobRequests/42075"
            }
        }
    }
}

Tâche 5 : Extraction des détails de sortie de l'extraction

Une fois le travail terminé avec succès, ses informations de fichier de sortie peuvent être extraites. Il s'agit d'utiliser l'API Job File Manager pour l'instance de demande de tâche d'extraction particulière.

La sortie est stockée dans des fragments compressés.

URL	/api/saas-batch/jobfilemanager/v1/jobRequests/{{jobRequestId}}/outputFiles
Méthode HTTP	GET

Taille du fichier :

La taille du fichier est retournée dans l'attribut de réponse items.fileSize et exprimée en octets.

Lien de clôture :

L'URL du contenu réel du fichier est retournée dans l'attribut de réponse items.$context.links.enclosure.

Exemple

Exemple de demande

GET /api/saas-batch/jobfilemanager/v1/jobRequests/42075/outputFiles

Exemple de réponse

Dans l'exemple ci-dessous, la sortie complète est stockée dans deux fichiers compressés.

200 OK
 
{
    "items": [
        {
            "fileName": "result_1_json.zip",
            "fileSize": 9390419,
            "timeCreated": "2025-04-22T22:04:22.667Z",
            "$context": {
                "links": {
                    "enclosure": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_1_json.zip/content"
                    },
                    "$self": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_1_json.zip"
                    }
                }
            }
        },
        {
            "fileName": "result_2_json.zip",
            "fileSize": 4462724,
            "timeCreated": "2025-04-22T22:04:36.565Z",
            "$context": {
                "links": {
                    "enclosure": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_2_json.zip/content"
                    },
                    "$self": {
                        "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles/result_2_json.zip"
                    }
                }
            }
        }
    ],
    "totalItems": 2,
    "$context": {
        "links": {
            "$self": {
                "href": "https://example.com/api/saas-batch/jobfilemanager/v1/jobRequests/40071/outputFiles"
            }
        }
    }
}

Tâche 6 : Télécharger la sortie d'extraction

Enfin, les fichiers de sortie d'extraction peuvent être téléchargés à l'aide de l'API Job File Manager pour l'instance de demande de tâche d'extraction et le fichier de sortie particuliers.

URL	/api/saas-batch/jobfilemanager/v1/jobRequests/{{jobRequestId}}/outputFiles/{{fileName}}/content
Méthode HTTP	GET

Attention :

Vous pouvez télécharger jusqu'à 32 Mo en une seule demande. Si le fichier individuel est plus grand, vous obtiendrez par défaut une partie de 32 Mo du fichier. Pour des demandes consécutives, vous devez utiliser l'en-tête HTTP Range comme ci-dessous. L'utilisation de l'en-tête Range vous permet également de mettre en oeuvre le téléchargement multifil pour extraire des fichiers volumineux plus efficacement, si nécessaire.

Range: {{startByte}}-{{endByte}}/{{fileSize}}

Conseil :

Pour éviter d'utiliser complètement l'en-tête Range, soumettez les demandes de tâche avec le paramètre supplémentaire boss.export.maxChunkSize avec la valeur 180. Cela garantira que chaque morceau compressé sera inférieur à 32 Mo et vous pourrez le télécharger en une seule demande.

Exemple

Exemple de demande

GET /api/saas-batch/jobfilemanager/v1/jobRequests/42075/outputFiles/result_42075.json/content

Exemples de réponse

La réponse réelle est le contenu du fichier compressé binaire. Une fois décompressée, elle est complète ou partielle (en cas d'utilisation d'en-tête Range), les données utiles JSON non formatées, avec des résultats complets ou partiels (en cas de fragment de fichier) de l'interrogation d'extraction.

Exemple de résultats complets non compressés

{"items": [
    {"id":"300008335145001","assignmentType":"E","assignmentStatusType":"ACTIVE","effectiveStartDate":"2025-05-02","effectiveEndDate":"4712-12-31","businessTitle":"E7356262523","workAtHomeFlag":false,"assignmentNumber":"E7356262523","timeUpdated":"2025-05-01T07:53:15.722Z","$id":"300008335145001","$context":{"etag":"1"},"personDetail":{"personNumber":"7356262523","$id":"300008335144985","$context":{"etag":""}},"globalName":{"firstName":null,"lastName":"oracle","$id":"300008335144986","$context":{"etag":""}},"department":null,"legalEmployer":{"id":"300001939234024","name":"AORT Oracle United States","$id":"300001939234024","$context":{"etag":"6","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/legalEmployers/300001939234024?$effectiveDate=2025-05-13"}}}},"workRelationship":{"id":"300008335144995","$id":"300008335144995","$context":{"etag":"1"}}},
    {"id":"300000310085281","assignmentType":"E","assignmentStatusType":"ACTIVE","effectiveStartDate":"2018-03-04","effectiveEndDate":"4712-12-31","businessTitle":"Medical Technologist Corporate Level-35321","workAtHomeFlag":false,"assignmentNumber":"EHDLWorker_190409_467490","timeUpdated":"2025-05-07T15:29:46.59Z","$id":"300000310085281","$context":{"etag":"90"},"personDetail":{"personNumber":"HDLWorker_190409_467490","$id":"100000127293313","$context":{"etag":""}},"globalName":{"firstName":"Martin-David","lastName":"Oestrovsky-Krein","$id":"300000310075057","$context":{"etag":""}},"department":{"id":"300000041568062","name":"GFIN Global Controlling-GROUP/GFINGC74155","title":null,"$id":"300000041568062","$context":{"etag":"13","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/departments/300000041568062?$effectiveDate=2025-05-13"}}}},"legalEmployer":{"id":"300000046740247","name":"PSR_US_LE_1","$id":"300000046740247","$context":{"etag":"15","links":{"$self":{"href":"/ora/hcmHrCore/workStructures/v1/$en-US/legalEmployers/300000046740247?$effectiveDate=2025-05-13"}}}},"workRelationship":{"id":"100000127362395","$id":"100000127362395","$context":{"etag":"1"}}}
]}

Autres ressources d'apprentissage

Explorez d'autres laboratoires sur le site docs.oracle.com/learn ou accédez à plus de contenu d'apprentissage gratuit sur le canal Oracle Learning YouTube. De plus, visitez education.oracle.com/learning-explorer pour devenir un explorateur Oracle Learning.

Pour obtenir la documentation sur le produit, visitez Oracle Help Center.

---

Informations sur le titre et les droits d'auteur

Extraire les données du magasin de données optimisé pour la lecture HCM

G38790-07 —

Avril 2026

Copyright ©2026,

Oracle et/ou ses sociétés affiliées.