Infolinks

Wednesday 16 May 2012

Oracle Apps Technical Interview Questions & Answers


       Oracle Apps Technical Interview Questions & Answers

               ===================================================

1.Question :
------------
How dou you enable trace/debug in apps?

Answers:
--------
This is Technical Consultant work.

We can enable the trace by using HELP(in the Oracle Apps instance)-> Oracle Applications.

&

Go To System Administrator Responsibility

Select Tools -> custom properties -> enable Trace

&

open any form go to help=>diagnostics=>trace then u can select any regular trace so many options are there

&

We can enable trace at concurrent program level also.

Go to System Administrator resposibility

Concurrent --> Program --> Define

You will find the Enable Trace check box.

Thanks.

&

open any form go to help=>diagnostics=>trace then u can select any regular trace so many options are there

2.Question :
------------
How can you restrict the access(to oracle apps)to a group of users using personalization?

Answers:
--------
Node or Responsibility Trust Level : is profile option, to restrict access to set of responsibilities based on Web Server from which user logs in.

This profile option can take one of three values -
?Administrative
?Normal (Default Value)
?External

3.Question :
------------
What are different types of Journal entries ?

Answers:
--------
Ans: Encumbrance,Stats,Actual


There are 3 types of journels in GL
A-Accounting
B-Budget
E-Encoumbrance

4.Question :
------------
Can anybody suggest me how can the multi org. be set up?

Answers:
--------
We can do the multi org set up with this command like

begin

fnd_client_info.set_org_context(204);

end;

Run this package then u will get the output.


multi org will be installed at the time of oracle 11g installed and to knw whether multi org is present in ur system just type this query
select * from fnd_product_groups if multi_org_flag='y' then it is installed in your system

5.Question :
------------
Which module is not a multiorg?

Answers:
--------
General Ledger and CRM Foundation Modules


General ledger is a multiorg but inventory is not multiorg.

&

Genrel ledger correct because of it having the set_of_bokks_id

&

GL

&

general ledger
is not multiorg
and inventory is multiorg
then crm is not multiorg

6.Question :
------------
If I stopped the concurrent manager, then where and how I can see that concurrent manager is stoped or not??

Answers:
--------
I think We can also check the status of that service of that particular concurrent manager(OracleConcMgr)

there u will find the Status as Stopped.

Actually u may not have access for the services (these services will be running in the server) only DBA can access those services



this job can be done by DBA`s

As a DBA the status of concurrent manager can be seen by giving the following line in the commandline

ps -ef|grep FNDLIBR

when u perform this,
if u see a single line as output the status of concurrent manager is stop

if u see a more than one line as output the status of concurrent manager is running

&

AFCONSTAT.SQL BY RUNNING THIS SCRIPT ALSO WHICH IS IN AD_TOP/SQL WE CAN KNOW THE STATUS

7.Question :
------------
What are Summary Accounts and Rollup groups ?

Answers:
--------
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.

8.Question :
------------
What are cycles of GL, AP, and AR?

Answers:
--------
The process is

gl-->ap-->ar-->


9.Question :
------------
What are different types of invoices and what is a recurring invoice?

Answers:
--------
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.

10.Question :
-------------
What is the difference between discounts and adjustments?

Answers:
--------
Discount : attached to price.

Adjustments : At the time of transactions can give additional discount through adjustments.

Note: If i m wrong pls correct.

11.Question :
-------------
What are the setup steps for testing ?

Answers:
--------
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.

12.Question :
-------------
What id recurring invoices ?

Answers:
--------
Recurring invoices are those invoices which re occur after a specific time interval eg. Monthly Rent


we can create same invoice to multiple times to supplier


18.Question :
-------------
What are AP setup steps ?

Answers:
--------
setup---->suppliers....>invoices..>payments.....>reports......>periods.....>transfer to GL

19.Question :
-------------
Can you add a descriptive FlexField to a table which already have data in it ?

Answers:
--------
yes,,u can add descriptive flex fields to the table that is already existing..but it should be registered using ad_dd package.and after table registeration,,ur columns must also be registered.and once this database registeration is over,,u need to login as appdevelop responsibility and then dff steps is to be done,,,like giving the name of the attribute category to hold the dff columns..

20.Question :
-------------
If any conflict occurs in FSG the who will override Column Set or Row Set ?

Answers:
--------
Column set provided while defining Columns you should have checked the "Override Row Calculations" checkbox.

21.Question :
-------------
How to take care of null values in SQL Loader ?

Answers:
--------
By using the following statement in Control file.

TRAILING NULLCOLS

22.Question :
-------------
What is ICA (Internet Computing Architecture)?

Answers:
--------
In ICA we have desktop Client,Application Server and Database Server.

23.Question :
-------------
What is the difference between cross-validation rules and security-rules?

Answers:
--------
Security rules applies at Value Set level while Cross Validation Rule applies on Segment values.

24.Question :
-------------
In how many ways can you enter a journal in GL?

Answers:
--------
We can add JE by EDI.There is a separate responsibility called Oracle EDI which created standard excel templates.It has a menu called 'Oracle' which has a submenu called 'upload'.Enter all the Journals and click on upload.A consurrent request gets submitted and Journals are entered.

25.Question :
-------------
What are the setup steps for AP, AR, GL?

Answers:
--------
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

26.Question :
-------------
What are the different types of files used in SQL Loader ?

Answers:
--------
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.


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.

&

In SQL LOADER have 5 files

they are

1.control file

2.bad file

3.discard file

4.data file

5.log file

27.Question :
-------------
How can you handle multiple rows without using loops in PL/SQL ?

Answers:
--------
By Using Cursor.



using record type or index by table

&

REF CURSOR is one way you can do this.
say TYPE f1 IS REFCURSOR
if you want a function to return multiple rows then declare the return type as a REF CURSOR .
when reading it can be a simple select f1_refcursor from dual

&

PL/SQL provide functionlity to fetch more than one row which are satisfied by given query with the help of cursors. cursors are temporaray work area which is used to hold rows. It is categorized into two category implicit cursor and explicit cursor.......

28.Question :
-------------
What do you mean by HZ_ in customer tables ?

Answers:
--------
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

29.Question :
-------------
What are value sets ?

 Answers:
Value sets are nothing but a set of values, and if u want to list out the parameters we use value set.

Value set defines the segment size, data format and validation technique.

we have different validation techniques:

they are

1.Independent

2.Dependent

3.Table

4.None

etc...



vlaue set is nothing but a list of values with validation.
these are 8 types .
i.e.
1.NONE
2.INDEPENDENT
3.DEPENDENT
4.TABLE
5.TRANSLATED INDEPENDENT
6.TRANSLATED DEPENDENT
7.SPECIAL
8.PAIR

&

THERE ARE 8 TYPES OF VALUE SETS,
CREATING VALUE SET IS BASED ON 2 METHODS
1)STATIC
2)USING SQL QUERY

VALUE SETS ARE

1.NONE

NIETHER STATIC NOR SQL IT IS USER FRIENDLY

2.INDEPENDENT

STATIC

3.DEPENDENT

STATIC AND IT DEPENDS ON INDEPENDENT VALUE SET WITH OUT INDEPENDENT WE CAN NOT CREATE DEPENDENT VALUE SET

4.TABLE

USING SQL QUERY

5.TRANSLATED INDEPENDENT

SAME AS INDEPENDENT BUT 1 EXTRA COLUMN WILL BE ENABLE WHENEVER ORACLE APPS IS IMPLEMENTED IN MULTIPLE LANGUAGE

6.TRANSLATED DEPENDENT

SAME AS DEPENDENT BUT 1 EXTRA COLUMN WILL BE ENABLE WHENEVER ORACLE APPS IS IMPLEMENTED IN MULTIPLE LANGUAGE

7.SPECIAL
8.PAIR

THESE ARE USED FOR FLEXIFIELD PURPOSE


30.Question :
-------------
What are different types of transactions in AR ?

Answers:
--------
Possible Transaction types in AR are:
Invoice transaction.
Deposit transaction.
Debit memo transaction.
Credit memo Transaction.
Charge back transaction.
Guarantee Transaction.

31.Question :
-------------
What is FSG and what is its use ?

Answers:
--------
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.

32.Question :
-------------
What are ad-hoc reports ?

Answers:
--------
Adhoc querys is query where run time we can give more conditions ,

using and ,or , between etc for parameters values . Generally we use

Lexical parameters for this type of querys.

33.Question :
-------------
What are the new features in Release 11I ?

Answers:
--------
Significant New features in Accounts Payable 11i ?
Invoice Matching to Receipts
Recoverable Taxes
Record Refunds
Flexible Accounting Entries
View Accounting Lines Window

Significant New features Accounts Receivable 11i ?
AutoAccounting Enhancements
AutoInvoice Exception Handling
Bills of Exchange (BOE)
IReceivables

There are a lot of other enhancements in both these modules which can be analyzed further from the Product update Notes for R11i.

34.Question :
-------------
How many reporting currencies can be attached to Primary Set Of Books ?

Answers:
--------
Only one reporting currency can be attached to one Primary Set of Book. If the currency changes then the SOB will also change.

35.Question :
-------------
What is MRC and what are its use?

Answers:
--------
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.

36.Question :
-------------
How many Flexfields are there in AR and what are they ?

Answers:
--------
There r two Flex fields available in AR

1) SALES TAX LOCATION.

2)TERRITORY.

37.Question :
-------------
Can you use REF cursors in CUSTOM library?

Answers:
Could someone please answer why we cannot use REF Cursors in CUSTOM.pll

38.Question :
-------------
Can you call APPCORE library in CUSTOM library ?

 Answers:
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.

39.Question :
-------------
How to handle errors in Customer interface ?

Answers:
--------
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.

40.Question :
-------------
What are the steps in Customer Interface ?

Answers:
--------
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.

41.Question :
-------------
What are the libraries attached to TEMPLATE form ?

Answers:
--------
The Template form required 19 .pll in 11i version. Those pll names are :

APPCORE.pll
APPCORE2.pll
FNDSQF.pll
APPDAYPK.pll
GLOBE.pll
JE.pll
JL.pll
JA.pll
VERT.pll
GHR.pll
PQH_GEN.pll
PSAC.pll
PSB.pll
PSA.pll
IGILUTIL.pll
IGILUTIL2.pll
CUSTOM.pll
GMS.pll
FV.pll
OPM.pll

42.Question :
-------------
If the valueset if of type ?TABLE then how many tables can we attach in the valueset ?

Answers:
--------
You can assign only one table for TableValueset. But The where condition depends any number of table valueset using the key word ':$FLEX$'


We can use any number of tables using where condition.

&

You can attach N number of tables in Table Name separated with comma and in where clause as well.

&

Normal we can use only one table in table type,but if u r using $flex$ we can use any no.of tables using "where" separated by "Comma"

43.Question :
-------------
What are different period types ?

Answers:
--------
Period Types can be Month Week Period Quarter or Year. In terms of module there is cost periods, AR, AP, GL and Purchasing Periods

44.Question :
-------------
What is Set of Books ? What are the four conditions when you change your SOBs?

     Answers:
Chart of Accounts, Currency & Calender



Sob is combination of 3 C's.they are Chart of account and currency and calender.

45.Question :
-------------
How to register tables and columns in AOL?

Answers:
--------
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.


No Sandeep we cant register a table or its column like that. the window you hav mentioned doesnt allow us to enter nething. we can just see all the registered tables and their columns here.

one way which i know to register a table and their columns is thru backend .

eg.SQL> EXEC AD_DD.REGISTER_TABLE (?SQLGL?, ?EXAM?,?T?)

where SQLGL is aplication short name and EXAM is the table name and T stands for Transaction Data

SQL> EXEC AD_DD.REGISTER_COLUMN (?SQLGL?, ?EXAM?,?SNO?, 1, ?NUMBER?, 5, ?N?, ?Y?);

?EXAM? ? Table Name

?SNO? ? Column Name

1- Sequence one or column one

?NUMBER?- Number Data type

5-Size

?N? ? Null able

?Y? ? Translate (Y/N)


46.Question :
-------------
What are User Exits ?

Answers:
--------
A user exit is a C subroutine written by you and called by Oracle Forms to do special-purpose processing. You can embed SQL statements and PL/SQL blocks in your user exit, then precompile it as you would a host program.

When called by an Oracle Forms V3 trigger, the user exit runs, then returns a status code to Oracle Forms. Your exit can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table lookups, and manipulate Oracle data.

To incorporate a user exit into a form, you take the following steps:
Write the user exit in Pro*C.
Precompile the source code.
Compile the. c file from step 2.
Use the GENXTB utility to create a database table, IAPXTB.
Use the GENXTB form in SQL*Forms to insert your user exit information into the table.
Use the GENXTB utility to read the information from the table and create an IAPXIT source code module. Then compile the source code module.
Create a new SQL*Forms executable by linking the standard SQL*Forms modules, your user exit object, and the IAPXIT object created in step 6.
In the form, define a trigger to call the user exit
Instruct operators to use the new IAP when running the form. This is unnecessary if the new IAP replaces the standard one.


user exists a program that is written and linked report builder

it's 5 types
1.before parameter
2.after parameter
3 before report trigger
4.after report trigger
5.between pages

&

User Exit :
-----------
User_Exit is a facility given in reports, to transfer the execution of report from report builder to the 3GL.

1.SRW.USER_EXIT('FND SRWINIT');
It will capture profile values of the user when the report is executed from SRS window.
FND SRWINIt User_Exit will be called from Before Report Trigger.

2. SRW.User_Exit('FND SRWEXIT');
It will be called from After Report Trigger which frees the memory occupied by the parameters of the report.

Below User_Exit are used to capture the data which stored in segments of the tables. one user exit is used to capture the segment data and another is used to populate the data.

3. SRW.User_Exit('FND FLEXSQL
CODE = " "
NUM = " "
Appl_Short_Name=" "
Output=" "
Mode= " "
Display = " "');
Used for the Key Flex Fields and stored in the Before Report Trigger.


4. SRW.User_Exit('FND FLEXIDVAL
CODE = " "
NUM = " "
Appl_Short_Name=" "
DATA=" "
Value= " "
Mode= " "
Display = " "');
is used for the Key flex fields this user_exit is written in the Formula column.

47.Question :
-------------
What is Multiple Organization technical architecture?

Answers:
--------
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)

48.Question :
-------------
What can we find TEMPLATE.FMB file ?

Answers:
--------
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.

49.Question :
-------------
What is the use of CUSTOM Library in Oracle Apps?

Answers:
--------
Custom library or custom.pll give the programmer a flexibility to add code on allowed custom events . As custom .pll is general for all the forms that open in application , you have to specify in you code , the exact form name , block name , item name and event name where the code should execute.

However not all the events are supported in custom .pll but you can very control the behaviour of object and add logic to some extent with the help of custom .pll coding. For more information please refere Oracle Applications Developers Reference Manual

50.Question :
-------------
What is FlexField?

Answers:
--------
Flexfiled is nothing but a Flexable data,
Oracle Application uses Flexfield to capture information about Your organization.
Like Company,
Cost Center,
Account.
They r two types of FlexFields :
They r:
1.Key Flexfield:collection of Atributtes
Discriptive Flex Fild:collection of Segments


Flexfields are special type of text fields which is internally mapped to a set of segments or attributes depending on the type of flexfield. This mapping is defined by the customer as per his requirement.

There are two types of flex fields. One is Key flex field which stores the combination of the segments in a seperate unique column and another contains the structure.For example code_combination_id and chart of accounts in gl_code_combinations table. Descriptive flex field does not contain any storage column for storing combinations. Instead descriptive flex field contains a context column which stores context information.

51.Question :
-------------
What are User Exits and what are different types of User Exits in Oracle Apps ?

Answers:
--------
User Exit is nothing but a colection of changable optin that it can be change in the way of our applicalion
In Apps 4 types of User Exits.
Saite Level
Application Level
Resposibility Level
User Level

User Level: It is Higer level , it is applicable to the all users.
Application Level: It is applicable to that particular application only
Resposibility Level:
For that Particular resposibility

Site Level:Is lower level , if we difiened if it is Site level , it will appilicable to the all users..




Program that can be written and linked into the report builder executable or user exit DLL files.
User exits are build when ever the control need to be passed from the report builder to a program, which performs some function and then control returns to the Report Builder.

Types of user exits :-
A)    Oracle Pre-Complier user exits.
B)    OCI (Oracle Call Interface user exits)
C)    Non ? Oracle user exits.
User exits can perform the following tasks.
Perform complex data manipulation.
Pass data to report builder from OS text files.
Support PL/SQL blocks.
Control real time devices be printer or robot.

&

User Exits are 5 types.
FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXIDVAL
FND FLEXSQL


52.Question :
-------------
What are different types of Journal entries ?

Answers:
--------
There are mainly two types of Journal entries :

1. Simple Journal Entry

2. Recurring Journal Entry

53.Question :
-------------
What is an Invoice ? How many types of invoices are there in AP and AR ?

Answers:
--------
There are 8 Types of Invoices.

1) Standard Invoice.

2) Debit Memo.

3) Credit Memo.

4) Expense Report Invoice.

5) PO Default Invoice.

6) Quick Match Invoice.

7) Fixed Invoice.

8) Pre - Payment Invoice.



AP
=======================
Standard
Credit Memo
Debit Memo
Expense Report
Prepayment
Retainage Release
Transportation Invoices
Withholding Tax
Mixed

AR
===========
Credit Memo
Debit Memo
chargeback
Deposit
Guarantee
Invoice


54.Question :
-------------
I'm new to oracle apps...please tell me...

What is integration between modules?
What modules in Order management can be integrated with Finance
modules ?
How this integration is done?

Answers:
--------
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.

55.Question :
-------------
How do u 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,,,,plz respond

Answers:
--------
i wonder why it didnt work for u.

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,,,

56.Question :
-------------
How can i incorporate a lexical parmater in my report for having the FROM DATE and TO DATE parameter?. Can u Pls let me know of the steps involved in doing the same?

Answers:
--------
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

57.Question :
-------------
Can anybody suggest me how can the multi org. be set up?

Answers:
--------
We can do the multi org set up with this command like

begin

fnd_client_info.set_org_context(204);

end;

Run this package then u will get the output.


We can do the multi org set up with this command like

11i Instance

begin

fnd_client_info.set_org_context(204);

end;
R12 Instance
begin

mo_global.set_policy_context(Org Identifier,ORG_ID);
Org Identifier having below mentioned three values
S Single Org
M Multi Org
A All Org

end;

Run this package then u will get the output.

&

in 11i
Begin
fnd_client_info.set_org_context(org_id);
end;


in R12
mo_global.set_policy_context(Org Identifier,Org_id);
end;

we can find multi_org is installed or not using table
fnd_product_groups
column is multi_org_flag=
if 'Y' installed

58.Question :
-------------
What does US mean in appl_top/au/11.5.0/reports/US?

 Answers:
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


59.Question :
-------------
What are the types of Concurrent Managers?
Can we delete a Concurrent Manager?

Answers:
--------
There are three types of Concurrent manager, list Below

1-Standard Concurrent Manager

2-Conflict Concurrent Manager

3-Not Recalling later on

60.Question :
-------------
What is the RFQ Report from PO?


there are mainly three types of concurrent managers are there they are as follows :

1 : internal concurrent manager
2 : standard concurrent manager
3 : conflict resolution manager

to delete a concurrent manager :

You can disable the manager by checking the 'Enabled' checkbox You can simply Terminate the manager and it will not run
again unless you reactivate it. Or, if you really, really want to, you can query the manager in the 'Define Manager' form, and
delete the row. (But DONT do this)

Answers:
--------
As per my knowledge,

Purchasing formats your purchase orders to be printed on a standard

purchase order form. This section explains how Purchasing prints the

purchase order information. You can use the standard format or

customize the report to meet your needs.

The Printed RFQ Report (Portrait/Landscape) prints in respective style format RFQs

with a Status of Active. Purchasing lets you specify the RFQs you want

to review or print. Purchasing provides a default landscape format for

preprinted landscape forms.

61.Question :
-------------
what is a request Sets? how to create a request Set?

Answers:
--------
Request sets define run and print options and possibly parameter values for a collection of reports or concurrent program.... End user & System Adminstrator can define request 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.

62.Question :
-------------
What are the different types of value sets and also explain each briefly ?

Answers:
--------
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

63.Question :
-------------
What are the diiferent types of Value sets and expalin them briefly which value set will use when?

Answers:
--------
There r six diffrent types of Value sets available in Oracle Apps.

1)Independent.

2)Dependent.

3)Table.

4)Special.

5)Pair.

6)None.



There are eight(8) diffrent types of Value sets available in Oracle Apps.

1)Independent value set : If user set of values need to be populated to a perticular parameter then we can use Independent value set.

2)Dependent value set : It always dependent upon independent value set only.

3)Table value set : It will get the values from the database objects (such as table or view).

4)Special value set : It is used for Flex Fields.

5)Pair value set : To give maximum value and minimum value to the value set.

6)None Value set: If parameter value has to enter by end user.

7)Translated Independent value Set : It translate values into different languages for an independent value set.

8)Translated Dependent Value Set : It Translate values into different languages for an dependent value set.


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

FND FLEXSQL

FND FLEXIDVAL

Answers:
--------
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?]


These two user exits are used for the Key Flex field reporting. Where you have to capture and print the date which stored in the segments of the table.

FND FLEXSQL is used to capture the data from segments.
FND FLEXIDVAL is used to populate the captured segment values.

If you want to use these user exits then we have follow below steps :

1. Create 3 Variables

Name DataType Initial value
P_CONC_REQUEST_ID Number(20) --
P_Struct_Num Number(20) --
P_Flex_Data Char(6000) (Segment1||' '||Segment2......||Segmentn)

2. In Before Report Trigger

SRW.Reference(:P_Struct_Num);
SRW.User_Exit('FND SRWINIT');
SRW.User_Exit('FND FLEXSQL
CODE="GL#"
NUM=":P_Struct_Num"
Appl_short_Name="SQLGL"
Output=":P_Flex_Data"
Mode = "Select"
Display ="All"');
compile and close.

3. In After Report Trigger
SRW.USER_EXIT('FND SRWEXIT');
compile and close.

4. Go to Data Model in Report Builder
selet Last_update_date,&P_Flex_Data C_Flexdata from gl_code_combinations
where chart_of_accounts_id=:P_Struct_Num

5. got to Data model create layout using wizard.

6. Create a formula column with CF_Data datatype char(6000)

In that formula column

SRW.REFERENCE(:P_Struct_Num);
SRW.REFERENCE(:C_Flexdata);
SRW.USER_EXIT('FND FLEXIDVAL
CODE="GL#"
NUM=":P_Struct_Num"
Appl_short_Name="SQLGL"
Date=":C_Flexdata"
Value = ":CF_Data"
Mode = "Select"
Display ="All"');
return (:CF_Data);

compile and close.

7. Register the report in the applications and run it.

65.Question :
-------------
How to submit concurrent program through pl/sql

Answers:
--------
The below procedure will submit the request from the back end where

application is Short name of application under which the program is registered.

program is concurrent program name for which the request has to be submitted

declare
conc_id number(10);

begin
FND_GLOBAL.APPS_INITIALIZE (user_id,resp_id, resp_appl_id);
conc_id:=submit_request('application','program');
dbms_output.put_line(conc_id);
end;

The above program will print the Concurrent request ID.


begin
fnd_request.submit_request(concurrent program application name,conc programm short name,start time,parameter values,creation time);
fnd_global.apps_initialize(user_id,respid,respapplid);
end;



 Posted by: Mohan Kumar   

 Contact Mohan Kumar
Function FND_REQUEST.SUBMIT_REQUEST
( application    in varchar2    default null,
program     in varchar2    default null,
description in varchar2    default null,
start-time     in varchar2    default null,
sub_request    in bookan default False,
argument1,
arguemnt2,
argument 100) return number;
* If this is submitted from oracle forms, all the arguments ( 1 to 100 ) must be specified.


66.Question :
-------------
Which module is not a multiorg?

     Answers:
There r multiorg in gl when we check there r multy org property


GL, FIxed Assets are regardless org_id

&

inventory module.because it is does not contain any profile value

67.Question :
-------------
When form builder open which trigger will fire first and last?

 Answers:
When first open the form,the first trigger going to be fired is PRE-FORM TRIGGER and last trigger is POST-FORM TRIGGER


when we open the form the following tigger fired are

pre-form
when-new-form-instance
when-block-instance
when-record-instance
when-new-item-instance

&

When we open a form, the trigger which is fired first is on-logon and the trigger fired last is on-logout.


68.Question :
-------------
I am new to this forum and also to Oracle HRMS. I have 5 questions:
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?
Would appreciate quick answers!!!

Answers:
--------
1. DateTrack adds the dimension of time to an application?s database.

The value of a DateTracked record depends on the date from which

you are viewing the data. For example, querying an employee?s annual

salary with an effective date of 12?JUL?1992 might give a different

value than a query with an effective date of 01?DEC?1992. However,

the application and the user see the employee?s pay as a single record.

For more information to how to use it look at this document available in Oracle web site

Implementing Oracle HRMS (US)




1) Date Track option in oracle Hrms used to see the history of the employee and also set the future dated tasks to the employees in the system.
date track tables are always ends with _f and columns of date track are effective_start_date and effective_end_date
2)No you cannot delete an employee from the system once the payroll has been run for the employee
3)Api are mostly used for the designing the interfaces for data migration
Data pump:-
4)User Hooks are used for the validations. with the user hooks u can do validation on the Jsp page as well as the Form.


69.Question :
-------------
Please tell me the difference between Conversions and Interfaces.

Answers:
--------
Conversion is to bring the data from other (non-OraApps) system to Oracle-Application system. This is one time activity (bring account details, transactions, orders, receipts and so on). So conversion itself is a project.

Interfaces are Concurrent PRograms/Program sets (pl/sql, pro*C, unix scripts, executables) . Interfaces are basically of two types (Oracle supplied (vanila programs eg:Autoinvoice in AR) and created by developer).

Hope this clarifies the concepts.


CONVERSION :-
IT IS A PROGRAM
->IT IS ONE TIME DATA TRANSFER
->WE WILL BE KNOWING THE VOLUME OF THE FLAT FILE
->NO NEED KNOW ALL EXCEPTIONS
->THIS IS USED IN UPGRADING,MIGRATION PROJECTS

INTERFACE:-
IT IS A PROGRAM TO TRANSFER THE DATA FROM ONE LOCATION TO ANOTHER
LOCATION
->IT IS SCHEDULED CONCURRENT PROCESS TO EXECUTED MULTIPLE TIMES
->WE WILL NOT BE KNOWING FLAT FILE VOLUME
->WE NEED TO HANDLE ALL EXPECTED EXCEPTIONS
->USED IN ENCHANCEMENT,CUSTOMIZATION PROJECTS

69.Question :
-------------
I want to know what is the column link between OM and AR and also the link between AR and GL?

Answers:
--------
Column 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.


the order_number in oe_headers_iface_all is to be linked with interface_header_attribute1 in ra_customer_trx_all from here link customer_trx_line_id to customer_trx_line_id in ra_customer_trx_lines_all

&

There is no column in the OM(OE_ORDER_HEADERS_ALL) and Interface table also. I hope that is SOLD_TO_ORG_ID instead of SALES_TO_ORG_ID.

&

link between OM and AR

order_number in OE_ORDER_HEADERS_ALL
and
interface_header_attribute1 in RA_CUSTOMER_TRX_ALL

link between AR and GL

trx_number in RA_CUSTOMER_TRX_ALL
and
reference2 in GL_JE_LINES

&

link between oe_order_headers_all and ra_customer_transactions_all

&

The links between OM and AR are
(1) OM(so_headers_all(customer_id))=AR(ra_customers(customer_id))
The link between GL and AR
(2)GL(gl_code_combinations(code_combination_id))=AR(ra_cust_trx_line_gl_dist_all(code_combination_id))

&

In R12, try using the query below:

SELECT b.NAME batch_name,
b.description batch_description,
h.je_category,
h.je_source,
h.period_name je_period_name,
h.NAME journal_name,
h.status journal_status,
h.description je_description,
l.je_line_num line_number
FROM gl_je_batches b,
gl_je_headers h,
gl_je_lines l,
gl_code_combinations_kfv glcc,
gl_import_references gir,
xla_ae_lines xlal,
xla_ae_headers xlah,
xla_events xlae,
xla.xla_transaction_entities xlate,
ra_customer_trx_all rct,
WHERE b.je_batch_id = h.je_batch_id
AND h.je_header_id = l.je_header_id
AND xlal.code_combination_id = glcc.code_combination_id
AND l.je_header_id = gir.je_header_id
AND l.je_line_num = gir.je_line_num
AND gir.gl_sl_link_table = xlal.gl_sl_link_table
AND gir.gl_sl_link_id = xlal.gl_sl_link_id
AND xlal.ae_header_id = xlah.ae_header_id
AND xlah.event_id = xlae.event_id
AND xlae.entity_id = xlate.entity_id
AND xlae.application_id = xlate.application_id
AND h.je_source = 'Receivables'
AND h.period_name = '2009-10'
AND rct.trx_number = xlate.transaction_number
AND xlate.transaction_number ='<TranxName>'

70.Question :
-------------
What is Data Migration and what is Conversion?
Whats the difference between both.

Answers:
--------
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.


Migration Means Upgrading the data from lower version to Higher version like 10.7 to 11i.
Integration Means Passing the Data from Higher Versionof oracle database to lowerversion of oracle database like 10g(Application R12 or 11i) database to 8i Database(Application 10.7).

Implementation Means we are introducing first time oracle database in client system.

Generally implementation projects we are using conversions.

&

Migration:Changing from legacy system into Oracle apps

Conversion:Converting the format from Oracle 11.5.9 to Oracle 11.5.10

&

Data Migration is upgrade the data old version to new version. like 11.5.0 to 12.01.1
and conversion is transfer the data from one instance to another instance

71.Question :
-------------
What is the difference between Quick Pick and Quick Codes?

Answers:
--------
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.

72.Question :
-------------
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

Answers:
--------
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.

No comments:

Post a Comment