Question { 9785 }

How many types of trigger can be used in a table at a time ?

Answer

u can define a trigger
1. For Each Row
2. For Each Statement

You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE

So it makes a total of 12.

Question { Oracle, 9186 }

What are the types of key Flexfield forms?

Answer

Key flexfields appear on three different types of
application form:
1. Combinations form
2. Foreign key form
3. Range form
These form types correspond to the types of tables that
contain key flexfield data.

"Combinations form"
A combinations form is a form whose only purpose is to
maintain key flexfield combinations. The base table of the
form is the actual combinations table. This table is the
entity table for the object (a part, or an item, an
accounting code, and so on). The table contains a unique ID
column (also called the code combination ID column) as the
primary key, as well as individual segment columns, a
structure ID column, and other flexfields-related columns.
The combinations form contains hidden fields for each
segment column in the table, as well as displayed fields for
the concatenated segment values (the combination) and any
other fields (and columns) that the entity
requires, such as a concatenated description field. A
combinations form is sometimes also called a maintenance form.

"Foreign key form"
A foreign key form is a form whose underlying base table
contains only one or two columns that contain key flexfield
information, and those columns are foreign key columns to
the combinations table (usually a foreign key to the CCID
column of the combinations table and sometimes a structure
ID column as well). The purpose of a foreign key form often
has very little to do with the key flexfield itself, and
that the key flexfield appears on the form is essentially
incidental. For example, if you have a key flexfield that
represents a part number, you would use the combinations
form to define new parts and maintain existing part numbers.
You would then have many foreign key forms that you use to
manipulate your parts. You might have a form where you take
orders for parts, another form where you receive parts, and
yet another form where you ship parts. The fact that your
part number happens to be a key flexfield is not important
to your taking orders for your parts, for example.

"Range form"
A range form displays a range flexfield, which is a special
pop-up window that contains two complete sets of key
flexfield segments. A range flexfield supports low and high
values for each key segment rather than just single values.
Ordinarily, a key flexfield range appears on your form as
two adjacent flexfields, where the leftmost flexfield
contains the low values for a range, and the rightmost
flexfield contains the high values. A user would specify a
range of low and high values in this pop-up window. For
example, you might choose a range of part numbers for which
you want to run a report.

The range form uses a special table as its base table. This
table contains one or more (usually two) columns for each
segment column that appears in the combinations table.
However, these columns do not necessarily contain actual
segment values, and a row in the table does not necessarily
contain actual valid combinations. Usually this table
contains two columns for each segment, called SEGMENTn_LOW
and SEGMENTn_HIGH (where n is the segment column number),
that store the range of values for each segment.

Note:- For more information refere to "Flexfields Guide
Pages 2 - 5"

Question { 7794 }

what is mean by confine mode and flexi mode?

Answer

Confine Mode = When confine mode is on, an object cannot be
moved outside its parent in the layout.

Flex Mode = When flex mode is on, reports automatically
resizes the parent when the child is resized.

Question { 7324 }

what is the use of format trigger?a

Answer

Format triggers are PL/SQL functions executed before the
object is formatted. These triggers are used to dynamically
change the formatting attributes and used to conditionally
print and not to print a report column value. These triggers
return Boolean values TRUE or FALSE. If the return value of
the format trigger is FALSE, the value is not displayed.

Question { 5251 }

what is meant by boilerplates?

Answer

Boilerplate consists of text (label of the column) and
graphics that appear in a report each time it is run.

Question { Oracle, 6105 }

Where we r defining the payment limits.
ex:As per my business requirement business have a payment
limit is 10000.Where we defined this type of limits.

Answer

Payables > Setup > Payment > Banks

Query for the Bank and then go to Bank Accounts. Then go to
Payables Options Tab. Here you will see the following
options:

Minimum Payment
Maximum Payment

You can define the maximum and minimum amount here.

Question { Oracle, 21223 }

where should liability account define in account payable

what are the steps for payment process

Answer

Payables > Setup > Options > Financials
You can define the Liability Account here.

Question { Oracle, 21223 }

where should liability account define in account payable

what are the steps for payment process

Answer

Payment Process
1. Select Invoices
2. Build Payment
3. Format Payment
4. Confirm Payment

These are the four steps in Payment Processing

Question { 7460 }

what is the difference between General Calendar and
Inventory Calendar?

Answer

GL calendar is the your financial calendar as part of the
3Cs in 11i.

Inventory Calendar is also called as the Workday Calendar.
It is also known as the Manufacturing calendar. In a workday
calendar you specify which days are worked within your
organization and which shifts are available to be worked.
When you are defining an inventory organization, you need to
assign the work day calendar / inventory calendar.

Question { Genpact, 8966 }

I want to develop a oracle applications report using report
builder 6i. I have two user parameters. How to provide list
of values to parameters, which should show me at the time
of submitting concurrent program.

Answer

1. Create two new value sets for the paramters that are to
be used.
2. Query the concurrent program definition.
3. Go into Parameters window
4. Attach the value set to each of the parameters that are
being used.

Thats it. And you can see the LOV when you submit the
report. Hope this helps.

Raj

Question { Infosys, 11638 }

any one can expalin report registration steps?

Answer

All the above answers are correct. Wanted to add one more
step in this. Before moving the rdf to the server, you
should compile the rdf by connecting to the database.

Thanks,
ARS