How purchase ordered entered in Oracle11i AP Module.what is the entry system will create for that..

ravi_kishore

 Profile Answers by ravi_kishore Questions by ravi_kishore

• Sep 15th, 2010

No purchase order is entered in po module.

jaalioracle

 Profile Answers by jaalioracle Questions by jaalioracle

• Sep 11th, 2010

AT the time of creation of invoice PO matching takes place. If matching is approved then payment is made to supplier.

Answer Question  Select Best Answer

When a form will open, which trigger will fire First and Last?

prasa

• Sep 5th, 2014

Whenever we open the WHEN_NEW_FORM_INSTANCE and we will close the form then PRE_FORM Triggers is fired...

Praveen Reddy

• Sep 4th, 2014

Hi,

first trigger is pre form trigger
last trigger is post form trigger

thanks

Answer Question  Select Best Answer

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

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