What is the Item Category? What is the use of it?

Divya Gaba

• Apr 24th, 2013

Item Category is grouping of items. Item Category Sets is grouping of Item Categories. An item can belong to any number of category sets. We can assign item to one category within each category set. T...

Raaj Kiran

• Dec 24th, 2012

Mtl_item_categories

Answer Question  Select Best Answer

Which table holds the Master Vs child Organization Details?

priyanka

• Aug 2nd, 2012

Mtl_parameters , ORG_ORGANIZATION_DEFINITIONS

priyanka

• Jul 31st, 2012

Mtl_system_items_b consists all master and child items details

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

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

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

Bonthu Nagi Reddy

• Oct 31st, 2007

We can enter journal in GL in Three Ways.1) Entering Journal by Journal Entry Screen on Application Side.2) Importing Journals to GL by Interface.3) Using Application Desktop Integrator ( ADI).With Rgds,Nagi Reddy.Bonthu

Hassan Shoaib

• Nov 5th, 2006

Hi,1. Standard Method2. Through Interfaces3. Through ADI ( or WeB ADI)

Answer Question  Select Best Answer

Krishna Kumar

• Jun 22nd, 2006

The Flow of PO starts when the Request for Goods started, This is the P2P (Procure to Pay) Cycle. The Matching is one of the concepts in the P2P The 2 way matching is the Ensuring the Invoice and PO d...

Vijay

• Jun 21st, 2006

Two-way Matching means checking of the invoice by ordered quantity & PO rateThree-way Matching means checking of the invoice by ordered quantity & PO rate,invoiceFour-way Matching means checking of the invoice by ordered quantity & PO rate,invoice,quantity recieved

Answer Question  Select Best Answer

latha

• Jul 10th, 2007

We can say Multi org concept in another way that we can use different views for different purposes. So that data can be saved differently.

fanish

 Profile Answers by fanish Questions by fanish

• Aug 30th, 2006

Taking Example of GE IndutriesBusiness Group is GE industriesIf they are in India there GE India would be one Legal EntityThey have different Sales/Admin offices in India like Delhi, Bglr that th...

Answer Question  Select Best Answer

Manivasagam

• Jul 9th, 2014

See..Conversion means moving data from one apps system into another apps system.But data migration means moving from non apps system to apps system(Like Upgrading).

Andy Noble

• Oct 25th, 2007

Data Migration is the one off PROCESS of moving data from one system to another, whether that be an upgrade or from legacy.Data Conversion is a step in the data migration process that involves a some ...

Answer Question  Select Best Answer

mallikarjunekmn

 Profile Answers by mallikarjunekmn Questions by mallikarjunekmn

• May 16th, 2008

Hi,As per my Knowledge as per ERP ProcessSteps:1. Purchase Order will be in Fresh Status when it is created.2. It will be in Approved Status after it is approved by Purchase Dep Head or correspon...

AYAN BASU

• Sep 29th, 2006

Please consider two situtions:1. An order with a single line2. An order with a multiple lineIn a single line order , when the entire quantity is fullfilled i.e shipped and AR interface being run the l...

Answer Question  Select Best Answer

Sandeep

• Sep 1st, 2006

Concurrent Managers:$COMN_TOP/admin/scripts/SID_HOST/adcmctl.shps ?ef | grep CPMGR________________________________________From front endConcurrent ->manager->Administrator

Atul

• Aug 14th, 2006

On Concurrent Manager node type ps -ef | grep FNDLIBR   to see if any concurrent request still running or all finished or check in $APPLCSF/$APPLOG/_DD_MM.mgrOracle Apps DBA Xperthttp://teachmeoracle.com

Answer Question  Select Best Answer

aksesa

 Profile Answers by aksesa Questions by aksesa

• Apr 1st, 2010

API are application program interface. API are provided by Oracle in PLSQL code. Whenever you want to either load or update data in base tables like PO_HEADERS_ALL or FND_PROFILE_OPTIONS bulk records ...

sudheer12d

 Profile Answers by sudheer12d Questions by sudheer12d

• Jan 18th, 2007

Hi API - Application Program Interface It is an inbuilt PL/SQL coding which explains the particular functionality which interfaces legacy to Apps.We use it by running the concurrent program; executable as one of the concerned API.Cheers Sudheer

Answer Question  Select Best Answer

By using ad_dd.register.table

neela manohar

• Jan 8th, 2007

use  ad_dd.register_table to regiseter tables.       ad_dd.register_column to register columns of that tablewe can also use         ad_dd.delete_table to unregister tables.

Dimple_me

 Profile Answers by Dimple_me Questions by Dimple_me

• Dec 8th, 2006

Use AD_DD.Register_Table procedure to register the table.

Answer Question  Select Best Answer

Manivasagam

• Jul 9th, 2014

API means we can directly insert data into base tables with standard validations through calling API.
But Interface means we have to load data into interface tables.After that we have to run Import program.

sateesh.talanki

 Profile Answers by sateesh.talanki Questions by sateesh.talanki

• May 21st, 2008

API is nothing but application program interface.when we call an API first of all it will check the validations for the data(validations u can see in the API) that u are inserted through API, if the validations are successful the n it will insert data into the base tables.

Answer Question  Select Best Answer

Ashish Vishwakarma

• Oct 16th, 2006

                            ACME Inc.(Business Group)  ...

Mohammed Abdul Rahman

• May 12th, 2006

 before multi org existed, we could have only one bussiness group,set of books, legal entity, operating unit  in one installation of oracle E-bussiness suite, and now with the multi organisa...

Answer Question  Select Best Answer

BarunHazra

 Profile Answers by BarunHazra Questions by BarunHazra

• Dec 22nd, 2009

Yes, as long as the descriptive flexfield use seperate columns 

audiresri

 Profile Answers by audiresri Questions by audiresri

• Feb 25th, 2009

Yes we can add a DFF if table already have a data. Thanks, Sreeni

Answer Question  Select Best Answer

Bonthu

• Feb 11th, 2006

1)Control File.2)Data File.3)Logfile.4)Bad File5)Discard File.Cheers,Bonthu.

sameer

• Jan 14th, 2006

Hithere is one more file called parameter file given on command line as parfile that is also used by sqlldrin this file diff. parameters can be specified

Answer Question  Select Best Answer

Haresh

• Jul 1st, 2007

1. The balances cannot be transferred from the general ledger to the sub-modules. If you want to transfer the balances back to the sub-ledger for rectification and then transferring again to general l...

suman sanam

• Jun 26th, 2007

We cannot transfer the ledgers from GL to sub modules directly as such, but you can use reversal journal concept to that.

Answer Question  Select Best Answer

selvakumarapps

 Profile Answers by selvakumarapps Questions by selvakumarapps

• May 20th, 2009

Conversions: It's nothing but transfer of data from other application ?to oracle application(it's one time data transfer). eg SAP(data) to Oracle APPS(data).Interfaces: It's nothing but transfer of d...

Christopher Joseph

• Aug 26th, 2006

Upgrading your data to a newer version is not Conversion, Its Data Migration.Conversion is as correctly mentioned, a One time activity to Convert the Data from a Legacy System to be loaded into Apps Tables. Interfaces: They are periodically run for exchange of data between Apps and Non-Apps Systems.

Answer Question  Select Best Answer