Thursday, June 24, 2010

Oracle Apps Interview Questions

Oracle Apps Technical Interview Questions

1. Sand Pile Dimensions What are the criteria to decide the depth and diameter of a sand pile?

2. What is Journal Import.How do I import vendor info into purchasing.
Ans.  Journal Import is the program is used to import the data from the Interface table to main table.      
                               
Interface Table :
GL_INTERFACE

Base Tables :
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_BALANCES.

3. ONT and PO What is the table column link between ONT and PO?
 Ans.   In the ONT table OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF is matched with the Requisition Table PO_REQUISITION_HEADERS_ALL.SEGMENT1 for Internal Requisition Type only(STOCK Transfer)

4.  RFQ Tables What are RFQ tables? What is the relation between RFQ and Requisition, RFQ and Quotation?
Ans.    Flow of PO module:

Requisition
  |
RFQ
  |
Quotation
  |
Purchase order

Requisition
It is prepared by emp wheneve emp needs the goods
In this we have 2 types
Internal: within org
External: from outside

Tables are :
po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all
RFQ
Once req is approved..we will prepare the rfq doc which will b delivered to the customer.supplier will respond for that with quotation

Quotation
It is a doc we receive from the supplier which contains supplier code details

Tables are:
po_headers_all
po_lines-all

5. Concurrent program :How many Parameters can pass to Concurrent Program
Ans. 100 Parameters are permitted from back end (FND_REQUEST.SUBMIT_REQUEST) and from front end as well.

6.  Inventory :How to restrict the item in INV?
Ans. In the Master Item creation form
|
Under Inventory Tab
|
Uncheck the check box called "Inventory Item"

7. Difference between Oracle 11i and R12
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

Ans. 
1) Oracle Purchasing Release 12.0 speeds up daily purchasing tasks with an enhanced Professional Buyer’s Work Center. Based on the latest web-based user interface models, the Work Center is a central ‘Launch Pad’ from which buyers can efficiently perform their daily tasks:
1. View and Act upon Requisition Demand
2. Create and Manage Orders and Agreements
3. Run Negotiation Events including Auctions and RFxs (requires Oracle Sourcing)
4. Manage Supplier Information
2) In Release 12.0, Oracle Purchasing will leverage the new Multi-Org Access Control capabilities to support more streamlined operation of Shared Procurement Service Centers. Without changing Responsibility, and without closing windows, buyers will now be able to view consolidated requisition demand spanning multiple operating units. Using a single Responsibility, they will be able to manage demand (i.e. requisitions), conduct sourcing events, enter into agreements and issue purchase orders on behalf of any of the operating units that they serve. The operating units that they can transact on behalf of will be controlled by the security profile associated with their responsibilities.
3) In Release 11i10, generation of purchasing documents in Adobe PDF format required organizations to create layout templates in the form of XSL-FO style sheets. With Release 12.0, organizations can also use RTF or PDF layout templates which require little training to configure and maintain.
4) Oracle Purchasing supports various types of file attachments (MS Word, Excel, PDF etc.) that can be appended to purchasing documents in addition to long and short text attachments. In previous releases, only text attachments were communicated to suppliers. With Release 12.0, buyers can communicate all necessary attachments to suppliers, including file attachments via email.
5) Release 12.0 allows finer control of how blanket agreements are enabled for automatic document sourcing. Buyers can now choose to enable them only in specific inventory organizations. Thus, buyers can negotiate a blanket agreement to fulfill requisition demand for a subset of inventory organizations and enable the agreement for autosourcing only in those inventory organizations.

8. Oracle Apps process of item conversion and interface tables Hi! Any one can you send me the details and process of item conversion?
1.What are the interface tables in item conversion?
2.What are the base tables in item conversion?
3.what are the validations and what is the standard program in item conv.?

Ans.

Interface tables involved in Item COnversion:
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
MTL_ERRORS_INTERFACE

Base Tables:
MTL_SYSTEM_ITEMS
MTL_ITEM_CATEGORIES

Standard Import Program name: Item Import (INCOIN)
This program does most of the standard validations.

9. Once we receive the material what is the entry in Oracle Apps APOnce we receive the material what is the entry ... in AP? whether system ll automatically cleared.. or ll we create manually

Ans. Invoice

10. how to handle ' , ' in the data of csv filehey...if any of the fields in sql loader script.. eg.. empname is Jain,anisha then how can we handle this ' , ' in Jain,anisha while using csv file in a sql loader

Ans.  One needs to enter the value with double quotes like "Jain Anisha" to all the values so the comma can be stored in the columns.

11. What are the manadatory user exits in Oracle Apps Reports?

Ans.  See there are 2 mandatory User exits in Oracle application Reports.
SRW.USER_EXIT( 'FND SRWINIT')
srw.user_exit( 'FND SRWEXIT' )

12. What are the manadatory parameters in Oracle Apps Reports?

Ans. P_CONC_REQUEST_ID is one of the mandatory parameter.

13.  why we register a table in apps schema? why we register a table in apps schema by using ad_dd.register_table procedure

Ans. We register a custom table in the custom schema. Then give all permissions to APPS schema. Reason being when stored procedures or functions are written to perform DMLs on the custom table it is done from APPS schema.

14. second parameter should depend on first parameter when i am running my report in apps i have to pass two parameters second parameter should be depend on first parameter. and in first parameter it consist two list of values
ex:1. approve 2. in process
when i pass approve in first parameter then second parameter should be enable and when i pass in process second parameter should be disabled. How this can be possible . i would appreciate if u people suggest correct answer.
 Ans. second parameter should depend on first parameter because we have to specifie the parameters according to the required range. So what ever paremeter we specified first according to that we have to specifie second parameter so thats why second parameter should depend on first parameter.
15. what is visual attribute

Ans. Visual attributes are the font color and pattern properties that you set for form and menu objects that appear in your application's interface.

16. SOB (set of books) Level what are the Modules we will Maintain at SOB (set of books) Level?

Ans. Set of Book is used in GL module alone
 17. FND Table: Who is the owner of FND_TABLES and Why we shouldn't create table in APPS Schema?

Ans.  APPLSYS is the owner of FND tables.
APPS schema contains the package code for all the E-Biz products.
and needs to be kept secure.
So we can't create tables in APPS schema if we want to make use of them in our custom code.

18. Flex FieldsWhat are Flex fields in Oracle Apps Technical? What is different between Flex Fields and User Parameter.What r types of Flex Fields?

Ans. Flexfield is a field on which capture varying length of data.A flexfiled is a field made up of segments.each segment has a name & set of valid values.
two types of flexfield
1. Key flexfield(KFF)
2.Descriptive flexfield(DFF)

19. What is an Extension in Oracle Applications and What are the steps to implement Extensions?
Ans .
An extension is a custom development which satisfies a business need which is not available in oracle apps.
If any Oracle Apps. module does not cover or does not have functionality to satisfy a customer requirement then an extension is carried out.
For example if you like to see the customer wise invoice no. and amount in AR which is not present in Apps. standard forms then you can develop a new form to satisfy this need. (But it is available actually)

Steps to implement extensions are
1. Try to solve the customer requirement with out any extensions if possible.
2. Create new tables forms and other database objects as per requirements.
3. register all the forms reports in the concerned modules.
4. If the extension is larger then go for a complete custom module. for example if you want to extend some functionality in GL module then go for a custom module XXGL with out customizing the GL module itself.
(You can refer Oracle Apps. developer document for more information)

20. What is the difference between independent valueset and translatable independent value set

Ans. The difference between the indepedent and translatable independent value set is that in Trans inde val set u can change the value (Translate the value) while setting the values of this type.but in Independent value set whatever value u give automatically the translated value will be the same.it wont allow you to cahnge.the advantage is like you want user to see the value ICICI HDFC HSBC(for example) where as you are actually passing values like 001 002 003 etc...i hope you got my point.
 
21.  What is the table column link between PO and AP ?

Ans.  If the Iinvoice Distribution is matched to a Purchase Order then
ap_invoice_distributions_all.PO_DISTRIBUTION_ID is the link to po_distributions_all table


22. what is the interface error table for order management
Ans. oe_interface_errors_all

23.  What is R2R Cycle in Apps?
Ans.  R2R stands for Record 2 Report i.e. Record Jounal entries in the General Ledger and Report to the Financial Managers using reporting tools such as hyperion.
Below modules come under R2R cycle
1) General Ledger
and below could be part of R2R cycle as well.
2) Financial Consolidation Hub
3) Enterprise Planning and Budgeting.

24. What will happen if we dont get template.fmb when developing a form?
Ans. This form is the starting point of all development involving forms. It contains some special libraries and triggers that render the application using the template form some standard characteristics.
Hence the template form comes along with many attachments predefined program units and defined visual attributes as well as examples that not only give the forms that are developed using the template.fmb a standard look and feel but also make it easier to develop forms with consistent and standard functionality.

25.  How do you configure the system to send notifications to the userid instead of email
Ans.     NO ANSWER  AVAILABLE

26.  Explian about p 2 p cycle
Ans. p2p cycle (procure to pay cycle)
there r certain steps involved in p2p cycle
1. a requision is raised
2. rfq i.e request for quotation is made
3.then the rfq is send to the list of suppiers.
4. the quotation comes in and the best quotation is selected
5.then p.o is generated against that quotation
6.then the product is been supplied by the supplier
7.then the invoice is been made
8. then recieving reciepts r done.
9. later all the transaction r done in general ledger in the new books of accounts

26. Explain about functional flow of the project accounting, the actual setup steps for the total flow of the PA
Ans.     NO ANSWER  AVAILABLE

27. What is cost allocation in HRMS?
Ans. Cost allocation is a flex field in payroll

Ans. Common values passed by procedures in variable (ERRBUFF and RETCODE) are:

ERRBUFF : SQLERRM;

and

RETCODE : ERRCODE;

29. What access levels should be used, when we customize an existing workflow and when we develop a new workflow?
Ans. Existing Workflows are generally protected at level 20 so you have to level 20 to customize existing workflow process. Any custom development should be done at level 100 or above

30. What is a segment qualifier and how is it set for the segments of a KFF ?
Ans. Segment qualifiers contain information about a value rather than the segment that uses the value.

After you have saved your segment qualifier values the values for your segment qualifiers appear in the Qualifiers field in the main window. You can click in the
Qualifiers field to bring up the Segment Qualifiers window and see the qualifiers.

Eg:-For the Accounting Flexfield.
The Allow Budgeting Allow Posting and Account Type fields are segment qualifiers for the Accounting Flexfield.

31. What is the purpose of CV10 document?
Ans. CV010 documents contain Data Conversion Requirements and Strategy information.

32. Why is my Purchase Order closing before a receipt is processed?
Ans. If the invoice approval matching is set to the 2-way matching then the PO will close as soon as it approved

33.  The information setup in the Purchasing Options form is not defaulting on to my purchase order form? give me the possible reasons.

Ans.

34. Where do you use parameterized cursor in oracle apps? Explain with real-time example?
Ans. Parameterized Cursors are frequently used when picking the data from master -detail tables .(Generally in interfaces) Or the same table with header as well as line information

cursor c1 is select a from dummy1;

cursor c2(v_variable number) is
select b from dummy2 where
a v_variable

I hope it is clear...


35. What is an API & what is the sequence of events that happens after calling API ?
Ans. API is nothing but application program interface.
when we call an API first of all it will check the validations for the data(validations u can see in the API) that u are inserted through API if the validations are successful the n it will insert data into the base tables.

36. What is the difference between parameter passing by reference and passing by value.
Ans. IN parameter and IN OUT Parameter are the parameters can be passed by reference or Valur whereas OUT parameters are passed by value.
 
36. How do you find the output of a concurrent program is in character mode or in bitmap mode?
Ans. Go to concurrent program define window and see the output style if its text means character mode or it's in PDF means bitmap.

37. 1.How to create concurrent program with out system administrator responsibility from front end.?

2.How to call one concurrent program from another concurrent program?

Ans.  We can define concurrent program with application developer responsibility also.

We can all another conc prog from one prog using fnd_request.submit_request api

38. How many max parameters are allowed in concurrent program?
Ans.  Maximum 100 parameters for PLSQL procedure executable concurrent programs.

39. What is the difference between sales order and invoice?
Ans.  Sales order is list of material that a customer is buying from a comapny having useful information as such order no customer information.
Invoice is defined as bill for any purchase.
 
40. Is there any inbuilt interface programs in the Oracle financials? If the answer is yes , list all interface programs for all modules? Why we are creating interface programs even there are inbuilt interface programs?

Ans.

41. What is procure-to-pay cycle in oracle applications?
Ans. Hi all Procure 2 Pay -> 1. Procure and Pay2. This is a cycle starts with Procure and ends with Pay 3. Procure - PR(Purchase Requisation) > approval PR > PO(Purchase Order) > Approval PO > generated PO goes to approved Supplier > get the item into the INV (Inventory).4. Pay - Make the payment against invoice in AP(Acount Payables).

42. What is the difference between standard and open interfaces?
Ans.  Standard and Open interfaces are same.
Interfaces can be classified as standard or open and custom interface.

43. What is the function of TOKEN in concurrent program window?
Ans. Token is nothing but a interface between report builder parameters and concurrent program parameter.
Report bulider parameters are not in sequence. that is why we combine with token .
44
. What are the standard programs for Oracle GL,AP,PO modules open interfaces?
Ans. PO- Import Standard purchase Orders
GL- Journal Import
AP- Pyables invoice Import

45. Is it mandatory to use the user exist in Apps. If so why..(May i know the functionality)
Ans.  No it is not mandatory to use SRW Exits or User Exits for reports or forms in Apps the main intention of using User Exits is when we want to do the computation or calculations or perform some functions apart from oracle say suppose we have a DLL coded in VB or VC then we need to use the user exits.
the main intention is to pass the control while still keeping the session alive to outside third party tool other than or to any other oracle functions.
one of the best functionality used is while preparing reports based on account codes or reports where we print chart of accounts along with individual entries of accounts. here we call the srw exit for FND FLEXSQL and FND FLEXIDVAL both these functions are AOL functions are are specifically used to pass the control out of the current report go to the chart of accounts of the Buisiness group level and find the relevant entires against the account code of present in the chart of accounts present in the SOB of that organisation unit.
other wise we do have normal reports where we donot use user exits.


46. What is meant by ERP?
Ans.  ERP Stands for Enterprise Resource Planning . it is a customized s/w whcih is develop as per requirement of organization.

 47.  How to register a table or view or synonym from backend?
Ans.  use ad_dd.register_table to regiseter tables.
ad_dd.register_column to register columns of that table
we can also use
ad_dd.delete_table to unregister tables.

48.  What are the ways of creating multi-org views apart from using adaadmin utility
Ans.

49. How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.

Ans. Use Base table instead of multi-org table. Mean to say...
use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.

50. What are the changes 10.7 to 11.5.9?
Ans.  Navigation Changed for all the modules
Feel & look is chnaged.
Email notification is enabled in 11.5.9
Extra Forms are added to the modules for the ease understanding for the users
Many DFF's are enabled in the updated version
New KFF's are added to the existing list
List of standard reports are added to the exiting.
Very much web enabled.
Attachments concept is introduced.

51.  What is API? How we use it?
Ans.  API - Application Program Interface
It is an inbuilt PL/SQL coding which explains the particular functionality which interfaces legacy to Apps.
We use it by running the concurrent program; executable as one of the concerned API.

52. What is the difference between D2K Reports and Oracle Apps Reports?
Ans. Differences between D2k Report and Apps Report
(1) in D2k Report there is no fecility to schedule the program where as in Apps report we have that fecility
(2) in D2k Report we can't use User-Exits where as we can use in Apps Report... to add dff values and diff currencies.
(3) when Compare to D2k Report in Apps report we can have more fecility to give out put in Fonts and formats.

53. What is quote to cash cycle in oracle? what are the modules that are covered here?
Ans. Quote to cash cycle will essentially have
1. BOM
2 Inventory
3. Order entry (OE)
4. Order Managemnet (ONT)
5. ASO (Order Capture)
6. WF (workflow )

54.  Tell me about TCA(Trading Community Architecture)?
Ans.  TCA API's brought a fresh approach to standardise DML's in Oracle Apps. I think this is one of Oracle's best written modules in APPS but the flaws that exist are primarily because Oracle developed TCA a bit too late after the other modules like Payables Receivables etc. What is TCA TCA stands fortrading community architecture. As the name suggests any business with which a company does or did trading or can potentially do trading in future can be in Oracle TCA. With whom can we possibly trade with in Oracle Applications? To name a few....
1. Customers - We sell our products/services & bill customers using Order Management & Receivables

2. Suppliers - They sell us their goods (PO & iProc) and we pay their
Payables invoices in Oracle

3. Employees - These can be special customers or pseudo vendor if they even
sue you as you make them payment.

4. Banks Banks - can be paying us interest or charging penalties or selling
us products.

5. Insurance Company - This is Interesting. When you buy their policy you become their customer. However when you make a claim
they become your customer (as you get paid).

6. Students - Even more interesting than 5 above. They are your customers as you would bill them. They can become your staff latter. Or they can become your vendor if they become independent contractor latter by selling their services to you. Even more they can become your student again (for post-grad) after resigning as an employee.

55. Can we add independent value set to the DFF?
Ans. Sure we can use the independent vlaue set to the DFF

56. Can anyone give the entire life cycle of CRM?
Ans.  No Answer Available

57. Complete Auto invoice interface information?
Ans. AutoInvoice is the interface where Customer Invoices are generated. Source of Invoices is Order Management, PA.
Interface tables: ra_interface_lines_all. Table stores Invoice Line level details.
Ra_interface_distributions_all. Accounting distribution of each invoice.
Once records are inserted into ra_interface_lines_all, run the Autoinvoice interface from AR. If any errors occur, it can be found in ra_interface_errors_all table. The concurrent has 2 stages. First the Master program fires which intern kicks of Import Program. Once this is completed, data is inserted into the following tables.
1) ra_customer_trx_all (Invoice Header Info)
2) ra_customer_trx_lines_all (Invoice Line Level Info)
3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for each Account Type is inserted into this.. ex. Receivable, Revenue, Tax, Freight etc)
4) ar_payment_schedules_all (All Payment related info)

58. If I stopped the concurrent manager, then where and how I can see that concurrent manager is stopped or not??
Ans.  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.mgr
Oracle Apps DBA Xpert


59. How to create Structure2 in KFF? But Already Structure1 is Used. KFF is Collection of Structure1,structure2..,Structure is Collection of Segments. Segments is Collection of Value Set. But My Question How to Use Structure2 in KFF? Can I use the Same KFF - Code No in Structure2.
Ans. You can create any number of structure for a KFF. In a Structure u can have 30 segments.If you wanna create a new structure and use that structure for your KFF follow the following steps.1. create a new structure for your KFF.2. Goto Organization definition screen and query for your BG. 3. In you BG you will see a classification called Business group. Click on that and select others->*Business Group Info.4. Here map your KFF and the structure to use.Hope you got it.

60.What is the difference between Quick Pick and Quick Codes?
Ans.   Quick Pick is variable because it selects values from user-defined tables.
  Quick Code is static & it selects values from system table called FND_LOOKUPS. Quick Code is faster then Quick Pick because it uses internal CACHE.

61. What is Data Migration and what is Conversion?Whats the difference between both?
Ans. Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA) validating it and converting it to ur our the target module using the standard import program.
62. I want to know what is the column link between OM and AR and also the link between AR and GL?
Ans.C olumn link between OM and AR You have customer_id in AR table and
sales_to_org_id in OM.using these mentioned columns we can link.

63. Tell me the difference between Conversions and Interfaces.Give example?
Ans. conversion means one time activity
interface means periodic activity
example:- to transfer the data old version to new version it is called conversion
to transfer the data from staging table to interface table it is called
interface it is process on every day or every hour ........

64. Can someone give an example of loading data from a control file for AR Lockbox.
Ans. No Answer Available.

65. How can we tell the difference between seeded tables, static tables and the main transaction tables?
Ans. Seeded Tables - Fnd_table name are the seeded tables in apps
Static Tables - Static tables are one that are updated using some scripts or triggers.
Transactions tables - Tables that link the trasactions between modules (Eg: PO & AP) or Tables in which a transaction data gets stored.

66. a. Can someone please tell me what is the date tracked option and how to use it?
b. Can I delete an employee from a table?
c. What is the difference between APIs and DataPumps?
d. What are user hooks?
e. Can we see the time stamp also with the "from" and "to" dates?

Ans.   a. Can someone please tell me what is the date tracked option and how to use it?

If the table had effective_start_date and effective_end_date columns then its called date tracked table. e.g. in a person table per_all_people_f it tells us when the person started and ended his employent with a company. if he is still an employee then effective_end_date 01-Dec-4712 for tht employee.

b. Can I delete an employee from a table?

you can but this is will end ur support licence. Oracle suggest that u never touch these shipped tables. its never practised by developers at all. BEWARE.. never do this.

c. What is the difference between APIs and DataPumps?

API are plsql procedures which insert data based on some validations.API's also do a host of other activities.Donno abt data pumps in detail..sorry..

d. What are user hooks?

No Idea..

e. Can we see the time stamp also with the from and to dates?

No u cant see time stamps. tht concept is not used in Apps. Only DD-MON-YYYY is available

67. Give me the details of Positive pay file for bank report?
Ans. No Answer Available.

68. When form builder open which trigger will fire first and last?
Ans. When first open the form the first trigger going to be fired is PRE-FORM TRIGGER and last trigger is POST-FORM TRIGGER

69. Which module is not a multiorg?
Ans. GL is the perfect answer GL Operates at Set of Books level and not at the operating unit level. This is purely dependent on set_of_books_id and not the org_id. Where as AP PO AR etc operates at Operating Unit Level and are purely based on org_id.

70. How to submit concurrent program through pl/sql?
Ans. fnd_request.submit_request(parameters) by using this we can submit the concurrent program thru pl/sql.

71. Can Any body explain me how to use the following user_exits in apps reports which have flex fields as display/query columns.

Ans.  FND FLEXSQL - This user exits allows you to use Flex fields in Reports
Call this user exit to create a SQL fragment usable by your report to tailor your SELECT
statement that retrieves flexfield values. This fragment allows you to SELECT flexfield
values or to create a WHERE ORDER BY GROUP BY or HAVING clause to limit or
sort the flexfield values returned by your SELECT statement. You call this user exit once
for each fragment you need for your select statement. You define all flexfield columns in
your report as type CHARACTER even though your table may use NUMBER or DATE or
some other datatype.
Syntax:
FND FLEXSQL
CODE flexfield code
APPL_SHORT_NAME application short name
OUTPUT : output lexical parameter name
MODE { SELECT | WHERE | HAVING | ORDER BY}
[DISPLAY {ALL | flexfield qualifier | segment number} ]
[SHOWDEPSEG {Y | N} ]
[NUM : structure defining lexical |
MULTINUM {Y | N} ]
[TABLEALIAS code combination table alias ]
[OPERATOR { | < | > | < | > | ! | || |
BETWEEN | QBE} ]
[OPERAND1 : input parameter or value ]
[OPERAND2 : input parameter or value ]
e.g-
SRW.USER_EXIT('FND FLEXSQL CODE MSTK NUM :P_STRUCT_NUM DISPLAY ALL
APPL_SHORT_NAME INV OUTPUT :P_ITEM_FLEXDATA MODE SELECT TABLEALIAS msi ');

FND FLEXIDVAL - This user exits allows you to use Flex fields in Reports
Call this user exit to populate fields for display. You pass the key flexfields data retrieved
by the query into this exit from the formula column. With this exit you display values
descriptions and prompts by passing appropriate token (any one of VALUE
DESCRIPTION APROMPT or LPROMPT).
Syntax:
FND FLEXIDVAL
CODE flexfield code
APPL_SHORT_NAME application short name
DATA : source column name
[NUM : structure defining source column/lexical ]
[DISPLAY {ALL| flexfield qualifier| segment number} ]
[IDISPLAY {ALL| flexfield qualifier| segmentnumber} ]
[SHOWDEPSEG {Y | N} ]
[VALUE : output column name ]
[DESCRIPTION : output column name ]
[APROMPT : output column name ]
[LPROMPT : output column name ]
[PADDED_VALUE : output column name ]
[SECURITY : column name ]

72.  What are the different types of Value sets and expalin them briefly which value set will use when?
Ans.  The valueset are like how we define constraints in Oracle Database. In oracle Apps there are six value sets
Independent - The Value which we provide to the Segments are independent (Ex. Company Segment - 01 02 03) (Ex. Primary key)

Dependent - The Value which we provide to the dependent segments are depends upon some other value set. (Foreign Key). Ex. Major Segment is Independent Minor Segment is dependent segment which depends upon Major Segment. (Ex. Computer - Major Segment)(Mouse Keyboard - Minor segment (Depends upon Computer). To provide value to dependent segments always depends upon some other values.

Table - The value for these segments will be retrived from some tables in the database.

Special - These value set are used for reports paramaters. The Special is always used for Report Parameters where the parameters are the values from Key Flexfield.

Pair - Same has special but have low and high values.

73. What are the different types of value sets and also explain each briefly ?
Ans. There are 4 types of valu sets
1> Dependent Valuset
2>InDependent Valuset
3> Table Valuset
4> Dependent Valuset with table
5> InDependent Valuset with table

74. What is a request Sets? How to create a request Set?
Ans. Request sets define run and print options and possibly parameter values for a collection of reports or concurrent program.... End user & System Adminstrator can definerequest sets.
By Creating Request sets u can submit the same sets of requests regularly using a single transaction.
You can create request sets by using request set Wizard.


75. Discrete Job Pick List Report from PO module?
Ans.  No Answer Available.

76. What is the RFQ Report from PO?
Ans. RFQ-reques for quotation
in purchase module-if company have internal supplier then company will issue rfq else company will issue rfq so that supplier can send their quotation.forpurchase order

77. What are the types of Concurrent Managers?
Can we delete a Concurrent Manager?
Ans.  There are many concurrent managers each monitoring the flow within each apps area.
but there are 3 MASTER CONCURRENT MANAGERS:
1. Internal Conccurent Manager (ICM): This is the one which monitors all other CMs
2. Standard Manager (SM) : This takes care of report running and batch jobs
3. Conflict Resolution Manager (CRM): checks concurrent program definitions for incompatability checks.
We cannot delete a concurrent manager... but we can disable it... but it's not recommended.

78.What does US mean in appl_top/au/11.5.0/reports/US?
Ans.  US is the language directory specifying that the source files to be placed under this dir is for English/American Language
This is the standard of apps directory structure that for very language you implement oracle apps there should be a language specific folder
So if you are implementing oracle apps lets say for UK as well as France then your source directories for oracle reports Forms and htmls will have subfolder US and F for English and French source files respectively .. something like --
APPL_TOP (/appl/v1100000)
|
XXCUS_TOP (/appl/v1100000/XXCUS)
|
------------------------------------------------
| | | | | | | |
bin forms html lib log mesg out reports
| | | | | |
US F US F US F

79. Can anybody suggest me how can the multi org. be set up?
Ans.  Multi-Org can be setup/installed by adadmin utility provided by the Oracle. adadmin will create the _ALL table and appropriate views (single org views) which can then be used to view the data for specific operating unit to which your user/responsibility has access to!

80. How can I incorporate a lexical parameter in my report for having the FROM DATE and TO DATE parameter?. Can you Pls let me know of the steps involved in doing the same?
Ans. To use a lexical parameter in the query of your data model prefix it with a '&' (ampersand)
example SELECT ename FROM emp WHERE &lp_lexical_val
The value of p_lexical_val may be set in the code in a trigger etc. as follows:
:lp_lexical_val : 'empno 1111';
or
:lp_lexical_val : 'empno '||:p_input_val;
where p_input_val may be a report input parameter.

81.  How do you create custom program for chargeback,I tried with the API ,arp_process.crate chargeback,but its not working,any other method or suggestions to do this.
Ans. ARP_PROCESS_CHARGEBACK CREATE _CHARGEBACK IS THE API u need.
there are around 42 parameters in which 2 are in params and 2 are inout params.we have done the similar thing once..i am sure it will work procided u have populated the columns properly

82.  What is integration between modules?What modules in Order management can be integrated with Finance modules ?How this integration is done?
Ans. orader mangemnet is integrated with finance AR (accounts receivables)
for creating the invoice for the products delivered.
order mangement is also integrated with Inventory for inventory transations of the item.
and Purchasing in case of drop shippment.
83. What is an Invoice ? How many types of invoices are there in AP and AR ?
Ans. A invoice is a Document created whenever a product or service are sold. And if the sale is made on credit the invoice remains open in the Receivables Module utill the Funds for it are received . And once the Funds are received the invoice is closed with the receipt .
There are 9 types of Invoices in AP : Standard Credit Memo Debit Memo Prepayment Withholding Tax Mixed Invoice Expense Report PO default and QuickMatch.
There are 6 types of Invoice in AR : Invoice Credit Memo Debit Memo Chargeback Deposit and Guarantee.
84. What are different types of Journal entries ?
Ans. A Debit or Credit to a General Ledger Account is called Journal Entry...
Types of Journal Entries:-
1) General Journal Entry.
2)Recurrning Journal Entry.
3)Mass Allocation Journal Entry.
4)Reversing Journal Entry.
85.  What are User Exits and what are different types of User Exits in Oracle Apps ?
Ans. User exit are programs thats enables you to execute external procedure.
5 types of user exit are there in APPS.
FND SRWINIT--Used to set the profile option and environment vallue.
FND SRWEXIT--Used to release the profile option and environmental value
FND FORMAT_CURRENCY--Used to format the currency dynamically.
FND FLEXIDVAL--Used to populate the fields for display.
FND FLEXSQL--this user exit is called to create a SQL fragment usable by your report to tailer your SELECT statement that retrives FLEX FIELD value.
86. What is FlexField?
Ans. A Flexfield is used to capture information about Your organization. Flexfield have flexible structure for storing key(main) information. Like Company Cost Center and Account. They also give u highly adaptable Structure for storing customized information inoracle Applications.
2types of flex fields are
1.key flex field:is collection os segments.and used to enter key information abt ur org.
2.descriptive flex field:collection of attributes and used to enter extra information abt ur organization.
87. What is the use of CUSTOM Library in Oracle Apps?
Ans. Custom Library allows extensions of oracle application modules with out modifying module code
Custom Library can found in $AU_TOP/res/plsql directory.
After designing & Developing u must replace ur code in custom library.
After ur code has been written u must compile & Generate the library using oracle forms on the application server ( not the development machine ) & place in $AU_TOP/resource directory.
.plx (executable code) is created when u generate .pll (librarary code) when u generate a library using the forms generator COMPILE_ALL parameter set to ' YES ' .
88. What can we find TEMPLATE.FMB file ?
Ans.  Template.fmb file can be found in AU_TOP resource directory. This file contains all the Common characterstics all the forms. And also Contains Diffrent libraries. like CUSTOM.pll APPCORE APPCOREE2 FNDSQF JE JL JA VERT GLOBE etc.. And Template.fmb cotains Diffrent propery classes for all the objects. This Template.fmb can be used for developing the new form.
89. What is Multiple Organization technical architecture?
Ans. Multi Organization :Using a single installation of any oracle application product to support any number of an organization even it has different Set Of Books
Bussiness Level(It Secures Human TransactionInformation)
||
Set Of Books(It secures all Transaction Information In Oracle Genral Ledger)
||
Leagel Entry(All leagal Information in the Organization)
||
OPerating Unit(It Uses Order management Cash managment AR AP...it may be Sales Office Division Department)
||
Inventry Organization(Inventry Details)

90. How to register tables and columns in AOL?
 Ans. To register the table and columns in AOL the navigation is:
Open Appliaction Developer---> Appliaction--->Database--->table.(In table mention the table name(which you want to register) user table name columns user column name).

The table & columns which you are going to register should be present in your module specific schema.

91. What is Set of Books ? What are the four conditions when you change your SOBs?
Ans.  SOB are the legal entities are used to define the profiles for a responsibility.
For defining the SOB you need 4 conditions.

1. Chart of Accounts
2. Calendar
3. Currency
4. Retained Earnings (Mandatory)

92. What are different period types ?
Ans. Year Quarter Month & Week
93.  If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Ans. WE CAN use multiple tables in table value set in table field we can use the tables and must give the alias names for the tables and in where clause write the join conditions
94.  What are the libraries attached to TEMPLATE form ?
Ans. Hi there are 18 standard plls used by TEMPLATE.fmb
u can find thwese with any VISION installation

95.  What are the steps in Customer Interface ?
Ans. Insert the customer details viz. name country ship to address bill to address etc into ra_customer_interface_all table. Then run the customer interface program to import the customers.
96.  How to handle errors in Customer interface ?
Ans.  Take the error code which you have encountered in the interface table and check it in AR document where u can find the list of customer error codes and their description.
You can act on the error code accordingly.
97.  What was your role in Customer Interface?
Ans. Generally to start with the role involves creation of staging tables by copying the same structure of interface tables so that it could be easy these staging tables are to be loaded with leagacy data and then when u find the data in staging tables thru the SQL loader programs
then we will run the package created to transfer the data from staging tables to interface tables with necesary validations made on the requied columns
then when we find the data in interface tables then run the standard interface program 'Customer open interface Program' so that the data gets transferred from interface tables to oracle base tables.
98. Can you call APPCORE library in CUSTOM library ?
Ans. You cann't call appcore library from custom library.Becuase the Custom.pll is itself attached (called ) by APPCORE pll.
So once you try to call Appcore in forms a indefinite cycle.
So instead you can call the APPCORE2 which duplicate all functions and properties of APPCORE except it wouldn't reffer custom.pll.
99. Can you use REF cursors in CUSTOM library?
Ans.  We cannot use ref cursors in the client side (FORMS Libraries ) library. This feature is available only on the server side PLSQL. i.e. Packages which reside in the databse.
100. How many Flexfields are there in AR and what are they ?
Ans.  There are 2 flexfields in AR
1.Sales Location
2.Teritory
Of which sales location is mandatory.A sales tax is calculated by considering the ship-to information.
Teritory flexfield is optional.
101. What is MRC and what are its use?
Ans. MRC ( Multi Reporting Currencies ):- A Unique set of features embedded in oracle applications that allows u to maintain and report accounting records in your functional currency.
To use Multiple Reporting currencies you must create a primary set of books and seperate reporting sets of books for each functional Currency.
102. How many reporting currencies can be attached to Primary Set Of Books ?
Ans. Only one reporting currency can be attached to one Primary Set of Book. If the currency changes then the SOB will also change.
103. What are the new features in Release 11I ?
Ans. Many changes in 11i Some of Important r below.
Supporting global operations .
Move to a single database - Leverage to Multi org.
Extended functionality via the web Suppliers Customers Employees.
104. What are ad-hoc reports ?
Ans. Ad-hoc report means temporary report.these reports are useful for a certain period and they are not useful for a long time purpose.
105. What is FSG and what is its use ?
Ans. FSG (Financial Statement Generator) Is a powerful Flexible Reporting tool available in Oracle General Ledger u can use it for Reports with out programming......
U have to define following to generate FSG.
1)Row Set
2)Column Set
3)Row Order
4)Content Sets
5)Report Defnition.
106. What are different types of transactions in AR ?
Ans. Possible Transaction types in AR are:
Invoice transaction.
Deposit transaction.
Debit memo transaction.
Credit memo Transaction.
Charge back transaction.
Guarantee Transaction.

107. What are value sets ?
Ans. Value sets are nothing but a list of values with some validations.There are 8 types of value sets.They are
1.None
2.Independent
3.Dependent
4.Table
5.Special
6.pair
7.Translatable Independent
8.Translatable Dependent
108.  What do you mean by HZ_ in customer tables ?
Ans. hz stores the customer information
some table which stores customer information
hz_parties -> store oraganization and people information
hz_cust_accounts -> sores customer informatiom
hz_cust_acct_sites_all->customers site info like bill-to ship-to
hz_cust_site_use_all->stores the business requirement of the site
hz_location->physical location address of customers
109. How can you handle multiple rows without using loops in PL/SQL ?
Ans. Using cursors.
 
110. What are the different types of files used in SQL Loader ?
Ans. There are 5 files are user in SQL Loader.
they are.
1. Data File.
2.Control File.
3.Log file.
4.Bad File.
5.Discard file.
data file and control file are required file.
example
SQL> sqlldr userid apps/apps control XYZ.ctl
This control file contain the referance of data file.
log file and bad file autometically created by sql Loader.
and Discard file is optional.
111. What are Interface table in AP, AR,GL ?
Ans. AP INTERFACE TABLE:
1). AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
8). RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL
GLINTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_interface
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
112. What are the setup steps for AP, AR, GL?
Ans. Below are some of the Main Step in GL, AP, AR Module

GL:  Account Flex field
         Account Combinations
         Period Types
         Define Calendar
         Define Currency
         Define Set of Books
         Assign Set of Books to Responsibility
         Daily Conversion Rate Types
         Rates
         JE Sources
         Categories
         System Controls
          Profile Options
          Open and Close Accounting Period

AP:  Define Payables Lookups.
        Define Purchasing Lookups.
        Define payment programs.
        Define your payment terms.
        Define bank accounts.
        Define Suppliers.
        Define invoice approval codes.
        Open your Payables accounting period.

AR: Define Payment Terms
         Open and Close Period
         Auto Accounting
         Transaction Types
         Transaction Source
         Collectors
          Approval Limit
          Remittance Bank
          Payment Method
          Receipt Source
          Aging Bucket
          Customer Profile Classes
          Customers
          Customer Sites
          Uses of Customer Sites (Ship to /Bill to)
          Remit-to Address

113. In how many ways can you enter a journal in GL?
Ans. 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).

114. What is the difference between cross-validation rules and security-rules?
Ans. SR rules specify responsiblity level
SR restrict user dedine segment values


cvr specify chart of account level
cvr restrict enter the code combination
115. What is ICA (Internet Computing Architecture)?
Ans. In ICA we have desktop Client Application Server and Database Server.
116. How to take care of null values in SQL Loader ?
Ans. By using the following statement in Control file.
TRAILING NULLCOLS
117. If any conflict occurs in FSG the who will override Column Set or Row Set ?
Ans. Column set provided while defining Columns you should have checked the Override Row Calculations checkbox.
118.  Can you add a descriptive FlexField to a table which already have data in it ?
Ans. Yes we can add a DFF if table already have a data.
119. What are AP setup steps ?
Ans.  setup---->suppliers....>invoices..>payments.....>reports......>periods.....>transfer to GL
120. What id recurring invoices ?
Ans. Recurring invoices are those invoices which re occur after a specific time interval eg. Monthly Rent
121. What are the setup steps for testing ?
Ans. ifits for PVCS testing instance then step -1 : developers develop or customize the form and is stored in the PVCS patches with the lateast version.step -2: this patches or developing packets are then compiled and tested at the end userplacestep 3: the developed PVCS packets are tested at the testing instance.if nay comopilation errors exist then they are again send to the developing insatnce or it is subimmitted to DBA to for production instance.
122. What is the difference between discounts and adjustments?
Ans. adjustment is some thing that is written off on a invoice.eg a customer short pays a 100$ invoice by 5 $ you write off this 5$ this is an adjustment.
while a discount is something a customer gets from our side. eg if the customer has net 30 5 discount in his payment term this means if he pays within 30 days he gets a discount of 5 so for the above eg the customer pays 95$ within 30 and oracle gives him a discount of 5$ automatically
from accounting perspective the 5$ of the adj will go to the account of the receivable activity
123. What are different types of invoices and what is a recurring invoice?
Ans. Types of Invoices:
1)standard invoice 2)pre-payment 3)debit memo 4)credit-memo 5)with-holding tax 6)PO DEFAULT 7) Quick Match 8)Expense Reort
Recurring Invoices: Recurring Invoices are the invoices in which the payment falls on every month such as rent electricity etc.
124. What are cycles of GL, AP, and AR?
Ans.  the process is
gl-->ap-->ar-->
P2P cycle come into picture here in AP GL AR.
Its procure 2 pay
125. What are Summary Accounts and Roll up groups ?
Ans. Summary Account: An account whose balance represents the sum of other account balances. We can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.
Rollup Groups: A collection of parent segment values for a given segment. We use rollup groups to define summary accounts based on parents in the group. We can use letters as well as numbers to name the rollup groups.



1.       Single Inventory OrganizationIs it possible to have a single inventory organization associated to Multiple Operating Units?
  Ans. Yes it Is possible to have a single inventory organization associated to Multiple Operating Units.                       each organization you created will have an Organization_ID. Operating unit is an organization and inventory organization is an organization too and each of them have its own ID.

2.       Segment QualifiersWhy should we have to give flexfield qualifiers for company and account segments?
Ans.  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
3.       advance pricing :what is advance pricing and how do you define it in oracle application
Ans. 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 Applications. This application is licensed as Oracle Advanced Pricing.

Oracle Advanced Pricing provides the flexibility to meet the needs of complex pricing situations for a range of demanding industry business requirements which include: Consumer goods telecommunications services high technology automotive businesses and aerospace/defense businesses that sell to other businesses. Telemarketing mail order catalog and web store businesses that sell directly to consumers. Oracle Advanced Pricing provides advanced pricing capabilities that enable you to set up your pricing information and to model complex data relationships to determine the correct price.
4.       suppliers mergeAt 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?
Ans.    NO ANSWER AVALIABLE
5.       What are Oracle Apps API? Where APIs are physically store? n What is the latest version of API?
Ans. They are Application Program Interfaces which are standard stored procedure package or functions created for performing specific activities in theOracle Apps E-Business Suite.

Ex: The Order Import API when called would create orders corresponding to the record in the Order Interface tables.


6.       What is the difference between Customization and Personalization?
Ans. Customization is done by making the changes in the cutom.pll whereas the Form Personalization is done through the Front End in Oracle Apps.
7.       What is the difference between spfile and pfile?
Ans.  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 spfile is a binary file which means it can't be edited directly (if you try to edit it directly it'll corrupt the file). The spfile can only be modified by using the "alter system" command. The spfile's name is spfileSID.ora.

The spfile is useful to have because it lets you dynamically make changes to some parameters whereas the pfile does not - you will need to shutdown and startup the instance for any changes you make in the pfile to be applied.
 
8.       What are the validations to be taken in doing Customer Conversion using TCA APIs
Ans.  NO ANSWER AVALIABLE
9.       What is the difference between Supplier and Vendor?
Ans.  Supplier - Supplier are those which provide some material to the company but they have not any contract to the company
Vendor - They also provide the material to the company but they have contract to the company
10.   Explain about localizations (Ind, US) in Oracle Financials ?
Ans. Do u know meaning of localization? In India to identify the person legal entities and suppliers etc use some specific method like PAN TIN TDS. Actually these term differed with nation or state so to capture identification data of legal entities needed to setup a patch in Oracle 11i that called Lacalization patch. Aftersetup a patch we get some more screens menu and reports for lacalizations.
Localization made be country specific for US:Faderal Financials for india: india Localizations.
I use PAN to identify the Employee in India other side in US use Social Security Number.
so we need to setup country specific loacalizations. Mostly varied in taxation identification and business methods-reporting.
11.    What is FNDLOAD and how is this used
Ans.  FNDLOAD is an API provided by Oracle to download/upload Flexfields Concurrent programs Valuesets Menu etc.

12.   What is the use of Translator Code in Trading Partner E-commerce gateway?
Ans. No Answer
13.    What is Receipt Routing
Ans.  Receipt routing is a process by which the receipt is processed and sent to Accounts Payables for payment to vendor or supplier 3 options are available for processing the receipts in oracle

1. Direct

2. Standard

3.Inspection required
Direct : Delivers directly to stores
Standard : Standard process of receipts
Inspection Required : Raw Material is checked for Quality parameters (as per the quality plan) then accepted or rejected and sent to stores.
14.   Open interfaces in oracle application 11i module wise?
Ans. GL
1) Gl Interface using gl_interface (watch out gl_pa_interface and gl_hr_interface new table for 11.5.9 on words)
2) GL Budget Interfce using gl_budget_interface
3) Currency Interface using
GL_daily_rates_interface
AP
1)Invoice import using
ap_invoices_interface
ap_invoice_lines_interface

2) AP Expense Report
ap_expesne_report_headers_all
ap_expense_report_lines_all

3) No interface exists for AP Payment if you try to convert legacy payment
But you will need to populate ap_invoice_checks_All and ap_invoice_payment directly(need to get approval from Oracle opening SR on Metalink)

AR
1) Invoice Import using auto invoice
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL

2)AR Payement Receipt
AR_PAYMENT_Interface_all
3) Customer Import
RA_CUSTOMERS_INTERFACE_ALL
4) Sales Tax Interface
FA
1) FA_MASS_ADDITIONS
Cash Management
CE_STatement_headers_int_all
CE_statement_lines_interface

15.   What is the need of a staging table or temporary table in between flat file and standard interface table while transferring data from flat file to interface table?
Ans.  these staging tables are used to hold temporary data i.e data with in the temporary table will be automatically get deleted when we issue commit or when we close oracle session that depends on how we create table
eg: create global temporary table eg1(name varchar2(20) num number(10)) on commit delete rows;
this will delete the rows on temporary table when we issue a commit at sql prompt.
moreover these staging tables are used to do some primray validations before inserting data into actual tables.
so we need data to be erased after inserting into acutal tables. so we go for staging tables.
we can use normal tables also as staging table but we need to truncate table for each insert. thats why we go for temporary tables.
16.     Interview Questions for Oracle 11i Apps (Manufacturing)?Item Setup FAQs


Once an item is assigned to an organization, is it possible to remove this association at a later time?
A. If you have assigned an item to an organization, it can only be deleted from that organization if the item has NOT been transacted. If it has been transacted against you cannot delete the item from the organization. See the Oracle Inventory User's Guide. You can, however, make the status of the item "inactive" on the main region of the Item Define form INVIDITM in 'Item Status' field. This will prevent users from transacting against the item although the item will continue to be included in LOV's. ---

Q. How do you setup Unit of Measure for an item?
A. When transacting an item, it will always default to the defined Primary Unit of Measure, so if you need to use another UOM, you must select it from the List of Values when you transact it. This implies that you want the Primary Unit of Measure to be that which is used most often and which is likely to be the smallest unit of that type of item. Once you have set the primary UOM for an item, it CANNOT be changed.

--- Q. How do I change an item's locator control method once I have transacted against it, for example from No Control to Prespecified?

A. You cannot change this attribute if there is onhand quantity for the item. You must first perform a miscellaneous issue of all quantity. Then the attribute can be changed and once the locator(s) are set up, you can perform a miscellaneous receipt to receive the quantity back into a specified subinventory/locator.

--- Q. How do I change an item's Unit of Measure?

A. You CANNOT change the UOM for an item once the UOM is assigned to the item. The suggested solution is as follows: If the item has not been transacted you can delete the item and then re-add it with the correct UOM. If the item has been transacted and has no outstanding orders, purchase orders or WIP jobs you can do the following if approved by your management.

1. Rename the existing item '123' to '123-Bad UOM' and save the item. Any prior history for item '123' will now be associated with item '123-Bad UOM'.

2. Add a new item '123' with the correct UOM.

--- Q. How do I delete an Item Template I no longer use?

A. Suggested steps to follow to delete unwanted Item Templates:
1. Navigate Setup: Items: Templates - Find Item Templates form appears.
2. Click on the LOV, and select the Item Template that is to be removed.
3. Click the [Find] button on the Find Item Templates form. The Item Templates Summary form appears, with the Item Template selected.
4. Click the [Open] button on the Item Templates Summary form, and the Item Templates form appears.
5. From the menu, select Edit | Delete Record, then select Action | Save and Proceed. 6. Close the Item Templates Summary form. Be careful not to delete Item Templates you may need again as they are not retrievable once deleted.

--- Q. Is there a way to create custom item attributes?

A. No but you can create and define the descriptive flexfield for this form. This will allows you to associate additional data with an item such as an attribute. See theOracle System Administrators Users Guide and the Oracle Flexfields Manual for information on creating Descriptive Flexfields.

--- Q. Why does the application prompt you for Organization when you enter the Master Item form for the very first time even though you have only one Master Organization.

A. Once you setup a Multi-Org environment and you enter the form for the first time, there is the possibility there can be more than one MasterOrganization. The application therefore prompts you for an organization which is then used to determine the Master Organization associated with it. In other words, you are choosing the Master Organization by choosing one of the Orgs that belongs to it.

--- Q. How do you change the control level for item attributes from master level to organization level for example. When I try to change this in the Attribute Control Form, I get the message: frm-40200: field protected against update.

A. First change value of the field called "status" to "not used". You should then be able to change the control level of the attribute from master level to org level. Make sure and change tostatus back to what it was before the change and save the record.

--- Q. How do I inactivate an item?

A. On the Master Item Form (Inventory->Items->Master Items), change the item status field to "Inactive" or any another defined status which disables all attributes that make an item usable (stockable, shippable, orderable, etc.). The "Inactivate" status comes pre-seeded with the Application and is for this purpose.
--- Q. What characters can I use in an item name (including special characters)?

A0. The only hard fast rule is not to use the character designated in the segment delimiter for the System Item Flexfield. Also, you will not be able to enter any characters not allowed by the valueset associate with the flexfield. It is recommended that you avoid the use of any char that can be used as a delimiter to avoid future problems. It is best to not use special characters like #@%& if at all possible as these may have a negative impact down the road. Some characters, like percent (%), underscore (_), and pound(#), have special meaning when performing queries by form as do the query operator characters (=!><).

--- Q. Can you change the costing enabled and inventory asset flags on an item that has already been transacted against even if there is no on-hand quantities for the item?

A. Yes, you can change the flags. If you are changing the flags from checked to unchecked you will receive a warning that the associated cost records will be deleted alerting you that the Cost of Goods will not be calculated any longer for transactions of this item. In effect what you are doing is changing the item from an asset item to an expense item. If you are changing the flags from being unchecked to checked then a database trigger will fire and cause cost records to be added for this item. There is no warning that is given.

--- Q. When I create a new item, and choose to assign to All orgs, the application allows me to even though some of those organizations are restricted to my responsibility. Is this the way it is supposed to work? If I assign in anOrganization by Organization fashion, I am not allowed to assign to the restricted organizations.

A. The situation described is standard functionality. Even if a responsibility has limited access to a certain number of organizations, the "Assign to All Organizations" check box will assign the item to all orgs, not just the ones limited to the user's responsibility.

--- Q. How do you tell that an item is an expense item or asset item?

A. Navigate to the Organization Items form: Inventory->Items->Organization Items. Query up the item in question. Change to the "Costing" alternative region. The value of the "Inventory Asset Value" flag determines this. If checked, the item is an asset item.

--- Q. Is there a way to delete or disable an item revision once entered?

A. There is no way to delete a revision nor is there a way to disable it. It must remain there for historical data. The suggested workaround is to create a new item, transfer any Quantity on-hand from the old item to new item and delete the old item. The only down side is you will lose some transaction history.

17.   What is business process in oracle applications11i?
Ans. For any Organization or company which is dealt with Business of any kind and the same business process would be studied for mapping into Oracle 11i Software.

18.   What is auto invoice in OM module?what is use of it?
Ans.  invoice can be raised in two ways 1.auto invoice 2.manual invoice
invoice must be raised in ar module na. in manual invoice we will enter all details about customers manually
like cust id contacts address . incase on autoinvoice we will not enter all these data. just we will run
programs
1. wfbp(work flow background process) this will dump data from omtables to om_interface
2. autoinvoice master program: this will dump data from om_interface to ar_interface
3. autoinvoice import program : this will dump data from ar_interface to ar tables
so data will be automatically dumped from om tables to ar tables and invoice will be raised automatically.
i dont have table names exactly but i will let you know them later.
19.   What is the difference between Organization_id and Org_id ?
Ans.  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

20.   Is the accounting entry different for Credit Card Transactions or normal Invoice - Payment transactions. If so, how?
Ans.  A credit card order is same as any other order for accounting. i.e. DR Rec CR Rev

But the receipt process can be different depending on ur clients requirements to categorize remitted receipts and cleared receipts different.

Receipt Cleared
CR Rec DR Cash ( Clearing account)

Receipt Remitted
CR Cash (Clearing) DR Cash ( Remitted account)

if both are setup same in bank then the above is just a moo point :-)

21.    What are the setup steps to setup Credit Card Transactions?
Ans. For the setup of Credit Cards we have to initally set Credit Card Programs and Code Sets Window.
We are setting credit card programs for our enterprise's credit card and procurement card requirements.Set up Credit Card Program with a card type of Travel for employees to enter credit card transactions on expense reports.Set up Credit Card Program with a card type of Procurement for employees to use procurement cards to purchase items directly from suppliers.
In Code Sets Window we are setting credit card codes for our Procurement cards.Payables use these codes to create default accounting distributions for transactions that we import from our credit card issuer.
22.    How do we change a custom API to include business needs?
Ans. NO ANSWER
23.   What is the difference between data conversion and data migration?
Ans. Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA) validating it and converting it to ur our the target module using the standard import program.
24.   What are the related set ups to be done for AP invoice approval?Can we set the approval hierarchy even for this?
Ans. 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 payment method bank payment document etc.
After defining all the above we can raise a invoice There s no need of defining the approval group it s not a mandatory
25.   Invoice Accounting - TDS entry not generated in service bills?
Ans. For TDS Credit Memo Generation make sure that TDS Type TDS age and TAxable amount is entered.
26.   Which table stores receipts information?
Ans. If you are looking for Receipt information in Receivables (AR) then these are the following tables:
1) AR_CASH_RECEIPTS_ALL (Header Level) 2) AR_CASH_RECEIPT_LINES_ALL (Line Level) and 3) AR_CASH_RECEIPTS_HISTORY_ALL (History)
If you are looking for Receipt Information in Purchasing (PO) then the tables are:
1) RCV_SHIPMENT_HEADERS (Header Level) 2) RCV_SHIPMENT_LINES (Line Level)
27. What is profile options? what are the types of profile options in AR / AP ?
Ans. The profile options are available to every product in Oracle Applications. For each profile option we give a brief overview of how Oracle Application Object Library uses the profile's setting.
1)User Level
2)Responsibility Level
3)Application Level
4)Site Level.
28. How many templates use for oracle reports in oracle applications and what they are ?
Ans. 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 Letter
29. What is one full life cycle implementation?
Ans. Full life cycle is started from scratch to Production which includes mainly
1) Designing Modules.
2)Development of Modules.
3)Testing of Modules.
4)Going to Production.
30. What are _ALL tables in Oracle Apps?
Ans.  _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.
31. What are APIs? Can you name a few APIs?
Ans. API - Application Program Interface is a PL/SQL call made to the application to create business transactions or events. This is an alternative to using the interface tables in applications to insert and process transactions. You can find the APIs from the database by querying the all_objects table for name like '%_PUB'
eg: AR_ADJUST_PUB in AR to create adjustments

32. What is Ship-From/Customer Rules?Ship-From/Ship-To Rules? Ship-From/Customer Item Rules?
Ans. These are Global Scheduling Rules or Logistics Rules use for Scheduling the Order in Order Management.
33. What is descriptive flex field and what is the use of them? What is the procedure for using them?
Ans. Descriptive Flexfileds r used to add additional informations.and these values r stored to the column attributes.
go to sysadmin application-flexfields-descriptive-segments
34. Why is FND CURRENCY used in reports?
Ans. FND_CURRENCY is basic foundation class used to format currency.
Ex. 1234556
By using above we can print it as
12 34 556

35. What happens to the form when u register?
Ans.  Registration of Form in Oracle Apps indicates that the form can be accessed from Oracle Application Responsibility. For that you have define the following.
 1. Define the form
 2. Define the function
  3. Attach the funtion to the Menu
  4. Attach the Menu to the responsibility.
36. Difference between Key and Descriptive Flexfield?
Ans. Key flex filed is used to store key information whereas descriptive flexfiled is used to store additional informations.
ex: if you go to Application Developer then flexfiled---key flexfiled ---segments---segment separator
Segment separator is a key flexfiled
whereas a small box besides segment separator is descriptive flexfiled.
37. What is Key and Descriptive Flexfield?
Ans. Key Flex Field:
KFF is a Mandatory field which is already driving the functionality and it is the field where atleast first segment is made mandatory.
KFF willbe filled in segments
KFF Is mandatory
KFF Drives functionality
Navigation is Inventory(Navigator)->Setup->FlexField-Key->Segments
then you can search for application and the flex field
Examples : in Oracle Inventory
System Items Stock Locators Item Categories Item Catalogs etc
Descriptive Flex Field :Descriptive flex field is the data which can be entered into the each of the oracle forms which can take extra information and this option is there for almost all forms in oracle.you find the option of dff in every form that you work
DFF: Is not a mandatory field
DFF Information will go into attributes of the table
DFF does not drive any functionality but you can drive by writing a custom code on the dff fields..
Navigation is Inventory(Navigator)->Setup->FlexField-Descriptive->Segments
then you can search for application and the flex field
Examples : in Oracle Inventory
System Items subinventories stock locators any other form
38. How to use Flexfields in reports?
Ans. 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.

39. What are forms customization steps ?
Ans. For form customization we need to download the template.fmb in binary format from AU_TOP directory.
Then rename template.fmb to the your form name and start customizing it.
Upload the form into AU_TOP/forms/US
Compile the form.
Copy the form into respective custom top as INV_TOP PO_TOP etc.
For registering in apps -
Register form --> Register function --> Register Menu -->
40. Do you have to register feeder programs of interface to AOL ?
Ans.  Yes ! you have to register the feeder programs as concurrent programs to Apps.
41. How to pass parameters to a report ? Do you have to register them with AOL?   
Ans. frist of all you have to register the parameters of your repot in AOL.
setps
1.switch to SYSADMIN responsibility.
2 register the executable navigation is
Concurrent>program>executable
3 register the program for this navigation is
concurrent>program>define
in this form there is a one button click and register your
report parameter.
42.  What are the steps to register concurrent programs in Apps ?
Ans. The steps to register concurrent programs in apps are as follows :
· Register the program as concurrent executable.
· Define the concurrent program for the executable registered.
· Add the concurrent program to the request group of the responsibility

43. What is the use of Temp tables in Interface programs ?
Ans. Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.
44. What is the use of triggers in Forms ?
Ans. Triggers are used in forms for event handling. You can write PL/SQL code in triggers to respond to a particular event occurred in your forms like when user presses a button or when he commits the form.
The different type of triggers available in forms are :
· Key-triggers
· Navigational-triggers
· Transaction-triggers
· Message-triggers
· Error-triggers
· Query based-trigger

45. What are Autonomous transactions ? Give a scenario where you have used Autonomous transaction in your reports ?
Ans. An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.
Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction. So, you can log events, increment retry counters, and so on, even if the main transaction rolls back.

More important, autonomous transactions help you build modular, reusable software components. For example, stored procedures can start and finish autonomous transactions on their own. A calling application need not know about a procedure's autonomousoperations , and the procedure need not know about the application's transaction context. That makes autonomous transactions less error-prone than regular transactions and easier to use.
Furthermore, autonomous transactions have all the functionality of regular transactions. They allow parallel queries, distributed processing, and all the transaction control statements including SET TRANSACTION.
Scenario : You can use autonomous transaction in your report for writing error messages in your database tables.
46. What is a FlexField ? What are Descriptive and Key Flexfields ?
Ans. 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 of Flex field..
Key Flexfield: Key flexfield are flexible enough to let any organization use the code scheme they want wothout programming.Key flexfield can be used to represent codes that is made up of meaningful segment to identify GL a/c Part no. and other business entities..Oracle app store these codes in key flexfields..
Descriptive Flexfield: They provide customizable expansion space on ur forms. You can use desc flexfields to tract additional information important and unique to ur business that would not otherwise be captured by the form.
47. What is record group ?
Ans. Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables thru sql queries.  
48. What is the use of cursors in PL/SQL ? What is REF Cursor ?
Ans. The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all it’s queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs.   
49. What are different report triggers and what is their firing sequence ?
Ans. There are five report trigger :
· Before Report
· After Report
· Before Parameter Form
· After Parameter Form
· Between Pages

The Firing sequence for report triggers is
  • Before Parameter Form
  • After Parameter Form 
  • Before Report 
  • Between Pages 
  • After Report.
50. How to attach reports in Oracle Applications ?
Ans. 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.
51. How to debug the form?
Ans. Forms has features that helps you more easily debug your application
including Debug Messages which notifies you every time a trigger starts
to fire and Debug Mode which allows you to dynamically view the execution
of your triggers and variables.
52.  What is auto reduction?
Ans. LOV Auto-reduction : Lov Auto-reductions is used in forms.

The general idea is to wrie a statement like Select {name column} {value column} from {table}
where {name column} like ' {:Combo_Item} '
You can create a record group out of this statement ans populate the combo box dynamically.

example

When the user types in 0208

This list has the following items is displaced
02080006
02080023
02080116
02080222
02080273
02080452
02080705
02080709
02080749
02080800
53.  What are context sensitive segments?
Ans. Context Sensitive Segment is a type of Descriptive Flex Feild.

Context Sensitive Segment: only appears when an appropriate selection is made in the context segment (the controlling field) See below for more details.
Global and context-sensitive segments may consist of the following widgets:



http://www.oracle.com/technology/tech/blaf/specs/flexfields.html#contextual_descriptive
view-only label/data pair
text box
date picker
choice list
LOV field
54. What are global segments?
Ans. Global segment is a type of decsriptive flex field.

Global Segment: always appears on the customer's application page regardless of the context

please refer to note

http://www.oracle.com/technology/tech/blaf/specs/flexfields.html#global_descriptive
55. What is segment qualifier?
Ans. Segment qualifiers hold extra information about individual segments such as if the account is an Asset Liability or Expense if you can post to the account and more.

When we define a segment value in the Segment Values window we must also assign qualifiers which determine the account type (asset liability or expense) whether budgeting is allowed whether posting is allowed and other information specific to the segment value.

Allow Budgeting Allow Posting Account Type Control Account Reconciliation Flag.
segment qualifier are used to identify a particular segement within key flexfield
56. What is flex field?
Ans. A flexfield is a placeholder set of fields that can be configured by customers for use by their organizations. Once configured, the customer-defined fields (label/widget pairs) may appear in either form or tabular layouts. There are two main types of flexfields: Descriptive flexfields, which are configured as a set of fields that are indistinguishable from core (default) application fields, and key flexfields, which consist of multiple segments for entry of codes, such as a product serial numbers or bank account numbers. 
57. How to register Form , Reports?
Ans. Registering Oracle Reports
 
Step 1: Register a concurrent program executable  
Navigate to the Define Executable form (AOL Reference manual pg 9-84)  
This determines the type of program being run,ie an Oracle Report. Fill in the executable name, application and execution method. For the Execution File, fill in just the filename. The concurrent manager will look in the appropriate directory under the application's top directory.  
For spawned programs, the file must be in the bin directory, for Oracle Reports the rdf file must be in the srw directory.  
For PLSQL concurrent programs, put the name of the stored procedure.  
Step 2: Define the concurrent program  
Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87)  
This form links a concurrent program to the executable you just defined, as well as defines the programs parameters, incompatibilities, and other options.  
Enter the concurrent program name, application, short name and description. Check Standard Submission if you want to be able to submit this program from the Standard Report Submission form.  
Enter the name of the executable you defined and any report information if necessary. Also define any parameters your program needs here and any incompatibilities.  
Step 3: Add the concurrent program to a Report Group  
First you will need to find the name of the Report Group to use.  
Go to Security->Responsibility and query the responsibility you want to run the program with.  
It should show a Report Group name. Query this name in Security->Responsibility->Report  
Add your new program to the list of available programs. Now when you go to submit a request with this responsibility, you will be able to submit your custom program. 
 
Forms Registration  
 
1. Develop the form in Developer 2000. 
2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US] 
3. Define the FORM in Application Developer 
4. Define FORM as FUNCTION. 
5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine] 
6.Copy the above MENU and go to Application Developer and query on MENU tab  
58. Where you will keep the host source code?
Ans. Host resource is located under AU_TOP/11.5.0/bin
Ans might be C:\windows\system32\drivers\etc\hosts.
59. How to implement Flex fields in forms , name the triggers & user exits?
Ans. The necessary step we have to follow to implement Flexfield in forms:
1. Create a table through which we are going to create the flex field.
2.Registered the table.
3.Registered the column of the table.
4.Insert few data into the table.
5.fire a commit statement after inserting the data.
6.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Register.
7.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Segment.
8.Create a non-database field in your form where you are going to implement the flexfield.
9.Define the corresponding flexfield in the WHEN-NEW-FORM-INSTANCE trigger of your form.
10.Activate the event like WHEN-NEW-ITEM-INSTANCE and WHEN-VALIDATE-ITEM in the created non-database field item by using FND_FLEX.EVENT procedure.
11. Run your form and text it.
60.  What is the difference in Quick pick & quick code?
Ans. Quick codes form is used to predefine a list of values for a particular field.
61. What are special triggers created in the form when u register it?
Ans. 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.....
62. How will u display message for testing the form u modified?
Ans. You can use
fnd_message.debug('message string');
for testing purpose

63. How can u see the global parameter values in the form without coding?
Ans. One way of viewing parameter values at run-time in Apps is by Navigating to Tool-->Examine menu. Enter the block name as parameter and then give the parameter name in the item field and then press tab.examine
64. What was the structure of the accounting flexfield in previous project?
Ans. NO ANSWER
65. What is balancing segment?
Ans. Balancing segment is the level for balancing the accounting entries.
For example the accounting flexfield structure is company-costcenter-project.
If you define the balancing segment as company then both debit and credit should be balanced at the company level when the transactions are posted to GL.
66. What is cost center segment?
Ans. It is one of the segment in the accounting flexfield. It is not necessary that this segment should always be there in the accounting flexfield, but most of the companies include this segment in the accounting flexfield to post the assets and expenses costcenter wise and get the report accordingly.
67. Can you have two accounting Flexfields in AR?
Ans. 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 should correspong to 2 different SoB's because if any of the 3 C's chage (Currency Chart of Accounts and Currency) SoB differs.
One can have >1 Accounting flexfield if he has >1 SoB created.
68. What are on-account sales credits?
Ans. By definition credits you assign to your customer s account that are not related to a specific invoice. You can create on account credits in the Transaction window or through AutoInvoice.
If the item is returned and the order flow for your return includes the Invoicing Activity and if you use a reference source for a return line you can populate the Credit Invoice field. In this case Oracle Receivables creates an applied credit memo and the sales credits from your original invoices are reduced accordingly regardless of the sales credits you enter on the return. If you create an on-account credit from a return sales credits are reduced according to the sales credit information you enter on the return. Order Management also provides the option of not using any reference source and entering return line information without defaults. This results in the creation of a single return line and an on-account credit.
69. What is customer merging?
Ans. Customer merging is done to avoid the Customer Duplication
For Ex: You can Create Same Customer: ABC Limited as
1) ABC Limited
2) ABC LTD
So You can merge ABC LTD to ABC Limited and Maintain ABC Limited going forward
70. What happens when u complete an invoice?
Ans. It is interfaced to AR
71. What all things are stored in RA_CUSTOMER_TRX?
Ans. The header information about transactions are stored in this view(RA_CUSTOMER_TRX_ALLtable).
The RA_CUSTOMER_TRX_ALL table stores invoice debit memo commitment bills receivable and credit memo header information. Each row in this table includes general invoice information such as customer transaction type and printing instructions. One row exists for each invoice debit memo commitment bill receivable and credit memo that you create in Oracle Receivables. Invoices debit memos credit memos bills receivable and commitments are distinguished by their associated transaction types which are stored in the RA_CUST_TRX_TYPES_ALL table.
72. What are chargebacks?
Ans. A new debit item which we assign to a customer while closing a existing, outstanding debit item is known as 'Chargebacks'.
73. What is lockbox?
Ans. Lockbox is a services provided by bank to corporate customers to transfers there payables in receviables so that they can update their balances.
here all the cheque or payments are collect by bank and send a dat file to there corporate so that they can directly transfer that file through interface in their modules (ap ar)
74. What is address validation?
Ans. The type of validation you want the system to use for your address if you are not using a flexible address format for validation. You can implement address validation at three levels: Error No Validation or Warning.
'Error' ensures that all locations exist for your address before it can be saved.
'Warning' displays a warning message if a tax rate does not exist for this address (allows you to save the record).
'No Validation' does not validate the address
75. What is "Finance Charge"?
Ans. Additional charges that you assign to customers for past due items.Finance charges can be included on your customer s statements and dunning letters.

76. How AR & OE are related?
Ans. 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)
77. What Credit memo / Debit Memo?
Ans. Credit memo In Oracle Payables and Oracle Projects, a document that partially or fully reverses an original invoice.
Debit memos
Debits that you assign to a customer to collect additional charges. For example, you may want to charge a customer for unearned discounts taken, additional freight charges, taxes, or finance charges.
78. What is the link between CM & invoice column name ?
Ans. The Parent_invoice_id column of the ap_invoice_distributions_all will give you the main invoice# to which this CM/DM has been matched to.

79.What is set of books?
Ans. You define 3c's i.e. Chart of accounts currency & calender to define chart of accounts

80. How to find overdue invoices?
Ans. Use Past Due Invoice Report.
81. What is accounting rule?
Ans. accounting rules detrmine the period in which the revenues were genereated against the transactions. Rules that Receivables AutoInvoice uses to specify revenue recognition schedules for your transactions. You can define an accounting rule where revenue is recognized over a fixed or variable period of time.

82. What is invoicing rule?
Ans. Invoicing Rule determine when to recognise the receivable for transactions. There are 2 types invoicing rules:Bill in arrears and Bill in advance.
Bill in Arrears recognise receivables at the end of the revenue recognistion schedule. Bill in advance recognise receivables as soon as invoice generated.
83. What is auto invoice?
Ans. It is a program that imports invoices credit memos debit memos on account credits from other system to Receivables.

84. List the key flexfields in AR?
Ans. 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.
 
85. Which is the parameter set to validate keyflexfield value?
Ans. Validation occurs on exit of the key flexfield (on the primary page) and any subsequent action is ignored until the validation is finished. Validation on field exit allows robust pre-search capabilities: The value is checked against the database list of values and based on the findings the appropriate functions occur (for example if exact match dependent fields may also be populated or on exit of field with a partial string the Search page may appear allowing the user to select one of the partial string matches.)
Source: http://www.oracle.com/technology/tech/blaf/specs/flexfields.html#key_populate
86. What is dunning letter?
Ans. Dunning Letter: A letter which is sent to customers to inform about the past due debit items is know as 'Dunning Letter'

87. What is profile?
Ans. Profile is one of the option which is used to change the application based on value.

88. What is pick release
Ans. Pick release is the process by which the items on the sales order are taken out from inventory. The flow is as follows:
1) When an order is booked based on the setups the lines are scheduled and they are ready to release. This means the inventory is informed that there is requirement of certain quantity of certain items on certain date.
2) The inventory person according to availability allocates the items to those SO Lines and reserves them. 3) Then on the day of delivery or somewhere between these items are taken out of inventory and moved to staging subinventory. This means that the items are now ready for shipping and are out of inventory.
When the items reach staging subinventory they are said to be picked and shipping execution can now ship these items.

89. Concurrent prg.
Ans. Concurrent Program is nothing but an instance of execution file along with parameters and incompatable.

90. What are the i/p for pick release?
Ans. Order Number -- Order Tab form
Warehouse and Ship Locator --INVENTORY Tab form

91. After which stage we can not cancel the order?
Ans. order status has changed to shipped/interfaced/closed these orders only not able to cancel
remaining all other order status are possible to cancel
92. What is order cycle
Ans. The order cycle is as follows:
Order entry
Book the order
Schedule the order
Pick release
Ship confirm
Close the order

93. Name important tables from OE /AR?
Ans. 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

94. Give the complete process cycle for OE / AR?
Ans. Order EnteredOrder BookedDispatch EligibleDispatchedPick Release EligiblePick ReleasedShip ConfirmInvoicedPosted in GL






95. Interface tables in OE/AR?
Ans. In Ar
1) Invoice Import using auto invoice
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL

2)AR Payement Receipt
AR_PAYMENT_Interface_all
3) Customer Import
RA_CUSTOMERS_INTERFACE_ALL
4) Sales Tax Interface























AOL Interview Questions
1.       How do you create calender value set?
Ans. We can do this in Apps Forms.

Prerequisite: We need to load all the predefined plls for example APPDAYPK for calendars.

Once we have all the dll's required

Assign the key list lamb LOV to the textfield.
Validate from list (property) : No
Key list val trigger of that field --> calendar.show;

You will get the calendar LOV whenever you enter into that text field...!
2.       Table for independent value set
Ans. If you want the base table where the name of the value set is stored then it is
FND_FLEX_VALUE_SETS.

3.       Define Shipping Parameters
Ans. This is detail about Shipping Parameters..for OM.. The below details are breifly descripb u.. If any clarifications plz.. go to India Local Order Management>> Shipping>> Setup>> Shipping Parameters..

General:

Weight UOM Class : VOLUME
vOLUMEN uom cLASS : volume

pERSENT Fill Basis: Quantity
Export Compliance Screening : Not Required -- as per requirement..

PICK RELEASE:

Release Sequence Rule : Default: Order Number
Pick Slip Grouping Rule : Default: Order Number
Print Pick slip : At the End
Number of pick slip lines: null
Default Pick release document set : create Default rule
Default Stage Subinventory: org code
Autocreate Deliveries: Check
Auto Allocate: Check
Default Stage Locator: Stock locator


Shipping Transaction:
Delivery

4.       How to schedule the concurrent programs from Back end(PLSQL) -not from SRS form.
Ans. fnd.request.submit_request( Concurrent_program_name,
                                              application_short_name
                                               description,
                                               parameters)
                                                ,

5.       What is the role of applsys and applsyspub
Ans. All the technical products' database objects are consolidated into a single schema called Applsys

Applsyspub is used for authentication by having read only views
 

6.       How can we delete a Concurrent Program which is already registered?
Ans. Through the Application Front end its not possible to delete CP. But from backend we can delete it.

TO DELETE CONCURRENT PROGRAM
---------------------------------------------

begin
fnd_program.delete_program('SHORTNAME','APPLICATION');
fnd_program.delete_executable('SHORTNAME','APPLICATION');
end;

7.       What is a concurrent program and a concurrent request set ?
Ans. A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing your hardware capacity. Typically, a concurrent program is a long-running, data-intensive task, such as posting a journal or generating a report.

A concurrent request is a request that you submit to run a concurrent program as a concurrent process.

A request set is a collection of reports and/or programs that you group together. You can submit the reports and/or programs in a request set all at once using a single transaction.


8.       How do you attach javascript to a menu ? When user clicks on a menu it should display simple message
Ans. No Answer
9.       How do I submit a Series of requests from PL/SQL?
Ans. May be your question about series of requests is from PL/SQL. For this it is not possible to submit series of requests at a time their is only one option to submit request from backend is
fnd_request.sumbint_request(Paramenters)
10.   What is US directory under any TOP?
Ans. This directory contain code related to base language which is US English
11.   What so you mean by Hierarchical and non Hierarchical security type in value set?
Ans. This comes into picture when security rule comes into picture.
For example Say Maintanance is the one of the accounts in that we have cleaning painting expenses when we are not accesssible to main a/c (i.e maintanance) we cannot use sub a/c i.e cleaning and painting when you select Hierarchicalsecurity when it is non-Hierarchical we can use sub a/c i.e painting cleaning etc...
12.   What is the difference between organization id and master organization id?
Ans. In simple wordsOrg_id referes the operating unit and and organization id refers the Inventory OrganizationRegardsKarthikeyan
13.   What is quick code? Why is it called a quick code?What is steps of defining a quick code?
Ans. Quick Code or Lookup Code are short names given to some field values. an example is two letter codes given to Country names.

14.   What is '$flex$ and '$profile$, What is the use of '$flex$'?
Ans. $Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .
For Ex . $Flex$. would return the value held by that valueset .
$profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.
Ex. $profiles$.org_id would return the operating unit which is active at that time for the user.
15.   How can i implement and manage the custom schema?
Ans.  basically a schema is collection of objects(tables views indexes sequences) belonging to particular user here in case of Oracle apps every module is implemented as a user for example Order Management is implemented as a user ONT so to create a custom schema we need to create a user and register the user with AOL.check this link for step by step process to create a custom module(Application) and register with oracle AOL.
16.   How can I change in custom.pll? After changes how can I send on the server and what's effect in this condition?
Ans. 1. FTP the Custom.pll from $AU_TOP/resource
2. Open the Custom.pll in Forms6i
3. Include the following code for your Form logic :
begin
Form_Name varchar2(50) : name_in('system.current_form');
If Form_Name 'YOUR CUSTOM FORM then
begin
include your logic
end;
end;
4. Once changes over using the following command to generate the CUSTOM.plx
f60gen module CUSTOM.pll userid apps/apps@mfgdev module_type LIBRARY
to generate the latest CUSTOM.plx and move this CUSTOM.plx to $AU_TOP/resource

17.   I have run a request but it is not completed. His status is (running normal) and those requests are giving after this he will be completed.So,now what steps I have to follow for the running request?
Ans. give it some more time. Did you ensure that you had run immediately checked when you submitted the report/request? If it was accidentally scheduled for a later date/time the best thing you can do is to submit it again with correct parameters.
 
18.   I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?
Ans. use adctrl utility to monitor and restart adworkers after fixing your locking problem. check ad workers log file that show you which table has problem and error message

19.   where would i find the .rf9 files what actualy it dose
Ans. .rf9 files are created while applying patches usually in $APPL_TOP/admin/SID/restart directory
20.   How can i disabled and enabled the standard button's in apps window?
Ans. You can do this with Custom.pll and if ur using apps version greater that 11.5.9 then you can do this with form personlization too

21.   How do i recover the responsibility in apps if it is disabled?
Ans. We can also recover through the following steps:
Go to system administrator responsibility > Security > Responsibility > Define > Give the particular responsibility name query on it and then see the effective dates to field. If any date is there then that repsonsibility will expire on that date and if it is null then it will not expire on any date.
22.   Where do concurrent request log files and output files go?
Ans. The concurrent manager first looks for the environment variable $APPLCSF
If this is set, it creates a path using two other environment variables:
$APPLLOG and $APPLOUT
It places log files in $APPLCSF/$APPLLOG
Output files go in $APPLCSF/$APPLOUT
So for example, if you have this environment set:
$APPLCSF = /u01/appl/common
$APPLLOG = log
$APPLOUT = out
The concurrent manager will place log files in /u01/appl/common/log, and
output files in /u01/appl/common/out
Note that $APPLCSF must be a full, absolute path, and the other two are
directory names.
If $APPLCSF is not set, it places the files under the product top of the application associated with the request. So for example, a PO report would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT
Logfiles go to: /u01/appl/po/9.0/log
Output files to: /u01/appl/po/9.0/out
Of course, all these directories must exist and have the correct permissions.
Note that all concurrent requests produce a log file, but not necessarily an output file.

23.   What are the logfile and output file naming conventions?
Ans. Log file get following name by default: lRequest_id.req
and Output file get following name by default : oRequest_id.out
Output files are stored at $APPLCSF/$APPLOUT
and Log files are stored at $APPLCSF/log
These paths may vary depending on the setups that sys admins perform at the time of Oracle Apps installation
24.How do I check if Multi-org is installed?
Ans. SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS
If MULTI_ORG_FLAG is set to 'Y' Then its Multi Org.
If MULTI_ORG_FLAG is set to 'N' Then its single Org.
 Print  
25.How do I find out what the currently installed release of Applications is?
Ans. 1 - We can also find out through Help > About Oracle Applications
         2- SELECT release_name FROM fnd_product_groups
26.   How do I find the name of a form?
Ans. GUI: Use Help->About Oracle Applications
Scroll down to find the form name
Character: Use Help->Version
27.   How do I lookup ORA errors? (and TNS errors)
Ans. Use: oerr ora XXXX
or: oerr tns XXXX
where XXXX is the error number
(This also supports a number of other error types. Use the 3-letter error prefix in place of 'ora')
28.   How do I generate a message file (usaeng.msb)?
Ans. It can be generated through submission of Concurrent Program from Application Developer responsibility.
29.   How do I submit a concurrent request from PL/SQL?
Ans.  FND_REQUEST.SUBMIT_REQUEST ( ' Parameters');
 Print  

30.    How do I cancel a running concurrent request?
Ans. Navigate to the Concurrent Request Summary form
Select a request
In character, do a Quickpick on the Status column
You can select Cancel or Hold
In GUI, use the Cancel or Hold buttons
The Sysadmin responsibility can cancel or hold any running request

 Print  
31.   Why does Help->Tools->Examine ask for a password?
Ans. Navigate to the Update System Profile Screen.
(\ navigate profile system)
- Select Level: Site
- Query up Utilities:Diagnostics in the User Profile Options Zone.
If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities Menu must enter the password for the ORACLE ID of the current responsibility to use Examine. If set to Yes, a password will not be required.
32.   How do I open a form in query-only mode?
Ans. go to applcation developer responsibilitynavigation->Application/function.query the function name then goto form tab then goto parameters field then write the following code in that fieldQUERY_YES= YES save the changes and then see the forms get affected in query only mode.
33.   How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Ans. One of the easiest ways is to run the product if you can. Running Reports designer will give you the Reports version, running SQL*Plus will give you its version etc.
Another easy way is to launch the Oracle Installer and look in the installed products on the right side. It will list all the products installed with their versions.
Another way is to look at the .rgs file. This file is located in $ORACLE_HOME/orainst
On UNIX, it will be called unix.rgs. On the PC, it will be called Windows.rgs.
This file will list all the products installed and their versions. Note though that
this file is not always correct. For example, patching Reports from 2.5.5.4 to 2.5.5.8 will not show up in this file as the new version. Running Reports Designer is the best way of getting the correct version.
Also, on UNIX there is an executable called 'inspdver'. It is located in $ORACLE_HOME/orainst.
Running it will produce a display of all the installed products. It just pulls the information from unix.rgs, so it may show the wrong information as well.

34.   How do I generate one single form? (As opposed to using adadmin to generate them all)
Ans. No ANSWER
35.   What should I do if I am missing an executable from my APPL_TOP?
Ans. relink the particular module eg :if FNDLOAD is missing then relink FND module













Flexfields Interview Questions





1.       Flexfield Qualifiers and Segment Qualifiers

Ans. Qualifiers are used to set a specific property to the segment columns or segment values.

Flexfield qualifiers are used to set a specific property to the segment columns like balancing segment natural accounting segment cost center intercompany.

For any structure Balacing segment & Natural accounting segemnt should be mandatorily set.

Segment qualifiers are used to set for the values of the segments like expense revenue asset etc in GL

2.       Descriptive Flex Field
Ans. Descriptive Flexfields are used to capture additional or extra business information of the organization.

3.       Context field and Reference field in DFF
Ans.  DFF has two types of segments

1. Global Segments
2. Context Sensitive Segments

Context Sensitive Segments depends on value of another field.

REFERENCE Field - If the context sensitive information is derived from a field in the form then that field is called as a Reference Field.

CONTEXT Field - If the context sensitive information is derived from a field / segment in the DFF pop up windown then that field is called as a Context Field.

4.       flex fields issues
Ans.

5.       what are the mandatory fields you should enabled while designing the descriptive flexfields?
Ans.  Mandatory fields are also called as KEY FLEXFIELDS. Key flexfileds are used to capture mandatory or key business information of the organization. Key flexfields are DATE CURRENCY TYPE OF ACCOUNT.

6.       what are the things you should consider at the time of designing the flexfields?
Ans. NO ANSWER

7.       What is the difference between EITs and DFFs?
Ans.  EIT is HRMS functionality and are used for DFF
DFF is used in GL AP AR....modules to add extra columns to a particulare field
8.       How many flex fields are available in ONT and what are they
Ans. No Answer.
9.       What are range flexfields? How can we create them in our form
Ans.  The Accounting Flexfield Ranges block of the 'Define Budget Organization form' contains a range flexfield called Accounting Flexfield. This is based on Accounting KFF only.
10.   is it possible to do any calculation on DFF or KFF or these are informative fields, and How do you search for specific DFF or KFF?
Ans. Its possible to do calculations on KFF or DFF columns.

But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.

Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.

eg: In PRE-INSERT trigger

:M_RECEIPTS.ATTRIBUTE3 :M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2



11.   How many Key Flex fields are there in financial modules and what are they module wise?
Ans. GL : Accounting KFF

FA: Asset KFF Category and Location KFFs

PO : Item KFF

AR: Location and Territory KFF

12.   How many attribute columns can we have for single dff?
Ans. attribute columns max we can use 1 to 20

13.   how to make DFFs with value set to be non-updatable for the user?
Ans. Enable Freeze Flexfield Check Box to make DFF non-updatable

14.   How do You enable DFF in your form?
Ans.  
Hi, Whether u want to enable (Invoke) the DFF in the Front end Application.if its so then follow the steps.1.Go to the Dff which you want to enable2.keep the mouse pointer on the dff.3.go to the Help-->Diagonast -->Examine4.enter password as APPS5.Note the Title name of the Dff6.switch to the Application Developer.7.go to flexfields--Descriptive--Segments8.Go to Query mode 9.Enter the Dff title name in the Title column10.check out the freeze flexfield definition check box11.compile the form or save the form.

15.   what is element wizard?
Ans.   NO ANSWER

16.   What are the differences between SIT's & EIT's?
Ans.  EIT Extra Information Types
SIT Special Information types
Bothe are HRMS functionalities; SITs are normally KFFs (Key flexfield) and EIT are normally DFFs.

17.   How do we make the segments in a particular flexfield mandatory?
Ans. While defining the segments there is a checkbox called Required . By default it is checked. Checking or un-checking this box decides whether the segment is mandatory or optional.

18.   Can we disable/enable a whole DFF(not few Attributes)
Ans.  Yes this can be done with Custom.pll It has a procedure call Event.In this procedure u can capture events like when-new-form-instance when-new-item-instance etc So capture tht event on which u want to disable your DFF and use name_in('system.current_form/item') to know the name of ur DFF and then using form built-in set_item_property disable that field. Same way we can do enable the DFF

19.   What is the purpose of a flexfield qualifier? Why is it needed when you can have a unique name for a segment?
Ans.   Flexfield qualifiers are basically used to identify the nature of the segment at the flexfield level. Qualifiers like Balancing Cost Center InterEntity Natural Account etc..indicates the type of segment.
For Ex--> Normally company segment is qualified as Balancing which will intimate that the debits should balance the credits for a particular account for a specifiedcompany. i.e for a specific GL code combinations.
Hence having unique names to the segments/flexfield has no connection with this as the purpose of the above is totally different
20.   Is it possible to enable/disable only few fields of any DFF?
Ans. yes by selecting the check box of enable/disable we can select only few attributes of any DFF.

21.   how many flexfields are there in total modules
Ans. 
Owner
Key Flexfield Name
Flexfield Code
Oracle Assets
Asset Key Flexfield
KEY#
Oracle Assets
Category Flexfield
CAT#
Oracle Assets
Location Flexfield
LOC#
Oracle General Ledger
Accounting Flexfield
GL#
Oracle Human Resources
Grade Flexfield
GRD
Oracle Human Resources
Job Flexfield
JOB
Oracle Human Resources
Personal Analysis Flexfield
PEA
Oracle Human Resources
Position Flexfield
POS
Oracle Human Resources
Soft Coded KeyFlexfield
SCL
Oracle Inventory
Account Aliases
MDSP
Oracle Inventory
Item Catalogs
MICG
Oracle Inventory
Item Categories
MCAT
Oracle Inventory
SalesOrders
RLOC
Oracle Inventory
Stock Locators
MTLL
Oracle Inventory
System Items
MSTK
Oracle Payroll
Bank Details KeyFlexField
BANK
Oracle Payroll
Cost Allocation Flexfield
COST
Oracle Payroll
People Group Flexfield
GRP
Oracle Receivables
Sales Tax Location Flexfield
MKTS
Oracle Receivables
Territory Flexfield
CT#
Oracle Service
Oracle Service Item Flexfield
SERV
Oracle Training Administration
Training Resources
RES

22.   What is the use of Group Flex field and where exactly we use?
Ans. Group Flexfield is Used in Oracle Payroll. This Group Flexfield catches the information to which the employee belongs. eg : Regular then the employee belongs to Regular payroll Group,Based on our requirements we categorize the employees in to groups for easy identification purpose.
23.   How do I enable a database column to use it in a DFF segment?
Ans. while u will go through the following
Application developer--> flexfleds--> dff-->segment
there u can find out the enabled check box if u want use the database column then u will check the enabled check box instead of that unchecking the enabled check box
24.   Are the value sets mandatory for DFF segments?
Ans. Valuesets for the segments in DFF's are not mandatory.
25.   Do we need to register Standard DFF’s?
Ans. Stndars DFF's are given by Oracle.We need not register.We can register CustomDFF's .
26.   What is the maximum number of segments that can be defined for KFF?
Ans. Depends on KFF. For example it is 30 in the case Accounting Flexfield and 20 in the case of Sales Tax Location Flexfield
 

27.   What is the significance of structure id in key flexfields?
Ans. The structure ID is the unique identifier for the Flexfield structure defined across the entire installation. It is this unique identifier which helps in associating a structure with an entiry in your installation /Business Unit/Legal entity
28.   What are context sensitive segments in descriptive flexfields?
Ans. Context Sensitive Segments are conditional DFFs. Only when a condition is met a particular field 'appears' and we are able to capture details. So for that first DFF is made context sesitive and then second one if made reference.
29.   What is the difference between key flexfield and Descriptive flexfield?
Ans. Key Flexfield is used to describe unique identifiers that will have a better meaning than using number IDs. e.g a part number a cost centre etc
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.

30.   Can we use other columns (beside attributes) as segments for DFF?
Ans. yes we may.if we register some other columns then we may use them as flexfields.But this is not recommended by Oracle
31.   Which procedure should be used to make the DFF read only at run time?
Ans. FND_DESCR_FLEX.UPDATE_DEFINITION()
32.   What is the significance of cross validate segments in the Key flexfield structure screen (figure 6)?
Ans. Cross validation rule prevents user to enter invalid segment value code combinations.
33.   What is the significance of reference field in a DFF?
Ans.  Using reference field in the DFF you can toggle the DFF on the basis of reference field value.
34.   How do I enter the default value of Key flexfield or DFF segment?
Ans. while defining segments or attribute of KFF or DFF in segement(accounting flexfield) window in validation box select constant in default type and enterdefault value.
35.   What is the difference between flexfield qualifier and segment qualifier?
Ans. Flexfiled qualifier identifies segement in a flexfield and segment qualifier identifies value in a segment.
There are four types of flexfiled qualifier 1) Balancing segment qualifier 2) cost center 3) natural account and 4) intercompnay
segemtn qualifier :- 1) allow budgeting 2) allow posting 3) account type 4) contral account and 5) reconciliation flag
36.   How do I define global segment qualifier?
Ans. Global segment qualifier is a hidden qualifier. By default this flexfield qualifier is assigned to all the segments of the structure by the system.

1. Allow Budgeting: YES/NO

If we enable 'Allow Budgeting' ---- YES on any segment value it means we can allow budget values on that segment value.

2. Allow Posting: YES/NO

If we enable 'Allow Posting' ------YES on any segment we can post journals created on that segment value.

37.   Which procedure should be called to enable a DFF in a form?
Ans. FND_DESCR_FLEX.DEFINE (BLOCK > 'BLOCK_NAME'
FIELD > 'FORM_FIELD_NAME'
APPL_SHORT_NAME > 'APP_NAME'
DESC_FLEX_NAME > 'DFF_NAME'
);