1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with Tax Reporting Applications
  4. Registering Tax Reporting Applications
  5. Predefined Properties for Tax Reporting Applications

Predefined Properties for Tax Reporting Applications

The following properties are predefined for all Tax Reporting applications.

Property Data Type Inherited Level Description

Access Granted to Member Creator

String

No

Node

Determines the access that member creators have to dynamic members that they create

Account Type

String

Yes

Node

Defines account time balance (how values flow over time) and determines accounts sign behavior for variance reporting with member formulas

Alias: {Alias Table}

String

No

Node

Alternate unique description for the dimension member
Allow Upper Level Entity Input Boolean No Node

Specify whether parent entity input is allowed for this member.

Base Currency

String

Yes

Node

Specifies the base currency for an entity dimension member in a Standard multiple currency application

Data Storage

String

No

Relationship

Specifies whether data is stored or calculated for a dimension member

Data Type

String

Yes

Node

Specifies the type of data values for a dimension member

Enable for Dynamic Children

Boolean

No

Node

Enables users to create children for this member by entering a member name in the runtime prompt for a business rule that has been configured with a dynamic parent member

Exchange Rate Type

String

Yes

Node

Determines how exchanges rates are used to calculate values

Formula

Memo

No

Node

Member formula used to calculate a value for a dimension member.

Formula Description

String

No

Node

Description for a member formula

Hierarchy Type

String

No

Node

Available for dimension bound to an aggregate storage cube. Aggregate storage dimension are automatically enable to support multiple hierarchies. The first hierarchy in a multiple hierarchy dimension must be stored.

Number of Possible Dynamic Children

Integer

No

Node

Maximum number of dynamic children that can be created for a dimension member. This option is available if Enable for Dynamic Children is selected.

Process Management Enabled

Boolean

  

Node

Determines whether process management is enabled

Skip Value

String

Yes

Node

Determines how database calculations treat zeros and missing values when Time Balance is First, Balance, or Average.

Smart List

String

No

Node

Select a smart list to associate to a dimension member.

Source Plan Type

String

Yes

Node

Source plan type for a dimension member

Time Balance

String

Yes

Node

Specifies how the application calculates the value of summary time periods

Two Pass Calculation

Boolean

No

Node

Recalculate values of members based on values of parent members or other members. Available for Account and Entity members with Data Storage of Dynamic Calc or Dynamic Calc and Store.

UDA

List

No

Node

User defined attribute used for calculation or reporting purposes

Variance Reporting

String

No

Node

Determines whether an account is treated as an expense during variance reporting

Weekly Distribution

Boolean

No

Node

Sets the weekly distribution. Available for bottom level account members if the option was selected when creating the application and the base time period is 12 months.

The following properties are predefined for each cube in your application:

Table 31-1 Tax Reporting Properties by Cube

Property Data Type Inherited Level Description

Aggregation {Cube}

String

Yes

Relationship

Determines how child member values aggregate to parent members

Data Storage {Cube}

String

No

Relationship

Specifies whether data is stored or calculated for a dimension member

Formula {Cube}

Memo

No

Node

Member formula used to calculate a value for a dimension member.

Formula Description {Cube}

String

No

Node

Description for a member formula
Plan Type {Cube} Boolean Yes Relationship Specifies whether the dimension member is valid for the plan type.
Solve Order {Cube} Integer No Node Specifies the order in which formulas are evaluated. The formulas for members that have a specified solve order are calculated in order from the lowest solve order to the highest.

Predefined Attribute Properties

See Predefined Attributes for Tax Reporting Applications for a list of attribute properties that are created when you register a Tax Reporting application. Note the following about attribute properties:

  • They use the TRCS namespace.
  • They are all at the Node level.
  • They are all string data types, except for FX Rates - Global Account Rate Override and Plug Account, which are node data types.