1. User's Guide
  2. Smart View and Oracle Journals for Financial Management
  3. Creating Journals
  4. Guidelines for Creating Journals from Ad Hoc Grids or Data Forms

Guidelines for Creating Journals from Ad Hoc Grids or Data Forms

Refer to this section when creating journals from ad hoc grids or forms, as described in Creating Journals. When you are finished reviewing this topic, you can continue with the steps in Editing Journal Properties.

You may start the journal creation process by selecting one or more cells in an ad hoc grid or data form. Note that:

  • The journal will be displayed with the selected members in the cell intersections as the line items.

  • The selected cells should have valid members in the Value dimension.

  • Before saving the journal, make any necessary changes to the POV in the POV toolbar. Once you save or refresh the journal, you can no longer make any changes to the POV.

Working with Value Members

  • If you select one or more value members from <Entity Currency>, <Entity Curr Adjs>, or <Entity Curr Total>, the new journal will use <Entity Curr Adjs> as the Value member.

  • If the selection has one or more members from <Parent Currency>, <Parent Curr Adjs>, or <Parent Curr Total>, the new journal will use Parent Curr Adjs> as the Value member.

  • If you select one or more members [Parent], [Parent Adjs] or [Parent Total], the new journal will use [Parent Adjs] as the Value member.

  • [Contribution Adjs], will be used if the selection has one or more of the following members: [Proportion], [Elimination], [Contribution], [Contribution Adjs], [Contribution Total].

  • If the selected members contain <Currency>, <Currency>_Adjs, or <Currency>_Total, and the selection has only one Entity member, the following checks are performed:

    • If the Entity default currency is the selected Currency, <Entity Curr Adjs> is used as the Value member.

    • If the default currency is not the selected Currency, and the Entity has a single parent, and if the parent's currency is the selected Currency, use <Parent Curr Adjs> as the Value member.

    • If neither of the above conditions are met, an <Entity Currency> and <Parent Curr Adjs> will be available for the selection.

  • If the selection does not contain any of the valid members noted above, an error message is displayed.

  • If the selection contains members from different valid groups—for example, <Entity Curr Adjs> and <Parent Curr Adjs>—you will be given selection options.

Scenario, Period, and Year Members

If the selection contains multiple Scenario, Period, or Year members, you will have the option to select one of these. Otherwise, the selected value will be used as the POV.