SSIS Components for Oracle Fusion Cloud Financials

Build 25.0.9539

FedBETCAdjustmentsLOV

Displays the list of values (LOV) for federal adjustment business event type codes (BETC).

Table-Specific Information

Select

The component uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The component processes other filters within the component.

For example, the following query is processed server-side:

SELECT * FROM Financials.FedBETCAdjustmentsLOV WHERE Finder='adjustmentBETCFinder' AND BusinessEventTypeName = 'Test';

Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.

The FedBETCAdjustmentsLOV view supports the 'adjustmentBETCFinder' finder. The fields which can be used along with it are

  • BusinessEventTypeCode
  • BusinessEventTypeName

Columns

Name Type Description
BusinessEventTypeCode String The code that identifies the business event type.
BusinessEventTypeName String The name of the business event type.
BusinessEventTypeId [KEY] Long The unique identifier of the business event type.
Enabled String Specifies whether the business event type is enabled.
PaymentOrCollection String Specifies whether the event is a payment or a collection.
FundingDerivationType String The type of funding derivation associated with the adjustment BETC LOV. The valid values include: Derived from General Fund and Not Derived from General Fund.
Finder String The finder criteria used to filter federal adjustment BETC LOV based on specific search parameters and conditions.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539