Value Sets and its Types

 Value Set is nothing but the list of values with validation. We can use the value set whenever the concurrent program has parameters and while defining the flex field. We have to attach the value set to the concurrent program. When attaching or enforcing the value set on the segment, the segment will behave or act according to the Value Set. There are following eight types of value sets - 

1.None(Not validated at all) - You use the none type value set when you want to allow the users to enter the any value so long as that value meets the value set formatting rules.

2. Independent - An independent value set provides a predefined list of values for the segment. These value can have an associated description.

3. Dependent - A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of the given value depend on which independent value was selected in a prior segment of the flexfield structure.

4.Table - A table–validated value set provides a predefined list of values like an independent set, but its values are stored in an application table. You define which table you want to use, along with a WHERE cause to limit the values you want to use for your set.

5.Special & 6. Pair - Special and pair value sets provide a mechanism to allow a "flexfield-within-a-flexfield". These value sets are primarily used for Standard Request Submission parameters. You do not generally use these value sets for normal flexfield segments.Special and Pair value sets use special validation routines you define. For example, you can define validation routines to provide another flexfield as a value set for a single segment or to provide a range flexfield as a value set for a pair of segments.

7. Translatable Independent - A Translatable Independent value set is similar to Independent value set in that it provides a predefined list of values for a segment. However, a translated value can be used.

8. Translatable Dependent - A Translatable Dependent value set is similar to Dependent value set in that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure.




Comments

Post a Comment

Popular posts from this blog

Accounting entries of P2P cycle in Oracle R12

 The Procure-to-Pay (P2P) cycle in Oracle R12 involves various transactions that generate accounting entries as goods and services are purchased, received, and paid for. Below is a detailed breakdown of the typical accounting entries generated during each step of the P2P cycle: 1. Purchase Order Creation When a Purchase Order (PO) is created, there are no accounting entries recorded immediately. The creation of a PO is a commitment to purchase and does not impact the financials until the goods or services are received. 2. Receipt of Goods or Services (Receiving Transaction) When goods or services are received, accounting entries are generated to reflect the receipt in inventory or as an expense. The entries depend on whether the receipt is for inventory or direct charge (expense) items. a. Inventory Receipt (Accrual-Based) Dr. Inventory Material (Asset) Reflects the increase in inventory. Cr. Accrual (Receiving Inventory or Purchase Price Variance Account) Represents the liability...
Read more

Multi Org in Oracle ERP R12

Image
Multi-Org means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. There are Hierarchy Flow of Multi-Org -  1. Business Group - This is highest level in the Organization Structure. The Business group secures HR     Information. Multiple set of books can share same business group.  2. Legal Entity - It is a legal Business purpose, At this Level we prepared income tax reports.  3. Ledger - It is use to secure Journal and Ledger Balances of a company. A Ledger is a collection of   Currency, chart of account, calendar and accounting Methods.  4. Operating Unit - It is a strategic business unit, At this level we partition and secure sales and purchase   transaction data.  5. Inventory Organization - An Organization for which you track Inventory transactions and balances   and/or an Organization that manufactures or distributes products. ...
Read more

Accounting entries of O2C cycle in Oracle R12

 The Order-to-Cash (O2C) cycle in Oracle R12 involves various transactions that generate accounting entries as goods or services are sold, shipped, invoiced, and payment is collected. Below is a detailed breakdown of the typical accounting entries generated during each step of the O2C cycle: 1. Sales Order Creation When a Sales Order (SO) is created, no accounting entries are generated. The order creation is a commitment from the customer and does not affect the financials until the goods or services are delivered or invoiced. 2. Shipping of Goods (Shipping Transaction) When goods are shipped to the customer, accounting entries are generated to reflect the reduction in inventory and the recognition of the Cost of Goods Sold (COGS). Dr. Cost of Goods Sold (COGS) Reflects the cost of the goods that are shipped to the customer. Cr. Inventory (Asset) Reduces the inventory account to reflect the goods leaving the inventory. 3. Invoicing the Customer (Invoice Creation) When an invoice is...
Read more