BudgetaryControlValidationRequestControlBudgetResult

A budgetary control validation request control budget result contains the control budget, budget account, budget period, validation result, budgetary control balance impacted by the transaction line, and whether the balance was updated or not.

Expand all

Collapse all

Business Views

** Available for extracting data

• budgetaryControlValidationRequestControlBudgetResultsExtract**

  A budgetary control validation request control budget result contains the control budget, budget account, budget period, validation result, budgetary control balance impacted by the transaction line, and whether the balance was updated or not.

  Label, Plural Label

  Budgetary Control Validation Request Control Budget Results, Budgetary Control Validation Request Control Budget Results

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allocationHeaderNumber (string)

    Number assigned to the source transaction or the number assigned to the control budget impact of the original budgetary control validation request that's being liquidated or backed out, respectively.

    Label

    Liquidation Original Assigned Transaction Number

  • allocationLineNumber (int64)

    Number assigned to the source transaction line of the original budgetary control validation request that's being liquidated.

    Label

    Liquidation Original Assigned Line ID

  • assignedControlBudgetResultNumber (string)

    Number assigned to the control budget result of a source transaction line or distribution.

    Label

    Assigned Control Budget Result Number

    Properties

    • searchable
    • sortable
    • not nullable
  • assignedLineId (int64)

    Number assigned to a source transaction line or distribution within a budgetary control validation request.

    Label

    Assigned Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • assignedTransactionNumber (string)

    Number assigned to a source transaction within a budgetary control validation request.

    Label

    Assigned Transaction Number

    Properties

    • searchable
    • sortable
    • not nullable
  • backoutHeaderNumber (string)

    Number assigned to the source transaction or the number assigned to the control budget impact of the original budgetary control validation request that's being backed out or liquidated, respectively.

    Label

    Reversal Original Assigned Transaction Number

  • backoutLineNumber (int64)

    Number assigned to the source transaction line of the original budgetary control validation request that's being backed out.

    Label

    Reversal Original Assigned Line ID

  • balancesUpdatedFlag (boolean)

    Indicates whether the control budget balances are updated by the budgetary control validation request.

    Label

    Balances Updated Indicator

    Properties

    • searchable
    • sortable
  • budgetAdjustmentAmount (big-decimal)

    The amount by which the budget has been adjusted.

    Label

    Budget Adjustments

    Properties

    • searchable
    • sortable
  • budgetCurrencyAmount (big-decimal)

    The transaction amount in the budget currency.

    Label

    Budget Amount

    Properties

    • searchable
    • sortable
    • not nullable
  • budgetDate (date)

    The budget date of the source transaction line for the budgetary control validation request.

    Label

    Budget Date

    Properties

    • searchable
    • sortable
    • not nullable
  • budgetPeriod (string)

    The budget period for which the balance is tracked.

    Label

    Budget Period

    Properties

    • searchable
    • sortable
  • closedPeriodOverrideTakenFlag (boolean)

    Indicates whether the budgetary control transaction requires an override for reserving funds from a closed budget period.

    Label

    Closed Period Override Taken Indicator

    Properties

    • searchable
    • sortable
  • commitmentAmount (big-decimal)

    The budget consumption balance classified as commitments, typically requisitions.

    Label

    Commitments

    Properties

    • searchable
    • sortable
  • conversionRate (big-decimal)

    The currency conversion rate used to convert the entered transaction amount to the budget currency amount.

    Label

    Conversion Rate

    Properties

    • searchable
    • sortable
    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • estimatedOverrideAmountNeeded (big-decimal)

    The estimated override amount needed for funds reservation.

    Label

    Estimated Override Amount Needed

  • estimatedToleranceNeeded (big-decimal)

    The estimated tolerance amount needed for funds reservation.

    Label

    Estimated Tolerance Needed

    Properties

    • searchable
    • sortable
  • expendituresAmount (big-decimal)

    The budget consumption balance classified as actual expenditures, typically receipts or invoices.

    Label

    Expenditures

    Properties

    • searchable
    • sortable
  • fundsAvailableAmount (big-decimal)

    Funds available amount for consumption.

    Label

    Funds Available

    Properties

    • searchable
    • sortable
  • fundsOverrideTakenFlag (boolean)

    Indicates whether the budgetary control transaction requires an override for insufficient funds.

    Label

    Funds Override Taken Indicator

    Properties

    • searchable
    • sortable
  • obligationAmount (big-decimal)

    The budget consumption balance classified as obligations, typically purchase orders.

    Label

    Obligations

    Properties

    • searchable
    • sortable
  • otherEncumbrancesAmount (big-decimal)

    The budget consumption balance classified as encumbrances other than commitments and obligations.

    Label

    Other Encumbrances

    Properties

    • searchable
    • sortable
  • pendingAmount (big-decimal)

    The total pending amount from transactions processed earlier in the same or different validation request reserved against the same control budget, budget account, and budget period.

    Label

    Pending Amount

  • pendingReservationOfSameBudget (big-decimal)

    Total pending reservations for other lines in this budgetary control validation request for the same control budget, budget period and budget account.

    Label

    Pending Reservation of Same Budget

    Properties

    • searchable
    • sortable
  • pendingTransactionGroupAmount (big-decimal)

    The total pending amount from transactions processed earlier in the same validation request under the same header group reserved against the same control budget, budget account, and budget period.

    Label

    Pending Transaction Group Amount

  • projectBurdenFlag (boolean)

    Indicates whether the control budget impact is for the burdened cost of a project.

    Label

    Project Burden Indicator

    Properties

    • searchable
    • sortable
  • reversedInDifferentPeriodFlag (boolean)

    Indicates when the reversal for this line by a later budgetary control validation request is in a different budget period for the control budget and budget account.

    Label

    Reversed in Different Period Indicator

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • toleranceAllowed (big-decimal)

    The computed tolerance amount allowed for the control budget, budget period and budget account based on control budget setup. The lesser of the tolerance amount and percentage of total budget is allowed.

    Label

    Tolerance Allowed

    Properties

    • searchable
    • sortable
  • toleranceAmount (big-decimal)

    The tolerance amount by which the budgetary control transaction can exceed budget.

    Label

    Tolerance Amount

    Properties

    • searchable
    • sortable
  • tolerancePercent (big-decimal)

    The tolerance percentage of budget by which the budgetary control transaction can exceed budget.

    Label

    Tolerance Percentage

    Properties

    • searchable
    • sortable
  • totalBudgetAmount (big-decimal)

    The total budget balance amount. It includes the initial and budget adjustment amounts.

    Label

    Total Budget

    Properties

    • searchable
    • sortable
  • transactionAmount (big-decimal)

    The entered transaction amount, burdened amount, or liquidation amount in the transaction currency.

    Label

    Transaction Amount

    Properties

    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • activityType (StandardLookupCode)

    The type of control budget impact activity, such as liquidation, reservation, and so on.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • balanceSubtype (StandardLookupCode)

    The budgetary control balance subtype that further divides the balance type, such as payables expenditures balance subtype within the expenditures balance type.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • balanceType (StandardLookupCode)

    The balance type of a budgetary control balance, such as commitments, obligations, expenditures, and so on.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • budgetAccount (ControlBudgetAccount)

    A budget account is a combination of budget segment values for a budgeting flexfield structure. It's used to record budget and consumption balances for a control budget of a given structure, which can be based on applicable accounting segments or project attributes. Separate budgeting flexfield structures can have a different number of budget segments to control budget and consumption balances.

    Business Object

    ControlBudgetAccount

    Expand all

    Collapse all

    Fields

    • budgetChartOfAccountsId (string)

      The identifier of the key flexfield structure for the budget chart of accounts.

      Label

      Budget Chart of Accounts ID

      Properties

      • inherited
      • searchable
      • sortable
    • budgetCodeCombinationId (int64)

      The unique identifier of the budget account.

      Label

      Budget Account Code Combination ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • budgetCurrency (Currency)

    The currency of the control budget.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • controlBudget (ControlBudget)

    A control budget contains structural information, such as the budget chart of accounts and budget calendar, and budgetary control validation options, such as whether a transaction with insufficient funds should be stopped or allowed to continue with or without warning and how much tolerance can be factored into the validation. Separate control budgets are used to record budget and consumption balances that are structured by different budget chart of accounts, budget calendar, or period range.

    Business Object

    ControlBudget

    Expand all

    Collapse all

    Fields

    • controlBudgetId (int64)

      The unique identifier of the control budget.

      Label

      Control Budget ID

      Properties

      • searchable
      • sortable
      • not nullable

  • controlBudgetResultDetail (StandardLookupCode)

    The budgetary control validation result detail for the control budget within a validation request, such as passed budgetary control validation, insufficient funds, and so on.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • controlLevel (StandardLookupCode)

    Indicates the degree of enforcement in controlling consumption against budget such as absolute, advisory, track, and none. Track indicates that no enforcement is in place to control the consumption. None indicates that no enforcement is in place and no recording of the consumption.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • generalLedgerAccount (GeneralLedgerAccount)

    A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • projectCostType (ProjectCostType)

    A cost type is a classification of project cost used in planning, budgeting, forecasting, and reporting. It's a primary driver for cost processing, such as calculating raw and burden costs, controlling which charges are allowed for a project, capturing retirement costs in a capital project, and tracking miscellaneous costs like asset depreciation, allocations, and interest charges.

    Business Object

    ProjectCostType

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the cost type.

      Label

      Cost Type ID

      Properties

      • searchable
      • sortable
      • not nullable

  • projectResource (ProjectPlanningResourceBreakdownStructureResource)

    A resource represents the labor or nonlabor assignment on a project to complete the specified work within a defined period. It's composed of one or more resource elements, depending on the levels of the associated resource format, and primarily used in planning, budgeting, and forecasting.

    Business Object

    ProjectPlanningResourceBreakdownStructureResource

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the resource breakdown structure.

      Label

      Resource Breakdown Structure ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top