Get all activity records
get
/fscmRestApi/resources/11.13.18.05/sustainabilityActivities
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- ActivityIdFinder Finds the activity using the specified Activity ID.
Finder Variables- ActivityId; integer; Unique identifier of the activity record.
- PrimaryKey Finds the activity using the specified primary key.
Finder Variables- ActivityId; integer; Unique identifier of the activity record.
- ActivityIdFinder Finds the activity using the specified Activity ID.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- ActivityDate; string; Date of the activity record.
- ActivityId; integer; Unique identifier of an activity record.
- ActivityNumber; string; Unique number for the activity record.
- AlertFlag; boolean; Alert
- CalculationOverride; string; Mode used for calculation of emissions. For example, using matched factors, by manual entry of factors, or by manual entry of emissions.
- CalculationOverrideCode; string; Code that uniquely identifies the calculation mode.
- ClassificationCategory; string; Classification Category
- ClassificationCategoryId; integer; Classification Category ID
- ClassificationRuleId; integer; Classification Rule ID
- ClassificationRuleName; string; Classification Rule
- Comments; string; Additional information for an activity that can be entered in a free-text field.
- ConsumptionEndDate; string; Date when the consumption related to the activity will end.
- ConsumptionStartDate; string; Date when the consumption related to the activity started.
- Country; string; Name of the country.
- CountryCode; string; Code used to uniquely identify a country.
- CreatedBy; string; User who created the record.
- CreationDate; string; Date and time when the record was created.
- DataQuality; string; Indicates the data quality of the activity record. For example, High confidence, Moderate confidence, and Low confidence.
- DataQualityCode; string; Code that helps uniquely identify data quality.
- Description; string; Description of the activity record.
- DistributionLineNumber; integer; Distribution Line Number
- EntryType; string; Type of entry for the record such as Standard or Adjustment.
- EntryTypeCode; string; Code that helps uniquely identify the type of entry.
- EsgLedgerId; integer; Unique identifier of the sustainability ledger.
- ExternalReferenceNumber; string; Reference to a record in another application.
- InventoryItemId; integer; Unique identifier of the item.
- InvoiceDistributionId; integer; Invoice Distribution ID
- InvoiceId; integer; Invoice ID
- InvoiceLineNumber; integer; Invoice Line Number
- ItemDescription; string; Item Description
- ItemNumber; string; Unique number of the item.
- LastUpdateDate; string; Date and time when the record was last updated.
- LastUpdatedBy; string; User login by whom the record was last updated.
- Ledger; string; Sustainability Ledger
- LegalEntity; string; Name of the legal entity.
- LegalEntityId; integer; Unique identifier of the legal entity.
- OriginalActivityId; integer; Unique identifier of the original activity record.
- OriginalActivityNumber; string; Unique number of the original activity record.
- Period; string; Period
- PeriodId; integer; Unique identifier for the period under which the activity is reported.
- PostingDate; string; Date on which the activity status was changed to posted.
- Scope; string; Scope of emissions as defined by the Greenhouse Gas Protocol, that's, Scope 1, Scope 2 Location-based, Scope 2 Market-based or Scope 3.
- ScopeCategory; string; Category under which Scope 3 emissions are reported. Purchased goods and services, waste generated in operations are few such categories.
- ScopeCategoryCode; string; Code that identifies a Scope 3 category.
- ScopeCode; string; Code that identifies a scope.
- SourceType; string; Source of the activity record, such as Manual, External, Invoice autocreate, or File-Based Data Import.
- SourceTypeCode; string; Code of the source type that helps to uniquely identify the source type.
- Status; string; Status of the activity record such as Draft, Posted, or Canceled.
- StatusCode; string; Status code that helps to uniquely identify a status.
- Supplier; string; Unique name of the supplier.
- SupplierId; integer; Unique identifier of the supplier.
- TotalCo2e; number; Total calculated CO2e for the activity record.
- TotalCo2eUOM; string; Code identifying the UOM for the total CO2e.
- TotalCo2eUOMName; string; Total CO2e UOM
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : sustainabilityActivities
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : sustainabilityActivities-item-response
Type:
Show Source
object-
ActivityDate: string
(date)
Title:
Activity DateDate of the activity record. -
ActivityDff: array
ActivityDff
-
ActivityId: integer
(int64)
Title:
Activity IDRead Only:trueUnique identifier of an activity record. -
ActivityNumber: string
Title:
Activity NumberRead Only:trueMaximum Length:100Unique number for the activity record. -
AlertFlag: boolean
Read Only:
trueAlert -
CalculationDate: string
Title:
Calculation DateRead Only:trueMaximum Length:255Date when the emissions were last calculated. -
CalculationOverride: string
Title:
Calculation ModeMaximum Length:255Mode used for calculation of emissions. For example, using matched factors, by manual entry of factors, or by manual entry of emissions. -
CalculationOverrideCode: string
Title:
Calculation Mode CodeMaximum Length:100Code that uniquely identifies the calculation mode. -
ClassificationCategory: string
Read Only:
trueMaximum Length:255Classification Category -
ClassificationCategoryId: integer
(int64)
Read Only:
trueClassification Category ID -
ClassificationRuleId: integer
(int64)
Read Only:
trueClassification Rule ID -
ClassificationRuleName: string
Read Only:
trueMaximum Length:255Classification Rule -
Comments: string
Title:
CommentsMaximum Length:4000Additional information for an activity that can be entered in a free-text field. -
ConsumptionEndDate: string
(date)
Title:
Consumption End DateDate when the consumption related to the activity will end. -
ConsumptionStartDate: string
(date)
Title:
Consumption Start DateDate when the consumption related to the activity started. -
Country: string
Title:
CountryMaximum Length:255Name of the country. -
CountryCode: string
Title:
Country CodeMaximum Length:2Code used to uniquely identify a country. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64User who created the record. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueDate and time when the record was created. -
DataQuality: string
Title:
Data QualityMaximum Length:255Indicates the data quality of the activity record. For example, High confidence, Moderate confidence, and Low confidence. -
DataQualityCode: string
Title:
Data Quality CodeMaximum Length:30Code that helps uniquely identify data quality. -
Description: string
Title:
DescriptionMaximum Length:4000Description of the activity record. -
DistributionLineNumber: integer
Distribution Line Number
-
EmissionFactorMapDFF: array
EmissionFactorMapDFF
-
Emissions: array
Emissions
Title:
EmissionsRepresents the details in an emission record of a sustainability activity, including emission type, emission factor, emission quantity and, where applicable, the associated carbon dioxide equivalent. For example, an activity record representing the consumption of 5,000 standard cubic feet of natural gas might have several emission records such as emission type methane, an associated emission factor, the resulting calculated emissions, and the associated carbon dioxide equivalent. -
EntryType: string
Title:
Entry TypeMaximum Length:255Type of entry for the record such as Standard or Adjustment. -
EntryTypeCode: string
Title:
Entry Type CodeMaximum Length:30Code that helps uniquely identify the type of entry. -
EsgLedgerId: integer
(int64)
Title:
Sustainability Ledger IDRead Only:trueUnique identifier of the sustainability ledger. -
ExternalReferenceNumber: string
Title:
External Reference NumberMaximum Length:100Reference to a record in another application. -
InventoryItemId: integer
(int64)
Title:
Item IDUnique identifier of the item. -
InvoiceDistributionId: integer
(int64)
Invoice Distribution ID
-
InvoiceId: integer
(int64)
Invoice ID
-
InvoiceLineNumber: integer
(int64)
Invoice Line Number
-
InvoiceNumber: string
Maximum Length:
80Invoice Number -
ItemDescription: string
Read Only:
trueMaximum Length:255Item Description -
ItemNumber: string
Title:
ItemMaximum Length:255Unique number of the item. -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueDate and time when the record was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64User login by whom the record was last updated. -
Ledger: string
Read Only:
trueMaximum Length:255Sustainability Ledger -
LegalEntity: string
Title:
Legal EntityMaximum Length:255Name of the legal entity. -
LegalEntityId: integer
(int64)
Title:
Legal Entity IDUnique identifier of the legal entity. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Measures: array
Activity Measures
Title:
Activity MeasuresRepresents the details of the measure record of a sustainability activity. The details include measure type, measure quantity, unit of measure, and currency. For example, for an activity record that represents the burning of 10 cubic feet of natural gas, the measure type is Quantity, the measure quantity is 10, and the unit of measure is cubic feet. -
OriginalActivityId: integer
(int64)
Title:
Original Activity IDUnique identifier of the original activity record. -
OriginalActivityNumber: string
Title:
Original Activity NumberMaximum Length:255Unique number of the original activity record. -
Period: string
Maximum Length:
255Period -
PeriodId: integer
(int64)
Title:
Period IDUnique identifier for the period under which the activity is reported. -
PostingDate: string
(date-time)
Title:
Posting DateRead Only:trueDate on which the activity status was changed to posted. -
Scope: string
Title:
ScopeMaximum Length:255Scope of emissions as defined by the Greenhouse Gas Protocol, that's, Scope 1, Scope 2 Location-based, Scope 2 Market-based or Scope 3. -
ScopeCategory: string
Title:
Scope CategoryMaximum Length:80Category under which Scope 3 emissions are reported. Purchased goods and services, waste generated in operations are few such categories. -
ScopeCategoryCode: string
Title:
Scope Category CodeMaximum Length:30Code that identifies a Scope 3 category. -
ScopeCode: string
Title:
Scope CodeMaximum Length:30Code that identifies a scope. -
SourceType: string
Title:
Source TypeMaximum Length:255Source of the activity record, such as Manual, External, Invoice autocreate, or File-Based Data Import. -
SourceTypeCode: string
Title:
Source Type CodeMaximum Length:100Code of the source type that helps to uniquely identify the source type. -
Status: string
Title:
StatusRead Only:trueMaximum Length:255Status of the activity record such as Draft, Posted, or Canceled. -
StatusCode: string
Title:
Status CodeRead Only:trueMaximum Length:30Default Value:ORA_SUS_STATUS_DRAFTStatus code that helps to uniquely identify a status. -
Supplier: string
Title:
SupplierMaximum Length:255Unique name of the supplier. -
SupplierId: integer
(int64)
Title:
Supplier IDUnique identifier of the supplier. -
TotalCo2e: number
Title:
Total CO2eRead Only:trueTotal calculated CO2e for the activity record. -
TotalCo2eUOM: string
Title:
Total CO2e UOM CodeRead Only:trueMaximum Length:3Code identifying the UOM for the total CO2e. -
TotalCo2eUOMName: string
Read Only:
trueMaximum Length:255Total CO2e UOM -
ValidationMessages: array
Validation Messages
Title:
Validation MessagesContains details of the validation issues that are generated when an activity record is validated. Validation messages explain the reasons for inconsistencies in an activity record, that must be addressed before the record can be posted.
Nested Schema : Emissions
Type:
arrayTitle:
EmissionsRepresents the details in an emission record of a sustainability activity, including emission type, emission factor, emission quantity and, where applicable, the associated carbon dioxide equivalent. For example, an activity record representing the consumption of 5,000 standard cubic feet of natural gas might have several emission records such as emission type methane, an associated emission factor, the resulting calculated emissions, and the associated carbon dioxide equivalent.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Activity Measures
Type:
arrayTitle:
Activity MeasuresRepresents the details of the measure record of a sustainability activity. The details include measure type, measure quantity, unit of measure, and currency. For example, for an activity record that represents the burning of 10 cubic feet of natural gas, the measure type is Quantity, the measure quantity is 10, and the unit of measure is cubic feet.
Show Source
Nested Schema : Validation Messages
Type:
arrayTitle:
Validation MessagesContains details of the validation issues that are generated when an activity record is validated. Validation messages explain the reasons for inconsistencies in an activity record, that must be addressed before the record can be posted.
Show Source
Nested Schema : sustainabilityActivities-ActivityDff-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context SegmentMaximum Length:30Context Segment -
__FLEX_Context_DisplayValue: string
Title:
Context SegmentContext Segment -
ActivityId: integer
(int64)
Read Only:
true -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : sustainabilityActivities-EmissionFactorMapDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Activity TypeMaximum Length:150Activity Type -
__FLEX_Context_DisplayValue: string
Title:
Activity TypeActivity Type -
ActivityId: integer
(int64)
Read Only:
true -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : sustainabilityActivities-Emissions-item-response
Type:
Show Source
object-
ActivityEmissionId: integer
(int64)
Title:
Activity Emission IDRead Only:trueUnique identifier of an activity emission record. -
ActivityId: integer
(int64)
Title:
Activity IDUnique identifier of an activity record. -
ActivityMeasureId: integer
(int64)
Title:
Activity Measure IDRead Only:trueUnique identifier of an activity measure record. -
Co2eEmissionQuantity: number
Title:
CO2eRead Only:trueQuantity of CO2e emission. -
Co2eUOM: string
Title:
CO2e UOMRead Only:trueMaximum Length:255Unit of measure for the quantity of CO2e emission. -
Co2eUOMCode: string
Title:
CO2e UOM CodeRead Only:trueMaximum Length:3Code identifying the unit of measure for the quantity of CO2e emission. -
DenominatorCurrency: string
Title:
Denominator CurrencyMaximum Length:80Currency of the denominator of the emission factor. -
DenominatorCurrencyCode: string
Title:
Denominator Currency CodeMaximum Length:15Currency code of the denominator of the emission factor. -
DenominatorUOM: string
Title:
Denominator UOMMaximum Length:80Unit of measure of the denominator of the emission factor. -
DenominatorUOMCode: string
Title:
Denominator UOM CodeMaximum Length:3Code for the unit of measure of the denominator of the emission factor. -
Description: string
Title:
DescriptionMaximum Length:4000Description of the emission factor. -
EmissionFactor: number
Title:
FactorValue of the emission factor. -
EmissionFactorMappingId: integer
(int64)
Title:
Emission Factor Mapping IDRead Only:trueUnique identifier of the emission factor mapping. -
EmissionQuantity: number
Title:
Emission QuantityQuantity of emission. -
EmissionType: string
Title:
Emission TypeMaximum Length:80Name of the type of emission. An emission type is a substance such as a greenhouse gas or an air pollutant that's emitted by a process such as fossil fuel combustion or a chemical reaction. For example, CO2 and CH4 could be associated with an activity type, stationary combustion. -
EmissionTypeCode: string
Title:
Emission Type CodeMaximum Length:30Code identifying an emission type. -
EmissionUOM: string
Title:
Emission UOMMaximum Length:255Unit of measure for the quantity of emission. -
EmissionUOMCode: string
Title:
Emission UOM CodeMaximum Length:3Code identifying the unit of measure for the quantity of emission. -
FactorSource: string
Title:
SourceMaximum Length:1000Source of the emission factor provided as free-form text. For example, Supplier-provided carbon footprint. -
GwpFactor: number
Title:
GWP FactorRead Only:trueMetric value used to assess the potential contribution of different greenhouse gases to global warming over a specific period, usually 100 years. -
GwpId: integer
(int64)
Title:
GWP IdentifierRead Only:trueUnique identifier of global warming potential (GWP) that's a metric used to assess the potential contribution of different greenhouse gases to global warming over a specific period, usually 100 years. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Measure: integer
(int64)
Title:
MeasureRead Only:trueValue for the measure type used for calculating the emission. -
MeasureType: string
Title:
Measure TypeMaximum Length:80Name of the measure type. For example, quantity, amount, or distance. -
MeasureTypeCode: string
Title:
Measure Type CodeMaximum Length:30Code identifying a measure type. -
MeasureUnit: string
Title:
Measure UnitRead Only:trueMaximum Length:255Unit for the measure value. For example, US Dollar, Kilometer, or Kilogram. -
NumeratorUOM: string
Title:
Numerator UOMMaximum Length:255Unit of measure of the numerator of the emission factor. -
NumeratorUOMCode: string
Title:
Numerator UOM CodeMaximum Length:3Code for the unit of measure of the numerator of the emission factor.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : sustainabilityActivities-Measures-item-response
Type:
Show Source
object-
ActivityMeasureId: integer
(int64)
Title:
Activity Measure IDRead Only:trueUnique identifier of an activity measure record. -
Currency: string
Title:
CurrencyMaximum Length:80Currency when the measure is monetary, for example, Amount. -
CurrencyCode: string
Title:
Currency CodeMaximum Length:15Code that identifies the currency when the measure is monetary, for example, Amount. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Measure: number
Title:
MeasureMeasure to be used for emission calculation and reporting. -
MeasureType: string
Title:
Measure TypeMaximum Length:255Name of the measure type. For example, quantity, amount, or distance. -
MeasureTypeCode: string
Title:
Measure Type CodeMaximum Length:30Code identifying a measure type. -
UOM: string
Title:
UOMMaximum Length:80Unit of measure when the measure isn't monetary, for example, Quantity or Distance. -
UOMCode: string
Title:
UOM CodeMaximum Length:3Code that identifies the unit of measure when the measure isn't monetary, for example, Quantity or Distance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : sustainabilityActivities-ValidationMessages-item-response
Type:
Show Source
object-
ActivityId: integer
(int64)
Title:
Activity IDRead Only:trueUnique identifier of the activity record for which the validation message is generated. -
EmissionTypeCode: string
Title:
Emission Type CodeRead Only:trueMaximum Length:30Emission type code for which the validation message is generated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Message: string
Title:
MessageRead Only:trueMaximum Length:255Full text of the validation message that was generated during activity validation. -
MessageCode: string
Title:
Message CodeRead Only:trueMaximum Length:30Message code that helps to uniquely identify the message details. -
MessageLevel: string
Title:
Message LevelRead Only:trueMaximum Length:255Indicates the level of the message, error, warning, or informational. -
MessageLevelCode: string
Title:
Message Level CodeRead Only:trueMaximum Length:30Message level code that helps to uniquely identify the message level. -
MessageSummary: string
Title:
Message SummaryRead Only:trueMaximum Length:255Summarized explanation of the validation message. -
MessageSummaryCode: string
Title:
Message Summary CodeRead Only:trueMaximum Length:30Message summary code that helps to uniquely identify the message summary. -
ValidationMessageId: integer
(int64)
Title:
Validation Message IDRead Only:trueUnique identifier of the validation message.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source