Value Sets: Related Tables and Query to Fetch the Details

Value Sets are used in Oracle to define a limited sets of values for a particular field. There are 3 main tables in Oracle Fusion to fetch the values assigned to a value set. Here is a brief description of them:

1. FND_VS_VALUE_SETS: Table to hold the value set information ( Header level data).

2. FND_VS_VALUES_B: Table to hold the values of the value set.

3. FND_VS_VALUES_TL: Table to hold the description of the values.

Now let’s cut to the chase and see the query. Pretty simple it is:

select 

vsval.VALUE_ID,

vsval.VALUE_SET_ID,

vsval.VALUE,

vsval.description,

vt.description,

vsval.flex_value_attribute3,

vsval.CREATION_DATE,

vsval.CREATED_BY,

vsval.LAST_UPDATE_DATE,

vsval.LAST_UPDATED_BY

from  

fnd_vs_value_sets vset,

fnd_vs_values_vl vsval,

FND_VS_VALUES_TL vt

where 

1=1

and vset.value_set_id = vsval.value_set_id

and vsval.CREATION_DATE >= (:pcreationdate) and  vsval.CREATION_DATE <= (:pEnddate) 

and vset.VALUE_SET_CODE = 'Project CCC COA'

AND vt.value_id = vsval.value_id

and vt.language = 'AR'

order by vsval.value

Oracle Fusion Financials

 Oracle Fusion Financials is a complete and integrated suite. It offers all of the core functions in a complete finance system, such as a general ledger to process journals and allocations, accounts payable to process and pay supplier invoices, accounts receivables to invoice customers and receive payments, and so on. It includes a broad suite of applications that are completely integrated. It has your traditional GL, Payables, Receivables, Assets, Expenses, Collections and Cash Management as well as the common module architecture from EBS that includes the centralized Subledger Accounting, centralized customer and supplier data (TCA :Trading Community Architecture), Tax, Payments, and Intercompany.

General Ledger:

This topic includes details about the Oracle Fusion General Ledger reports predefined using Oracle Transactional Business Intelligence (BI).The Oracle Business Intelligence reports for the General Ledger include: Account Analysis Report,General Journals Report & Trial Balance Report

Account Payables:

Oracle Fusion Payables provides predefined reports that cover the following areas:

Invoices

Payments

Payables to Ledger Reconciliation

Period Close

Prepayments

Income Tax and Withholding

Cash Management:

Oracle Fusion Cash Management provides predefined reports that are used in the following areas:

Bank Statements

Cash Transit

Reconciling to the General Ledger

Account Receivables:

Oracle Fusion Receivables provides predefined reports to help you analyze and manage your accounts receivable information.

The Receivables predefined reports cover the following areas:

Bill Presentment Templates

Accounting Reports

Billing Reports

Receivables Balances Reports

Bills Receivable Reports

Reconciliation Program and Report

Fixed Assets:

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions.

The following tables list the predefined reports by type.

Additions by Source Report

Asset Additions Report

Asset Transfers Report

Cost Adjustment Report etc

Tax:

Oracle Fusion Tax provides operational, business, and reconciliation reports for tax activity associated with buying and selling goods and services through Oracle Fusion Payables and Oracle Fusion Receivables. Manual and imported tax transaction details also provide the source for the predefined tax reports.Oracle Fusion Tax reporting also provides reporting data models on which you can prepare custom and specialized tax reports.