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

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

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

FSG (Financial Statement Generator) is a tool for reporting on account balance by period. Accounting flexfield, accounting periods and type of balance these are the details which make the rowset and column set. Column set overrides rowset.

Divya

• Sep 26th, 2005

Column set provided while defining Columns you should have checked the "Override Row Calculations" checkbox.

Answer Question  Select Best Answer

you cannot attach the APPCORE library to CUSTOM because it would cause a recursion problem (because CUSTOM is attached to APPCORE). As of Oracle Applications Release 11i, you may attach the APPCORE2 library to CUSTOM. The APPCORE2 library duplicates most APPCORE routines with the following packages:
APP_ITEM_PROPERTY2
APP_DATE2
APP_SPECIAL2
These packages contain the same routines...

Ashutosh

• Sep 8th, 2007

You can call APPCORE from Custom.pll or a customized library which is then called from Custom.pll and it may even work fine but you will face issues while converting pld to pll.DBAs need pld to pll conversion to log comments about modifications as they don't use D2K.

P.Maria Varuvel Raj

• Jan 7th, 2006

hi You cann't call appcore library from custom library.Becuase the Custom.pll is itself attached (called ) by APPCORE pll.So once you try to call Appcore in forms a indefinite cycle.So instead yo...

Answer Question  Select Best Answer

Ashok

• May 19th, 2006

There are 2 flexfields in AR1.Sales Location 2.Teritory Of which sales location is mandatory.A sales tax is calculated by considering the ship-to information.Teritory flexfield is optional.Ashok

Bonthu N Reddy

• Feb 14th, 2006

           There r two Flex fields available in AR 1) SALES TAX LOCATION.2)TERRITORY.Cheers,Bonthu N Reddy.

Answer Question  Select Best Answer

Bonthu

• Feb 13th, 2006

By Using Cursor.Cheers.Bonthu N Reddy.

PRATIK GHOSHAL

• Jan 4th, 2006

We can use bulk collect in a collection.

Answer Question  Select Best Answer

srikanth

• Jul 10th, 2007

Documentation can be done based on the org. requirements, for apps we are mainly using BR100 and MD50, configuration settings we?have to do in this documents, BR100 is the functional document, MD50 i...

gony

 Profile Answers by gony Questions by gony

• Jun 7th, 2006

HI,  Ther are various types of documents that you will come across in any software development. If u are familiar with SDLC (Software Development Life Cycle) then u must have already heard about ...

Answer Question  Select Best Answer

Manishas

 Profile Answers by Manishas Questions by Manishas

• Apr 1st, 2007

If Your Responsibility is disable then you have to  just remove to_date under effective dates. But to do this change System Administration responsibility must be on.Navigation : System Administration -->User-->Detail Responsibility Block.

Jugander

• Nov 4th, 2005

Use oracle utility FNDCPASS to reset the password

Answer Question  Select Best Answer

Bonthu N Reddy

• Jan 11th, 2007

Lot of questions :-)1) You can get the oracle application documentations and user guides, sample code at this site .http://www.oracle.com/technology/documentation/applications.html2)  A set ...

braghu

• Dec 25th, 2005

profile options are used to change the  beheviour of oracle  applications forms,reports and programs at run time.there are  four types of profile options in oracle--1.site level2.applic...

Answer Question  Select Best Answer

madhu

• Nov 6th, 2006

   ru    bandhavi      study   1st class   to    tenth  class   in YELLANDU  khammam&...

sameer

• Jan 14th, 2006

yes i hav also came across such an error u hav to set the sequence name for the parameters like check if when u hav defined ur sequence u shud define it for the same category, check ur periods as this...

Answer Question  Select Best Answer