Predefined Properties for Financial Consolidation and Close Applications
The following properties are predefined for all Financial Consolidation and Close 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 |
Aggregation |
String |
Yes |
Relationship |
Determines how child member values aggregate to parent members |
Alias |
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 Note: Base Currency is added to the Entity dimension only if Multi Currency is enabled during application registration. |
Data Storage |
String |
No Note: For the Consol and Rates cubes in new applications, the data storage property for the cube (for example, PLN.Data Storage (Consol)) is derived from the application default data storage property (PLN.Data Storage) |
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 |
Enterprise Predefined Member |
Boolean |
No |
Node |
Designates a dimension member as predefined by the application. Predefined members are restricted to only specific types of changes such as moves, or adding a child under or a top node above them. Note: This property is set by the import process when importing predefined members from a Financial Consolidation and Close application and it cannot be manually edited in Oracle Enterprise Data Management Cloud. |
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. |
Plan Type |
Boolean |
Yes |
Relationship |
Specifies whether the dimension members if valid for the plan type. |
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. |
Depending on your dimensions and application settings, the following properties may also be predefined for Financial Consolidation and Close applications. These properties do not get inherited.
Property | Created If | Data Type | Level | Description |
---|---|---|---|---|
Is CICTA Account | Account type dimension is defined |
String |
Node |
Specifies if an account is a Comprehensive Income Cumulative Translation Adjustment (CICTA) account ( |
CICTA Redirection Account | Account type dimension is defined |
Node |
Node |
Specifies the CICTA redirection account. This property is restricted to nodes where the Is CICTA Account property is set to |
Intercompany Account |
Account type dimension is defined and Intercompany is enabled |
String |
Node |
Specifies if an account is used for intercompany eliminations. |
Is Plug Account |
Account type dimension is defined and Intercompany is enabled |
String |
Node |
Specifies if an account is a plug account ( |
Plug Account |
Account type dimension is defined and Intercompany is enabled |
Node |
Node |
Specifies the intercompany plug account. This property is restricted to nodes where the Is Plug Account property is set to |
Intercompany Entity |
Entity type dimension is defined and Intercompany is enabled |
String |
Node |
Specifies if an entity is used for intercompany eliminations. |
Default Movement | Account type dimension is defined |
String |
Node Note: This property can be set on bottom nodes only. |
Specifies members in the Movement dimension to calculate movements for a member of the Account dimension. Note: The Default Movement property is set up to use an Allowed Values list, with no values identified initially. Populate the allowed values list with the nodes from the Movement dimension where you specified that Is Default Movement is set to YES. |
Is Default Movement | Movement type dimension is defined |
String |
Node Note: This property can be set on bottom nodes that are under the FCCS_Mvmts_Subtotal ancestor only. |
Designates a Movement dimension member for selection as a Default Movement for an Account dimension member. Note: Set this field to YES for nodes that will be used in the Account dimension Default Movement property. After you set this field to Yes, you must add the node to the allowed values for the Default Movement property in the Account dimension. |