FLEX FIELDS?
Answers were Sorted based on User's Feedback
As the name says, it is a flexible field with multiple
segments. There are two types of flex fields in oracle
apps. 1. Key flex field and 2. Descriptive flexi field.
Key flex fields are mandatory fields whereas descriptive
flex fields are not mandatory and used to store some values
for reporting purpose.
Key Flexi field Example - Accounting flexi field, Location
flexi field.
Accounting flexi field contains 30 segments with 25 char
each.
Some accounting flex field value examples are
1. Account code(seg1)-Costcenter(seg2)-product code
2. Account code(seg1)-department(seg2)
Refer to Oracle documentation-GL manual/AR Manual for more
details
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / suresh.somayajula
It is nothing but group of segments which are more
flexible than normal fields.
| Is This Answer Correct ? | 2 Yes | 1 No |
Sys Admin Module?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
in one report using two layout models.if yes how to do
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
can we execute one concurrent program through another concurrent program?
where u do setup of operating unit?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
what are the balancing segments in AR?
what is unit of measure classes? give atleast two examples. name the underlying table.
Can We Create a Synonym On Trigger?
Tell me where we find the status of order information?
tell my any difficult situtation you solved in your experience in your company?