ADO.NET Provider for Oracle Fusion Cloud HCM

Build 26.0.9770

LearningSelfPacedItems

Returns Self-paced learning items available in the Oracle Fusion Cloud HCM learning catalog.

Columns

Name Type SupportedFinders Description
LearningItemAttributionType String Indicates who this learning item is attributed to. Valid values are ORA_PERSON or ORA_SPECIALIST.
LearningItemAuthorDisplayName String Display name of the learning item author.
LearningItemAuthorPersonId Long Person identifier for the learning item author.
LearningItemAuthorPersonNumber String Person number of the learning item author.
LearningItemAuthorType String Learning author type. Valid values are ORA_PERSON or ORA_ADHOC.
LearningItemBusinessDriver String Business driver, such as Compliance or Self Development.
LearningItemCoordPersonId Long Person identifier for the learning item coordinator.
LearningItemCoordPersonNumber String Person number of the learning item coordinator.
LearningItemCreationDate Datetime Date when the learning item was created.
LearningItemPublishEndDate Datetime Date when the learning item stops being visible in the learning catalog.
LearningItemInstructorDisplayName String Display name for the learning item instructor.
LearningItemInstructorPersonId Long Person identifier for the learning item instructor.
LearningItemInstructorPersonNumber String Person number of the learning item instructor.
LearningItemInstructorType String Type of instructor. Valid values are ORA_PERSON or ORA_ADHOC.
LearningItemLastModifiedDate Datetime Date when the learning item was last modified.
LearningItemId [KEY] Long PrimaryKey, findByLearningItemId Learning item Id of the course.
LearningItemNumber String FindByLearningItemNumber User-friendly number identifying the learning item. It is a surrogate key shown in the user interface (UI).
LearningItemType String Type of learning item, such as video, online course, document, assessment, or observation checklist.
LearningItemLearningLevel String Learning level, such as Beginner, Moderate, or Advanced.
LearningItemInactiveDate Datetime Date when the learning item is set to inactive.
LearningItemNotificationPattern String Notification pattern, such as Default Notification Pattern.
LearningItemProvider String Name of the provider used to create the learning item, such as Skillsoft or LinkedIn.
LearningItemProviderType String Type of the provider used. Valid values are File,URL,Connector or Questionnaire.
LearningItemPublisher String Learning item publisher, such as Learning Department.
LearningItemPublishStartDate Datetime Date when the learning item starts being visible in the learning catalog.
LearningItemStatus String Status of the learning item.
LearningItemVisibility String Visibility of the learning item, such as Public or Secret.
DataSecurityPrivilege String Data security privilege, such as Learner or Learner Manager. Valid values are defined in the DataSecurityPrivilegeLOV.
LearningItemExpectedEffortInSeconds Decimal Expected effort needed by the learner to complete the learning item.
LearningItemDescription String Plain text version of the long description of the learning item.
LearningItemDraftExists String Indicates whether a draft version of this learning item exists. Valid values are Y or N.
LearningItemPublishedExists String Indicates whether a published version of this learning item exists. Valid values are Y or N.
LearningItemSupportedLanguages String List of languages the learning item supports.
LearningItemDetailsDeepLink String URL to open the learning item page directly from the browser.
LearningItemDetailsEmbedLink String URL that can be used to embed the learning item page in other pages. It opens the isolated learning item page without the global tool bar on the top.
LearningItemCoverArtHighRenditionLink String Link to the high rendition version of the learning cover art image.
LearningItemCoverArtMedRenditionLink String Link to the medium rendition version of the learning cover art image.
LearningItemCoverArtLowRenditionLink String Link to the low rendition version of the learning cover art image.
LearningItemDeliveryURL String URL used to deliver the learning item to the learner.
LearningItemLongDescription String Long, rich text description of the learning item.
LearningItemTypeMeaning String Meaning for the learningItemType attribute.
LearningItemShortDescription String Short description of the learning item.
LearningItemCreatedByDisplayName String Display name of the person who created the learning item.
LearningItemLastModifiedByDisplayName String Display name of the person who last modified the learning item.
LearningItemCoordDisplayName String Display name of the learning item coordinator.
LearningItemTitle String Title of the learning item.
LearningItemFeatureStartDate Datetime Date when the learning item starts being featured.
LearningItemFeatureEndDate Datetime Date when the learning item stops being featured.
LearningItemSelfEnrollmentURL String URL for the learner to self-enroll.
LearningItemPublisherName String Name of the publisher of the learning item.
LearningItemProviderMeaning String Description for the learningItemProvider attribute value.
LearningItemProviderTypeMeaning String Description for the learningItemProviderType attribute value.
LearningItemRatingAverage Long Rating average for the learning item.
LearningItemRatingCount Long Rating count for the learning item.
LearningItemTrailerLink String URL to open the learning item trailer directly from the browser.
LearningItemAuthoredOnDate Datetime Date when the learning item was authored.
LearningItemPreviewURL String URL used by the administrator to preview the learning item.
LearningItemInactiveReasonCode String Reason for moving the learning item to inactive status.
LearningItemStatusComment String Status change comment for the learning item.
LearningItemReactivationReasonCode String Reason for moving the inactive learning item to active status.
LearningItemDeletionReasonCode String Reason for deleting the learning item.
LearningItemActiveDate Datetime Date when the learning item was activated.
LearningItemContentDeleteDate Datetime Date when the learning item content was deleted.
LearningItemContentDeleteReasonCode String Reason for deleting the learning item content.
LearningItemKeepCompletionsOnDelete String Indicates whether learning completions should persist when the learning item is deleted. Valid values are Y and N.
LearningItemAuthorEmailAddress String Primary email address of the person.
LearningItemInstructorEmailAddress String Primary Email address of the instructor for the learning item.
LearningItemCoordEmailAddress String Email address for the learning item coordinator.
LearningItemAuthorPhoneNumber String Phone number for the learning item author.
LearningItemInstructorPhoneNumber String Phone number of the instructor.
LearningItemCoordPhoneNumber String Phone number for the learning item coordinator.
LearningItemCommunityOverridesVisibility String Indicates whether the learning item visibility can be overridden by a community. Valid values are Y or N.
LearningItemLearningPathOverridesVisibility String Indicates whether the learning item visibility can be overridden by a learning path. Valid values are Y or N.
LearningItemApprovalRuleESS String Determines how approvals are configured for self-service enrollment.
LearningItemApprovalRuleMSS String Determines how approvals are configured for manager enrollment.
LearningItemMarkCompleteMSS String Indicates whether the manager can mark an enrollment as complete. Valid values are Y or N. The default value is Y.
LearningItemCatalogProfileNumber String Number for the learning catalog profile.
LearningItemCatalogProfileId Long Unique identifier for the learning catalog profile.
LearningItemCatalogProfileName String Name of the learning catalog profile.
LearningItemEnrollCondition String Indicates when a learner can enroll in this learning item.
LearningItemEnrollmentEndDate Datetime Date when the enrollment period ends.
LearningItemEnrollmentStartDate Datetime Date when the enrollment period begins.
LearningItemEnrollmentVisibilityMSS String Indicates whether the enrollment details are visible to the line manager. Valid values are ORA_SHOW and ORA_HIDE. The default value is ORA_SHOW.
LearningItemWithdrawalRuleESS String Determines how the learner's assignment withdrawals are processed.
LearningItemWithdrawalRuleMSS String Determines how the manager's assignment withdrawals are processed.
LearningItemSourcePublishedDate Datetime Date when content for the self-paced learning was published. This value is imported for self-paced learning managed by external content providers.
LearningItemCompletionCertificateEnabled String Indicates whether a completion certificate is enabled. Valid values are Y or N.
LearningItemCompletionCertificateFileName String File name of the completion certificate.
LearningItemCompletionCertificateTitle String Title of the completion certificate.
LearningItemCompletionCertificateLink String Preview link for the completion certificate.
LearningItemLearnerDataCollectionTypeESS String Determines how the learner information is collected, such as questionnaire or form.
LearningItemLearnerDataQuestionnaireNameESS String Name of the questionnaire.
LearningItemLearnerDataQuestionnaireCodeESS String Unique code for the questionnaire.
LearningItemSelfEnrollRetakeRule String Determines whether the learners can retake the learning again or not. Valid values are ORA_NEVER,ORA_PASS or ORA_PASS_FAIL. The default value is ORA_PASS.
LearningItemDownloadURL String URL to download the learning from the browser.
IsProviderSkillsProfiled String Indicates whether the learning is profiled with source skills from the provider.
LearningItemNeedsKnowledgeIndexing String Indicates whether the content backing this learning needs to be indexed. Valid values are Y or N.
LearningItemKnowledgeIndexingStatus String Status for the content indexing.
Finder String The named finder used to filter the records returned for this resource.
SysEffectiveDate String FindByLearningItemId, findByLearningItemNumber The effective date used to retrieve records valid as of the specified date.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770