Oracle fusion related value sets

have hit the mark. something also..

Oracle fusion related value sets

This post gives you a very simple introduction to Flexfields, to set the stage for our additional posts on creating related customizations. If you have an E-Business Suite background most of this will be familiar territory.

1st phorm retail locations

In general terms Flexfields offer you the opportunity to declaratively add custom fields to your application. These might be simple text entry fields or more complex fields with list of values with content dependent on the user or current transaction. They are a mature technology, existing in E-Business Suite for many years where they proved very successful, and as such the same capability has have been included - and extended - in Fusion Applications.

In this article series we'll not focus on Key Flexfields as they are generally related to functional setup, whereas customization work centers around the use of DFF's and EFF's. Whilst the following is not a full glossary of terms related to flexfields, it provides the bare minimum you'd need to understand before looking at our additional articles. Once implemented via the Setup and Maintenance task "Manage Flexfields" they can be enabled for display on the UI associated with the related business object or transaction data found under the Administration menu item Highlight Flexfields.

As with other fields their exact positioning on the page is not customizable. Oracle Sales Cloud does not use flexfields, but instead uses Application Composer to extend the data model in much the same way, adding new custom fields to business objects.

Flexfield data values are stored as s egments and each flexfield can be made up of one or more concatenated segments. For number, date, and timestamp data types the column names include the data type also.

The amount of ATTRIBUTE columns in the application tables is fixed and it obviously governs how much flexfield data segments can can use for that particular business object, however this limit is rarely reached. The following is our intended content based on what we see on our forum and blog comments, however if there is something more you'd like to see please let us know.

Flexfields Series: A Basic Introduction

Whilst our additional posts will expand on this simplified explanation, if you need alternative descriptions see the following recommended documents:. We've seen creative solutions to tricky business requirements addressed through the use of Business Intelligence tools. For example new You may have spotted a 'Deep Links' menu item under the Administration section of the Navigator menu. This opens the page below, showing a Customizations are rarely standalone features which operate in isolation to the rest of the application, they usually need to include Fusion Applications Developer Relations.

It's All About the Platform. May 15, Richard Bingham Senior Development Manager. Introduction This post gives you a very simple introduction to Flexfields, to set the stage for our additional posts on creating related customizations.

Types There are three types of flexfields that exist in Fusion Applications: Key Flexfields KFF - used for standardized data that has a fixed structure. Each elemental value known as a segment is meaningful and are combined into a usable group. For example Accounting Codes are key flexfields where each part represents a meaningful value, such as the code which might equate to DepartmentCost CenterAccount 56, and Purchase Type Descriptive Flexfields DFF - represent the basic option for adding custom fields to a business object or transaction.

Descriptive flexfields can have one or more segments and support the option to add specified contexts against which they offer users a set of input values. Extensible Flexfields EFF - are similar to DFF's however are stored in their own tables allowing unlimited numbers of segments, the support for groups of multiple records per parent record, and additional context configuration options.

These were new for Fusion Applications. Key Concepts Whilst the following is not a full glossary of terms related to flexfields, it provides the bare minimum you'd need to understand before looking at our additional articles.

Segments - Each flexfield implemented is defined by one or more segments which hold the data values assigned.This article looks at basic Dynamic Flexfield DFF setups, illustrating the components involved for those new to flexfields and also helping highlight variations to the E-Business Suite flexfield implementation. Additional articles will cover more specific requirement use-cases and features.

For more details review the other posts in this series or use the references at the bottom of the page. This article primarily focuses on the Oracle Cloud deployment where full access to related administration and configuration screens is available.

If you have an on-premises deployment then you can also review the Fusion Applications Developers Guide - Part IV Developing With Flexfieldswhere you can learn about adding entirely new flexfields to your environment. There are two entry points for your configuration of dynamic flexfields.


The first is online inside Fusion Applications pages. Select the menu associated with your login name top right of all pagesunder the Administration group you will find the Highlight Flexfields option. From here you can access some quick-create type screens as well as the detailed management screens.

The second option is to use the same flexfield management screens directly, as accesible under the Navigator menu, under Setup and Maintenance.

From here select the items in the Manage Flexfields task list. The obvious benefit of using the first option is that you're already in the page where the flexfield will be displayed, and as such you can make sure what you setup looks and works correctly. Generally speaking flexfields operate outside sandboxes as they are part of the base product and not related to MDS, however if you are also setting other page component properties around the flexfields then you might find your customization session needs to be in a sandbox.

It is recommended to either publish or exit the sandbox once you've finished configuring and deployed your DFF's, as this is the only way to see the completed flexfield-related parts of the page. Each field of data for a flexfield is stored in a segment, and there are two main DFF segment types.

The first, a global segmentis the most simple and after basic definition the entered value gets stored in the associated transaction table.

Kogama mansion

These simple data-capture fields can be text, numbers, dates, or predefined static lists of values. The reference to "global" purely signifies that there is no configured conditional logic or contextual data associated with their use, they work the same way for all system users.

For Fusio Application creating global segments can be done without visiting the flexfield management screens, through a single pop-up window that allows you to define the basic attributes of the segment data type, name, id, size limit etcand of course how it will look as a field on the page. Not every business case can be satisfied by global segments, and they require may things like sets of reusable values and conditional logic which determines what values the user can choose.

Let's look at how the introduction of this logic is done. The field that controls what values are displayed is known as the Contextand this is entirely configurable. Once you've created the values in your context then you can create segments that are related to each value. For example ContextA has values 1,2 and 3 and ContextB has values 9, 8 and 7. As such when the user chooses the context displayed as a field on the UI then the appropriate set of values is displayed as a second field.

Note that there is no support for writing scripts or code to control the condition here, it is simple a matter of configuring your data appropriately. If you wanted to set field properties based on the fields on the page - you'd more likely use Page Composer and Expression Language. The data for each of these flexfield segments is stored in the database just like that for global segments, stored along with the transaction record in the same table.

The embedded video below demonstrates a flexfield with a simple context that controls two segments. The following is a selection of facts and recommendations that we considered potentially useful for those new to using dynamic flexfields in Fusion Applications. We will be looking to compile similar lists as we explore flexfields further and will publish these as a Frequently Asked Questions document.

In the meantime please review this short list of tips and tricks:. The following may be useful references, in addition to the Online Help and the related Oracle Documentation mentioned in the original Getting Started article. We've seen creative solutions to tricky business requirements addressed through the use of Business Intelligence tools.

For example newCreating Accounting Method: Explained. Creating Account Rules: Points to Consider. Creating Description Rules: Explained. Creating Supporting References: Explained. Define Subledger Application and Sources.

Accounting methods group subledger journal entry rule sets together to define a consistent accounting treatment for each of the accounting event classes and accounting event types for all subledger applications. The grouping allows a set of subledger journal entry rule sets to be assigned collectively to a ledger.

Alcatel linkzone factory reset

By assigning a different subledger accounting method to each related ledger, you can create multiple accounting representations of transactions. Accounting rules can be defined with either a top down, or a bottom up approach. When defining subledger accounting rules from the top down, you will initially define the accounting method followed by components of each rule, which will need to be assigned to it.

When defining subledger accounting rules from the bottom up, you will initially define components for each rule and then assign them as required. The Create Accounting program uses the accounting method definition with active journal entry rule set assignments to create subledger journal entries.

When an accounting method is initially defined, or after modifying a component of any accounting rule associated to the assigned journal entry rule set, its status changes to Incomplete. The accounting method must be completed, by activating its journal entry rule set assignments, so that it can be used to create accounting.

The following definitions are utilized to define the journal entries, and are applied as updates to the accounting method:. You may update a predefined accounting method by end dating the existing assignment and creating a new assignment with an effective start date.

You create the assignment of a journal entry rule set for an accounting event class and accounting event type using the accounting method page. If the accounting method has an assigned chart of accounts, you can select journal entry rule sets that use that same chart of accounts, or that are not associated with any chart of accounts.

oracle fusion related value sets

If the accounting method has an assigned chart of accounts, it may only be used by ledgers that use the same chart of accounts. If the accounting method does not have an assigned chart of accounts, the accounting method can be assigned to any ledger. You can activate the subledger journal entry rule set assignments from the Accounting Method page.

The figure below shows the relationship of components making up an accounting method as described in the above text. Subledger journal entry rule sets provide the definition for generating a complete journal entry for an accounting event. Select the option to define the subledger journal entry rule set for a particular accounting event class or accounting event type. If you are using multiple ledgers to meet divergent and mutually exclusive accounting requirements, you can vary journal entry rule sets by ledger.

Each of the subledger journal entry rule sets can meet a specific type of accounting requirements. These two sets of definitions have differences based on the setup of the various components that make up their subledger journal entry rule sets.

Seeded subledger journal entry rule sets are provided for all Oracle subledgers. If specific requirements are not met by seeded subledger journal entry rule sets, users can create new ones of copy the seeded definitions and then rename and modify the new copied definitions and their assignments. Subledger journal entry rule set assignments can be made at two levels, header and line. The following are the subcomponents of a subledger journal entry rule set:. Header assignments define subledger journal header information and line assignments define journal line accounting treatment.

You can define multiple subledger journal entry rule sets for an accounting event class or accounting event type. A single journal entry is generated per accounting event per ledger using the line assignments from the journal entry rule set assigned to the accounting event class or accounting event type.Register and Participate in Oracle's online communities.

Essential oil recipe to attract men

Learn from thousand of experts, get answers to your questions and share knowledge with peers. Can any one please tell me the table name which is used in fusion app to store the value set name which we create. Thanks i need to check it, but when i searched on the table name on google i am not getting any info about it. Also one more thing there is a etrm.

Kindly help. In Fusion the details can be found in OERsearch with type "table". Fusion Applications Developer Relations. You are right, I forgot that the FND tables are not included. I remember this issue being raised before, but I do not remember what the conclusion was I'll need to ask around. In any case let me get back to you on what the plan is. Did you try querying from DB from the table I mentioned above i.

Similarly other flex table name also changed. There is a data issue where content prior of R8 was in correctly categorized such that its not available under "technology" product family and my query failed since used combination of both criteria. In any case just use "All versions" for the version criteria and the data will be returned.

They are internally working to fix the product family for previous releases. Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Welcome to Oracle Communities. Please enter a title. You can not post a blank message. Please type your message and try again. This discussion is archived. I have the same question Show 0 Likes 0. This content has been marked as final.

Show 8 replies. Regards, Pawan. Thanks Jani for OER. But i am still not able to find that table. Eagerly waiting for a response. Warm Regards, Ajay. Go to original post.Oracle Application Object Library uses values, value sets and validation tables as important components of key flexfields, descriptive flexfields, and Standard Request Submission.

This section helps you understand, use and change values, value sets, and validation tables. When you first define your flexfields, you choose how many segments you want to use and what order you want them to appear. You also choose how you want to validate each of your segments. The decisions you make affect how you define your value sets and your values.

You define your value sets first, either before or while you define your flexfield segment structures.

Browser apk

You typically define your individual values only after your flexfield has been completely defined and frozen and compiled. Depending on what type of value set you use, you may not need to predefine individual values at all before you can use your flexfield.

You can share value sets among segments in different flexfields, segments in different structures of the same flexfield, and even segments within the same flexfield structure.

Join the world’s largest interactive community dedicated to Oracle technologies.

You can share value sets across key and descriptive flexfields. You can also use value sets for report parameters for your reports that use the Standard Request Submission feature. Because the conditions you specify for your value sets determine what values you can use with them, you should plan both your values and your value sets at the same time.

For example, if your values are 01, 02 instead of 1, 2, you would define the value set with Right-Justify Zero-fill set to Yes. Remember that different flexfields may have different requirements and restrictions on the values you can use, so you should read information for your specific flexfield as part of your value planning process. For example, the Accounting Flexfield requires that you use certain types of value sets.

Choose a format for your values. See: Choosing Value Formats. Decide whether your segment should have a list of values. Choose an appropriate validation type for your segment.

Oracle Fusion? No Confusion - Oracle Fusion Applications' Overview

Consider using values that group neatly into ranges so that using range-based features value security, value hierarchies, and so on will be easier.

Plan any value hierarchies, cross-validation rules, value security rules, and so on as appropriate. Since a value set is primarily a "container" for your values, you define your value set such that it can control the types of values that are allowed into the value set whether predefined or non-validated.

You can specify the format of your values:. Warning: Date and DateTime will be obsolete in a future release and are provided for backward compatibility only. You can also specify the maximum length your values can be, as well as a minimum and maximum value that can be used with your value set. Choosing the maximum size for your value set depends on what flexfield you plan to use with your value set.

Your value set size must be less than or equal to the size of the underlying segment column in the flexfield table.

Oracle E-Business Suite does not allow you to assign a value set whose values would not fit in the flexfield table. You want to specify a maximum size for your values that fits the way your organization works. Generally, if you use values with descriptions, your values tend to be short and have longer descriptions.In this example, you're creating an "AutoPost criteria set" to post the general ledger journal entries created by journal import for your subledger transactions.

You use a non-Oracle subledger called Fast Assets for fixed asset tracking and depreciation. You plan to automate posting of general ledger journal batches created by journal import.

The automation is to protect the subledger-sourced journal entries from edits or deletion that could cause an out-of-balance situation between the subledgers and general ledger.

14 Define Subledger Accounting Rules

Use the All option for category and accounting period to reduce maintenance and ensure that all journal imports are included in the posting process. Create a criteria set that includes all your subledger sources. Create multiple criteria sets by source only if you must schedule different posting times to balance close activities or reduce processing time. Here's the relevant setup for your Vision Corporation ledger.

Consider these points when creating a criteria set: Use the All option for category and accounting period to reduce maintenance and ensure that all journal imports are included in the posting process. Tip: Schedule the process to run immediately after the Import Journals process to prevent changes to the journals.

Run the process during nonpeak times to save resources.Product Management Features by License: Overview. Managing Default Item Class: Explained. Managing Cross-Reference Types: Explained. Managing Related Item Subtypes: Explained. Managing Descriptive Flexfields for Items: Explained. What's the difference between lifecycle phase types and lifecycle phases.

oracle fusion related value sets

Assigning Items to Categories: Explained. Value sets are specific to the application in which they will be used.

In the Oracle Product Information Management application, value sets are used primarily for defining attributes where the values that an attribute can have is limited to a specific set of values.

Value sets can be edited or new value sets can be created from the Manage Product Value Sets page. The Edit icon launches the Edit Value Sets page, which redraws in the same region of the local area.

The Create icon launches the Create Value Sets page, which redraws in the same region of the local area. A value set is defined by the value set code and is specific to the module of an application in which the value set is to be used, such as Item Class. The validation type determines how the value of field is validated for the assigned value set. The following are the seeded values:. The value data type determines the data type for the value set.

oracle fusion related value sets

A child value set is used to define variants for stock-keeping units or SKUs. A SKU contains the common properties for an item. For example, a shirt can be produced with colors; white, red, yellow, and blue. The variant is used to represent the colors of the shirt. Create a value set with validation type of Subset and enter the first value set you created for the independent value set, for example: Summer Colors.

Click Manage Values and then click the Add icon. The dialog will show a list of values based on the value set named Summer colors. Select two of them. The Manage Default Item Class task enables Product Model customers to manage item class templates, descriptive flexfields, attachment categories and lifecycle phases.


thoughts on “Oracle fusion related value sets

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top