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

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

What is Multiorg? Explain.

Shubh

• Jan 22nd, 2018

Suppose your company is operating in multiple countries. Working in different countries indicates multiple organizations across multiple countries. If the company wants to implement multiple organizat...

Aswin

• Nov 11th, 2016

One single instance have the access to multiple operating unit, inventory org and do the transactions without doing the switch responsibility any other operating unit, Inventory org called Multi org c...

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

What is the Maximum Number of Records Per Page Using XML Publisher With RTF Template?

Goutham

• Aug 1st, 2017

Based on your limitation in the output you can access no. of records. while defining variable you have to set how many records you need to retrieve for page. We can use the code to generate maximum re...

shaik mazhar

• Jun 2nd, 2016

Hi Priyanka, In XML publisher reports, most commonly there will be scenarios where customer asks us to print the report records in a pre-printed paper, which is having a logo on the header and below ...

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 migrate the custom tables from apps 11.5.10.2 to R12 WHEN we are doing the upgradation of reports?

Goutham

• Aug 1st, 2017

In order to migrate reports from one instance to other we need to create the custom tables in upgraded version and validate the package in current version and generate a new report

Vinay

• Jan 25th, 2017

We migrate the custom table creation scripts through kintana.

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

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

How many Parameters can pass to Concurrent Program

ANIL SAPRA

• Jun 22nd, 2017

We can pass maximum 100 Parameters in a Concurrent Program.

prasad

• May 24th, 2017

We can pass Maximum 100 parameters .

Answer Question  Select Best Answer

What is the difference between MTL_SYSTEM_ITEMS_B and
MTL_SYSTEM_ITEMS_KFV?

Poonam

• Jun 14th, 2017

_b is the item master table and _kfv is the flex field view where we can get the concatenated segments

NITIN

• Nov 3rd, 2015

B is Base table and KFV Key Flex Field Value

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

Briefly explain about the reports you developed as Oracle apps scm consultant??

Sushant Baban Sawant

• Nov 10th, 2016

I developed 5+ reports in scm. For e.g. Purchase order report, purchase order print report, AFE report, GRN Accounting details report etc. 1. In purchase order report and purchase order print re...

Answer Question  Select Best Answer

What is the use of Aging Buckets in AR?

Ravi

• Nov 4th, 2016

Aging buckets are time periods you can use to review and report on your open receivables. For example, the 4-Bucket Aging bucket that Receivables provides consists of four periods: -999 to 0 days past...

Answer Question  Select Best Answer

nayeem

• Jul 1st, 2016

What is the static table and dynamic table in Oracle? Please say What are the difference between 10g and 11g

Andy Noble

• Oct 25th, 2007

You can tell based on the TABLESPACE the table belongs to - this is the new Oracle Applications Tablespace Model (OATM)Run the following code to see:SELECT tablespace_name, table_nameFROM all_tablesWH...

Answer Question  Select Best Answer

How to Refresh External table?

Ajesh

• May 2nd, 2016

Write a select statement on external table and replace the file with same structure to refesh the data in the external table

Answer Question  Select Best Answer

What is the difference between Credit Memo and Debit Memo in AR and AP?

Parakram

• Apr 19th, 2016

AR: In AR Debit Memo is Positive, which means organization is going to receive more money on a particular transaction which might be raised because they want to add freight charge or any other addit...

Answer Question  Select Best Answer

What is the difference between Attribute and Global Attribute in Oracle Apps

Pulkit

• Mar 31st, 2016

Descriptive flexfield configuration: A descriptive flexfield enables you to add two types of custom attributes to a page global and context sensitive. Global attributes are always available as fie...

DP

• Mar 2nd, 2016

Attribute columns on oracle tables are used for Descriptive Flexfields to enter additional information on a form. Global attributes are used for country specific information that is used in Oracle localization.

Answer Question  Select Best Answer

What is the importance of using flexfield qualifiers?

DP

• Mar 2nd, 2016

Flexfield qualifiers identify segments of a Key Flexfield for a specific purpose. For example the natural account of the Accounting Flexfield can be set for the account segment in the Flexfield Qualifiers window.

Naidu

• Dec 8th, 2015

A Flexfield qualifer identifies a particular segment of a Key flexfield.

Answer Question  Select Best Answer

Siva koti reddy

• Feb 26th, 2016

A segment in the chart of accounts can be designated as a secondary tracking segment, in addition to the balancing segment, to perform more detailed analysis within Oracle General Ledger. The secondar...

Answer Question  Select Best Answer