The input param will be the "function name" and the output should be "all the responsibilities that use that function" irrespective of whether the function in under the menu or the sub-menu of that responsibility.

Mozen

• May 25th, 2018

The compiled_menu_functions table also takes into account submenus.. the table contains the result of the loop you have used in your query. I cant seem to find the correct query that takes into account exclusions

Paras

• Feb 27th, 2018

Fouzias answer is correct if you add following where clause in last two inner queries

and frf.responsibility_id = r.responsibility_id

Answer Question  Select Best Answer

when i am running my report in apps i have to pass two parameters second parameter should be depend on first parameter. and in first parameter it consist two list of valuesex:1. approve 2. in process when i pass approve in first parameter then second parameter should be enable and when i pass in process second parameter should be disabled. How this can be possible . i would appreciate if u people suggest...

Manivasagam

• Jul 9th, 2014

:$FLEX$.Value_ Set_Name

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

In this senario we unable to disable the parameter for that what you can do like this     In the 2nd parameter value set you have to hardcore in the where caluse like   &...

Answer Question  Select Best Answer

What are the manadatory user exits in Oracle Apps Reports?

Naresh Bandla

• Jun 24th, 2015

There are no mandatory User Exits , If business is asking for User Exits then we need to use
SRWINIT and SRWEXIT.

CHALAM

• Jan 29th, 2013

Srwinit and srwexit

Answer Question  Select Best Answer

What are RFQ tables? What is the relation between RFQ and Requisition, RFQ and Quotation?

kishore05101984

 Profile Answers by kishore05101984 Questions by kishore05101984

• Dec 23rd, 2010

Po_headers_all, po_lines_all

Srinu_d83

 Profile Answers by Srinu_d83 Questions by Srinu_d83

• Aug 27th, 2009

Flow of PO module:Requisition  |RFQ  |Quotation  |Purchase orderRequisitionIt is prepared by emp wheneve emp needs the goodsIn this we have 2 typesInternal: within orgExternal: from out...

Answer Question  Select Best Answer

Suppose if there are 100 rows and you need to retrieve one particular row without using where clause?

Manivasagam

• Jul 9th, 2014

Code
 

ptmich

 Profile Answers by ptmich Questions by ptmich

• May 28th, 2012

Select rownum=1 from table;

Answer Question  Select Best Answer

audiresri

 Profile Answers by audiresri Questions by audiresri

• Feb 25th, 2009

We can attach only one table.

Pradeep_R

 Profile Answers by Pradeep_R Questions by Pradeep_R

• Apr 5th, 2008

To define validation table information:1. Enter the name of the application with which your validation table is registered. Application name and table name uniquely identify your table. If you plan to...

Answer Question  Select Best Answer

Krishna

• Oct 21st, 2011

There are total 6 Types of Journals 1. Functional Journals, Where functional currency will be used. 2.Foreign Currency journals, where Foreign currency will be used. 3.Reversal Journals, this will be...

Pallavi

• Jul 21st, 2007

Seketon, formula and Standard JE are types of Recurring JE. The JE types are only five:1. Basic JE2. Importing from other subledgers3. Recurring4.Reversal5. Mass Allocation

Answer Question  Select Best Answer

sridevikoduru

 Profile Answers by sridevikoduru Questions by sridevikoduru

• Mar 14th, 2014

I am Sridevi Koduru, Oracle Apps Techno Functional Faculty with 5+ Years Training Experience on Oracle Apps Technical, Oracle Apps Functional, SQL, PL/SQL and D2K including 3+ Years of Real Time Exper...

bala koti reddy

• Feb 21st, 2013

In R12

begin
mo_global.set_policy_context(s,orgid);
end;

Answer Question  Select Best Answer

RAMESH BABU.R

• Apr 24th, 2013

What are the currencies will be used by the revaluation?

Sandeep Pareek

• Sep 4th, 2012

Revaluation is used if, and only if, you have foreign currency transactions (i.e.Conversion of foreign currency transactions).

Revaluation uses the Period Rates Table. The Revaluation Rate is simply 1/Period End Rate.

Answer Question  Select Best Answer

varun kumar

• Jun 19th, 2015

1) Org-ID comes under Operating UNIT level,
Organization_id comes under Inventory Level.
2) Base table for Org_id is hr_operating_units,
Base table for Organization_id is Mtl_perameters.
3) Org_id involves in PO,OM,AP,AR....,
Organization_id involves in INV, BOM, WIP..

sivareddy

• Mar 15th, 2015

Org_id contains the -all ex:-po_headers_all and organization doesnt contains -all :--mtl_system_items_b

Answer Question  Select Best Answer

Dinesh

• Feb 27th, 2015

PRE-LOGON

anil

• Sep 10th, 2014

Pre trigger

Answer Question  Select Best Answer

Kiran praveen kumar Thota

• Nov 1st, 2018

Not sale_order ,its sales_order

leela

• Aug 11th, 2017

Xla_ae_lines(gl_sl_link_table,gl_sl_link_id)=gl_import_references(gl_sl_link_table,gl_sl_link_id)
gl_je_lines(gl_je_header_id)=gl_import_references(gl_je_header_id)

Answer Question  Select Best Answer

How to restrict the item in INV?

GANESH RONGALI

• Jul 16th, 2012

Dropshipment

teja

• Feb 23rd, 2012

Uncheck purchasing

Answer Question  Select Best Answer

Inventory

suraj Mishra

• Mar 16th, 2017

Sonia Your answer is wrong. Right answer is GL and CRM

subbupdk

 Profile Answers by subbupdk Questions by subbupdk

• Apr 14th, 2008

I agree with Mohanty

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

Token field is used to map the concurrent program parameter to report parameters .

Poorna Nannapaneni

• Jan 28th, 2015

Token is an Interface between Concurrent Program and Report builder. This will map the concurrent program parameter values to the report builder parameters.It is case sensitive.

And it is enabled for Oracle Reports only.

Answer Question  Select Best Answer

Gowthami

• Sep 19th, 2017

Invoice is a document process in AP & AR There are totally 13 types of invoices on AP:1.Prepayment 2.Credit memo 3.Debit memo 4.Standard 5.With holding tax 6.Po_default 7.Recurring 8.Expe...

Julia Boyd

• Jan 13th, 2017

An invoice is a document which shows the amount of goods purchased or about to be purchased and the due date for payment or delivery.

Answer Question  Select Best Answer

Oracle Application uses Flexfield to capture information about Your organization. Flexfield have flexible structure for storing key information. Like Company, Cost Center, and Account. They also give u highly adaptable Structure for storing customized information in oracle Applications.

shrikantgarud

 Profile Answers by shrikantgarud Questions by shrikantgarud

• Apr 25th, 2008

Simple way to descriptive flexfield are the flexible data fields designed and customised according to business needs. Types1. kff- key flexfeilds 2. dff- descriptive flex fieldsThe basic steps in de...

Dawson

• Apr 20th, 2007

KFF - DFFWrong. Please follow GL Module document. in OTN

Answer Question  Select Best Answer

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

In this FMB only all the Standard Libraries are available for APPS like Menu key.

paresh123

 Profile Answers by paresh123 Questions by paresh123

• Mar 7th, 2010

under $AU_TOP/resource/US

Answer Question  Select Best Answer

Goutham

• Aug 1st, 2017

Conversion is one time process which is done when system is upgraded to new version whereas Interface is routine process

sridevik

 Profile Answers by sridevik Questions by sridevik

• Jul 12th, 2016

Interface is a program which we run daily or periodically. where as conversion we run only one time to get the data from legacy system to oracle system.

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

User Exits are Which makes User to Exit on going environment to perform certain actions. There are Five types of User Exits ---------------------------------------------- 1. SRW.USER_EXIT(FND SRW...

chandu

• Jun 4th, 2015

These are not user exits
user exits are
FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXSQL
FND FLEXID VAL
these are profile values

Answer Question  Select Best Answer