I want to know what is the column link between OM and AR and also the link between AR and GL?
Kiran praveen kumar Thota
- Nov 1st, 2018
Not sale_order ,its sales_order
- Aug 11th, 2017
Need a query that can give me all the responsibilities that have a specific function.
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.
- 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
- 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
What is Multiorg? Explain.
- 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...
- 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...
What is an Invoice ? How many types of invoices are there in AP and AR ?
- 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...
- 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.
Maximum Number of Records Per Page
What is the Maximum Number of Records Per Page Using XML Publisher With RTF Template?
- 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...
- 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 ...
Restrict Duplicate Records
How can we restrict the duplicate records from table value set?
- Aug 1st, 2017
By using the Distinct Command we can restrict duplicate records in table value set
- Aug 17th, 2016
Please tell us the specific example.
Custom Tables Migration
How to migrate the custom tables from apps 126.96.36.199 to R12 WHEN we are doing the upgradation of reports?
- 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
- Jan 25th, 2017
We migrate the custom table creation scripts through kintana.
What is the difference between conversion and interface
- Aug 1st, 2017
Conversion is one time process which is done when system is upgraded to new version whereas Interface is routine process
- 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.
Real time question submitting two concurrent program from back end?
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..?
- Jun 28th, 2017
Keep both programs in different PL/SQL blocks and try it once
- May 5th, 2017
The package name is fnd_concurrent.wait_for_request.
How many Parameters can pass to Concurrent Program
- Jun 22nd, 2017
We can pass maximum 100 Parameters in a Concurrent Program.
- May 24th, 2017
We can pass Maximum 100 parameters .
MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV
What is the difference between MTL_SYSTEM_ITEMS_B and
- Jun 14th, 2017
_b is the item master table and _kfv is the flex field view where we can get the concatenated segments
- Nov 3rd, 2015
B is Base table and KFV Key Flex Field Value
Which module is not a multiorg?
- Mar 16th, 2017
Sonia Your answer is wrong. Right answer is GL and CRM
- Apr 14th, 2008
I agree with Mohanty
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...
What is the use of Aging Buckets in AR?
- 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...
How can we tell the difference between seeded tables, static tables and the main transaction tables?
- Jul 1st, 2016
What is the static table and dynamic table in Oracle? Please say What are the difference between 10g and 11g
- 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...
Refresh External Table
How to Refresh External table?
- 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
Credit Memo and Debit Nemo in AR and AP
What is the difference between Credit Memo and Debit Memo in AR and AP?
- 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...
Oracle Apps Attribute and Global Attribute
What is the difference between Attribute and Global Attribute in Oracle Apps
- 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...
- 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.
What is the importance of using flexfield qualifiers?
- 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.
- Dec 8th, 2015
A Flexfield qualifer identifies a particular segment of a Key flexfield.
Explain about secondary tracking segment flex field qualifier ?
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...
Oracle Apps Technical Interview Questions