-
What are special triggers created in the form when u register it?
Brajesh Singh Bhadoriya
- Jan 3rd, 2007
No special trigger created in the form when it is registered....the triggers mentioned is created only when one creates the master detail relation ship between two data blocks.....Thanks ,Brajesh
MK
- Dec 28th, 2006
Special triggers created by the system are:On-Check-Delete-MasterOn-Populate-DetailsOn-Clear-Details
-
What are chargebacks?
sdsmt
- Mar 20th, 2008
Chargebacks: A new debit item which we assign to a customer while closing a existing, outstanding debit item is known as 'Chargebacks'.
Gopichand
- Oct 7th, 2005
Chargeback refers to closing the original Transaction that has become overdue and raising a new transaction in its place.
-
-
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.
-
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?
-
-
Difference between Key and Descriptive Flexfield?
Key Flexfield Descriptive Flefield1. Unique Identifier 1.To capture extra information2. Key Flexfield are stored in segment 2.Stored in attributes3.For key flexfield there are flexfield Qualifier and segment Qualifier 3. Context-sensitive flexfield is a feature of DFF. (descriptive flexfield)
-
-
Open interfaces in oracle application 11i module wise?
selvan.shree
- Apr 14th, 2008
gl1)gl_interface2)gl_budget_interfaceRa Customer1)ra_customers_interface_all2)ra_contact_phones_int_all3)ra_customer_profiles_int_allRa Invoices1)ra_interface_lines_all2)ra_interface_distributions_all...
aukumar
- Oct 29th, 2006
For POs:Purchasing Documents Open Interface1. PO_HEADERS_INTERFACE2. PO_LINES_INTERFACE3. PO_DISTRIBUTIONS_INTERFACE4. PO_INTERFACE_ERRORS (for recording purchasing validation errors)For Receiving:Rec...
-
What are Oracle Apps API?
Where APIs are physically store? n What is the latest version of API?
Diptiman Sengupta
- Apr 10th, 2008
The APIs are stored in the Database Server. You would be able to view them if you list the procedures, functions and packages under a particular user.
Diptiman Sengupta
- Apr 10th, 2008
They are Application Program Interfaces, which are standard stored procedure, package or functions created for performing specific activities in the Oracle Apps E-Business Suite.Ex: The Order Import API when called would create orders corresponding to the record in the Order Interface tables.
-
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)
-
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
-
What are forms customization steps ?
The steps are as follows :· Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us.Put it in custom directory. The libraries (FNDSQF, APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached .· Create or open new Forms. Then customize.· Save this Form in Corresponding Modules.
Brajesh Singh Bhadoriya
- Feb 13th, 2007
To upload a form in a particular directory you have to use Unix box for the same. Put the form in home directory thru FTP, then to copy form from home directory to the custom directory like CS_TOP you...
swarna
- Feb 4th, 2007
how to Copy the form into respective custom top as INV_TOP?
-
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: &...
-
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
-
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 -
Is the accounting entry different for Credit Card Transactions or normal Invoice - Payment transactions. If so, how?
menonsandeep1982
- Aug 20th, 2008
When you complete an invoice schedules are created in ar payments schedules all and the transaction distributions are elgible to send to GL
menonsandeep1982
- Aug 20th, 2008
A credit card order is same as any other order for accounting. i.e. DR Rec CR RevBut the receipt process can be different depending on ur clients requirements to categorize remitted receipts and clear...
-
What is the difference between spfile and pfile?
Cadie_H
- Aug 10th, 2008
An spfile and a pfile are both init parameter files.The pfile is a readable text file which you can edit directly in Notepad (Windows) or vi (Unix). The pfile's name is initSID.ora.The s...
suvashnaidu
- Aug 7th, 2008
Sfile is text file spfile is binary fileIt can be maintained using a standard operating system editorspfile is maintained by the Oracle Server.
-
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
Oracle Apps Basics Interview Questions
Ans