shwetac

 Profile Answers by shwetac Questions by shwetac

• May 2nd, 2007

In Oracle Apps, to get data from views we have to set the org id for the application so that we can fetch relevant data. This can be done using the following block : beginfnd_client_info.set_org_context( ) ;end;

ratnakar

• Jan 24th, 2007

View is a virtual table we can create view by using following query Create view view_name as select * from table_namewe can select data from view by using following query.select * from view...

Answer Question  Select Best Answer

MARUTHI

• Apr 6th, 2012

GO WITH TC:
SE11

NAVEEN

• Nov 25th, 2011

Through se16 we can see all the tables

Answer Question  Select Best Answer

Bonthu Nagi Reddy

• Mar 5th, 2012

Oracle Application Architecture is 3 Tier Architecture.

1) Database Tier ( Ex:- Oracle )/ Server/ Back End.

2) Client/ Front End ( Ex:- Forms ).

3) Application Tier ( New Tier ).

kesava.chunduri

 Profile Answers by kesava.chunduri Questions by kesava.chunduri

• Mar 11th, 2008

Hi,Did they ask you about the Apps Architecture (or) the Hierarchy? Generally they ask you about the Apps Hierarchy i.e, how Apps implemenations are done.As per what he/she has mentioned it, it is 3 t...

Answer Question  Select Best Answer

What is planned purchase order,when do we use it?

venkatesh

• Jul 1st, 2017

It is a long term agreement when you know the goods or services then you can raise PPO. whenever you make PPO you need to raise schedule releases against planned PO

vimalasridhar

 Profile Answers by vimalasridhar Questions by vimalasridhar

• Mar 16th, 2011

Planned purchase order is an agreement cum order where in we know the items, quantity, price and terms to purchase from the supplier but we still do not know the delivery schedules. For example for an...

Answer Question  Select Best Answer

Bonthu Nagi Reddy

• Mar 5th, 2012

Recurring Invoice is one of the invoice type which can be used for paying to the customer periodically the best example of RI is for paying the Rent.

mahes

• Apr 27th, 2007

Recurring invoice is one of the type of invoice in ap module.After receiving the material from the supplier and will pay the amount against the material. for that we will raise the invoice document. a...

Answer Question  Select Best Answer

Upender Prasad

• Apr 16th, 2007

Try to insert/update a row into table <wf_all_user_roles> as per following statement with Role_Orig_System_id =20420select * from wf_all_user_roles where user_name = 'ZZPRASAU' and role_orig_system = 'FND_RESP'AND NOT role_name LIKE 'FND_RESP|%|ANY'

gannesunil

• Mar 30th, 2007

we are not able to create table from oracle apps front end.we are suppose to create table from back end by usingAD_DD oracle package (try once)ad_dd.create table andad_dde.create column ue can use the...

Answer Question  Select Best Answer

knarender

 Profile Answers by knarender Questions by knarender

• Jun 27th, 2007

Conversion  is transfer of legacy system flat file data into oracle apps tables or from oracle apps table data to flat files like interface, but it is a one time data transfer. Extensions is used for form development/form customization.

harshal

• Oct 26th, 2006

Extensions are literally extensions to Oracle Apps.About conversions (if seen independent of extensions), i feel its more to conversions used for currency conversion. Types : corporate etc

Answer Question  Select Best Answer

ratnakar

• Jan 24th, 2007

While registering procedure as concurent program there we need to declare two mandatary OUT parameters in procedure. 1.Errbuf 2.Retcode Errbuf : Errbuf is one the paramter which will define in p...

ram

• Sep 20th, 2006

There is another parameter for apps procedure errbuff

Answer Question  Select Best Answer

Manishas

 Profile Answers by Manishas Questions by Manishas

• Feb 16th, 2007

Since Question is related to APPS If you want to see particular filed in particular table Go to Form, Click on that field --> press Help Button in Menu -->HistoryPopup window will show Table name

VijayAkumalla

 Profile Answers by VijayAkumalla Questions by VijayAkumalla

• Dec 8th, 2006

If you know the column name, you can find out what all tables the column is used. Use this SQL> Select table_name from all_tab_columns where column_name = '';

Answer Question  Select Best Answer

What journal enteries will come for the followingTravelling Advance given----- Rs. 10,000Spent--- 8,000Returned--- 2,000

Ajay

• Mar 1st, 2015

A?submit?the?claim?for?expenses?of Rs 1000

mukunthaniyer

 Profile Answers by mukunthaniyer Questions by mukunthaniyer

• Feb 28th, 2008

Travelling Advance given----- Rs. 10,000Spent--- 8,000Returned--- 2,000Jrnl 1   At the time of Despatch of Advance:          Conveyance Advance a/c &nbs...

Answer Question  Select Best Answer

At what level we will assign the Resposibility
SOB LEVEL
LEGAL ENTITY LEVEL
OPERATING UNIT LEVEL

RCPandre

 Profile Answers by RCPandre Questions by RCPandre

• Jul 21st, 2008

For General Ledger - we assign a responsibility at SOB level. For all the Subledger Applications we use Operating Unit to be assigned to a responsibility. Ramesh Chandra Pandre

ramesh.nalem

 Profile Answers by ramesh.nalem Questions by ramesh.nalem

• Feb 19th, 2008

SOB level

Answer Question  Select Best Answer

If HRMS is not there, how will you create buyer in PO?2. What are the types of invoices in AP and AR?

k_amjad

 Profile Answers by k_amjad Questions by k_amjad

• Sep 19th, 2008

AP INVOICE 11 invoice are there 1) Regular invoice (9) & 2) Special invoice (2)1) Regular Invoice1. Standard invoice?2. Credit memo?3. Debit memo?4. Prepaid invoice?5. Expence report?6. Quck invo...

raman av

 Profile Answers by raman av Questions by raman av

• Jun 2nd, 2008

(1) standard(2) Credit Memo(3) Debit Memo(4) prepayment(5)with holding Tax

Answer Question  Select Best Answer

What is the use of setting Profile option FND: Diagnostics to yes. In which table we can veiw the details.

Bonthu Nagi Reddy

• Mar 5th, 2012

This is one of the Profile option, if fnd: diagnostics = yes then we can examine any record information from the Form.

Form> Tools> Examine ( we can able to view the record history ).

mpoojari

 Profile Answers by mpoojari Questions by mpoojari

• Jun 15th, 2009

Self Service has a similar profile option. If the profile option FND: Diagnostics is set to Yes, then anyone can use the Diagnostics Examine function which allows users to change database records.rela...

Answer Question  Select Best Answer

In which table we can find out a) Shipped Qty b) received Qty c) Canceled Qty

Pavithara

 Profile Answers by Pavithara Questions by Pavithara

• Aug 23rd, 2010

If for Receiving Module,We can see the Shipped qty & Received Qty from the table RCV_SHIPMENT_LINESIf for Purchasing Module,We can see the Received qty & Cancelled Qty from the table PO_L...

Pavithara

 Profile Answers by Pavithara Questions by Pavithara

• Aug 23rd, 2010

We can find the Shipped Qty, Cancelled Qty details in the Table OE_ORDER_LINES_ALL. But i'm not sure about what is received qty?Regards,Pavithara R.

Answer Question  Select Best Answer

How to know which business group a given report belong to ? Plz let me know the full process ?

Naresh Bandla

• Dec 5th, 2014

You can see the BUSINESS_GROUP_ID and NAME by using HR_ORGANIZATION_UNITS from Back end.

kishore05101984

 Profile Answers by kishore05101984 Questions by kishore05101984

• Dec 23rd, 2010

verify HR_OPERATING_UNITS TABLE

Answer Question  Select Best Answer

Hi

What's the difference btw supplier_id,party_id,customer_id ,vendor_id

Tom Haughey

 Profile Answers by Tom Haughey Questions by Tom Haughey

• Apr 30th, 2012

Jaya is correct. But Party could be the super type that has all the data the other three share in common. All the common data goes in Party, the individually specific data goes in the other three.

Jaya

• Apr 28th, 2012

Supplier_id - is the party referred as, in payables AP
Vendor_id - is the party refereed as, in PO
customer_id and party_id is party referred as, in AR

Answer Question  Select Best Answer

Raghu

• Aug 25th, 2014

Yes,while done the conversion data will be stored into interface tables,after run the standard program data will be moved from interface tables to base tables

AISHWARYA.S

• Aug 21st, 2014

Automatically created..

Answer Question  Select Best Answer

geethika

• Oct 12th, 2007

for GL ValidationsGl_code_combination_id SOB IDJournal SourceJournal CatagoreyCurrency CodePeriod NameCurrency Conversion Type

aniyanremo

 Profile Answers by aniyanremo Questions by aniyanremo

• Mar 7th, 2006

Hi Following are the Required Validations for Autoinvoice : ?          AR Transaction Type Validation : Check if the Transaction type provided in data...

Answer Question  Select Best Answer

pnosko

 Profile Answers by pnosko Questions by pnosko

• Feb 5th, 2016

This is not entirely correct. Creating an Oracle directory using CREATE DIRECTORY creates a database object that is used to assign privileges to users against accessing the target location from within...

Krishna Mohan

• May 12th, 2006

To create a file it is required to initially create a directory.. CREATE DIRECTORY temp AS "/user/test/"this would create the directory inthe unix box with name temp under the path /user/test.now usin...

Answer Question  Select Best Answer

raju

• Apr 3rd, 2007

DFF means giving the additional information to the fields

gsdpdevi

• Sep 13th, 2006

There are no key flex fields in order management

Answer Question  Select Best Answer