-
How to use Flexfields in reports?
There are two ways to use Flexfields in report. One way is to use the views (table name + ‘_KFV’ or ’_DFV’) created by apps, and use the concatenated_segments column which holds the concatenated segments of the key or descriptive flexfields.Or the other way is to use the FND user exits provided by oracle applications.
Diptiman Sengupta
- Apr 10th, 2008
Can use fnd.flexsql for retreiving data from the flex-fields in the report using lexical reference.
-
What is Ship-From/Customer Rules?Ship-From/Ship-To Rules? Ship-From/Customer Item Rules?
parthm
- Dec 9th, 2009
These are Global Scheduling Rules or Logistics Rules use for Scheduling the Order in Order Management.
-
How many templates use for oracle reports in oracle applications and what they are ?
Jay
- Jul 5th, 2006
There are 8 templates in Oracle Reports.1.Tabular 2.Group Above 3.Group Left 4.Mailing Label 5.Matrix 6.Matrix with Group 7.Form Like 8.Form LetterCheers!!!!!!!
-
What are the related set ups to be done for AP invoice approval?Can we set the approval hierarchy even for this?
Ashok
- May 19th, 2006
Firstly we need to raise an Invoice...To raise an invoice we need to fill the basic information in the Invoice Fom.Invoice approval can be done hierarchially.This can be done by a Technical Consultant who sets responsibility for approvals only to certain persons.
chinnamba03
- May 1st, 2006
Hi.. For Approving an invoice in AP we have to raise one invoice for raising an invoice we have some mandatory fields like supplier, supplier number, Payment terms, distribution sets, date...
-
-
Suppliers merge
At the time of suppliers merge if we choose None (Means all the invoices are not transferred) then how will you make the payment of old suppliers invoices?
vimalasridhar
- Mar 11th, 2011
We have to select "all" only then old supplier pending invoices, PO's data will be moved to the new supplier.and buyers can communicate to the new supplier details.
-
Advance pricing
What is advance pricing and how do you define it in oracle application
bakerkha
- Oct 30th, 2008
Oracle Advanced Pricing supports e-business applications by providing a flexible pricing engine that executes pricing and promotional calculations for Oracle Order Management and other Oracle Applicat...
-
Accrual Details
Hi,Can anybody tell from which table i can get the details of material receipt for which bill booking is not happened in AP.RegardsJothees Nair
Binuss
- Mar 31st, 2010
In RCV_TRANSACTIONS Table there is a field Invoice_status_code which shows whether invoice is made or not against the receipt.
-
Segment Qualifiers
Why should we have to give flexfield qualifiers for company and account segments?
menonsandeep1982
- Aug 20th, 2008
Segment qualifiers is the way off letting the system know how to for eg balance a company segment. Unless the system knows which segment is the company segment all reporting may not balance at the company level
-
-
-
OPMN Control Services
Which services will get started when we execute opmnctl.sh script in R12.2 compared to R12.1.3?
-
Order Management Process
In the Order Management Process, When does the pick status of a line become cancelled or how to set the pick status of a line as cancelled. (Please explain step by step as I am a beginner.)
-
-
How will u display message for testing the form u modified?
palanivelu_b@yahoo.co.in
- Apr 27th, 2006
fnd_message.set_string('test only ');fnd_message.show;--or fnd_message.error;
-
Can you have two accounting Flexfields in AR?
viren56
- Mar 13th, 2010
In MultiOrg Environment, we can have 1+7 set of books (SOB) and hence can have 1+7 Chartsof Accounts or Accounting Flex fields.
Nitin Kanwar
- Feb 9th, 2006
No. You cannot have more than one Accounting Flexfields for a Set of Books in AR. Accounting Flexfield defines a Chart of Accounts. Having 2 different Accounting Flexfield structure implies that they ...
-
-
How to attach reports in Oracle Applications ?
The steps are as follows :Design your report.Generate the executable file of the report.Move the executable as well as source file to the appropriate product’s folder.Register the report as concurrent executable.Define the concurrent program for the executable registered.Add the concurrent program to the request group of the responsibility.
krish_ORA
- Sep 21st, 2007
STEP- ONE: Register the application. STEP-TWO: Put Report in appropriate server directory. STEP-THREE: &nbs...
Kiran Kumar
- Jul 11th, 2006
Design your report put your file into product_top>version>language>file.name define executable define concurrent add to the request group run the report respective responsibility.
-
What is profile?
roycbe
- Mar 25th, 2008
During your implementation, you set a value for each profile option in your General Ledger application to specify how your General Ledger controls access to and processes data. Basically in a way...
Suneel
- Aug 4th, 2006
Profile is one of the option which is used to change the application based on value.
-
What is a FlexField ? What are Descriptive and Key Flexfields ?
An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization.
san1975
- May 29th, 2009
Descriptive FlexFields are the additional fields provided by Oracle Apps to store any Additional Information which cannot be captured elsewhere in the form. There are maximum of 15 Attributes available in 11i whereas 30 Attributes that are available in R12.
Abhilash Awasthi
- Apr 18th, 2006
A flexfield is made up of sub-fields or segments.. A flexfield appers on ur form as a pop-up window that contains a prompt for each segment.Each segment has a name and a set of valid values..Two types...
Oracle Apps Basics Interview Questions
Ans