Introducción

Cloud HCM ofrece la capacidad de extraer datos de HCM mediante una plataforma de nueva generación con un almacén de datos optimizado para la lectura.

Objetivos

Al completar este tutorial, comprenderá cómo:

• Vistas de extracción de consultas y su jerarquía de objetos
• Envío asíncrono y seguimiento de solicitudes de trabajo de extracción para la recuperación de datos seleccionados
• Descargar archivos de salida de extracción

Requisitos

Antes de empezar:

1. Póngase en contacto con Oracle CoE para asegurarse de que el almacén de datos optimizado para lectura se aprovisiona en el pod y de que los datos se replican.
2. Realizar la configuración de seguridad necesaria, que incluye:
   • Configuración de seguridad de datos
   • OAuth configuración de la aplicación cliente

Consulte el tutorial Configuración de la seguridad para extraer datos del almacén de datos optimizado para lectura de HCM.

Casos de uso

Esta funcionalidad permite abordar los siguientes casos de uso.

Extracción completa de datos

La extracción completa de los datos seleccionados puede ser una actividad puntual o periódica.

Puede recuperar toda la jerarquía de objetos o solo un subjuego de ella.

La extracción completa de datos recuperará todos los registros que coincidan con los criterios de filtrado y los archivos de salida pueden ser muy grandes.

Los objetos de fecha de vigencia se recuperarán a partir de la fecha de vigencia solicitada, donde la fecha de extracción actual es la predeterminada.

Extracción incremental de datos

La extracción incremental de los datos seleccionados suele ser una actividad periódica y programada.

Puede recuperar toda la jerarquía de objetos o solo un subjuego de ella.

En este caso de uso, solo desea recuperar los objetos que se han cambiado desde la ejecución de extracción anterior, donde la primera ejecución de extracción es la base. Para lograrlo, los filtros de atributos timeUpdated se deben aplicar en cualquier nivel sujeto a detección de cambios.

La consulta de extracción de datos incremental puede aplicar criterios de filtrado adicionales. Los archivos de salida suelen ser más pequeños en comparación con la extracción completa, ya que solo contendrán delta.

Solo se recuperarán los valores actuales de los atributos.

Los objetos de fecha de vigencia se recuperarán a partir de la fecha de vigencia solicitada, donde la fecha de extracción actual es la predeterminada.

Atención:

Los registros eliminados físicamente no se devolverán mediante el filtrado por timeUpdated.

Tarea 1: Selección de una vista de extracción

Seleccione la vista de extracción que desea utilizar, según los objetos y atributos necesarios. Las vistas disponibles a partir de la versión 26B se enumeran a continuación, junto con los objetos y atributos que se pueden extraer, agrupados por módulo.

Para los objetos con fecha de vigencia, normalmente encontrará una vista normal que devuelve datos con fecha de vigencia a partir de la fecha indicada y, además, una vista de historial que devuelve todos los registros con fecha de vigencia.

Varios Idiomas:

Los atributos traducibles solo están disponibles en inglés en este momento.

Global HR - Empleo

Nombre del Módulo	oraHcmHrCoreEmployment
Ruta de contexto de módulo	hcmHrCore/employment

Nombre de vista	Atributos
actionExtracts	código de id startDate endDate nombre descripción timeCreated timeUpdated createdBy updatedBy
actionOccurrenceExtracts	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
actionReasonExtracts	id code name createdBy description endDate startDate timeCreated timeUpdatedBy 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
documentoDeRegistroExtractos	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
documentOfRecordTypeExtracts	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 timeUpdatedBy legislation.territoryCode legislation.territoryShortName personDetail.id personDetail.personNumber personDetail.effectiveStartDate personDetail.effectiveEndDate
legislativeInformationHistoryExtracts	id effectiveStartDate effectiveEndDate gender maritalStatus maritalStatusChangeDate highestEducationLevel createdBy timeCreated updatedBy timeUpdatedBy 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 creado por 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
PersonasGrupoExtractos	id creado por 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	Fecha de inicio efectiva Fecha de finalización efectiva 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
workerExtracts	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 - Estructuras de trabajo

Nombre del Módulo	oraHcmHrCoreWorkStructures
Ruta de contexto de módulo	hcmHrCore/workStructures

Nombre de vista	Atributos
gradeExtracts	id code effectiveStartDate effectiveEndDate status timeUpdated por timeCreated createdBy name actionOccurrence.id
gradeHistoryExtracts	id code effectiveStartDate effectiveEndDate status timeUpdated por timeCreated createdBy name actionOccurrence.id
gradeLadderExtractos	id effectiveStartDate effectiveEndDate activeStatus allowProgressionOverrideFlag allowSalaryOverrideFlag autoProgressionCode autoSalaryChangeCode createdBy groupCode gradeType nombre 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
ubicaciónDirecciónExtractos	id effectiveStartDate effectiveEndDate type building floorNumber townOrCity countryCode postalCode longPostalCode addressLine1 addressLine2 addressLine3 addressLine4 county state province createdBy updatedBy timeCreated timeUpdatedBy addressCreatedBy addressTimeCreatedBy addressTimeUpdated addressUpdatedBy
locationExtracts	id code createdBy timeCreated updatedBy timeUpdated employeeLocationFlag efectivaStartDate efectivaEndDate countryCode status shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdatedBy timezoneCode descripción nombre actionOccurrence.id mainAddress.id mainAddress.effectiveStartDate mainAddress.effectiveEndDate
locationHistoryExtracts	id code creado por timeCreated updatedBy timeUpdated employeeLocationFlag effectiveStartDate effectiveEndDate countryCode status shipToSiteFlag receivingSiteFlag billToSiteFlag officeSiteFlag detailCreatedBy detailTimeCreated detailUpdatedBy detailTimeUpdatedBy timezoneCode descripción 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

HCM Common - Eventos

Nombre del Módulo	oraHcmHrCoreEvents
Ruta de contexto de módulo	hcmHrCore/events

Nombre de vista

Atributos

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

Nómina - Definiciones de balance

Nombre del Módulo	oraHcmPayrollBalanceDefinitions
Ruta de contexto de módulo	hcmPayroll/balanceDefinitions

Nombre de vista	Atributos
balanceAttributeDefaultExtracts	id creado por legislationCode timeCreated timeUpdatedPor legislativeDataGroup.id balanceDimension.id attributeExclusion.id
balanceAtributoExtrae	id creado por legislationCode timeCreated timeUpdatedBy legislativeDataGroup.id definedBalance.id atributoExclusion.id
balanceDimensiónExtractos	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
balanceExtractos	id code currencyCode descripción name remunerationFlag reportingName timeCreated timeUpdated uomCode legislationCode createdBy updatedBy comments baseBalanceType.id baseBalanceType.name inputValue.id inputValue.effectiveStartDate inputValue.effectiveEndDate legislativeDataGroup.id
balanceGrupoAtributoExclusiónExtractos	id code alterable legislationCode groupLevelFlag timeCreated timeUpdated createdBy updatedBy balanceDimension.id legislativeDataGroup.id legislativeDataGroup.name
balanceGrupoAtributoInclusiónExtractos	id legislationCode timeCreated timeUpdated balanceGroup.id attributeExclusion.id legislativeDataGroup.id legislativeDataGroup.name
balanceGrupoExtractos	id code legislationCode balanceCategoryAttributeFlag balanceDimensionAttributeFlag groupLevelFlag timeCreated timeUpdated legislativeDataGroup.id
balanceGrupoUsoExtractos	id balanceReportType createdBy description formatType legislationCode timeCreated timeUpdated updatedBy code name balanceGroup.id legialtiveDataGroup.id
balanceReportSortItemExtracts	id createdBy legislationCode timeCreated timeUpdated updatedBy sequenceNumber legialtiveDataGroup.id
SaldoExtractos Definidos	id legislaciónCódigo grossupAllowedFlag grossupExcludeByDefault saveRunBalance timeCreated timeUpdated balanceType.id balanceType.name balanceDimension.id legislativeDataGroup.id
dimensionUsageExtracts	ID nombre databaseItemSuffix legislationCode useInExceptionReportingFlag timeCreated timeUpdated balanceDimension.id legislativeDataGroup.id

Nómina - Definiciones de conceptos

Nombre del Módulo	oraHcmPayrollElementDefinitions
Ruta de contexto de módulo	hcmPayroll/elementDefinitions

Nombre de vista	Atributos
elementClassificationExtracts	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
elementHistoryExtracts	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
inputValueHistoryExtractos	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

Nómina - Definiciones de nómina

Nombre del Módulo	oraHcmPayrollDefinitions
Ruta de contexto de módulo	hcmPayroll/definitions

Nombre de vista	Atributos
consolidacionesGrupoExtractos	id code name timeCreated timeUpdated description createdBy updatedBy legislativeDataGroup.id legislativeDataGroup.name
nóminasHistorialExtractos	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
timeDefinitionExtrae	id shortName nombre definitionType periodType periodUnit dayAdjust legislationCode numberOfYears startDate creatorType dynamicCode timeCreated timeUpdated createdBy updatedBy baseTimeDefinition.id baseTimeDefinition.name periodTimeDefinition.id periodTimeDefinition.name legislativeDataGroup.id legislativeDataGroup.name
timePeriodExtracts	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

Nómina - Relaciones de nómina

Nombre del Módulo	oraHcmPayrollRelationships
Ruta de contexto de módulo	hcmPayroll/relationships

Nombre de vista	Atributos
extractos de historial de detalles de nómina asignados	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
extracciones de nómina asignadas	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
nóminaFechaEmpleoExtractos	id creado por dateValue sourceType timeCreated timeUpdated updatedPor assignedPayroll.id payrollTerm.id payrollTerm.assignmentNumber payrollAssignment.id payrollAssignment.assignmentNumber payrollRelationship.id payrollRelationship.payrollRelationshipNumber timeDefintion.id timeDefintion.name
nóminasRelaciónDetalleHistoriaExtractos	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
nóminasRelaciónExtracciones	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
relationshipGroupDetailHistoryExtracts	id effectiveStartDate effectiveEndDate timeCardRequiredFlag timeCreated timeUpdated updatedBy createdBy overtimePeriod.id overtimePeriod.name assignmentStatusType.id assignmentStatusType.assignmentStatusCode elementCriteria.id
relationshipGroupExtracts	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

Nómina - Métodos de pago personales

Nombre del Módulo	oraHcmPayrollPersonalPaymentMethods
Ruta de contexto de módulo	hcmPayroll/personalPaymentMethods

Nombre de vista	Atributos
personalPaymentMethodHistoryExtracts	id effectiveStartDate effectiveEndDate amount createdBy name paymentAmountType percentage priority remainingAmountFlag timeCreated timeUpdatedBy updatedBy legislativeDataGroup.id legislativeDataGroup.name payrollRelationship.id payrollRelationship.payrollRelationshipNumber

Nómina - Tareas de flujo de proceso

Nombre del Módulo	oraHcmPayrollProcessFlowTasks
Ruta de contexto de módulo	hcmPayroll/processFlowTasks

Nombre de vista	Atributos
taskActionExtrae	id activeIndicator code createdBy defaultActionFlag descripción modo de ejecución legislationCode method name parentActionFlag actionSequence timeCreated timeUpdated type updatedBy baseTaskAction.id legislativeDataGroup.id legislativeDataGroup.name
taskExtracts	id automaticFlag code createdBy defaultCategoryType defaultChecklistName defaultSubCategoryType descripción destinationUiUrl hideIncompleteActionFlag legislationCode name requestCategory submittingUserIndicator timeCreated timeUpdated type updatedBy baseTask.id baseTask.name legislativeDataGroup.id legislativeDataGroup.name

Nómina - Resultados de proceso

Nombre del Módulo	oraHcmPayrollProcessResults
Ruta de contexto de módulo	hcmPayroll/processResults

Nombre de vista	Atributos
acción de nóminaExtrae	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
nóminaRelationshipActionExtracts	id actionSequence actionStatusCode chunkNumber endDate serialNumber startDate parentObject processPath payrollAction.id payrollRelationship.id prepayment.id
personResultsMessageExtracts	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
processResultsMessageExtracts	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

Tarea 2: Preparación y Prueba de una Consulta de Extracción

Cada vista de extracción tiene una API de consulta que permite crear y probar consultas de extracción.

URL	/api/boss/data/objects/ora/{{moduleContextPath}}/v1/{{viewName}}/$query
Método HTTP	POST
Plantilla de solicitud	{ "collection": { "limit": {{limit}}, "offset": {{offset}}, "sortBy": [ {{sortAttributes}} ], "filter": "{{topLevelFilter}}" }, "fields": [ {{topLevelAttributes}} ], "accessors": { "{{childObject}}": { "collection": { "filter": "{{childLevelFilter}}" }, "fields": [ {{childLevelAttributes}} ], "accessors": { {{nestedChildAccessors}} } }, ... } }
Plantilla de Respuestas	200 OK { "items": [ {{items}} ], "hasMore": {{hasMore}} }

Objetos y atributos

Definición de los datos que se van a extraer, es decir, los objetos y atributos de la vista que se deben incluir. Para incluir objetos secundarios es necesario agregar accessors, mientras que para incluir campos específicos es necesario mostrarlos en la matriz fields. Consulte el ejemplo completo.

Atención:

Si no especifica explicity accessors y fields secundarios, obtendrá la unidad por defecto de la vista. Tenga en cuenta que la unidad por defecto puede no incluir todos los objetos y atributos disponibles de la vista.

Filtrado

Definir cómo se deben filtrar los datos. Puede utilizar las siguientes expresiones para crear filtros para la consulta.

Finalidad	Expresión	Ejemplo
Prueba de igualdad	field = value	ename = 'KING'
Prueba de desigualdad	field != value	activeFlag != true
Prueba mayor que prueba menor que	field > value field < value	sal > 1999.99 hireDate < '2000-01-01' timeUpdated> '1900-01-01T13:51:54Z'
Prueba mayor que o igual que Prueba menor que o igual que	field >= value field <= value< code>	sal >= 1999.99 hireDate <= '2000-01-01' timeUpdated >= '1900-01-01T13:51:54Z'
Confrontación de patrones	field LIKE 'pattern'	job LIKE 'SALES%'
Prueba de afiliación	field IN (value1, ..., valueN)	deptno IN (10, 20, 40)
Comparación de no sensibilidad a mayúsculas/minúsculas	field ~= value field ~!= value field ~> value field ~< value field ~>= value field ~<= value field ~LIKE 'pattern' field ~IN (value1, ..., valueN)	ename ~= 'king'
Prueba de existencia (para relaciones de uno a varios)	child[expression]	assignments[startDate = null]
Conjunción lógica	expression AND expression
Disyunción lógica	expression OR expression
Negación lógica	!(expression)

Filtrado por objetos secundarios en una relación uno a uno:

En el caso de las relaciones uno a uno, puede hacer referencia a los objetos secundarios y sus atributos en la cláusula filter, al igual que a los atributos de otro objeto principal, por ejemplo legalEmployer.id in (1001, 1002).

Filtrado de objetos secundarios en una relación de uno a varios:

En casos raros de relaciones de uno a muchos indicados por el nombre del descriptor de acceso plural, la prueba de existencia de la tabla anterior filtrará los padres que tengan al menos un hijo que cumpla los criterios. Sin embargo, no significa que los registros secundarios, si se recuperan, se filtren automáticamente. Si desea asegurarse de que solo obtiene registros secundarios que cumplan los criterios, también debe repetir el filtro en el nivel secundario.

Por ejemplo, si desea recuperar solo los componentes de cambio del tipo físico UPDATE, debe aplicar los siguientes filtros en la consulta de cambios de objeto:

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

Filtrado por fecha efectiva:

En el caso de los objetos con fecha de vigencia, los datos entrarán en vigor a partir de la fecha actual por defecto. Para recuperar datos efectivos a partir de una fecha específica, utilice el parámetro de consulta HTTP $effectiveDate.

Por ejemplo, si desea recuperar datos efectivos a partir de 2023-01-01, utilice la siguiente URL para la consulta:

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

Ordenación

Definir cómo se deben ordenar los datos. La ordenación se expresa mediante una matriz de atributos de ordenación, incluida la dirección de ordenación (asc o desc). Por ejemplo:

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

Paginación

Defina cómo se deben paginar los datos. El cliente puede controlar la paginación proporcionando parámetros de límite y desplazamiento. Por ejemplo:

"limit": 200,
"offset": 400

El límite por defecto es 25 y el límite máximo es 1000.

El desplazamiento predeterminado es 0 e indica el comienzo de los resultados.

El atributo hasMore de nivel superior en la respuesta indica si hay más resultados que recuperar.

La paginación no debe utilizarse como una forma alternativa de extraer datos. Al consultar esta API, no hay garantía de que los datos no cambien entre las solicitudes. Utilice la API asíncrona para la extracción de datos.

Ejemplo

La siguiente consulta de extracción de ejemplo está diseñada para recuperar información de asignaciones junto con detalles de entidad legal empleadora y departamento, que:

• Son asignaciones principales
• Son del tipo Empleado
• No pertenece a entidades legales empleadoras con los ID 10001 y 10002
• Son efectivos a partir de la fecha de extracción
• Se ha actualizado (o creado) desde la ejecución anterior

Ejemplo de solicitud

Observe el parámetro limit y la condición de atributo timeUpdated con el registro de hora de la ejecución de extracción anterior.

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" ]
        }
    }
}
				

Ejemplo de respuesta

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
}

Tarea 3: Envío de una solicitud de trabajo de extracción

Una vez definida la consulta, se puede enviar una solicitud de trabajo de extracción mediante la API del programador de trabajos.

URL	/api/saas-batch/jobscheduler/v1/jobRequests
Método HTTP	POST
Plantilla de solicitud	{ "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 es un parámetro opcional que se debe proporcionar solo si desea recuperar datos con fecha de referencia de vigencia distinta de la fecha actual.
Plantilla de Respuestas	Al ejecutarse correctamente, se devolverá el código de respuesta 202, junto con la cabecera Location con la URL que apunta a la instancia de solicitud de trabajo concreta. 202 Accepted Location: {{jobRequestUrl}}

Paginación al extraer datos:

Aunque puede que haya utilizado controles de paginación, es decir, parámetros limit y offset, al crear y probar la consulta, no desea que los resultados de extracción estén limitados por ellos. Elimine cualquier uso de los parámetros limit y offset al enviar una consulta.

Transfiriendo la consulta:

La consulta transferida al enviar la solicitud de trabajo de extracción debe tener el formato de una cadena JSON estándar. Realice la consulta preparada y probada mediante el punto final de API $query y:

• Escapar de todas las comillas dobles (" → \")
• Eliminar cualquier carácter de nueva línea (\n)
• Reducir potencialmente otros espacios en blanco (por ejemplo, sangrías)

En general, desea ir, por ejemplo, desde:

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

Para:

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

Ejemplo

Ejemplo de solicitud

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\" ]}}}"
    }
}

Ejemplo de respuesta

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

Tarea 4: Comprobación de finalización de trabajo

La comprobación de la finalización implica el uso de la API del programador de trabajos para sondear periódicamente los detalles de la solicitud de trabajo hasta que se complete correctamente o falle.

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

Finalización correcta:

Una solicitud de trabajo se considera completada correctamente cuando se cumplen las siguientes condiciones:

Atributo	Valor esperado
jobDetails.jobProgress.completed	true
jobDetails.jobProgress.status	SUCCEEDED

Finalización fallida:

Se considera que una solicitud de trabajo ha fallado cuando se cumple la siguiente condición. En tal caso, el atributo jobDetails.jobProgress.message contendrá el mensaje de error.

Atributo	Valor esperado
jobDetails.jobProgress.status	FAILED

Ejemplo

Ejemplo de solicitud

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

Ejemplos de respuesta

A continuación, se muestran las distintas etapas de un trabajo enviado. Consulte los atributos jobProgress.status y jobProgress.completed en particular.

Aceptado/En cola

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 ejecución

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"
            }
        }
    }
}

Terminado Correctamente

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"
            }
        }
    }
}

Tarea 5: Recuperando detalles de salida de extracción

Una vez que el trabajo finaliza correctamente, se puede recuperar la información del archivo de salida. Implica el uso de la API del gestor de archivos de trabajo para la instancia de solicitud de trabajo de extracción concreta.

La salida se almacena en fragmentos comprimidos.

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

tamaño de archivo:

El tamaño del archivo se devuelve en el atributo de respuesta items.fileSize y se expresa en bytes.

Enlace de contenedor:

La URL al contenido del archivo real se devuelve en el atributo de respuesta items.$context.links.enclosure.

Ejemplo

Ejemplo de solicitud

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

Ejemplo de respuesta

En el siguiente ejemplo, la salida completa se almacena en dos archivos comprimidos.

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"
            }
        }
    }
}

Tarea 6: Descarga de salida de extracción

Por último, los archivos de salida de extracción se pueden descargar mediante la API del gestor de archivos de trabajo para la instancia de solicitud de trabajo de extracción y el archivo de salida concretos.

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

Atención:

Puede descargar hasta 32 MB en una sola solicitud. Si el archivo individual es más grande, por defecto obtendrá una parte de 32 MB del archivo. Para solicitudes consecutivas, debe utilizar la cabecera HTTP Range como se muestra a continuación. El uso de la cabecera Range también permite implantar la descarga multithread para recuperar archivos de gran tamaño de forma más eficaz, si es necesario.

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

Sugerencia:

Para evitar el uso completo de la cabecera Range, envíe solicitudes de trabajo con el parámetro adicional boss.export.maxChunkSize con el valor 180. Esto asegurará que cada fragmento comprimido sea menor de 32 MB y podrá descargarlo en una sola solicitud.

Ejemplo

Ejemplo de solicitud

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

Ejemplos de respuesta

La respuesta real es contenido de archivo comprimido binario. Una vez descomprimida, es completa o parcial (en caso de uso de cabecera Range), carga útil JSON sin formato, con resultados completos o parciales (en caso de un fragmento de archivo) de la consulta de extracción.

Ejemplo de resultados sin comprimir completos

{"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"}}}
]}

Más recursos de aprendizaje

Explore otros laboratorios en docs.oracle.com/learn o acceda a más contenido de aprendizaje gratuito en el canal YouTube de Oracle Learning. Además, visite education.oracle.com/learning-explorer para convertirse en un explorador de Oracle Learning.

Para obtener documentación sobre el producto, visite Oracle Help Center.

---

Título e Información de Copyright

Extracción de datos del almacén de datos optimizado para lectura de HCM

G38789-07

Abril 2026

Copyright ©2026,

Oracle y/o sus filiales.