Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

ScheduleExceptions

ScheduleExceptions

Columns

Name Type Description
ExceptionId [KEY] Long ExceptionId of ScheduleExceptions
Name String The name of the schedule exception that you provide when creating an instance. This attribute is required.
Description String The description of the exception that you provide when creating an instance.
ShortCode String The abbreviation that identifies the exception that is displayed.
ExceptionStartDate String The date when the schedule starts to use the exception.
ExceptionEndDate String The date when the schedule no longer uses the exception.
PeriodTypeCode String The abbreviation that identifies the type of period, such as Off period and Work period.
CategoryCode String The abbreviation that identifies the category, such as Holiday and Training.
AllDayFlag Bool Contains one of the following values: true or false. If true, then the exception is for the entire day and the Exception Start and the Exception End values are dates. If false, then the exception is for a subset of hours within each day in the exception range and the Exception Start and the Exception End values include date and time values. The default value is false.
CreatedBy String CreatedBy of ScheduleExceptions
CreationDate Datetime CreationDate of ScheduleExceptions
LastUpdateDate Datetime LastUpdateDate of ScheduleExceptions
LastUpdatedBy String LastUpdatedBy of ScheduleExceptions

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839