Skip to main content

Oracle Ledger Specifics

Use the following table to enter data in the Spreadsheet Server Settings > Ledger Specifics >Oracle panel, or to access other functions:

Field Description

Oracle Options:

 

Select Ledger

Click the drop-down list, and select the ledger, or ledger set and responsibility to be used to adjust values in the panel (for example, number of segments, segment labels, segment security, etc.). Right-click, and select Refresh to refresh the data. This value does not update the default responsibility for GXL formulas.

Number of segments

Specify the number of segments which make up the account. This value is automatically completed by the Select Ledger selection.

Segment number used for descriptions

For the currently-selected ledger, displays the segment number to be used for retrieving account descriptions in drill down panels and when processing GXE formulas. Use the Set Segment Number for All Ledgers button to change the value for all ledgers, or, click the Segment Mapping button to change the value for a single ledger.

Language

Specify the language to be used for account descriptions.

Balance SQL Statement Hint by Balance Type

Click the drop-down list and select the balance type (for example, A (Actual), B (Budget), E (Encumbrance), or P (Project), then in the adjacent field, specify the user-defined index to be used with the associated balance type, when processing Spreadsheet Server calculations.

Use summary accounts

If selected, summary accounts are included with non-summary accounts in the GXL formula calculation. Otherwise, only non-summary accounts are used. This option is only applicable if the GXL Summary Accounts parameter is not specified, or set to NA.

Segments

Displays the segment names for the specified ledger.
Button Function

Segment Mapping

Displays the Segment Mapping panel, allowing users for each ledger to assign the segment number to be used for descriptions, and to reorder account segments to match the order defined in the Oracle application (see Segment Mapping for more information).

Set Segment Number for All Ledgers

Displays the Oracle Segment Number Used For Descriptions panel, allowing users to assign the same segment number to be used for descriptions to all ledgers. This option is password protected.

Add Sample Hint

Inserts a sample index in the Balance SQL Statement Hint field.

View Segment Security

Displays any account restrictions based on the current user ID and responsibility.

See Spreadsheet Server Settings for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk