Guidelines for Loading the Default Access of an Oracle Learning Offering

You can load the default access properties of an offering using the Offering Default Access object. The access properties apply to all learners accessing offerings who aren't part of an access group and don't have a learning assignment.

To verify that the course successfully loaded, use the Offerings task on the My Client Groups > Learning and Development page. Open the offering details page and click Manage Default Access.

Examples for a New Offering

METADATA|OfferingV3|CourseNumber|OfferingNumber|EffectiveStartDate|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OfferingStartDate|OfferingEndDate|PrimaryInstructorId|FacilitatorType|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists

MERGE|OfferingV3|COURSE-202501250937-HDL|OFFERING-202501250937-HDL|2025/01/25|Title:Offering 202501250937-HDL||ORA_SP|2025/01/10|2027/03/10|||||4|US|5|30|4|FUSION_HCM_LEARNING|2021042809372|HCM Learning Source Info for 202104280937|Y

METADATA|OfferingDefaultAccessV3|OfferingNumber|DefaultAccessNumber|EffectiveStartDate|SelfViewMode|SelfInitialStatus|SelfEnrollForm|SelfActivateApprove|SelfEnrollQuestionnaire|SelfQuestionnaireCode|MgrInitialStatus

MERGE|OfferingDefaultAccessV3|OFFERING-202501250937-HDL|D-A-OFFERING-202501250937-HDL|2025/01/25|ORA_DETAILS|ORA_ASSN_REC_REQUESTED|||||ORA_ASSN_REC_REQUESTED

Examples for an Existing Offering

METADATA|OfferingV3|CourseNumber|OfferingNumber|EffectiveStartDate|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OwnedByPersonNumber|OfferingStartDate|OfferingEndDate|FacilitatorType|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists

MERGE|OfferingV3|HDL_COURSE_1|HDL_COURSE_1_OFF_1|27/01/25|HDL COURSE 1 OFF 1||ORA_SP|27/01/25|27/01/25|124882|10/03/27||||||||||

METADATA|OfferingDefaultAccessV3|OfferingNumber|DefaultAccessNumber|EffectiveStartDate|SelfViewMode|SelfInitialStatus|SelfEnrollForm|SelfActivateApprove|SelfEnrollQuestionnaire|SelfQuestionnaireCode|MgrInitialStatus

MERGE|OfferingDefaultAccessV3|HDL_COURSE_1_OFF_1|D-A-HDL-COURSE_1|2025/01/27|ORA_DETAILS|ORA_ASSN_REC_REQUESTED|||||ORA_ASSN_REC_REQUESTED