selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

We unable to compile the form as well as we unable to retrive the standard functionality of APPS like menu.

rakhi

• Oct 17th, 2007

This form is the starting point of all development involving forms. It contains some special libraries and triggers that render the application using the template form some standard characteristics.H...

Answer Question  Select Best Answer

rbaggu

 Profile Answers by rbaggu Questions by rbaggu

• Dec 6th, 2007

If the Iinvoice Distribution is matched to a Purchase Order thenap_invoice_distributions_all.PO_DISTRIBUTION_ID is the link to po_distributions_all table 

sjakkula

 Profile Answers by sjakkula Questions by sjakkula

• Nov 12th, 2007

Po_req_distributions_all.code_combination_id = ap_invoice_disributions_all.dist_code_combination_id

Answer Question  Select Best Answer

Richa Aggarwal

 Profile Answers by Richa Aggarwal Questions by Richa Aggarwal

• Aug 18th, 2010

There are various types of sales orders in order management which are as follows:-1. Standard Order2. Book and Bill 3. Expense Order4. Demonstration order5. CEU orders, i.e., Customer Evaluation order...

haveluck

 Profile Answers by haveluck Questions by haveluck

• Dec 1st, 2007

3 Types of Sales Order are Available. They are:1.Standard Sales Order2.Mixed Sales Order3.Return Sales OrderIn Standard Sales Order we have1.Back to Back2.Drop ShipmentInternal Sales Order are raised within an Organization

Answer Question  Select Best Answer

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 11th, 2008

By Using run_product('reportname')? in-built feature? you can call one report from another.

askvenki

 Profile Answers by askvenki Questions by askvenki

• Dec 19th, 2007

Run_product(,reportname')

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

Yes , We can develop reports without using "User Exit" , in this scenario no need define P_CONC_REQUEST_ID also.

arun kumar somayajula

• May 22nd, 2015

Yes, We can develop without using user exits, but our report shouldnt have p_conc_request_id

Answer Question  Select Best Answer

Who is the owner of FND_TABLES and Why we shouldn't create table in APPS Schema?

vineetjoshi5

 Profile Answers by vineetjoshi5 Questions by vineetjoshi5

• Feb 3rd, 2008

APPLSYS is the owner of FND tables.APPS schema contains the package code for all the E-Biz products.and needs to be kept secure.So, we can't create tables in APPS schema , if we want to make use of them in our custom code.

Manishas

 Profile Answers by Manishas Questions by Manishas

• Dec 18th, 2007

APPLSYS is the owner of the FND tables

Answer Question  Select Best Answer

sonal

• Jul 11th, 2015

Whenever you submit a purchase order or requisition for approval or take an action in the Notifications Summary window, Purchasing uses Oracle Workflow technology in the background to handle the appro...

Sonal

• Jul 11th, 2015

Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships

Answer Question  Select Best Answer

At what level do you assign the Responsibility?

fighter83

 Profile Answers by fighter83 Questions by fighter83

• Feb 27th, 2008

I think at SOB level

k_gopalsharma

 Profile Answers by k_gopalsharma Questions by k_gopalsharma

• Jan 18th, 2008

You can assign responsibility only if you have the system adminstration access.you can assign responsiblity at administrative level

Answer Question  Select Best Answer

What is ERS? Use of this Function?

durga.polina

 Profile Answers by durga.polina Questions by durga.polina

• Mar 23rd, 2011

ERS Belongs to AP Module.Pay on Receipt also known as ERS(Evaluated Receipt Settlement) or Self-Billing, is an Oracle Purchasing Concurrent Program, which automatically creates invoices in Payables and matches them with purchase orders for the received amount.

fighter83

 Profile Answers by fighter83 Questions by fighter83

• Feb 27th, 2008

ERS is used in ap not in GL

Answer Question  Select Best Answer

How to create India localization setups?

raju

• Dec 3rd, 2011

Hi,

Please share R12 Indian locailzation setup and Procedural documetns to me.

Regards
Raju

raghu.nandana

 Profile Answers by raghu.nandana Questions by raghu.nandana

• Oct 4th, 2008

For this there is a diff module called India localization in that there are separate setup is the based on the tax, local area its depend for ex. in standard when you create an organization in India l...

Answer Question  Select Best Answer

hey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader

siddhshah

 Profile Answers by siddhshah Questions by siddhshah

• Jun 22nd, 2009

One needs to enter the value with double quotes like "Jain, Anisha" to all the values so the comma can be stored in the columns.

harishkrishnagowda

 Profile Answers by harishkrishnagowda Questions by harishkrishnagowda

• Apr 4th, 2008

Its better to remove ',' for that column using replace commandsFor egREPLACE(TRANSLATE(empname, ',{}[]%"?*~&$|/@''', '    '),'    ')

Answer Question  Select Best Answer

What is Item Master Organization in Oracle Inventory? What is its use?

jphanireddy

 Profile Answers by jphanireddy Questions by jphanireddy

• Nov 20th, 2009

This is not Mandatory but recommanded by Oracle. Master Org is used only for Item defination. And later it can be assign to other Organization (Child Organization). You can restrict item attributes at master level or Chlid Organization Level.

madaninterview

 Profile Answers by madaninterview Questions by madaninterview

• May 15th, 2008

To create any item we  use  item master organization responsibility madan

Answer Question  Select Best Answer

How purchase ordered entered in Oracle11i AP Module.what is the entry system will create for that..

ravi_kishore

 Profile Answers by ravi_kishore Questions by ravi_kishore

• Sep 15th, 2010

No purchase order is entered in po module.

jaalioracle

 Profile Answers by jaalioracle Questions by jaalioracle

• Sep 11th, 2010

AT the time of creation of invoice PO matching takes place. If matching is approved then payment is made to supplier.

Answer Question  Select Best Answer

When a form will open, which trigger will fire First and Last?

prasa

• Sep 5th, 2014

Whenever we open the WHEN_NEW_FORM_INSTANCE and we will close the form then PRE_FORM Triggers is fired...

Praveen Reddy

• Sep 4th, 2014

Hi,

first trigger is pre form trigger
last trigger is post form trigger

thanks

Answer Question  Select Best Answer

Hi, Can anyone of you give me some points on what are the major differences between Oracle 11i and R12 on the below modules 1. iProcurement 2. Purchasing 3. iStores Waiting for your reply. Thanks, Vikram

bhaskarapps

 Profile Answers by bhaskarapps Questions by bhaskarapps

• Jul 2nd, 2009

1. In Oracle 11i 3c's i.e Currency, Calendar, Char of AccountIn R12 4c's
include sub-ledger account also2. In invoice screen invoice lines

Apps_Dragon

 Profile Answers by Apps_Dragon Questions by Apps_Dragon

• Nov 28th, 2008

1) Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyers Work Center. Based on the latest web-based user interface models, the Work Center is a ce...

Answer Question  Select Best Answer

How to activate, deactivate and run concurrent managers?

Bharat Bhatia

 Profile Answers by Bharat Bhatia Questions by Bharat Bhatia

• Jan 4th, 2015

Concurrent managers are components of Concurrent Processing that monitor and run time-consuming, non-interactive tasks without tying up your terminal. Whenever you or your users submit a request to ru...

sushma_anil

 Profile Answers by sushma_anil Questions by sushma_anil

• Apr 28th, 2009

CONCSUB is used to execute both seeded and customized concurrent programs. CONCSUB is a utility that allows you to submit concurrent program to the concurrent Manager from operation unit level. ...

Answer Question  Select Best Answer

How to get distinct value for any column in value set.E.g Table is emp, to Type value set for job then in lov it has to display distinct job.

Bhaskar Bethi

• Aug 12th, 2011

select PERIOD_YEAR
from gl_periods
where rowid in (select max(rowid) from gl_periods group by
PERIOD_YEAR )
order by PERIOD_YEAR

Follow the same with required table.

sridutta

 Profile Answers by sridutta Questions by sridutta

• Dec 8th, 2008

Use select distinct column name from table instead of table name

Answer Question  Select Best Answer

What is Journal Import.How do I import vendor info into purchasing.Thank u,

nakul.v

 Profile Answers by nakul.v Questions by nakul.v

• May 6th, 2009

GL Journal Import is a Standard Open Interface Program provided by Oracle Applications to import Journal Data from legacy systems/or even from Payables,Receivables,Inventory into GL Tables.Interface Table :GL_INTERFACEBase Tables : GL_JE_BATCHESGL_JE_HEADERSGL_JE_LINESGL_BALANCES.

rajeshnrk8

 Profile Answers by rajeshnrk8 Questions by rajeshnrk8

• Mar 10th, 2009

Journal Import is the program is used to import the data from the Interface table to main table.

Answer Question  Select Best Answer

Why we enable Allow Dynamic Inserts and what is the purpose?

praveen

• Oct 6th, 2014

Dynamic insertion used to create the code combinations at run time.

murari

• Oct 11th, 2013

If you allow dynamic inserts when you set up your key flexfield, a user can enter a new combination of segment values using the flexfield window from a foreign key form

Answer Question  Select Best Answer

What is meant by Lot and Serial controlled item?

Manivasagam

• Jul 9th, 2014

Lot contains multiple Items,so that particular lot have some details.
Serial number means every item in a lot have serial number details.

priya

• Sep 25th, 2012

Serial controlled means a serial number is associated to each piece of the item.Attribue1 in table mtl_system_items defines if the item is serial controlled.

Answer Question  Select Best Answer