-
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...
-
What is dunning letter?
chandra2001
- Jan 20th, 2009
Dunning is the process of methodically communicating with customers to ensure the collection of accounts receivable. Communications progress from gentle reminders to almost threatening letters as acco...
sdsmt
- Mar 20th, 2008
Dunning Letter: A letter which is sent to customers to inform about the past due debit items is know as 'Dunning Letter'
-
What are the i/p for pick release?
ashingeeks
- Apr 6th, 2009
Order Number -- Order Tab formWarehouse and Ship Locator --INVENTORY Tab form
mk
- Jan 2nd, 2007
Enter the order and book the order...maybe?
-
How can u see the global parameter values in the form without coding?
sajasand
- May 6th, 2009
You can access the Global parameter value by :GLOBAL. inside form PL/SQL Coding
Sandeep
- Sep 14th, 2007
Navigate to Help >> Diagnostics >> Properties >> Item Then you mention Object as Global variable, Object 4 as Global variable name you can get its value
-
After which stage we can not cancel the order?
velichetiraghav
- May 21st, 2009
We can cancel the order if it is in booked status, but cannot be cancelled once the order is Shipped...
k.R.Selvaraj
- Jun 4th, 2006
hiorder status has changed to shipped/interfaced/closed these orders only not able to cancelremaining all other order status are possible to cancelregardskrselvaraj
-
Name important tables from OE /AR?
velichetiraghav
- May 21st, 2009
OE_ORDER_HEADERS_ALL
nOE_ORDER_LINES_ALL
nWSH_DELIVERY_DETAILS
nWSH_NEW_DELIVERIES
nWSH_DELIVERY_ASSIGNMENTS
nWSH_TRIPS
nWSH_TRIP_STOPS
nWSH_DELIVERY_LEGS
nRA_INTERFACE_LINES_ALL
nRA_CUSTOMER_TRX_LINES_ALL
nRA_CUSTOMER_TRX_ALLsnehaniranjana
- Jul 6th, 2007
AR: Ra_customer_trx_all
Ra_customer_trx_lines_all
Ra_cust_trx_gl_dist_all
AR_payment_schedules_all
RA_cust_trx_types_all -
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...
-
What is the difference between Organization_id and Org_id ?
Adi_phaniK
- Sep 20th, 2009
Organization ID refers to a unique id of an inventory organization (mtl_parameters)Org_id refers to a operating unit (hr_operating_units)Below is the hirerarchy for your reference.Set of Books? |OU? |inv org? |sub inventory? |Locator
veersh
- Sep 27th, 2006
Organization_id is one of the column of inventory orgnization column(operating unit table column). But org_id is the profile value for Mo: Operating unit.When you open profilethru application develope...
-
What are _ALL tables in Oracle Apps?
Adi_phaniK
- Sep 20th, 2009
_all tables would be typically for transactions. it stores multi org information.
Eg: oe_order_headers_all ...stores information of sales order headers information of different OU's.
But oe_order_headers stores order header info of a particular OU (to which it has been set)neela manohar
- Jan 8th, 2007
_all tables will store information about multiple oraganizations. these table contain ORG_ID column that picks particular organizations from multiple organizations. _all tables will be created when we install multiorg.
-
List the key flexfields in AR?
Oracle_World
- Nov 24th, 2009
KFFs in Receivables (AR):- Sales Tax Location (code: MKTS)- Territory (code: CT#)You might also want to know the KFFs in ASSETS, which are:- Asset KFF (Code: KEY#)- Category (Code: CAT#)- Location (Code: LOC#)Hope it helps.Cheers!
Sridhar
- Jul 27th, 2006
There are 2 Kff's are there in AR1.Sales Tax Location FF-this is a mandatory one to implement2.Territory- its an optional one.
-
Single Inventory Organization
Is it possible to have a single inventory organization associated to Multiple Operating Units?If Yes, How can we query it from the database?
job4ronny
- Nov 28th, 2009
No, we cannot have single Inventory with multiple Operating units.Let us suppose if it happened then it wlll screwup material transactions. Material transaction will not be able to provide correct inf...
san1975
- May 29th, 2009
Once the item is assigned to an Organization, we can remove the same. It can be done thru Organization Item.. query for the item and make in "Inactive". Importantly it cannot be done by unchecking the Organization Assignment check box - Santosh Pandey
-
What is one full life cycle implementation?
parthm
- Dec 9th, 2009
Full life cycle implementation involves various cross functional team and Project management team working together through different PHASES of Oracle Application life cycle (case: Legacy system roll o...
hyddude
- May 2nd, 2006
Note: Please correct,if there are any mistakesFull Life Cycle means implementing a project from the begining to the production and maintenance stage.(1) System Planning: &...
-
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.
-
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 ...
-
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.
-
What is segment qualifier?
bharathpulluru
- Jun 17th, 2010
Qualifier means that behavioursegment qualifier means that it tells us abt behaviour of a segmentsegment qualifiers arefor company --- Balancing segmentDepartment --- cos...
mirunalinimiru
- Apr 24th, 2008
Segment qualifier are used to identify a particular segement within key flexfield
-
How AR & OE are related?
janacallsu
- Dec 25th, 2010
LINE_ID from OE_ORDER_LINES_ALL is stored in INTERFACE_LINE_ATTRIBUTE6 in RA_CUSTOMER_TRX_LINES_ALL
MK
- Dec 29th, 2006
AR and OE are related by the following keys:1. sales_rep_id (oe_order_headers_all <-> ra_salesreps_all)2. invoice_to_org_id, site_use_id (oe_order_headers_all <-> ra_site_users_all)
-
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.
-
Which table stores receipts information?
G M RAM
- Sep 21st, 2011
RCV_SHIPMENT_HEADERS
RCV_TRANSACTIONS
RCV_SHIPMENT_LINES
In case of any errors, i.e. if the receipt is not processed you can check in the below tables
RCV_TRANSACTIONS_INTERFACE
RCV_HEADERS_INTERFACE
PO_INTERFACE_ERRORS ( Reason its stuck in Interface)
velichetiraghav
- May 21st, 2009
RCV_SHIPMENT_HEADERSRCV_TRANSACTIONSRCV_SHIPMENT_LINESIn case of any errors, i.e. if the receipt is not processed you can check in the below tablesRCV_TRANSACTIONS_INTERFACERCV_HEADERS_INTERFACEPO_INTERFACE_ERRORS ( Reason its stuck in Interface)Thanks,Raghav
-
What are different report triggers and what is their firing sequence ?
There are five report trigger :· Before Report· After Report· Before Parameter Form· After Parameter Form· Between PagesThe Firing sequence for report triggers isBefore Parameter FormAfter Parameter Form Before Report Between Pages After Report.
Oracle Apps Basics Interview Questions
Ans