For one user the data needs to be in summary form and another one it needs to be in Detail form ?Can anyone let me know TY

If you are given the Requisition number how will you find out corresponding PO numbers?

oracle.mallik

 Profile Answers by oracle.mallik Questions by oracle.mallik

• Sep 22nd, 2010

Here you can find all the details, If you want more fields you can add it. select pha.segment1 "PO Number", pha.segment1 "REQ Number", pha.org_id from apps.po_headers_all ph...

Answer Question  Select Best Answer

In which table we can find out a) Shipped Qty b) received Qty c) Canceled Qty

Pavithara

 Profile Answers by Pavithara Questions by Pavithara

• Aug 23rd, 2010

If for Receiving Module,We can see the Shipped qty & Received Qty from the table RCV_SHIPMENT_LINESIf for Purchasing Module,We can see the Received qty & Cancelled Qty from the table PO_L...

Pavithara

 Profile Answers by Pavithara Questions by Pavithara

• Aug 23rd, 2010

We can find the Shipped Qty, Cancelled Qty details in the Table OE_ORDER_LINES_ALL. But i'm not sure about what is received qty?Regards,Pavithara R.

Answer Question  Select Best Answer

To which level of Multi-Org Structure Oracle CRM Service Modules operates? Like GL/AP/AR/PO/OM operates at Operating Unit Level & BOM/INV/MRP/WIP operates at Inventory Unit Level?

What is Standard Costing and Average Costing? What is the difference between them?

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

Cost Management offers two costing methods: standard costing and average costing. Average costing is used primarily for distribution and other industries where the product cost fluctuates rapidly, or ...

Answer Question  Select Best Answer

What are the standared erros in GL Interface?

agouthaman

 Profile Answers by agouthaman Questions by agouthaman

• Feb 19th, 2010

The Journal Execution Report is generated automatically when Journal Import is executed and shows the lines that could not be imported due to the signaled errors.Period Error Codes------------------EP...

Answer Question  Select Best Answer

What action one has to take in this scenario. A supplier gives 100 units for Rs1 each. But at the same time he is giving a offer that if we purchase 500 units, he will give 50 units free. How to deal with this situation in Purchasing?

zeet1982

 Profile Answers by zeet1982 Questions by zeet1982

• Feb 10th, 2010

You can create an Blanket Agreement and specify the Price Breaks to achive the same. There will be two price breaks:For quantity <= 499  ==>  price 1 Rs.For quantity > 500    ==>  price 50 paisa

Answer Question  Select Best Answer

If HRMS is not there, how will you create buyer in PO?2. What are the types of invoices in AP and AR?

k_amjad

 Profile Answers by k_amjad Questions by k_amjad

• Sep 19th, 2008

AP INVOICE 11 invoice are there 1) Regular invoice (9) & 2) Special invoice (2)1) Regular Invoice1. Standard invoice?2. Credit memo?3. Debit memo?4. Prepaid invoice?5. Expence report?6. Quck invo...

raman av

 Profile Answers by raman av Questions by raman av

• Jun 2nd, 2008

(1) standard(2) Credit Memo(3) Debit Memo(4) prepayment(5)with holding Tax

Answer Question  Select Best Answer

atishay

 Profile Answers by atishay Questions by atishay

• Aug 27th, 2008

There are two phases CRP1 and CRP 2CRP1: During CRP1, application is configured as per the business cases provided and discussed as per TO-BE analysis phase. Owners, keyusers, consultants meet to exch...

abhi_jaini

 Profile Answers by abhi_jaini Questions by abhi_jaini

• Sep 11th, 2007

CRP is one of the phase of ERP implementation where in use can see the working of the system and test his business case scenerios.There are mainly two phases i..e CRP-1&2.

Answer Question  Select Best Answer

At what level we will assign the Resposibility
SOB LEVEL
LEGAL ENTITY LEVEL
OPERATING UNIT LEVEL

RCPandre

 Profile Answers by RCPandre Questions by RCPandre

• Jul 21st, 2008

For General Ledger - we assign a responsibility at SOB level. For all the Subledger Applications we use Operating Unit to be assigned to a responsibility. Ramesh Chandra Pandre

ramesh.nalem

 Profile Answers by ramesh.nalem Questions by ramesh.nalem

• Feb 19th, 2008

SOB level

Answer Question  Select Best Answer

What are the two different types of predefined profile options?

kesava.chunduri

 Profile Answers by kesava.chunduri Questions by kesava.chunduri

• Mar 11th, 2008

Hi Kishore,XML/BI Publisher gives the flexibility to users inorder to select the output type in EXCEL/HTML/PDF/FO, etc as per their requirement. If a User ran a report in PDF and wants to get the...

Answer Question  Select Best Answer

What are the journal enteries for Encumbrance Accounting?

darma

 Profile Answers by darma Questions by darma

• Dec 7th, 2007

Sql is a structure query language where as sql plus is a environment

aptitude

 Profile Answers by aptitude Questions by aptitude

• Dec 5th, 2007

At a time only one statement is executed in SQL whereas in PLSQL a block of statements are executed

Answer Question  Select Best Answer

Shaikh Mobin

• Nov 14th, 2007

Request some one to Correct me if wrong,The One way u can create Contract Through Service Request is by Following, Following Steps:1) Create an Condition Template for Contract Creation ...

Answer Question  Select Best Answer

Jagannath

• Oct 30th, 2007

There is no limit to it.

Answer Question  Select Best Answer

geethika

• Oct 12th, 2007

for GL ValidationsGl_code_combination_id SOB IDJournal SourceJournal CatagoreyCurrency CodePeriod NameCurrency Conversion Type

aniyanremo

 Profile Answers by aniyanremo Questions by aniyanremo

• Mar 7th, 2006

Hi Following are the Required Validations for Autoinvoice : ?          AR Transaction Type Validation : Check if the Transaction type provided in data...

Answer Question  Select Best Answer

Mobin Shaikh

• Oct 6th, 2007

Auto Invoices are also used in  Service Contracts as a concurrent Program namely "Auto Invoice Import Program". This program is Owned by Oracle Receivables. It imports the bil...

Vijay Akumalla

• Dec 8th, 2006

We can also import Invoices from Legacy systems. Not only invoices, but Credit Memos, Debit Memos, Sales Credits

Answer Question  Select Best Answer

Akash

• Jul 20th, 2007

11.5.10 having some advance functionality like web-based forms for some selective parts of SCM. and having form persoanlization facility to customize the oracle forms.as well as enhancement of demand planning in ASCP module.

knarender

 Profile Answers by knarender Questions by knarender

• Jun 27th, 2007

The difference is  11.5.10 is the updated version used for oracle 111i in manufacturing and supply chian management where as  11.5.9 is the older version for 11imanufacturing and scm.

Answer Question  Select Best Answer