dasari.vg

 Profile Answers by dasari.vg Questions by dasari.vg

• May 20th, 2008

PO- Import Standard purchase OrdersGL- Journal ImportAP- Pyables invoice Import

trraka

 Profile Answers by trraka Questions by trraka

• Jan 23rd, 2008

This is for PO Requisition Import. The program for PO is 'Purchase Order Import'  

Answer Question  Select Best Answer

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

Hi! Any one can you send me the details and process of item conversion?1.What are the interface tables in item conversion?2.What are the base tables in item conversion?3.what are the validations and what is the standard program in item conv.?

sree

• Oct 1st, 2011

Oracle Apps process of item conversion and interface tables. Interface tables involved in Item Conversion: MTL_SYSTEM_ITEMS_INTERFACE Base Tables: MTL_SYSTEM_ITEMS MTL_PARAMETERS MTL_UNITS_O...

Madhu

• Jul 21st, 2011

BASE TABLE: MTL_SYTEM_ITEMS_B INTERFACE TABLE: MTL_SYSTEM_ITEMS_INTERFACE ERROR_TABLE :MTL_INTERFACE_ERRORS VALIDATIONS: ORGANIZATION IS VALID OR NOT MA...

Answer Question  Select Best Answer

Prateek

• May 30th, 2014

FND_PROGRAM.SUBMIT_REQUEST

Prateek

• May 30th, 2014

Use FND_PROGRAM.REGISTER

Answer Question  Select Best Answer

manohar reddy

• Jan 7th, 2014

Calender

balakotireddy

• Apr 26th, 2013

In R12 setbooks are called as ledgers

setofbook contain 3c->currency,calendar,chartofaccounts.

ledgers contain 4c->currency,calendar,chartofaccounts,conversion methods

Answer Question  Select Best Answer

rashve

 Profile Answers by rashve Questions by rashve

• Apr 14th, 2008

The settlement date is of no importance.The user has added the termination of the employee on 04-may-2006 for the 05-May-2006.This means that the last working of the employee will be 05-May-2006 , so ...

rahul.gatade

 Profile Answers by rahul.gatade Questions by rahul.gatade

• Apr 12th, 2008

Why the employee type ex_employee is upto 31-dec-4712...I mean why upto the year 4712....

Answer Question  Select Best Answer

How we submit two concurrent program from backend.if one program is got error out no need to stop the program u need to run second concurrent program..?

DDDD

• Jun 28th, 2017

Keep both programs in different PL/SQL blocks and try it once

Gajanan

• May 5th, 2017

Hi Ruby,
The package name is fnd_concurrent.wait_for_request.

Answer Question  Select Best Answer

prasad

• Jun 2nd, 2014

Cross Validation Rule:Rules that define valid combinations of segment values a user can enter in an account. Cross-validation rules restrict users from entering invalid combinations of account segment...

audiresri

 Profile Answers by audiresri Questions by audiresri

• Feb 25th, 2009

Security rules is nothing but restrict the user to enter invalid accounting values means we are restricting the to enter manually. If dynamic insert is on is checked then we can define the security r...

Answer Question  Select Best Answer

prashant

• Sep 21st, 2011

P2p PROCURE TO PAY CYCLE

Amit

• Sep 13th, 2011

Hi Soumya, P2P(Procure to pay Cycle): 1. Requisition 2. RFQ(Request for Quotation) 3. Quotation 4. PO(Purchase Order) 5. Receiving 6. Invoicing 7. Validation of Invoice 8. Accounting of Invoice 9. Pay...

Answer Question  Select Best Answer

kader_bathusha

 Profile Answers by kader_bathusha Questions by kader_bathusha

• May 14th, 2008

Template is predefine , future purpose like expenses template,or quick codes ,Token is unique no every user entering orcle gateway  used owen token same thing any problam or issuse share probalm ...

knarender

 Profile Answers by knarender Questions by knarender

• Jun 27th, 2007

Template.fmb is a predefined standard form ,which is having 21 libraries to support oracle application structureToken is a field in the parameter window  of a concurrent program which is used to map concurrent program parameter with the report builder  bindvariable.

Answer Question  Select Best Answer

Junaid Usman

• Aug 4th, 2011

"oracle8 ---- Junaid Usman (JBS) DECLARE l_request_id NUMBER(30); begin FND_GLOBAL.APPS_INITIALIZE(user_id => 7938, resp_id => 52342, ...

Adi_phaniK

 Profile Answers by Adi_phaniK Questions by Adi_phaniK

• Oct 2nd, 2009

If you want to run a concurrent request in application through PL/SQL code, then you can used an inbuilt funtion in Apps. Fnd_request.submit_Request

Answer Question  Select Best Answer

J. Diwakar reddy

• Mar 2nd, 2007

Why because 1) Is there any internal problem of your system.2) Another one is you didn't write procedure correctly.

Kranti Shah

• Feb 27th, 2007

APPLPTMP is a special directory used only for PLSQL temporary files.  When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes...

Answer Question  Select Best Answer

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

ERRBUFF is used for display the error in the log file andRETCODE is used to decide the status of the concurrentthere are 3 types of RETCODE they are:-# 0 : Success# 1 : Warning# 2 : Error

amit_exl

 Profile Answers by amit_exl Questions by amit_exl

• Sep 12th, 2008

Common values passed by procedures in variable (ERRBUFF and RETCODE) are:ERRBUFF := SQLERRM;andRETCODE := ERRCODE;Thanks & RegardsAmit Gupta

Answer Question  Select Best Answer

Why we register a table in apps schema by using ad_dd.register_table procedure

jith_in

 Profile Answers by jith_in Questions by jith_in

• Feb 25th, 2010

We register the table using ad_dd for the sole purpose of using the same in flexfields and alerts.

VijayAkumalla

 Profile Answers by VijayAkumalla Questions by VijayAkumalla

• Nov 18th, 2008

We register a custom table in the custom schema. Then give all permissions to APPS schema. Reason being, when stored procedures or functions are written to perform DMLs on the custom table, it is done from APPS schema.

Answer Question  Select Best Answer

How can we restrict the duplicate records from table value set?

Goutham

• Aug 1st, 2017

By using the Distinct Command we can restrict duplicate records in table value set

Nilima

• Aug 17th, 2016

Please tell us the specific example.

Answer Question  Select Best Answer

How to define parameters from and to range in oracle apps reports and also at where condition from and to range of numbers

waseem

• Oct 21st, 2011

Based on your requirement like from data and for this take bind parameter while registering in concurrent program in parameter form give range low and high....

whenkat

• Sep 24th, 2011

Based on your requirement...like from_date and to_date for this take bind parameters... while registering in concurrent program...in parameter form...give range low and high....

Answer Question  Select Best Answer