What is the purpose of ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER? What happens when delete ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER?

veerendra reddy

• Aug 24th, 2015

On_check_delete_master,on_populate_details are used to check the records whether details are exit or not
when we create the non isolated automatically this two triggers are created and one more trigger is created i.e on_clear_details trigger

Answer Question  Select Best Answer

hat is diagnostics in apps? How do you enable/disable it?How do you run diagnostics for a particular module to send it to Oracle support?

Dhanaraju

• Oct 14th, 2015

How are the opportunities for Oracle Apps Tech?

Neha

• Aug 29th, 2015

Application Diagnostics Responsibility --> Diagnose --> select application --> setup General --> execute

Answer Question  Select Best Answer

What are the manadatory parameters in Oracle Apps Reports?

ANsar Aluva

• Oct 20th, 2015

There is no fixed mandatory parameter for Oracle reports. Instead it based on how the reports develops. Normally the "Region, Location" can be mandatory.

Naresh Bandla

• Jun 24th, 2015

There is no mandatory parameters in reports. If you are using User Exits in your report then only we have to pass P_CONC_REQUEST_ID parameter.

Answer Question  Select Best Answer

What were the documents you have prepared during implementation project?
What are the major difference between 11i and R12?

VIVEK RAO

• Nov 18th, 2015

11i 1) Consist of 3C 2) No concept of MOAC. 3) Major table changes like po_vendors. 4) Banks are created in Account Payables. 5) Ap_Invoices_lines_all table in finance is not there. R12 1) Consist of...

Surendra

• Nov 20th, 2014

So many changes are there in tables.

Mainly In multi org architecture
in 11i set of books, 3cs (Currency,Calender,Chart of accounts)
now in R12 Set of books call it as a ledger 4cs(Currency,Calender,Chart of accounts,subledger accounting).

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

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

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 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

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

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

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

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

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

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

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

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

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 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

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

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