Define Interfaces. What are the different types of Interfaces?Interfaces are used to integrate external systems and data conversion in Oracle Applications.

These can be used to either transfer data from Oracle Applications to a Flat File or Data from Legacy System to Oracle Applications.

There are two types of Interfaces. Inbound and Outbound Interfaces.

Inbound Interfaces are used to transfer data from external system to Oracle Applications.

Outbound Interfaces are used to transfer data from Oracle Applications to External System.

Open Interface is the interface whose interface logic is provided by Oracle.

Custom Interface is an Interface whose logic is developed by implementation team.

What is Concurrent Programming?Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.

Use Concurrent Programming for

Long Running – Data intensive tasks such as Posting a Journal or generating a report.

3 What is the Role of Concurrent Managers?

A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer.

4. What is AOL?

Oracle Applications are constructed and maintained using the Application Object Library (AOL).

The Three main areas of AOL are

Applications Security
Operating Profile
Concurrent Processing

What are alerts? What are the different types of alerts? Explain.

Alerts

Immediately inform you of the database activity as it happens.
Can Periodically trigger off events as and when required
Can take predefined actions
Allow you to define distribution list
Can keep history of the exceptions and actions taken against them.

There are two types of alerts.

Event Alerts
Periodic Alerts

What is the Flex field? What are the types of Flex field?

Flex Field is “Flexible Field”
A Flexfield is made up of Segments.
Each segment has a name that can be assigned and has set of valid values.
There are two types of Flex field Key Flex Field and Descriptive Flex Fields.

What are the tables related to flex field?

FND_FLEX_VALUES
FND_FLEX_VALUE_SETS
FND_FLEX_VALUES_TL

What is AD_DD package?

AD_DD Package is used to register the Table, Columns, and Primary Key in Oracle Applications.

PROCEDURE REGISTER_TABLE

Arguments:

P_APPL_SHORT_NAME
P_TAB_NAME
P_TAB_TYPE
P_NEXT_EXTENT
P_PCT_FREE
P_PCT_USED

PROCEDURE REGISTER_COLUMN

Arguments

· P_APPL_SHORT_NAME

· P_TAB_NAME

· P_COL_NAME

· P_COL_SEQ

· P_COL_TYPE

· P_COL_WIDTH

· P_NULLABLE

· P_TRANSLATE

· P_PRECISION

· P_SCALE

What are the types of Value sets?

· None

· Table

· Special

· Pair

· Dependent

· Independent

· Translatable Dependent

· Translatable Independent

What are the Special and Pair Flex Field?

Special – Value Sets uses FlexField itself

Pair – Two Flex Fields together specifies a range of valid values.

What are the Translatable Dependent and Independent Flex Fields?

Translatable Independent – Input must exist on previously defined set List of

Values. Translated value can be used.

Translatable Dependent means Input is checked against a subset of values

Based on a prior value. Translated value can be used.

What is FND_REQUEST.SUBMIT_REQUEST?

Submits a Concurrent Request for Processing by a Concurrent Manager.

Arguments – Application,program,description,start_time,sub_request,arg1..

What is Client Info?

By calling this Program in SQL*PLUS or reports with correct parameters user can achieve concurrent program environment for testing.

FND_CLIENT_INFO.setup_client_info(application_id Number,

Responsibility_id Number,

User_id Number,

Security_Group_id Number);

Give the Directory structure in apps?

$APPL_TOP - Product Directory- Version-

What are the steps in Registering Concurrent Program?

Go to Programs and Define Executables.
Go to Programs and Define Concurrent Program
Go to Responsibility and attach the Request group you want.

What are the different types of executable available in Concurrent Programming?

Host
Oracle Reports
PL/SQL Stored Procedures
SQL*LOADER
SQL*PLUS
Spawned
JSP

What are Request Sets?

Request set is a collection of Reports/Programs that you group together and can be submitted to run is a single interaction.

What is Standard Request Submission (SRS Feature)?

SRS provides you with a set of windows for running reports and Programs and a set of windows for creating groups of reports and programs to run together.

Features

Specify whether reports or programs in a request set run sequentially or simultaneously
Specify whether to continue with a request set if a report or program in a sequential set fails
View a log file
Specify alternative requests based on completion status of previously run requests in a request set.

What are the different API’s for Concurrent Programming?

FND_CONCURRENT
FND_FILE
FND_PROGRAM
FND_SET
FND_REQUEST
FND_REQUEST_INFO
FND_SUBMIT

What are the Different PLL’s Used in Forms?

CUSTOM.pll
FNDSQF.pll
APPCORE.pll
APPCORE2.pll
appdaypk.pll
APPSTAND form

What are the Steps in Forms Customization?

Define the Form Name in FORM Screen
Define Form Functions
Attach to Menu/Attach to Request group

What are the triggers that can be modified during Forms Customization?

Pre-Forms
When-New-Form-Instance
Query_Find
Post-Form
Key-Clrfrm
Accept

What are the triggers that cannot be modified during Forms Customization?

STANDARD_ATTACHMENT
ZOOM
FOLDER_ACTION
KEY-HELP
KEY-EXIT
KEY-COMMIT
WHEN-WINDOW_CLOSED
CLOSE_WINDOW

What are the FlexField Qualifiers?

A Flex field qualifier identifies a particular segment of a key flex field.

What are the Segment Qualifiers?

A Segment Qualifier identifies a particular type of value in a single segment of a key flex field.

What is a Dynamic Insertion?

Dynamic Insertion is the insertion of new valid combination into a Key Flexfields Combinations Table from a form other than the combinations form.

All Validation rules still will apply during insertion.

What are the different Level of Profiles?

User Profiles are used

To set options that affect your applications behavior of your preference.
A Collection of changeable options that affect the way your applications run
Modify Product Specific variables
Gives Control over certain Oracle Applications features.

Profile Levels

· Site Level

· Application Level

· Responsibility Level

· User Level

Site Level is the lowest level.

Explain Multi-Organization Structure?

Set of book

A financial reporting entity that uses a particular chart of accounts, functional currency and accounting calendar.

Business Group

This is highest level in the Organization Structure. The Business group secures HR Information. Multiple set of books can share same business group.

Legal Entity

A legal company for which you prepare fiscal or tax reports.

Balancing Entity

Represents an accounting entity for which you prepare financial statements.

This is the segment in Accounting Flexfield.

Operating Unit

An Organization that Uses Oracle Cash Management, Order Management and shipping Execution, Oracle Payables, Oracle Purchasing, Oracle receivables.

It may be a Sales office division or a department. An Operating Unit is associated with legal entity.

Inventory Organization

An Organization for which you track Inventory transactions and balances and/or an Organization that manufactures or distributes products.

HR Organization

HR Organization represents the basic work structure of any enterprise. They usually represent Functional Management or reporting groups that exists within a business group.

How can u see Multi-Organization is enabled or not from SQL Prompt?

SELECT MULTI_ORG_FLAG FROM fnd_product_groups;

What are the two mandatory parameters required for PL/SQL stored Procedure Concurrent Program?

Errbuf and retcode two OUT Parameters are required while defining PL/SQL stored Procedure Concurrent Program.

Errbuf Returns any error messageand retcode returns completion status.

Retcode returns 0 for success, 1 for warnings and 2 for error.

Oracle Alert FAQ’s

What are the event alerts?

Triggered off when a particular event occurs in the Database.

Event can be Insert or Update.

What are Alert Action Level?

There are two levels of actions that can be performed

Detail Action and Summary Action.

What is a Summary Threshold?

Oracle Alerts automatically determine whether to perform a detail action or Summary action based on the number of exceptions in the database.

What are the different actions that can be performed in Alerts?

Message Actions
Concurrent Program Actions
Operating Script Actions
SQL Statement Script Actions

What are the steps involved in Creating Periodic alerts?

· Write a select statement

· Verify and Run the SQL

· Specify Alert Inputs

· Define Alert Outputs

· Create Periodic alert actions

· Define Periodic alert message actions

· Create a periodic alert action set

· Check your periodic alert.

What is the Distribution List in Alerts?

A Pre-defined set of electronic mail ids and printer Instructions that you can use on message actions instead of re-entering all the recipient names each time.

What are the Advance features available in alerts?

· Distribution List

· Periodic sets

· Summary Thresholds

· Action Set Checks

What are the four implicit Inputs in Alerts?

Mailid, rowid, org_id, date_last_checked

--FILE 2

Oracle Apps Question Answer

1.Q. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i).

Ans:- There are 8 types of Values Sets.

a. None (Non Validate at all) (Validation is Minimal)

b. Independent (Input must exist on previous defined list of values)

c. Dependent (Input is checked against a subset of values based on prior Value)

d. Table (Input is checked against a subset of values in an application table)

e. Special (advanced) (Value set uses a flexfield itself)

f. Pair (advanced) (Two Flexfields together specify a range of valid values)

g. Translatable Independent (Input must exist on previous defined list of values. Translated value can be used)

h. Translatable Dependent. (Input is checked against a subset of values based on a prior value; translated value can be used)

(Note:- When you first define your flexfields, you choose how many segments

You want to use and what order you want them to appear. You also

Choose how you want to validate each of your segments. The decisions

You make affect how you define your value sets and your values.)

2.Q. How to run a concurrent program. What all concurrent programs u have

created.

Ans:- (Definition :- A concurrent program is an instance of an execution file, along with

parameter definitions and incompatibilities. Concurrent programs use concurrent program executables to locate the correct execution file.)

Oracle Tool Concurrent Program * A concurrent program written in

· Oracle Reports, PL/SQL package procedures,

SQL*Loader, SQL*Plus, Host Scripting.

How to Run : * Write a execution file and place in correct directory.

· Establish executables in Oracle apps specify execution file and method.

· Define Concurrent Program (Program, Parameters and Incompatibilities)

· Call your Program (- Thu application form, from other concurrent program.

- OR through standard request submission, you must check the ‘USE in SRS check box’ and register your program parameters when you define your concurrent program. Add your program into the request security group for your custom application.)

I have created reports through concurrent program, load(sql*loader/pl-sql pkg-proc) the file through concurrent program.

3.Q. What is parameter in apps and from where u can create it.

Ans:- Parameters only using in report, you can create in defining the report in apps (you can create the parameter there only).

4.Q.What all are the tables used in the modules u have worked on.

*In GL – I have worked on GL_JE_HEADERS(JOURNALS HEADER),GL_JE_LINES(JOURNAL LINES), GL_JE_BACHES(JOURNAL BATCHES), GL_SET_OF_BOOK(SET_OF_BOOK_ID),

*In PO- I have worked on PO_HEADER_ALL…..

5.Q.What is Profile? Explain different levels of Profile.

Ans:- A user profile is a set of changeable options that affects the way your applications run. Oracle Application Object Library establishes a value for each option in a user’s profile when the user logs on or changes responsibility. Your user can change the value of profile options at any time a) To create Profile Option. ( Profile Option can created by developer in application developer area) b)set the value (Values of the profile option , who will have what value at various levels is set by SYSADMIN). Oracle Application Object Library provides many options that. (Edit profile feature for every user is available to set any value to allow the user).your users can set to alter the user interface of your applications to satisfy their individual preferences.

Profile Option – set at run time like – User Related, responsibility, Sequence, Printer, Security.

Values in 4 Levels(HIEARCHY WISE) :-

A. USER

B. RESPONSIBILITY

C. APPLICATION

D. SITE

Application Developer create the profile.

System Administrator make profile option.

(NOTE:- If any change in value, it will active when you re-login or switch

to the responsibility.)

( Usage in the multi-tier, the profile is biggest impact)

6. Q.How to restrict the data for a responsibility as per the ORG-ID

Ans:-Through Multi – Org(MO) u can restrict the data for a responsibility as per the ORG-ID. Only in GL- Set of book Id you set the value to restrict the data for a responsibility.

7.Q. What is Flexfield? What is flexfield qualifier and what is segment qualifier?

Ans:- A flexfield is made up a segments (Which are actually table columns). Each segment has a name that can be assigned, and set of valid value.

Purpose and Application:-

* Flexibility to implement code structure.

* Flexibility to capture additional information.

Two Types of Flexfields in oracle apps.

Key Flexfields (KFF)
Descriptive Flexfields (DFF)

A key flexfield segment has a name you assign, and set of valid values you specify. Each value has a meaning which can be specified.

Flexfield Qualifier:-A flexfield qualifier identifies a particular segment of a key flexfield..

Usually an application needs some method of identifying a particular

segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to

use for segment identification.

Segment Qualifier :- A segment qualifier identifies a particular type of value in a single

segment of a key flexfield.

In the Oracle Applications, only the. Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type

8.Q. Which flexfield qualifiers are mandatory?

Ans:- ‘Balancing Segment’ flexfield qualifier is mandatory.

9. Can we see our data of RA_CUSTOMER (account Receivables) in Order Management?

Ans:-**********

10. Difference Between versions of Apps.(Front end & Database)

Ans:- In backend- Client server architecture (old)/ Three tire architecture

In font end- Client Server Application (old)/ Web Based application

11.Q.What Difference Between report development and report customization.

Ans:- Report Development means – make the new report and attach to the oracle apps.

Report Customization means – customize the existing oracle apps report.

12.Q.How to change the forms and reports from older versions to newer

versions(for D2k).

Ans:-*******************

13.Q.What is MULTI-ORG and what is structure of multi-org.

Ans:- Use a single installation of any oracle applications product to support any number of organizations. if those organizations use different set of books.

Support any number or legal entities with a single installation of oracle applications.

Secure access to data so that users can access only the information that is relevant to them.

Structure :- Business Unit

-HRMS(Employee)

-GL(Set of Books)(Currency, Calendar, Chart of Account)

Balancing Segment(You can do multiple balancing segment)

-Operating Units (Purchase, Selling, Fixed Asset, Payable,

Receivables)

-Inventory Organizations (Storing Items, Transaction Happening,

Ware Housing)

(Note:- Means if you maintaining GL(set of book id), If u have operating unit, if you

have inventory then its called MULTI-ORG)

14.Q.What is difference between ORG_ID and ORGANIZATION_ID in Multi-Org.

At where we can set ORG_ID and ORGANIZATION_ID level it comes in the

structure.

Ans:-A Global Variable exists in the oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes are used to store the operating unit ID(or ORG_ID) for the multiple organization support feature.

Multi-Org views are partitioned by ORG_ID. The ORG_ID value is stored in CLIENT_INFO variable.(It comes in AP,PO,AR,OM level)

ORGANIZATION_ID – Its for Inventory, Mfg, & BOM.

15.Q.What are the default types of parameters. What is the use of each one of it.

Ans:-******

16.Q.ORG_ID can be set at master levels or transaction level.

Ans:- ORG_ID can be set at transaction Level.

17.Q.Differnet type of execution methods in Conc.Progs. Explain Each Type.

Ans:- a.Oracle Reports- You can register your report as executable file type is oracle reports.

b. PL/SQL Package Procedure - You can register your PL/SQL Package Procedure as executable file type is oracle PL/SQL Package Procedure.

SQL Loader- You can register your SQL Loader SQL Loader is your executable file type.(for data loading)
SQL*Plus :- You can register your SQL script as SQL*Plus executable type.
Host Scripting:- You can write down Unix Host scripting and register here.

18 .Q. What is Database Tuning:-

Ans:- Database Tuning is required when your program is using more resource and performance is very slow, database tuning is required. Means its required some optimization in database level. There are two types of optimization

Cost Based optimization.
Rule based optimization.

19.Q.What is Schema

Ans:-The create Schema command creates a collection of tables, views, and previlege grants as a single transaction. The schema name is the same as your oracle user name. The create table, create view, an grant commands are the standard commands, and the order in which the commands appear is not important, even if there internal dependencies.

20.Q. What is difference between oracle schema and apps schema.

Ans:-Database Schema-

The APPS schema- is an ORACLE schema that has access to the

complete Oracle Applications data model. This schema is maintained

by AutoInstall.

21.Q.What are the objects APPS schema contain.

Ans:- The APPS schema contains synonyms to all tables and

sequences as well as all server–side code (stored procedures, views,

and database triggers).

For ERP applications, data partitioning is performed by database

views. These views reside in the APPS Oracle schema and derive the

appropriate operating unit context from an RDBMS variable.

22.Q.What is Workflow and what is the benefit of using workflow

Ans:-A graphical tool that allows you to CREATE, TRACK and MODIFY business process.

Embedded in the Oracle Database Server, It can monitor the workflow activity statuses.

Benefits:-

*Create a clear business process definition

*Automate the business routings

*Monitor the process

*Allow users to define their own business process to suit their organization needs.

*Readily change the business process definitions in case of a change business process.

23.Q.Where exactly u place your forms in APPS environment.

Ans:- /apps/visappl/au/11.5.0/forms/US

24.Q.What are the factors for application developer responsibility.

Ans:-

25.

26.

27.

28.

29.

30.

Oracle PL/SQL/Forms/Reports:

31.Q.What is type of Triggers in Oracle

Ans:- Two Types of trigger in Oracle.

Trigger only fire on table or any specific column for that table, it will fire when any DML statement (INSERT,UODATE,DELETE) will execute, its system control

Statement Level Trigger. (Under this there are 6 triggers)

1.Befor Insert

2.Before Update

3.Before Delete

4.After Insert

5.After Update

6.After Delete

Row Level Trigger. (Under this there are 6 triggers)

1.Befor Insert

2.Before Update

3.Before Delete

4.After Insert

5.After Update

6.After Delete

32.Q. What is Mutating.

--FILE 3

Oracle Corporation

Dt:12-06-2003

_{Tell me about your-self?}
_{Which interface you has developed?}
_{What are steps of interface tell me briefly?}
_{What are the validations you have done in uploading date from Pre interface-to-interface table?}
_{What are the forms you have customized and developed?}
_{What is your role to develop a new form?}
_{Who is giving you specification?}
_{What’s are the step to develop a new form?}
_{What are the problems you had faced after developing a new form’s?}
_{Is this form is working fine or not?}
_{Tell me about the functionality of the new form you have developed?}

GE Industries

1. Tell me about your self?

2. What is AOL?

3. Which module you are comfortable in?

4. How you are rating your self in PL/SQL, Reports, Forms, and Modules?

5. What is value set and what are the types of value set?

6. What is Flex field and tell me briefly?

7. Tell me PO & Inventory flow?

8. What are the report’s you have developed & customized?

9. What is lexical & Bind parameter.

10. What is the step to develop new forms?

11. What are the concurrent steps?

12. How many reports you have developed?

13. How to registered a report in Apps environment?

--FILE 4

OUT BOND INTERFACE

DECLARE

l_output utl_file.file_type;

l_theCursor integer default dbms_sql.open_cursor;

l_columnValue varchar2(2000);

l_status integer;

l_colCnt number default 0;

l_separator varchar2(10) default '';

l_cnt number default 0;

P_QUERY VARCHAR2(2000) := 'SELECT * FROM emp';

p_separator varchar2(100) := ',';

p_dir varchar2(100) := 'c:\' ;

/* p_dir varchar2(100) := '/usr/tmp' ;*/

p_filename varchar2(200) := 'e508_out_apps.csv';

begin

l_output := utl_file.fopen( p_dir, p_filename, 'w' );

dbms_sql.parse( l_theCursor, p_query,

dbms_sql.native );

for i in 1 .. 255 loop

begin

dbms_sql.define_column( l_theCursor, i,

l_columnValue, 2000 );

l_colCnt := i;

exception

when others then

if ( sqlcode = -1007 ) then exit;

else

raise;

end if;

end;

end loop;

dbms_sql.define_column( l_theCursor, 1,

l_columnValue, 2000 );

l_status := dbms_sql.execute(l_theCursor);

loop

exit when ( dbms_sql.fetch_rows(l_theCursor) <= 0 );

l_separator := '';

for i in 1 .. l_colCnt loop

dbms_sql.column_value( l_theCursor, i,

l_columnValue );

utl_file.put( l_output,

l_separator || l_columnValue );

l_separator := p_separator;

end loop;

utl_file.new_line( l_output );

l_cnt := l_cnt+1;

end loop;

dbms_sql.close_cursor(l_theCursor);

utl_file.fclose( l_output );

end ;

--FILE 5

PO_HEADERS_ALL

PO_HEADERS_ALL contains header information for your purchasing

documents. You need one row for each document you create. There are

six types of documents that use PO_HEADERS_ALL:

RFQs

Quotations

Standard purchase orders

Planned purchase orders

Blanket purchase orders

Contracts

Each row contains buyer information, supplier information, brief notes,

foreign currency information, terms and conditions information, and

the status of the document. Oracle Purchasing uses this information to

record information that is related to a complete document.

PO_HEADER_ID is the unique system–generated primary key and is

invisible to the user. SEGMENT1 is the system–assigned number you

use to identify the document in forms and reports. Oracle Purchasing

generates SEGMENT1 using the

PO_UNIQUE_IDENTIFIER_CONT_ALL table if you choose to let

Oracle Purchasing generate document numbers for you. SEGMENT1is

not unique for the entire table. Different document types can share the

same numbers. You can uniquely identify a row in PO_HEADERS_ALL

using SEGMENT1 and TYPE_LOOKUP_CODE or using

PO_HEADER_ID.

If APPROVED_FLAG is ’Y’, the purchase order is approved. If your

document type is a blanket purchase order, contract purchase

order,RFQ, or quotation, Oracle Purchasing uses START_DATE and

END_DATE to store the valid date range for the document. Oracle

Purchasing only uses BLANKET_TOTAL_AMOUNT for blanket

purchase orders or contract purchase orders.

If you autocreate a quotation from an RFQ using the Copy Document

window, Oracle Purchasing stores the foreign key to your original RFQ

in FROM_HEADER_ID. Oracle Purchasing also uses

FROM_TYPE_LOOKUP_CODE to indicate that you copied the

quotation from an RFQ.

Oracle Purchasing does not use SUMMARY_FLAG and

ENABLED_FLAG. Because future versions of Oracle Purchasing will

use them, SUMMARY_FLAG and ENABLED_FLAG should always be

’N’ and ’Y’ respectively.

You enter document header information in the header region of the

Purchase Orders, RFQs, and Quotations windows.

PO_HEADERS_ALL PO_HEADER_ID FROM_HEADER_ID

PO_VENDORS VENDOR_ID VENDOR_ID

PO_VENDOR_CONTACTS VENDOR_CONTACT_ID VENDOR_CONTACT_ID

PO_VENDOR_SITES_ALL VENDOR_SITE_ID VENDOR_SITE_ID

PO_VENDORS

PO_VENDORS stores information about your suppliers. You need one

row for each supplier you define. Each row includes the supplier name

as well as purchasing, receiving, payment, accounting, tax,

classification, and general information. Oracle Purchasing uses this

information to determine active suppliers. VENDOR_ID is the unique

system–generated receipt header number invisible to the user.

SEGMENT1 is the system–generated or manually assigned number you

use to identify the supplier in forms and reports. Oracle Purchasing

generates SEGMENT1 using the

PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let

Oracle Purchasing generate supplier numbers for you. This table is one

of three tables that store supplier information. PO_VENDORS

corresponds to the Suppliers window.

PO_LINES_ALL

PO_LINES_ALL stores current information about each purchase order

line. You need one row for each line you attach to a document. There

are five document types that use lines:

RFQs

Quotations

Standard purchase orders

Blanket purchase orders

Planned purchase orders

Each row includes the line number, the item number and category, unit,

price, tax information, matching information, and quantity ordered for

the line. Oracle Purchasing uses this information to record and update

item and price information for purchase orders, quotations, and RFQs.

PO_LINE_ID is the unique system–generated line number invisible to

the user. LINE_NUM is the number of the line on the purchase order.

Oracle Purchasing uses CONTRACT_NUM to reference a contract

purchase order from a standard purchase order line. Oracle Purchasing

uses ALLOW_PRICE_OVERRIDE_FLAG, COMMITTED_AMOUNT,

QUANTITY_COMMITTED, MIN_RELEASE_AMOUNT only for

blanket and planned purchase order lines.

PO_VENDORS

PO_VENDORS stores information about your suppliers. You need one

row for each supplier you define. Each row includes the supplier name

as well as purchasing, receiving, payment, accounting, tax,

classification, and general information. Oracle Purchasing uses this

information to determine active suppliers. VENDOR_ID is the unique

system–generated receipt header number invisible to the user.

SEGMENT1 is the system–generated or manually assigned number you

use to identify the supplier in forms and reports. Oracle Purchasing

generates SEGMENT1 using the

PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let

Oracle Purchasing generate supplier numbers for you. This table is one

of three tables that store supplier information. PO_VENDORS

corresponds to the Suppliers window.

AP_DISTRIBUTION_SETS_ALL DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID

AP_TERMS_TL TERM_ID TERMS_ID

FND_CURRENCIES CURRENCY_CODE INVOICE_CURRENCY_CODE

FND_CURRENCIES CURRENCY_CODE PAYMENT_CURRENCY_CODE

GL_CODE_COMBINATIONS CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID

GL_SETS_OF_BOOKS SET_OF_BOOKS_ID SET_OF_BOOKS_ID

ORG_FREIGHT_TL FREIGHT_CODE SHIP_VIA_LOOKUP_CODE

PO_AGENTS AGENT_ID

PO_LINE_LOCATIONS_ALL

PO_LINE_LOCATIONS_ALL contains information about purchase

order shipment schedules and blanket agreement price breaks. You

need one row for each schedule or price break you attach to a

document line. There are seven types of documents that use shipment

schedules:

RFQs

Quotations

Standard purchase orders

Planned purchase orders

Planned purchase order releases

Blanket purchase orders

Blanket purchase order releases

Each row includes the location, quantity, and dates for each shipment

schedule. Oracle Purchasing uses this information to record delivery

schedule information for purchase orders, and price break information

for blanket purchase orders, quotations and RFQs.

PO_RELEASE_ID applies only to blanket purchase order release

shipments. PO_RELEASE_ID identifies the release on which you

placed this shipment.

SOURCE_SHIPMENT_ID applies only to planned purchase order

release shipments. It identifies the planned purchase order shipment

you chose to release from.

PRICE_OVERRIDE always equals the purchase order line price for

standard purchase order shipments. For blanket and planned purchase

orders, PRICE_OVERRIDE depends on the values of the

ALLOW_PRICE_OVERRIDE_FLAG and NOT_TO_EXCEED_PRICE in

the corresponding row in PO_LINES_ALL:

If ALLOW_PRICE_OVERRIDE_FLAG is ’N’, then

PRICE_OVERRIDE equals UNIT_PRICE in PO_LINES_ALL.

If ALLOW_PRICE_OVERRIDE_FLAG is ’Y’, the

PRICE_OVERRIDE can take any value that is smaller than

NOT_TO_EXCEED_PRICE in PO_LINES_ALL.

The QUANTITY field corresponds to the total quantity ordered on all

purchase order distribution lines (found in

PO_DISTRIBUTIONS_ALL).

Oracle Purchasing automatically updates QUANTITY_RECEIVED,

QUANTITY_ACCEPTED, and QUANTITY_REJECTED when you

receive, return, or inspect goods or services. Oracle Payables

automatically updates QUANTITY_BILLED when you match an

invoice with a purchase order shipment. Oracle Purchasing

automatically updates QUANTITY_CANCELLED when you cancel a

purchase order shipment.

Oracle Purchasing sets APPROVED_FLAG to ’Y’ when you approve

the corresponding purchase order if there are no problems associated

with the shipment and its related distributions.

Oracle Purchasing sets ENCUMBERED_FLAG to ’Y’ and enters the

ENCUMBERED_DATE when you approve a purchase order if you use

encumbrance.

PO_RELEASES_ALL

PO_RELEASES_ALL contains information about blanket and planned

purchase order releases. You need one row for each release you issue

for a blanket or planned purchase order. Each row includes the buyer,

date, release status, and release number. Each release must have at least

one purchase order shipment (PO_LINE_LOCATIONS_ALL).

RELEASE_NUM is the number you assign to the release.

--FILE 6

Reports Customization:

Present report takes GL period & if it lies between the given date then runs the report. Now we want to add customer numbers as another variable to the report. For this we o[pen the existing report, & in the user variables create two bind variables as p_cust_start & p_cust_end both of number type. Additionally we create a lexicon parameter lp_customer which is going to take the value based from the customer bind variables values that we pass runtime. (Lexicon parameter is of Char datatype & sufficiently large) The table from which we are going to get value of customer numbers can be seen from main query. There fore after creating the parameters, go to pl/sql syntax of after parameters query & add following code.

IF :P_CUST_START IS NOT NULL AND :P_CUST_END IS NOT NULL THEN

:LP_CUSTOMER :='AND CUSTOMER_NUMBER (* this tells that the customer numbers are to be taken from the customer_number column of the table*) BETWEEN :P_CUST_START AND :P_CUST_END';

END IF;

After the pl/sql code is compiled correctly, open the main query & open its sql query statement from the property palette & write &LP_CUSTOMER (no and written before this)

Create a table based value set as appl. Dev. With table application as oracle receivables, table name as ra_customer & table column as customer name & write order by customer_number in the where/order by clause.

Now save & compile the program. After that open ftp & transfer this file & by telnet transfer this in reports/US. After that register the report & execute it.

n FILE 7

Oracle Apps 11i Interview Questionnaire

1. Why do we call FND SRWINIT from Before Report Trigger

A. FND SRWINIT fetches concurrent request information and sets up the profile options. It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing)

2. Why do we call FND SRWEXIT from After Report Trigger

A. FND SRWEXIT frees all the memory allocations done in other Oracle Applications user exits. It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing)

3. Why do we call FND FLEXSQL from the Before Report Trigger?

A. One need to pass the concatenated segment values from the underlying code combinations table to the user exit so that it can display appropriate data and derive any description and values from switched value sets as needed. One gets this information by calling the AOL user exit FND FLEXSQL from the before report Trigger.

4. If u call the user exit FND FLEXSQL with MODE = “ WHERE” from the Before Report Trigger. What will it do?

A. This user exit populates a lexical parameter that you specify with the appropriate SQL fragment at run time. You include this lexical parameter in the WHERE clause of the report query. This user exit is called once for each lexical to be changed.

5. If u call the user exit FND FLEXSQL with MODE = “ ORDER BY” from the Before Report Trigger. What will it do?

A. This user Exit populates the lexical parameter that one specifies with the appropriate SQL fragment at run time. One includes this lexical parameter in the ORDER BY clause of the report query. This user exit is called once for each lexical to be changed.

6. How can we display flexfield segment values, descriptions, and prompts on the report?

A. Create a formula Column. Call the user exit FND FLEXIDVAL as the formula for this column. This user exit automatically fetches more complicated information such as descriptions and prompts so that one does not has to use complicated table joins to the flex field tables.

7. Name some options of the FND FLEXSQL user exit

A CODE, APP_SHORT_NAME, OUTPUT, MODE, DISPLAY, SHOWDEPSEG, NUM or MULTINUM, TABLEALIAS, OPERATOR, OPERAND1, OPERAND2.

8. Describe CODE option of the FND FLEXSQL user exit

A. Specify the flex field code for the report (for example, GL#, MCAT).

9. Describe the APP_SHORT_NAME option of the FND FLEXSQL user exit

A. Specifies the short name of the application that owns the flex field (for example: SQLGL, INV)

10. Describe the OUTPUT option of the FND FLEXSQL user exit

A. Specify the name of the lexical parameter to store the SQl fragment. One uses this lexical later in the report when defining the SQL statement that selects the flexfield values. the datatype of this parameter should be character.

11. Describe the MODE option of the FND FLEXSQL user exit

A. Specify the mode to use to generate the SQL fragment . valid mode are :

SELECT: Retrieves all segments values in an internal (non- displayable format).

WHERE: Restrict the query by specifying constraints on flexfield columns. The fragment returned includes the correct decode statement if one specifies MULTINUM. One must also specify an OPERATOR and OPERANDS.

HAVING: Same calling procedures and functionality as WHERE.

ORDER BY: Order required information by flexfield columns. The fragment Orders your flexfield columns and separates them with a comma. The fragment returned includes the correct decode statement, one specifies in MULTINUM.

12. Describe the DISPLAY option of the FND FLEXSQL user exit

A. One uses the DISPLAY token with the MODE token . the DISPLAY parameter allows you to specify segments that represent specified flexfield qualifiers or specified segments numbers , where the segment numbers are the order in that the segments appear in the flexfield window, not the segment number specified in the Define Key Segments form.

Eg. If your MODE is SELECT and you specify DISPLAY = “ALL” then the SELECT statement includes all the segments of the flexfield. . Similarly, if your MODE is WHERE and you specify DISPLAY = “ALL”, then your WHERE clause includes all segments.

13. Describe the SHOWDEPSEG option of the FND FLEXSQL user exit

A. SHOWDEPSEG = “N” disables automatic addition of depended upon segments to the order criteria. The default is “Y”. This token is valid only for MODE = “ODER BY” In FLEXSQL.

14. Describe the NUM option of the FND FLEXSQL user exit

A. Specify the name or lexical or source column that contains the flexfield structure information. If the flexfield uses just one structure, specify NUM only and use a lexical parameter to hold the value. If the flexfield uses multiple structures, specify MULTINUM only and use a source column to hold the value. The default value is 101.

15. Describe the TABLE ALIAS option of the FND FLEXSQL user exit

A. You use TABLE ALIAS if your SELECT joins to other flexfield tables or uses a self – join.

16. Describe the OPERATOR option of the FND FLEXSQL user exit

A. Specify an operator to use in the WHERE clause.

17. Describe the OPERAND1 option of the FND FLEXSQL user exit

A. Specify an operand to use in the WHERE clause,

18. Describe the OPERAND2 option of the FND FLEXSQL user exit

A. Specify a second operand to use with OPERATOR = “BETWEEN”

19. Where is FND FLEXIDVAL user exit used

A. Call this user exit to populate fields for display. You pass the key flex fields data retrieved by the query into this user exit from the formula column. With this exit you can display values, descriptions and prompts by passing appropriate token (any one of VALUE, DECRIPTION<APROMPT or LPROMPT).

21. Name the interface tables used for the customer interface?

A. 1. RA_CUSTOMERS_INTERFACE_ALL

2. RA_CUSTOMER_BANKS_INT_ALL

3. RA_CUST_PAY_METHOD_INT_ALL

4. RA_CUSTOMER_PROFILES_INT_ALL

5. RA_CONTACT_PHONES_INT_ALL

22 What is the name of the column in CUSTOMER_INTERFACE_TABLE that indicates whether you are inserting new or updating existing information?

A: When importing data into the interface tables, the column INSERT_UPDATE_FLAG indicates whether you are inserting new or updating existing information. This column is required in RA_CUSTOMERS_INTERFACE.

23 If the INSERT_UPDATE_FLAG is not set correctly or the required column is missing the value, will CUSTOMER INTERFACE reject the entire record or just the attributes u want to update?

A Reject the entire record.

24 List some of the required columns for the RA_CUSTOMERS_INTERFACE?

A. ORIG_SYSTEM_CUSTOMER_REF

INSERT_UPDATE_FLAG

CUSTOMER_NAME

CUSTOMER_NUMBER (if you are not using Automatic Customer Numbering)

CUSTOMER_STATUS

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

If you are importing an address and a business purpose, you must also populate the following columns:

PRIMARY_SITE_USE_FLAG (if you are inserting an address)

LOCATION (if you are not using Automatic Site Numbering)

SITE_USE_CODE (if you are inserting an address)

ADDRESS1

25 List some of the production tables that Customer Interface transfers customer data from the interface tables into?

A. AR_CUSTOMER_PROFILES

AR_CUSTOMER_PROFILE_AMOUNTS

RA_ADDRESSES

RA_CONTACTS

RA_CUSTOMERS

RA_CUSTOMER_RELATIONSHIPS

RA_CUST_RECEIPT_METHODS

RA_PHONES

RA_SITE_USES

AP_BANK_ACCOUNT_USES

AP_BANK_ACCOUNTS

AP_BANK_BRANCHES

26. What validation must be given on the customer_number?

A Must be null if you are using Automatic Customer Numbering. Must exist if you are not using Automatic Customer Numbering. This value must be unique within RA_CUSTOMERS.

27 What validation must be given on the CUSTOMER_STATUS?

A Must equal ’A’ for Active or ’I’ for Inactive.

28 Name some of the Oracle receivables Interfaces?

A a) Auto Invoice

b) Auto Lockbox

c) Customer Interface

d) Sales Tax rate Interface

e) Tax Vendor Extension

29 Give some of the Oracle Payables interface?

A. a) Credit Card Transaction Interface

b) Invoice Import Interface

c) Payables Open Interface

d) Purchase Order Matching

30. Name some of the oracle general ledger Interface?

A a) Budget Upload

b) Importing Journals

c) Loading Daily rates

31. What are the names of the parameters u pass to the Procedure which u register in the apps?

A. 1) retcode in varchar2

2) errbuf in varchar2

32. What is the use of Auto lock Box?

A Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.

33. Auto Lockbox is a three-step process, what are those?

A. a) Import

b) Validation

c) PostQuickCash

34. What is the order in which Autolock box searches for the types of the matching number?

A. 1. Transaction Number

2. Sales Order Number

3. Purchase Order Number

4. Consolidated Billing Invoice Number

5. Other, user-defined number.

35. What is application short name for General Ledger you specify in FND FLEXSQL user exit?

A. SQLGL

36 . What are validations to be done in Journal Import interface.

A. Batch level: Set of Books, Period Name, and Batch Name

Journal Level: Set of books, Period name, Source name, Journal entry name, Currency code, Category name, Actual flag, Encumbrance type ID, User conversion type, Accounting date, Budget version ID

37. What subclass in forms6i

A Specifies module, storage & name information about the source object and source module for a referenced objects.

38. What is the clause in SQL * Loader to program to override data into table

A. REPLACE

39. How do you set profile in oracle applications In Application Developer responsibility?

A Open ‘Profile’ Function

40. What is the syntax for loading data through SQL * Loader from multiple files simultaneously

A. Sqlldr scott/tiger@orcl control = ctlfile

parfile -- parameter file: name of file that contains parameter specifications

parallel -- do parallel load (Default FALSE)

41 What is the table name for items in Oracle Inventory

A MTL_SYSTEM_ITEMS, MTL_CATEGORIES

42. Tell me names of important production tables & their purpose AP, AR, GL, PO

A AP: AP_INVOICES_ALL, AP_INVOICE_LINES_ALL

To store invoices

AR: RA_SHIPMENT_HEADERS/ _LINES, RA_CUSTOMERS, RA_CONTACTS

PO: PO_VENDORS, PO_VENDOR_SITES - For storing vendor data.

43. Name the interface tables used for the LockBox Interface

A Interface table : AR_PAYMENTS_INTERFACE_ALL

Lockbox transfers the receipts that pass validation to the Receivables interim tables AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL

When you run Post QuickCash, the receipt data is transferred from the QuickCash tables to the following Receipt tables:

AR_CASH_RECEIPTS_ALL

AR_RECEIVABLES_APPLICATIONS_ALL

AR_CASH_RECEIPT_HISTORY_ALL

44 Name the interface tables used for the AutoInvoice Interface.

A AutoInvoice transfers transaction data from the interface tables

RA_INTERFACE_LINES_ALL,

RA_INTERFACE_SALESCREDITS_ALL, and

RA_INTERFACE_DISTRIBUTIONS_ALL

into the following Receivables tables:

• RA_BATCHES_ALL

• RA_CUSTOMER_TRX _ALL

• RA_CUSTOMER_TRX_LINES _ALL

• RA_CUST_TRX_LINE_GL_DIST_ALL

• RA_CUST_TRX_LINE_SALESREPS_ALL

• AR_PAYMENT_SCHEDULES_ALL

• AR_RECEIVABLE_APPLICATIONS_ALL

• AR_ADJUSTMENTS_ALL

REPORTS 6i

About User Exits

A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.

You can write the following types of user exits:

Ø ORACLE Pre-compiler user exits

Ø OCI (ORACLE Call Interface) user exits

Ø Non-ORACLE user exits

You can also write a user exit that combines both the ORACLE Pre-compiler interface and the OCI. User exits can perform the following tasks:

Ø Perform complex data manipulation

Ø Pass data to Report Builder from operating system text files

Ø Manipulate LONG RAW data

Ø Support PL/SQL blocks

Ø Control real time devices, such as a printer or a robot

You can use user exits for other tasks, such as mathematical processing. However, Oracle Corporation recommends that you perform such tasks with PL/SQL within Report Builder.

Usage Notes

Ø Not all types of user exits can perform all of the described tasks. You can accomplish most of these tasks only with ORACLE Pre-compiler user exits.

Ø Some details of implementing user exits are specific to each operating system.

Writing a user exit call

You can call the user exit from any place in which you can enter PL/SQL within Report Builder. Use the following syntax:

Syntax

Ø [SRW.REFERENCE(:object_name_1);]

Ø [SRW.REFERENCE(:object2_name_2); ...];

Ø SRW.USER_EXIT('user_exit_name [argument_list]');

where:

object_name_n Is the name of an Report Builder parameter or column whose value will be passed to the user exit in the user exit string. This causes Report Builder to build a dependency list: it will ensure that each referenced object will contain the most recently computed or fetched value before it is passed to the user exit. Note: You must reference each parameter or column separately. For details, see "SRW.REFERENCE".

user_exit_name Is the name of the user exit to which you are passing control. The user exit name may be any length. (On some operating systems, the name may be at most 6 characters. Check with your system administrator.)

argument_list Can contain the names of parameters and columns, constants, character strings, or any combination thereof, that you wish to pass to the user exit. The argument list may be any length. Note: The above syntax will need to be embedded in a PL/SQL program unit.

SRW.USER_EXIT

Description : This procedure calls the user exit named in user_exit_string. It is useful when you want to pass control to a 3GL program during a report's execution.

Syntax

SRW.USER_EXIT (user_exit_string CHAR);

Parameters :

user_exit_string :Is the name of the user exit you want to call and any columns or parameters that you want to pass to the user exit program.

SRW.REFERENCE

Description : This procedure causes Report Builder to add the referenced object to the PL/SQL construct's dependency list. This causes Report Builder to determine the object's value just before firing the PL/SQL construct. This is useful when you want to ensure that a column value passed to a user exit is the most recently computed or fetched value.

Syntax

SRW.REFERENCE (:object CHAR|DATE|NUMBER);

Parameters

object Is the Report Builder parameter or column whose value needs to be ascertained before the construct fires.

SRW.MESSAGE

Description :This procedure displays a message with the message number and text that you specify. The message is displayed in the format below. After the message is raised and you accept it, the report execution will continue.

MSG-msg_number: msg_text.

Syntax

SRW.MESSAGE (msg_number NUMBER, msg_text CHAR);

Parameters

msg_number Is a number from one to ten digits, to be displayed on the message line. Numbers less than five digits will be padded with zeros out to five digits. For example, if you specify 123, it will be displayed as SRW-00123.

msg_text Is at most 190 minus the msg_number alphanumeric characters to be displayed on the message line.

Lexical References :

Lexical references are placeholders for text that you embed in a SELECT statement. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

You cannot make lexical references in a PL/SQL statement. You can, however, use a bind reference in PL/SQL to set the value of a parameter that is then referenced lexically in SQL.

SELECT Clause

SELECT &P_ENAME NAME, &P_EMPNO ENO, &P_JOB ROLE FROM EMP

FROM Clause

SELECT ORDID, TOTAL FROM &ATABLE

WHERE Clause

SELECT ORDID, TOTAL FROM ORD WHERE &CUST

GROUP BY Clause

SELECT NVL(COMMPLAN, DFLTCOMM) CPLAN, SUM(TOTAL) TOTAL FROM ORD GROUP BY &NEWCOMM

HAVING Clause

SELECT CUSTID, SUM(TOTAL) TOTAL FROM ORD GROUP BY CUSTID HAVING &MINTOTAL

ORDER BY Clause

SELECT ORDID, SHIPDATE, ORDERDATE, TOTAL FROM ORD ORDER BY &SORT

CONNECT BY and START WITH Clauses

Multiple Clauses

SELECT &COLSTABLE

COLSTABLE could be used to change both the SELECT and FROM clauses at runtime. For example, you could enter DNAME ENAME, LOC SAL FROM DEPT for COLSTABLE at runtime.

Bind References :

Bind references (or bind variables) are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH clauses of queries. Bind references may not be referenced in FROM clauses or in place of reserved words or clauses.

You create a bind reference by entering a colon (:) followed immediately by the column or parameter name. If you do not create a column or parameter before making a bind reference to it in a SELECT statement, Report Builder will create a parameter for you by default.

SELECT Clause

SELECT CUSTID, NVL(COMMPLAN, :DFLTCOMM) COMMPLAN FROM ORD

WHERE Clause

SELECT ORDID, TOTAL FROM ORD WHERE CUSTID = :CUST

GROUP BY Clause

SELECT NVL(COMMPLAN, :DFLTCOMM) COMMPLAN, SUM(TOTAL) TOTAL FROM ORD GROUP BY NVL(COMMPLAN, :DFLTCOMM)

HAVING Clause

SELECT CUSTID, SUM(TOTAL) TOTAL FROM ORD GROUP BY CUSTID HAVING SUM(TOTAL) > :MINTOTAL

ORDER BY Clause

SELECT ORDID, SHIPDATE, ORDERDATE, TOTAL FROM ORD ORDER BY DECODE(:SORT, 1, SHIPDATE, 2, ORDERDATE)

Placeholder Columns :

A placeholder is a column for which you set the data type and value in PL/SQL that you define. You can set the value of a placeholder column in the following places:

Ø The Before Report Trigger, if the placeholder is a report-level column

Ø A report-level formula column, if the placeholder is a report-level column

Ø A formula in the placeholder's group or a group below it (the value is set once for each record of the group)

PROCEDURE RUN_PRODUCT (product NUMBER, module VARCHAR2, commmode NUMBER, execmode NUMBER, location NUMBER, paramlist_id VARCHAR2, display VARCHAR2);

Product :Specifies a numeric constant for the Oracle product you want to invoke: FORMS specifies a Runform session. GRAPHICS specifies Graphics Builder. REPORTS specifies Report Builder. BOOK specifies Oracle Book.

module Specifies the VARCHAR2 name of the module or module to be executed by the called product. Valid values are the name of a form module, report, Graphics Builder display, or Oracle Book module. The application looks for the module or module in the default paths defined for the called product.

commmode Specifies the communication mode to be used when running the called product. Valid numeric constants for this parameter are SYNCHRONOUS and ASYNCHRONOUS.SYNCHRONOUS specifies that control returns to Form Builder only after the called product has been exited. The end user cannot work in the form while the called product is running. ASYNCHRONOUS specifies that control returns to the calling application immediately, even if the called application has not completed its display.

Execmode : Specifies the execution mode to be used when running the called product. Valid numeric constants for this parameter are BATCH and RUNTIME. When you run Report Builder and Graphics Builder, execmode can be either BATCH or RUNTIME. When you run Form Builder, always set execmode to RUNTIME.

Location : Specifies the location of the module or module you want the called product to execute, either the file system or the database. Valid constants for this property are FILESYSTEM and DB.

Paramlist_name or paramlist_ID : Specifies the parameter list to be passed to the called product. Valid values for this parameter are the VARCHAR2 name of the parameter list, the ID of the parameter list, or a null string (''). To specify a parameter list ID, use a variable of type PARAMLIST.

Display : Specifies the VARCHAR2 name of the Form Builder chart item that will contain the display (such as a pie chart, bar chart, or graph) generated by Graphics Builder. The name of the chart item must be specified in the format block_name.item_name

PROCEDURE Run_Emp_Report IS

pl_id ParamList;

BEGIN

pl_id := Get_Parameter_List('tmpdata');

IF NOT Id_Null(pl_id) THEN

Destroy_Parameter_List( pl_id );

END IF;

pl_id := Create_Parameter_List('tmpdata'); Add_Parameter(pl_id,'EMP_QUERY',DATA_PARAMETER,'EMP_RECS');

Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');

Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);

END;

FORMS 6i

System Variables

SYSTEM.DATE_THRESHOLD : Represents the database date requery threshold.

Default : 01:00 (Synchronization occurs after one minute of elapsed time.) This does not mean that Form Builder polls the RDBMS once every minute. It means that whenever Form Builder needs to generate the value for the system variables $$DBDATE$$, $$DBDATETIME$$, $$DBTIME$$, or SYSTEM.EFFECTIVE_DATE, it updates the effective date by adding the amount of elapsed time (as measured by the local operating system) to the most previously queried RDBMS value. If the amount of elapsed time exceeds the date threshold, then a new query is executed to retrieve the RDBMS time and the elapsed counter is reset.

SYSTEM.EFFECTIVE_DATE: Represents the effective database date. The variable value must always be in the following format: DD-MON-YYYY HH24:MI:SS

Default: RDBMS date.

SYSTEM.FORM_STATUS represents the status of the current form. The value can be one of three character strings: NEW, QUERY, CHANGED

SYSTEM.SUPPRESS_WORKING suppresses the "Working..." message in Runform, in order to prevent the screen update usually caused by the display of the "Working..." message. The value of the variable is one of the following two CHAR values: TRUE, FALSE

SYSTEM.TRIGGER_RECORD represents the number of the record that Form Builder is processing. This number represents the record's current physical order in the block's list of records. The value is always a character string.

SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string. NORMAL, ENTER-QUERY, Enter Query mode.

SYSTEM.FORM_STATUS represents the status of the current form. The value can be one of three character strings: CHANGED, NEW , QUERY.

SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels: 0, 5, 10, 15, 20, or 25. The default value is 0.

PARAMETERS:

When you create a parameter, you specify its name, data type, length, and default value.

To create a parameter:

1. In the Object Navigator, create a parameter.

To create a parameter, select the Parameters node in the Object Navigator and then choose Navigator Create.

2. In the Property Palette, set the desired parameter properties:

In PL/SQL, you can reference and set the values of form parameters using bind variable syntax.

To reference a parameter: Preface the parameter name with the reserved word PARAMETER, as shown in the following examples:

:PARAMETER.parameter_name := 'TOKYO'; OR

:block.item := :PARAMETER.parameter_name;

Canvas Types :

Ø Content

Ø Stacked

Ø Tab

Ø Horizontal Toolbar

Ø Vertical Toolbar

Visual Attributes :

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

Ø Font properties: Font Name, Font Size, Font Style, Font Width, Font Weight

Ø Color and pattern properties: Foreground Color, Background Color, Fill Pattern, Charmode Logical Attribute, White on Black

Every interface object has a Visual Attribute Group property that determines how the object's individual visual attribute settings (Font Size, Foreground Color, etc.) are derived. The Visual Attribute Group property can be set to Default, NULL, or the name of a named visual attribute defined in the same module.

There are several ways to set the visual attributes of objects:

· In the Property Palette, set the Visual Attribute Group property as desired, then set the individual attributes (Font Name, Foreground Color, etc.) to the desired settings.

· In the Layout Editor, select an item or a canvas and then choose the desired font, color, and pattern attributes from the Font dialog and Fill Color and Text Color palettes.

· Define a named visual attribute object with the appropriate font, color, and pattern settings and then apply it to one or more objects in the same module. You can programmatically change an object's named visual attribute setting to change the font, color, and pattern of the object at runtime.

· Subclass a visual attribute that includes visual attribute properties and then base objects on it that inherit those properties.

· Create a property class that includes visual attribute properties and then base objects on it that inherit those properties.

About named visual attributes: Setting the Visual Attribute Group property to a named visual attribute defined in the same module specifies that the object should use the attribute settings defined for the named visual attribute. A named visual attribute is a separate object in a form or menu module that defines a collection of visual attribute properties. Once you create a named visual attribute, you can apply it to any object in the same module, much like styles in a word processing program.

Applies to canvas, tab page, item, radio button

Property Classes :

A property class is a named object that contains a list of properties and their settings. Once you create a property class you can base other objects on it. An object based on a property class can inherit the setting of any property in the class that makes sense for that object.

Property class inheritance is an instance of subclassing. Conceptually, you can consider a property class as a universal subclassing parent.

There can be any number of properties in a property class, and the properties in a class can apply to different types of objects. For example, a property class might contain some properties that are common to all types of items, some that apply only to text items, and some that apply only to check boxes.

When you base an object on a property class, you have complete control over which properties the object should inherit from the class, and which should be overridden locally.

Property classes are separate objects, and, as such, can be copied between modules as needed. Perhaps more importantly, property classes can be subclassed in any number of modules.

Menu Item Types

Separator Menu Item :

A separator menu item is displayed as a horizontal line (or other platform-specific visual element), and is useful for visually grouping related items on the same menu. For example, you could use a separator to isolate the radio items of one radio group from other menu items. You must set a separator item's Command Type property to Null. End users cannot select a separator menu item.

Magic Menu Item :

Magic items provide a way to quickly create menu items for standard functions available in most GUI applications. Form Builder provides the following magic item types: About, Copy, Clear, Cut, Paste, Help, Quit, Undo, Window.

Plain Menu Item : Default menu item.

Radio Menu Item

Check Menu Item

n FILE 8

Oracle Apps Questions Date 08/11/02

Different Type of Value sets. What is exactly translatable Independent and Translatable Dependent value sets (Introduced in latest version of 11i)

:$FLEX$. value_set_name

Retrieves a value (the hidden ID value, if a hidden ID value is defined) in a prior segment.

:$PROFILES$. profile_option

Retrieves the current value of a profile option. You must specify the option name of the profile option, such as GL_SET_OF_BKS_ID (which does not contain the Accounting Flexfield structure number).

Note that your profile option must be set wherever you use this value set (including the View Requests form if this value set is used as a report parameter and the user tries to view the status of the report after submission), or your user will see error messages.

:block.field

Gets the current value in a field. You must ensure that this value set is only used for forms that have the same block.field. For example, the following user exit on a Validate event obtains the Structure (NUM) of the key flexfield from a profile option:

How to run a concurrent program. What all concurrent programs u have created.
What is parameter in apps and from where we can create it.
What all are the tables used in the modules u have worked on.
What is profile? Explain different levels of profile.
How to restrict the data for a responsibility as per the ORG ID.
What is flexfield? What is flexfield qualifier and what is segment qualifier?

Flexfield Qualifier

A flexfield qualifier identifies a particular segment of a key flexfield. Usually an application needs some method of identifying a particular segment for some application purpose such as security or computations. However, since a key flexfield can be customized so that segments appear in any order with any prompts, the application needs a mechanism other than the segment name or segment order to use for segment identification. Flexfield qualifiers serve this purpose. You can think of a flexfield qualifier as an identification tag” for a segment.

Segment Qualifier

A segment qualifier identifies a particular type of value in a single segment of a key flexfield. In the Oracle Applications, only the Accounting Flexfield uses segment qualifiers. You can think of a segment qualifier as an ”identification tag” for a value. In the Accounting Flexfield, segment qualifiers can identify the account type for a natural account segment value, and determine whether detail posting or budgeting are allowed for a particular value. It is easy to confuse the two types of qualifiers. You should think of a flexfield qualifier as something the whole flexfield uses to tag its pieces, and you can think of a segment qualifier as something the segment uses to tag its values.

Which flexfield qualifiers are mandatory?
Can we see our data of RA_CUSTOMER (Account Receivables) in Order Management?
Difference between versions of Apps.(Front end & database)
What is the difference between report development and report customization?
How to change the forms and reports from older versions to newer version (For D2K)
What is Multi Org and What is the Structure of Multi Org?
What is the difference between ORG_ID and ORGANIZATION_ID in Multi Org? At where we can set ORG_ID and ORGANIZATION_ID level it comes in the Structure of the Multi Org.

a) Org Id will be set at operating unit level and Organization id will be set at inventory level. The structure of the Multi Org is

Business World (Set of Book id)àLegal Entitiesàoperating Unit àInventory

For GL we have Set of Books id For the Remaining modules like AP,AR we have to set the Org Id at the operating unit level.

What are the Default Types for Parameters. What is the use of each one of it.
ORG_ID can be set at master level or transaction level.

a) we have to set Org_Id in master level and transaction level also.

Different type of execution methods in Conc. Progs. Explain Each Type.
What is workflow and what is the benefit of using workflow?
Where exactly you place your forms in APPS environment.

a) Forms should be placed in the AU_TOP/forms directory and it has to compile it by using the code

F60gen module=forms.fmb userid = apps/apps@applinux

After that we have to move this fmx to CUS_TOP/forms directory

What are the factors for application developer responsibility?
What are basic changes you will made when converting reports or forms from previous versions to new versions (6)
What are major uses of work Flow Builder and what is the impact of this workflow compared to previous Apps versions?
What are the differences between executable and concurrent program
Is it mandatory to use API’s (like Fnd INIT, FND Flex, FND Exit) in forms and reports when working in Apps environment?

What other responsibilities Application Developer can contain?

What is a AOL

Oracle Application or constructed and Maintained by AOL

Main Areas are

Application security
Operating Profile
Concurrent Processing

Diff type of managers

Internal Concurrent Manager (it manages all the task Starts UP Verify the status of, resets, and Shut down the individual managers)

Standard Concurrent manager (check manager is working or not and any disturbance come it ‘ll restart the system)

Conflict Resulation Manager work’s to put one process into stop mode

And run others manager in some situation

Library Based Manager ‘ll work at scheduled time

Oracle /PLSQL/Forms/Reports

What is Type of database Triggers in Oracle

A Trigger is executed implicitly whenever a triggering event happens.The triggering event is a DML(Insert,Update,Delete) operations on a database

There is 12 types of triggers (Row level and Column level)

What is mutating.
What is Function Over loading?

a) Function Overloading means we can use the same procedure name more than one time in a package but the no of parameters should be different or their data type should be different.

How many types of reports are there?

There are five types of report triggers is there

Before report, after report, before parameter form, between pages and after parameter form.

What is function security?
What is the difference between a package procedure and procedure and difference between function & procedure

a) When we are working on modules it is good to write all the procedures in one package rather than scattered. The main difference between the function and procedure is normally a function will return a value and procedure wont

How can we return a value in procedures?

a) By using in, out parameters we can return the values in procedures

What are the steps to taken when we are converting the forms from previous versions to say 2.5 to new version 6i

a) We have to convert the reports or forms from older versions to new versions by step-by-step process like if we take forms 2.5 to 3 first and then 3 to 4.5 and then from 4.5 to 6i.open the form in the next version compile it. But in the case of reports it is very unpredictable. We cannot convert the reports from 2.0 to next version 2.5 but from 2.5 to next versions we can convert directly by opening the reports in next version directly.

What is Schema and what is the difference between apps schema when compared with other schema?

a) Apps Schema is the superior (Boss) of all the Schemas in the Apps.

All the synonyms, views, sequences will store here of the Modules

What are the objects in Apps schema?

A) APPS Schema

The APPS schema is an ORACLE schema that has access to the complete Oracle Applications data model. It is analogous to the SYSTEM schema, which has access to the entire database. The APPS schema dramatically simplifies and reduces the time of the installation process and the stability of upgrades.

Oracle Applications responsibilities connect to an APPS schema. Auto Install automatically sets the environment variable FNDNAM to the name of the APPS schema.

APPS and Base Product Schemas

AutoInstall creates one schema for each product—a base product schema—, which owns the data objects, and one schema—APPS—which owns the code objects and has access to all data objects. There is one APPS schema for every product installation group. The following code objects are installed in each APPS schema:

Views
Packages
Procedures
Functions
Triggers

The following objects are installed in the base product schemas:

n Tables

n Sequences

n Indexes

n Constraints

In addition, there are grants from the tables and sequences to the APPS schema, as well as synonyms from the APPS schema to those objects.

What is performance tuning and How you will do the tracing
You have Emp & Dept table and I want to see the employees which has no Foreign key deptno in Master details relations form

a) Hint: Use outer join (+)

1) Difference between open and call form

2) Use of placeholder columns

3) Reports trigger and execution hierarchy

4) New features of forms6i

5) Various triggers in forms

6) How to attach plsql Lib in forms

7) Difference between forms 4.5 & 6i

8) In reports, what is flex mode and Confine mode

9) Difference between Bind parameter and Lexical Parameter.

Multi Org data

Where to place org id

Currency rate (Tables)

Database triggers

Enabling Dff,Kff, Qualifiers

Forms library

Table of Gl, Ap, Ar, Inv and OM

FND API’s

Interface tables

Oracle Apps Versions

Value Sets

n FILE 9

1)Can different users share same responsibility? How to register a Form in Oracle Apps.

yes

for registering a form one must have to ftp to AU_TOPthen execute commant f60gen userid apps/respective password@hoststring, then add it in menu function , request requrity group.

Flexfield Value Security rules to restrict data entry of balancing segment values by legal entity or operating unit. Specify (True/False)

TRUE

Why do we call FND FLEXSQL from the Before Report Trigger?

for data population in lexical parameter.

On Query of On-Hand quantity shows the various quantities in an Inventory Organization. Can one assume that the user can find exactly the set of book names and operating unit being used for the query.Specify (True/False)

False

What is the name of the column of an interface you have worked. indicates whether you are inserting new or updating existing information?

last updated by

Name some of the Oracle receivables Interfaces in Oracle Inventory or General Ledger or Oracle WIP or Payables.

Auto Lockbox

Name some of the oracle general ledger Interface?

Daily Currency Rates,

Budget Upload,

Journal Entries.

What is the difference between a package procedure and procedure?

PACKAGE PROCEDURE IS A PROCEDURE DECLARED INSIDE THE SPECS OF A PACKAGE

WHILE SIMPLE PROCEDURE IS NOTHING BUT STORED PROCEDURE STORED INSIDE DATABASE

Where do you use :$FLEX$ and :$PROFILE$

IN HELP EXAMIN OPTIONS TO UNDERSTAND PROFILE OPTIONS.

If u call the user exit FND FLEXSQL with MODE = "WHERE" from the Before Report Trigger. What will it do?

IT WILL POPULATE DATA TO LEXICAL PARAMETER THAT IS IN WHERE

CLAUSE.

Give syntax and name the parameter of API that you can use for getting value of an text attribute in workflow.

DOCUMENT TYPE

(DOCUMENT_ID IN NUMBER,

DOCUMENT_KEY IN CHAR,

....)

Give syntax and APIs for running a workflow from SQL/PLSQL environment

FND_GLOBAL.APPINITALISE(...)

& IN THE PROCEDURE THERE WILL BE WORKFLOW INITIALISED.

Name two types of errors, when creating a workflow.

performer not specified, INVALID VARIABLE TYPE.

How will you fix an error that say performer not specified in workflow.

SET PERFORMET TO SYSADMIN

What access level is set for FND objects in oracle Apps?

Once the transactions have been imported successfully into AR using AutoInvoice, how can they be purged from the interface tables?

RECEIVABLE>>TRANSACTION>>PURGE TRANSACTION PUT VALID BUSINESS LOGIC.

What is the Payment Batch processing flow in AP?

PAYMENT TRANSACTIONS WHEN ENTERED THE ENTRIES ARE MADE IN gl DEPENDING UPON TYPE OF MATCHING I.E. 2 WAY, 3 WAY THE BILLS APPROVAL IS MADE & BILL IS APPRIVED/ NOT APPROVED.

What are the event alerts?

EVENT ALERTS GET FIRED WHEN A PERTICULAR EVENT OCCURS IN ORACLE APPS ENVIORNMENT.

The Balancing entity ensures that the sum of Credits are equal to debits for accounts that have same balancing segment value. Specify (True/False)

fALSE

The Master organization of a company acts as a default Inventory organization whenever user tries to create new Items. Specify (True/False)

TRUE

Item Planning is a mechanism to ensure is how inventory stock is replenished. Make or Buy decision about an Item is one of the ways of planning an Item replenishment. Specify (True/False)

TRUE

Defining UOM types for an Item is mandatory as part of setup of Inventory Organization setups. Specify (True/False)

TRUE

1)The business group represents the highest level in the organization structure. Specify (True/False)

True

2)What are the triggers that should not be modified during Forms Customization?

ON CHECK MASTER-DETAILS

4)Why is responsibility important what does it indicate?

responsibility means whatis the access level of a perticular person and whatall informations are to be stored with him and if incase any information is leaked it may have adverse effect

ex. in organisation a manager has a different responsibility,a supervisor has different responsibility,a worker has different responsibility.

A supervisor has control of workers.this is his responsibility

and manager has control over supervisor to evaluate his work and make the work successful. this is his responsibility.

5)What Difference Between report development and report customization.

report development means to develop report from a scratch by designing new query and layout for it.

while report customisation means to renew a report or do a patchup to a report by adding the fields in it or by changing the layout etc.

6)What is function security in Oracle Application.

7)How do you create debug message in Oracle Apps forms.

8)Why do we call FND SRWINIT from Before Report Trigger

we call FND SRWINIT in before report trigger to initialise the lexical parameters in the report

9)Describe the SHOWDEPSEG option of the FND FLEXSQL user exit

FND_FLEXSQL(

SOME COMMANDS

FND_MODE = SHOWDEPSEG

);

12)Where is FND FLEXIDVAL user exit used

IT IS USED IN THE BEFORE REPORT TRIGGER.

13)What are the different Level of Profiles? Give names of four profile options.

USER PROFILE

RESPONSIBILITY

APPLICATION

SITE PROFILE

16.How do you test a Workflow in Oracle Apps

AFTER DESIGNING WF WE GO TO THE MENU LAUNCH WF AND THEN TEST IT

18.Write the syntax for resultout in a function in workflow .

RESULTOUT:='COMPLETE:Y'

RESULTOUT:='COMPLETE:N'

19.What Access level is set for custom workflow development in Oracle Application?

100

22.Inter-company sales/Purchase transactions can be automatically generated based on Mult-Org setups. Example for such transaction is Purchase products through one legal entity and received thru another legal entity .Specify (True/False)

TRUE

27If a new table is being designed, one of the criteria to partition data will be: if the table is going to hold any transaction data. (True/False)

TRUE

28Organization using average costing should also define purchase variance account. Specify (True/False)

FALSE

29ORG_ID and Organization_ID are mandatory columns for Inventory transaction tables. Specify (True/False)

TRUE

30Oracle BOM will share calendar Information with Oracle Inventory for Shifts etc. Specify (True/False)

FALSE

(1)What are the Steps in Forms Customization?

1) Open the Template Form and save it with a different name

2)Make the modification on this form and save it,

save it with different name every time to prevent the Watson Error.

3)After the modification on form copy it to AU_TOP and complie it using f60gen

4)Copy the fmx generated to the respective forms folder of the respective TOp

5)After logon to apps using application developer register the form in (N)-> Application-Forms and register its function

6)Then add it to ur menu

7)Go to ur respective responsibility and run the form

(2)What is the importance of Short Name in program defination.

The short name is used to identify the program internally, ie whenever a API's are called to refer to this perticualar

program it is identified by its Short name

(3)What is the order in which Autolock box searches for the types of the matching number?

Autolock box searches the autolock box to first check the lockbox number, then the bank number then the transaction id

(4)What are validations to be done in Journal Import interface.

(5)Different type of execution methods in Conc.Progs. Explain Each Type.

The Concurrent Program methods may be

Oracle Reports:- Runs a report created using report builder

PL/SQL:- Runs querry with select statements which

is not an object of database

Stored Procedure:-Runs a procedure stroed as a part of database

Spawned :- Runs a program written in Pro C

(6)How can we return a value in procedure ?

A procedure can return a value using an OUT parameter defined in the procedure

(7)What is the Flex field? What are the types of Flex field?

Flex field are the a combination of segments for which a logic can be devised to store key information in the table

Types of Flex field

Key Flex field on which a business logic can be based and

Descriptive Flex Field for storing additional data

(8)Describe the NUM option of the FND FLEXSQL user exit

The NUM option of the FND FLEXSQL stores the structure defining column value

(9)Describe the OPERAND2 option of the FND FLEXSQL user exit

Name different types of Value set validations?

Table type

Independent

Dependent

Pair type

Translational Independent

Translational Dependent

(10)What are the Translatable Dependent and Independent value sets?

These value sets can be used for tranlation of language used

(11)What are the FlexField Qualifiers?

Flexfied qualifiers are used to identify column of flexfield

(12)How do you set timeout for Notification in Workflow.

The resultype can be set to timeout in the notification

(13)How do you make Notification have response in a workflow.

The respond type should be set to 'respond'

(14)Name two types of errors, when creating a workflow.

Performer not defined error saving

Cannot delete the message as it is referenced by the item type

(15)How do you set Performer dynamically in WF?

By setting the performer to 'attribute' type

(16)What access level is set for FND objects in oracle Apps?

0-9 is the access level for apps

(17)What is the use of selector function?

it is used to select a process when a item type is called when there is more than one process

it returns the conncatenated segment of a key flexfield

(18)What are the steps involved in Creating Periodic alerts?

specify the type of alert to periodic and select the duration to repeat it

(19)What is the Distribution List in Alerts?

The list of entities to whom the alert is to be sent

(20)What are the Advance features available in alerts?

(21)As a convention all views have _ALL for partitioning in multi-org specific requirements it implies that if CE_TRX_ALL exists then CE_TRX will be the table name. Specify (True/False)

False

(22)ORG_ID and Organization_ID are mandatory columns for Inventory transaction tables. Specify (True/False)

True

(23)Stock Locator is the third tier for Inventory Organization structure. It is not mandatory that Inventory Organization should have stock locator for various items assigned to them. Specify (True/False)

False

(24)System Item Key flexfield setups is mandatory. User may also setup descriptive flexfield on this table. Specify (True/False)

False

(25)Any Organization can be the first Organization defined in Oracle Inventory for Item creation since user can assign the Item to Master Organization later. Specify (True/False)

True

1. What is Threshold usage in workflow. Where do you set the function threshold

2.The business group represents the highest level in the organization structure. Specify (True/False)

True

3.Why do we call FND FLEXSQL from the Before Report Trigger?

To call flex field column from the select query statement

4.What does AOL consist of ?

All the libraries which we have to use in oracle apps.

5.Where is Custom .pll found. What is the importance of custom .pll

6.Give name of the interface and What validation must be given on specific columns you know.

Budget upload interface. Budget Upload Interface is used to upload budget data into Order General Ledger Application from spreadsheet program or other external source. This load table will have all not null values, a valid account combination in the segment columns appropriate to chart of accounts structure and supply the budget amounts in the appropriate amount columns

7.Name three concurrent managers and their use.

8.What is MULTI-ORG and what is name of multi-org.

Multi-org is for business and other. Organization-id and org_id.

9.How can we return a value in procedure ?

The procedure can be return through out parameter.

10.How can we display flexfield segment values, descriptions, and prompts on the report?

flexidval

11.Describe the OPERATOR option of the FND FLEXSQL user exit

execution

12.Describe the NUM option of the FND FLEXSQL user exit

13.Describe the OPERAND1 option of the FND FLEXSQL user exit

14.What is a Dynamic Insertion?

inserting at runtime

15.How do you create a function in workflow. Give API syntax of function in WF.

give the function name in function option of workflow. WF_engine(item_type,item_name,action_id,proc_name)

16.What is the step of creating deferred action in workflow?

17.Name of the tables in workflow to see how much time each activity processing took in a running workflow.

18.Use of effective date in Workflow

Until the effective date completes, the workflow will not complete

19.How do you make Notification have response in a workflow.

through lookups

20.What is Access and Protection in Workflow?

Access for user and protection is public if we give permission

21.How to get closed invoices into AR using Auto Invoice process?

22.Operating Unit is a financial reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Specify (True/False)

23.How do I reprint checks after payment batch has been formatted.

24.What is a Summary Threshold?

25.What are the steps involved in Creating Periodic alerts?

calender for period

26.What is the Distribution List in Alerts?

27.If a new table is being designed, one of the criteria to partition data will be: if the table is going to hold any transaction data. (True/False)

true

28.ORG_ID and Organization_ID are mandatory columns for Inventory transaction tables. Specify (True/False)

true

29.Item Planning is a mechanism to ensure is how inventory stock is replenished. Make or Buy decision about an Item is one of the ways of planning an Item replenishment. Specify (True/False)

false

30.System Item Key flexfield setups is mandatory. User may also setup descriptive flexfield on this table. Specify (True/False)

false

What are the four implicit Inputs in Alerts?

Why do we call FND FLEXSQL from the Before Report Trigger?

If u call the user exit FND FLEXSQL with MODE = "ORDER BY" from the Before Report Trigger. What will it do?

How can we display flexfield segment values, descriptions, and prompts on the report?

Describe the OUTPUT option of the FND FLEXSQL user exit

Describe the TABLE ALIAS option of the FND FLEXSQL user exit

Describe the OPERATOR option of the FND FLEXSQL user exit

Describe the DISPLAY option of the FND FLEXSQL user exit

Describe the OPERAND1 option of the FND FLEXSQL user exit

What is the order in which Autolock box searches for the types of the matching number?

What is application short name for General Ledger you specify in FND FLEXSQL user exit?

What is the clause in SQL * Loader to program to override data into table

What is the syntax for loading data through SQL * Loader from multiple files simultaneously

Name the interface tables used for the AutoInvoice Interface

What is parameter in apps and from where u can create it.

Can we see our data of RA_CUSTOMER (account Receivables) in Order Management?

What Difference Between report development and report customization.

What is MULTI-ORG and what is name of multi-org.

What is difference between oracle schema and apps schema.

What are the objects APPS schema contain.

Where exactly u place your forms in APPS environment.

How do you set Performer dynamically in WF?

What Access level is set for custom workflow development in Oracle Application?

What is the use of selector function?

How do you create time dependent actions in workflow?

Use of effective date in Workflow.

How do you make Notification have response in a workflow.

Give syntax for giving result to a function in workflow

Name two types of errors, when creating a workflow.

How will you fix an error that say performer not specified in workflow.

Give name of the interface and List some of the production tables that an open Interface transfers data from the interface tables into?

Name subclasses in forms6i you have assigned for Oracle Apps forms develop.

Give four names of important production tables & their purpose AP or AR or GL or PO or WIP or BOM

Where is Custom .pll found. What is the importance of custom .pll

Why is responsibility important what does it indicate?

Difference between Concurrent Process and Concurrent Request? Why do you need Request Group.

What different types of output formats can be set for reports?

How can you hide parameter when report registering so that user will not see it.

Give syntax and APIs for running a workflow from SQL/PLSQL environment

What is workflow and What is the benefit of using workflow in OracleName three concurrent managers and their use Apps. Give three workflow examples.

1. How many concurrent programs you have customized, can you name some of them

2. Total months of effort in Oracle Apps technical work

3. Which Oracle Apps version you are very confident in.

4. Which technical interfaces you have written yourself in say Oracle GL, AP & AR

5. Did you get trained in Oracle apps or was it in house learning

6. Are all the project listed actual real life project.

7. Are all the projects on-site Live and running.

8. How many PL/SQL package procedures have written.

9. How many Oracle applications reports have you written, total months you have worked on Oracle reports, which client was it.

10. Were you involved in any data conversion, which one

11. What was the volume of data converted by your program. ( like how many journals, how many invoices, how many…. )

12. How many Oracle Application Forms have you customized. Which one was a major customization , is it given in your resume.

13. Which Oracle applications PL/SQL standard APIs you are familiar, have you used most of them.

14. Are you familiar with internet architecture of Oracle Apps 11i

15. In oracle application how do you debug or trace errors

16. Which directory will you copy your new custom form, what would be its extension ( .fmb or .fmx )

17. Do you know what are User Profiles in Apps. Any examples you can give.

18. Which directory will you copy your new reports, what would be its extension ( .rdf or .rex )

19. Have you used lexical parameters in reports

20. Are you familiar with User exits in reports

21. How do you debug an Oracle application report developed using Reports 6i.

22. Which custom application did you work on.

23. rate your self in PL/SQL, SQL*Plus, SQL*Loader, Unix Shell scripting, Forms 6i, Reports6i

24. Have you good knowledge on Java.

25. Which Flexfields you have customized,

26. Do you know table based value sets

27. Any work done in Oracle Workflow builder. Did you customize or build a new workflow.

28. Do you know what is APPLYSYS in Oracle application database schema, what is APPS

29. what is the meaning of FND in AOL

SQL

1.What is SQL

2.What are the different type SQL statements( ddl. Dml, dcl, transaction control)

3.When does rowid change

4.What are synonyms

5.What is the difference between delete table and truncate table

6.When the having clause is used

7.What is the difference between where clause and having clause

8.Is it mandatory to have a group by clause if, having exists

9.What are set operators

10.What are row operators (distinct, all)

11.What is like, in and between operators

12.What are diff dml statements

13.What is the use of dynamic SQL statement prepare and execute

14.What is the difference between a simple join and a outer join

15.What is minextends and maxextends

16.What are ttitle and btitle clauses

17.What is serveroutput setting

18.What is instr function

19.How you specify column separators?

20.What is tabs table?

21.What are the pseudocolumns

22.What is mutating table

23.What are synonyms

24.What is the max. length for variable name and value to be stored in it

25.With set autocommit on command, a PL/SQL block having multiple insert, update or delete statements is executed. Now if the script aborts in between, will all the changes be committed or none at all ?

26.What are the uid and user functions

27.What does the set escape command does

28.How to execute operating system commands from SQL plus

29.What is & and && operators?

30.How to insert (') single quote as a value

31.How can a SQL script be executed automatically as soon as SQLplus is invoked

32.Give the usage of 'for - update'.

33.What are the new values

34.What is the maximum no of chars a accept statement can acquire ?

35.Which are the functions, which returns some argument even if null argument is passed ( decode, nvl, replace)

36.What are different date format models? Hoe the data stored in the database

37.How can we define a column in the table with all options

38.Can we define a descending sequence

39. 0.Give the usage of compute statement

40.What are the following set operators used for - heading ,page,pagesize,feedback

41.In a column clause what are the options used for formatting

42.Char datatype can be converted to how many types

43.What is the restriction on usage of & and && operators

44.How we display the generate timing data for SQL commands

45.How we return a value while exiting the SQLplus

46.How to disable some roles for users (hint : product_user_profile)

PL/SQL

1.What is %type and %rowtype?

2.What is a difference between procedure and function?

3.What is the difference between implicit and explicit cursors?

4.What is a transaction?

5.What are explicit cursor attributes?

6.For which SQL statements is the implicit cursor opened.

7.How cursor attributes can be referenced in case of implicit cursor

8.Which is the form of the cursor, where these operations are made automatically

9.Can you pass a parameter to a cursor? What is the mode of the parameter that can be passed?

10.What are bind variables?

11.What is decode function?

12.Can you pass parameters to a procedure?

13.What is the block structure of PL/SQL block

14.How PL/SQL is different than SQL

15.What is the structure of rowid?

16.What is an alias? What is used for?

17.Give 4 predefined exceptions raised

18.How the user defined exceptions are fired

19.What is PRAGMA EXCEPTION_INIT

20.What is the difference between actual parameter and formal parameter?

21.What are the different modes of the parameters?

22.Whether the rowid of deleted is used for inserting other record?

23.What is an exception

24.What is exception handler?

25. Is there any general exception?

26.What are the different type of triggers ( each row, each statement)

27.What are the types of exceptions(user defined, predefined)

28.How to define user defined exception?

29.How to implement user-defined exceptions

30.Can you access the variables defined in the package by a function outside the scope of the package?

31.Advantages of packages?

32.What is database trigger? What is the difference between a SQL/forms trigger and a database trigger?

33.What is the difference between Packages and stored procedures ?

34.What is the difference between a stored procedure and a database trigger?

35.What is PL/SQL table?

36.What are the two steps to define a PL/SQL table

37.How the nulls are handled in PL/SQL?

38.What are types of loops?

39.Can you use goto statement in PL/SQL?

40.What is array size max data parameter?

41.What is record type?

42.What are different types of loop constraints in PL/SQL?

43.Can you initialize a PL/SQL table while making the declarations

44.What is the datatype of primary key of a PL SQL table

45.Can you delete the records from PL/SQL table

46.How to compile a stored procedure?

47.What are scalar type of datatypes

48.What are composit type of data types

49.What is a subtype

50.Whether you can use rowid in comparison statement in SQL

51.What is implicit data conversion

52.What is explicit data conversion

53.How can you convert a datatype explicitly

54.What are the values which can be assigned to Boolean variable

55.In how different ways you can assign a value to a variable in PL/SQL

56.Which are the functions, which returns some argument even if null argument is passed ( decode, nvl, replace)

57.What are error reporting functions

58.What is returned by a function userenv

59.What is a datatype record

60.What are conditional control statement

61.What are iterative constructs

62.Whether the exit statement is written inside the loop or outside the loop

63.What are sequential control statements( goto, null)

64.Whether the null statement passes control to next sequential statement

65.Can the package variables be referenced in an external stored procedure

66.In how different ways you can assign a value to a variable in PL/SQL

67.What are conditional control statement

68.Will 'before delete trigger' get fired if table is truncated.

69.Can we trap all the triggering events in a single trigger.

70.What is cursor loop . How it is different than other cursor?

71.What is packaged cursor?

72.In how many ways you can open the cursor?

73.What are character conversion functions?

74.What type of information you can get from date format?

75.What is case structure used in PL/SQL?

What Are Cursor Variables?

Cursor variables are like C or Pascal pointers, which hold the memory location (address) of some item instead of the item itself. So, declaring a cursor variable creates a pointer, not an item. In PL/SQL, a pointer has datatype REF X, where REF is short for REFERENCE and X stands for a class of objects. Therefore, a cursor variable has datatype REF CURSOR. To execute a multi-row query, Oracle opens an unnamed work area that stores processing information. To access the information, you can use an explicit cursor, which names the work area. Or, you can use a cursor variable, which points to the work area. Whereas a cursor always refers to the same query work area, a cursor variable can refer to different work areas. So, cursors and cursor variables are not interoperable; that is, you cannot use one where the other is expected.

Why Use Cursor Variables?

Mainly, you use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients. Neither PL/SQL nor any of its clients owns a result set; they simply share a pointer to the query work area in which the result set is stored. For example, an OCI client, Oracle Forms application, and Oracle server can all refer to the same work area. A query work area remains accessible as long as any cursor variable points to it. Therefore, you can pass the value of a cursor variable freely from one scope to another. For example, if you pass a host cursor variable to a PL/SQL block embedded in a Pro*C program, the work area to which the cursor variable points remains accessible after the block completes. If you have a PL/SQL engine on the client side, calls from client to server impose no restrictions. For example, you can declare a cursor variable on the client side, open and fetch from it on the server side, then continue to fetch from it back on the client side. Also, you can reduce network traffic by having a PL/SQL block open (or close) several host cursor variables in a single round trip.

Defining REF CURSOR Types

To create cursor variables, you take two steps. First, you define a REF CURSOR type, then declare cursor variables of that type. You can define REF CURSOR types in any PL/SQL block, subprogram, or package using the syntax TYPE ref_type_name IS REF CURSOR [RETURN return_type]; where ref_type_name is a type specifier used in subsequent declarations of cursor variables and return_type must represent a record or a row in a database table. In the following example, you specify a return type that represents a row in the database table dept:

DECLARE

TYPE DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE;

REF CURSOR types can be strong (restrictive) or weak (nonrestrictive). As the next example shows, a strong REF CURSOR type definition specifies a return type, but a weak definition does not:

DECLARE

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; -- strong

TYPE GenericCurTyp IS REF CURSOR; -- weak

Strong REF CURSOR types are less error prone because the PL/SQL compiler lets you associate a strongly typed cursor variable only with type-compatible queries. However, weak REF CURSOR types are more flexible because the compiler lets you associate a weakly typed cursor variable with any query.

Declaring Cursor Variables

Once you define a REF CURSOR type, you can declare cursor variables of that type in any PL/SQL block or subprogram. In the following example, you declare the cursor variable dept_cv:

DECLARE

TYPE DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE;

dept_cv DeptCurTyp; -- declare cursor variable

Note: You cannot declare cursor variables in a package. Unlike packaged variables, cursor variables do not have persistent state. Remember, declaring a cursor variable creates a pointer, not an item. So, cursor variables cannot be saved in the database. Cursor variables follow the usual scoping and instantiation rules. Local PL/SQL cursor variables are instantiated when you enter a block or subprogram and cease to exist when you exit. In the RETURN clause of a REF CURSOR type definition, you can use %ROWTYPE to specify a record type that represents a row returned by a strongly (not weakly) typed cursor variable, as follows:

DECLARE

TYPE TmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

tmp_cv TmpCurTyp; -- declare cursor variable

TYPE EmpCurTyp IS REF CURSOR RETURN tmp_cv%ROWTYPE;

emp_cv EmpCurTyp; -- declare cursor variable

Likewise, you can use %TYPE to provide the datatype of a record variable, as the

following example shows:

DECLARE

dept_rec dept%ROWTYPE; -- declare record variable

TYPE DeptCurTyp IS REF CURSOR RETURN dept_rec%TYPE;

dept_cv DeptCurTyp; -- declare cursor variable

In the final example, you specify a user-defined RECORD type in the RETURN clause:

DECLARE

TYPE EmpRecTyp IS RECORD (

empno NUMBER(4),

ename VARCHAR2(1O),

sal NUMBER(7,2));

TYPE EmpCurTyp IS REF CURSOR RETURN EmpRecTyp;

emp_cv EmpCurTyp; -- declare cursor variable

Cursor Variables As Parameters

You can declare cursor variables as the formal parameters of functions and procedures. In the following example, you define the REF CURSOR type EmpCurTyp, then declare a cursor variable of that type as the formal parameter of a procedure:

DECLARE

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp) IS ...

Controlling Cursor Variables

You use three statements to control a cursor variable: OPEN-FOR, FETCH, and CLOSE. First, you OPEN a cursor variable FOR a multi-row query. Then, you FETCH rows from the result set. When all the rows are processed, you CLOSE the cursor variable.

Opening a Cursor Variable

The OPEN-FOR statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set. Here is the syntax:

OPEN {cursor_variable | :host_cursor_variable} FOR

{ select_statement

| dynamic_string [USING bind_argument[, bind_argument]...] };

where host_cursor_variable is a cursor variable declared in a PL/SQL host environment such as an OCI program, and dynamic_string is a string expression that represents a multi-row query.

Note: This section discusses the static SQL case, in which select_statement is used. For the dynamic SQL case, in which dynamic_string is used, see "Opening the Cursor Variable" on page 10-7. Unlike cursors, cursor variables take no parameters. However, no flexibility is lost because you can pass whole queries (not just parameters) to a cursor variable. The query can reference host variables and PL/SQL variables, parameters, and functions. In the example below, you open the cursor variable emp_cv. Notice that you can

apply cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) to a cursor variable.

IF NOT emp_cv%ISOPEN THEN

/* Open cursor variable. */

OPEN emp_cv FOR SELECT * FROM emp;

END IF;

Other OPEN-FOR statements can open the same cursor variable for different queries. You need not close a cursor variable before reopening it. (Recall that consecutive OPENs of a static cursor raise the predefined exception CURSOR_ALREADY_OPEN.) When you reopen a cursor variable for a different query, the previous query is lost. Typically, you open a cursor variable by passing it to a stored procedure that declares a cursor variable as one of its formal parameters. For example, the following packaged procedure opens the cursor variable emp_cv:

CREATE PACKAGE emp_data AS

...

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp);

END emp_data;

CREATE PACKAGE BODY emp_data AS

...

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp) IS

BEGIN

OPEN emp_cv FOR SELECT * FROM emp;

END open_emp_cv;

END emp_data;

When you declare a cursor variable as the formal parameter of a subprogram that opens the cursor variable, you must specify the IN OUT mode. That way, the subprogram can pass an open cursor back to the caller. Alternatively, you can use a stand-alone procedure to open the cursor variable. Simply define the REF CURSOR type in a separate package, then reference that type in the stand-alone procedure. For instance, if you create the following bodiless package, you can create stand-alone procedures that reference the types it defines:

CREATE PACKAGE cv_types AS

TYPE GenericCurTyp IS REF CURSOR;

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

TYPE DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE;

END cv_types;

In the next example, you create a stand-alone procedure that references the REF CURSOR type EmpCurTyp, which is defined in the package cv_types:

CREATE PROCEDURE open_emp_cv (emp_cv IN OUT cv_types.EmpCurTyp) AS

BEGIN OPEN emp_cv FOR SELECT * FROM emp;

END open_emp_cv;

To centralize data retrieval, you can group type-compatible queries in a stored procedure. In the example below, the packaged procedure declares a selector as one of its formal parameters. (In this context, a selector is a variable used to select one of several alternatives in a conditional control statement.) When called, the procedure opens the cursor variable emp_cv for the chosen query.

CREATE PACKAGE emp_data AS

TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp, choice INT);

END emp_data;

CREATE PACKAGE BODY emp_data AS

PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp, choice INT) IS

BEGIN

IF choice = 1 THEN

OPEN emp_cv FOR SELECT * FROM emp WHERE comm IS NOT NULL;

ELSIF choice = 2 THEN

OPEN emp_cv FOR SELECT * FROM emp WHERE sal > 2500;

ELSIF choice = 3 THEN

OPEN emp_cv FOR SELECT * FROM emp WHERE deptno = 20;

END IF;

END;

END emp_data;

For more flexibility, you can pass a cursor variable and a selector to a stored procedure that executes queries with different return types. Here is an example:

CREATE PACKAGE admin_data AS

TYPE GenCurTyp IS REF CURSOR;

PROCEDURE open_cv (generic_cv IN OUT GenCurTyp, choice INT);

END admin_data;

CREATE PACKAGE BODY admin_data AS

PROCEDURE open_cv (generic_cv IN OUT GenCurTyp, choice INT) IS

BEGIN

IF choice = 1 THEN

OPEN generic_cv FOR SELECT * FROM emp;

ELSIF choice = 2 THEN

OPEN generic_cv FOR SELECT * FROM dept;

ELSIF choice = 3 THEN

OPEN generic_cv FOR SELECT * FROM salgrade;

END IF;

END;

END admin_data;

Apps

1) How will u register RDF file and run it? Tell the Sequence?

Steps a. Save the copy of ur reports in rdf file in ur local directory.

b. Transfer or copy the rdf file to cus_top under reports directory through ftp.

C. Then go concurrent program under executable menu where u define executable file and program name

d. Then go to define the program name (which ur executable file name ) and check the srs box and define the parameter and give the parameter name in token

e. Attach the program(request to ur responsibility )

d run the program and view the out put is srs through ur responsibility

What are different types of value sets ?

2) What is translatable Independent & Dependent ?

The value set used to support the multilingual value set.

Oracle

3) What are dbms packages with some example ?

4) What is package ?

5) What is pragma ?

6) What is SQL Tunning ?

Reports

7) How many different layouts are in Reports ?

A. there 8 types of layout available in reports6i

1 Tabular

2.Form

3, Group left

4.Grout above

5.Matrix

6.mailing label

7.Matrix report with group

8. Form letter

8) In which sequence report trigger will fire ?

9) Suppose I have 5 pages report. On which page between page trigger will not fire ?

Forms

10) In which sequence form level trigger will fire ?

11) User B is locked the table and User A update same table through form and give commit what will happened?

Oracle –Reports 6i

1.How many types of Columns are there in Reports6i?

Answer : Three

There are three types of Columns. Formula Column, summary column,

placeholder column.

2.can you have more than one layout in One Report?

A YES

Answer : It is possible to have more than one layout in one

Report by using additional layout option in Layout Editor.

3.can you run Report without Parameter Form?

Answer :- YES

Yes it is possible to run the report without parameter form by setting the PARAM value to Null

4.What are the minimum number of groups required for a matrix report?

Answer : 4

The minimum of groups required for a matrix report are 4

5. Which of the following Option is valid for Panel/Print Order Property

in Report Builder?

Answer : Across Down/Down Across

6. What is default Unit of Measurement in Report?

Answer : Inch

Default Unit of measurement is Inch.

7. How many types of Parameters are available in Reports?

Answer : Two

There are two types of Parameters available in Reports

One is System Parameter and another is User Parameter.

8. What is the purpose of PlaceHolder Column in Report?

Answer : A column for which you set the datatype and value in

PL/SQL that you define.

9. What is the purpose of Summary Column in Reports?

Answer : A performs a computation on another column's data.

10. What is the purpose of Formula Columns?

Answer : A column performs a user-defined computation on another column(s) data, including placeholder columns.

11. Which of the following Procedures displays message number and text

that you specify?

Answer : SRW.MESSAGE

This procedure displays a message with the message number and text that you specify. The message is displayed in the format below. After the message is raised and you accept it, the report execution will continue.

12. What are bind variables?

Ans:-Variable that are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH clauses of queries. Bind references may not be referenced in FROM clauses or in place of reserved words or clauses.

13. Can lexical reference be made in PL/SQL statement?

Answer : No

14. Following of which trigger will fire first?

Between Pages
After Parameter Form
Before Parameter Form
Before Reprort

Answer : C

15. Is there a way to change the same format mask in a lot of fields in one

step?

Answer : A

Select all the Items and change the format mask for all the item once.

Questions

1. What is the Relationship between Request Group, Data group, Responsibility, Users and Menu.

2. Tables are need to be registered when used for ALERT, FORMS, AUDITING purpose (by using ADD_DD package)

3. When a request group is assigned to responsibility then its called REQUEST SECURITY GROUP.

4. What is SRS (Standard Request Submission)

5. Following tables are used for users and responsibility info. FND_USER, FND_RESPONSIBILITY_VL (maid up of FND_RESPONSIBILITY_TL, RESPONSIBILITY).

6. Type of concurrent managers – Internal, Standard, Specialized, Library based manager, conflict resolution manager.

7. What is conflict resolution/Incompatibility/Conflict Domain in concurrent program

8. Go to system responsibility to register concurrent program.

9. Path to put reports for concurrent program.

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/reports/US

For SQL query (normal and parameterized)

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/sql

For SQL*Loader scripts

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/bin

10. What is the use of FND_FILE

11. What are the server side and client side concepts in PL/SQL APIs

12. Using FND_REQUEST.SUBMIT_REQUEST we can call one concurrent program from other concurrent program. For testing in on sql prompt we have to set the SQL environment for Apps support by executing following procedure.

exec FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id,resp_appl_id,security_group_id).

(Parameter values will be available from help menu/examine tab.)

13. Value set can be registered as a Application Developer Responsibility.

14. When creating table based value, in the where clause we have to follow the following syntax

WHERE column_name =:$FLEX$.param_name (this useful to refer the above one parameter in the query).

What is ADDITIONAL COLUMNS fields (Which is after WHERE clause field) when we create the table based Value set.

15. What is context sensitivity, global fields, and reference flex fields in DFF.

16. In KFF only independent Value Sets can be used for different segments and all segments of type Varchar2.

17. What is Flex Field Qualifier, What is Segment Qualifier, What is Rollup Groups in ACCOUNTING KFF.

18. In DFF ATTRIBUTE_CATEGORY field is the column which stores the Structure of the DFF.

19. How to open new periods ? and how to create a new period.

n FILE 10

PO_REQUISITIONS_INTERFACE_ALL

PO_REQUISITIONS_INTERFACE_ALL contains requisition information from other applications. Each row includes all the information necessary to create approved or unapproved requisitions

in Oracle Purchasing. The Oracle Purchasing Requisition Import feature uses this information to create new requisition headers, lines and distributions. You use the Submit Request window to launch the Requisition Import program for any set of rows. You identify the set of rows you want to import by setting the INTERFACE_SOURCE_CODE and BATCH_ID columns appropriately in the interface table.

The Requisition Import program validates your data, derives or defaults additional information and writes an error message for every validation that fails into the PO_INTERFACE_ERRORS table.

Then the program groups and numbers requisition lines according to the criteria you specify in the GROUP_CODE and REQ_NUMBER_SEGMENT1 columns, and create new requisitions. Most of the columns in the PO_REQUISITIONS_INTERFACE_ALL table are identical to the corresponding columns in the

PO_REQUISITIONS_HEADERS_ALL,

PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL tables.

You can additionally enter reference information in the INTERFACE_SOURCE_LINE_ID column.

Foreign Keys

Primary Key Table Primary Key Column Foreign Key ColumnForeign Keys

Primary Key Table Primary Key Column Foreign Key Column

FND_CURRENCIES CURRENCY_CODE CURRENCY_CODE

GL_CODE_COMBINATIONS CODE_COMBINATION_ID CHARGE_ACCOUNT_ID

GL_CODE_COMBINATIONS CODE_COMBINATION_ID ACCRUAL_ACCOUNT_ID

GL_CODE_COMBINATIONS CODE_COMBINATION_ID VARIANCE_ACCOUNT_ID

GL_CODE_COMBINATIONS CODE_COMBINATION_ID BUDGET_ACCOUNT_ID

GL_DAILY_CONVERSION_RATES_R10 CONVERSION_RATE RATE

GL_DAILY_CONVERSION_TYPES CONVERSION_TYPE RATE_TYPE

GL_USSGL_TRANSACTION_CODES USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE

MTL_CATEGORIES_B CATEGORY_ID CATEGORY_ID

MTL_ITEM_REVISIONS REVISION ITEM_REVISION

MTL_KANBAN_CARDS KANBAN_CARD_ID KANBAN_CARD_ID

MTL_SECONDARY_INVENTORIES SECONDARY_INVENTORY_NAME SOURCE_SUBINVENTORY

ORGANIZATION_ID SOURCE_ORGANIZATION_ID

MTL_SECONDARY_INVENTORIES SECONDARY_INVENTORY_NAME DESTINATION_SUBINVENTORY

ORGANIZATION_ID DESTINATION_ORGANIZATION_ID

MTL_SYSTEM_ITEMS_B INVENTORY_ITEM_ID ITEM_ID

MTL_UNITS_OF_MEASURE_TL UNIT_OF_MEASURE UNIT_OF_MEASURE

PA_EXPENDITURE_TYPES EXPENDITURE_TYPE EXPENDITURE_TYPE

PA_PROJECTS_ALL PROJECT_ID PROJECT_ID

PA_TASKS TASK_ID TASK_ID

PO_AGENTS AGENT_ID SUGGESTED_BUYER_ID

PO_REQUISITION_HEADERS_ALL REQUISITION_HEADER_ID REQUISITION_HEADER_ID

PO_REQUISITION_LINES_ALL REQUISITION_LINE_ID REQUISITION_LINE_ID

PO_REQ_DISTRIBUTIONS_ALL DISTRIBUTION_ID REQ_DISTRIBUTION_ID

PO_VENDORS VENDOR_ID SUGGESTED_VENDOR_ID

PO_VENDOR_CONTACTS VENDOR_CONTACT_ID SUGGESTED_VENDOR_CONTACT_ID

PO_VENDOR_SITES_ALL VENDOR_SITE_ID SUGGESTED_VENDOR_SITE_ID

AUTHORIZATION_STATUS AUTHORIZATION STATUS PO_LOOKUP_CODES

APPROVED Document has been Approved

CANCELLED Document has been Cancelled

IN PROCESS Document is still undergoing

Approval

INCOMPLETE Document is not yet Complete

PRE–APPROVED Document is Approved but not yet Accepted

REJECTED Document as been Rejected

REQUIRES REAPPROVAL Requires Reapproval

RETURNED Document has been Returned

DESTINATION_TYPE_CODE DESTINATION TYPE PO_LOOKUP_CODES

EXPENSE Goods are expensed from the system upon delivery

INVENTORY Goods are received into inventory upon delivery

SHOP FLOOR Goods are received into an outside operation upon delivery

REQUISITION_TYPE DOCUMENT SUBTYPE PO_LOOKUP_CODES

BLANKET Blanket

PLANNED Planned

SCHEDULED Scheduled

STANDARD Standard

SOURCE_TYPE_CODE REQUISITION SOURCE TYPE PO_LOOKUP_CODES

INVENTORY Inventory Sourced Requisition

VENDOR Vendor Sourced Requisition

INTERFACE_SOURCE_CODE NOT NULL VARCHAR2(25) Interface transaction source

DESTINATION_TYPE_CODE NOT NULL VARCHAR2(25) Requisition destination type

QUANTITY NOT NULL NUMBER Quantity ordered

AUTHORIZATION_STATUS NOT NULL VARCHAR2(25) Authorization status type

Indexes

PO_REQUISITIONS_INTERFACE_N1 NOT UNIQUE 1 ITEM_ID

PO_REQUISITIONS_INTERFACE_N2 NOT UNIQUE 1 DELIVER_TO_LOCATION_ID

PO_REQUISITIONS_INTERFACE_N3 NOT UNIQUE 1 SOURCE_ORGANIZATION_ID

PO_REQUISITIONS_INTERFACE_N4 NOT UNIQUE 1 DESTINATION_ORGANIZATION_ID

PO_REQUISITIONS_INTERFACE_N5 NOT UNIQUE 1 REQUEST_ID

PO_REQUISITIONS_INTERFACE_N6 NOT UNIQUE 1 PROCESS_FLAG

PO_REQUISITIONS_INTERFACE_U1 UNIQUE 1 TRANSACTION_ID

Sequences

PO_REQUISITIONS_INTERFACE_S TRANSACTION_ID

n FILE 11

Questions

20. What is the Relationship between Request Group, Data group, Responsibility, Users and Menu.

21. Tables are need to be registered when used for ALERT, FORMS, AUDITING purpose (by using ADD_DD package)

22. When a request group is assigned to responsibility then its called REQUEST SECURITY GROUP.

23. What is SRS (Standard Request Submission)

24. Following tables are used for users and responsibility info. FND_USER, FND_RESPONSIBILITY_VL (maid up of FND_RESPONSIBILITY_TL, RESPONSIBILITY).

25. Type of concurrent managers – Internal, Standard, Specialized, Library based manager, conflict resolution manager.

26. What is conflict resolution/Incompatibility/Conflict Domain in concurrent program

27. Go to system responsibility to register concurrent program.

28. Path to put reports for concurrent program.

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/reports/US

For SQL query (normal and parameterized)

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/sql

For SQL*Loader scripts

$CUS_TOP = apps/visappl/cus/11.5.0/

Cd /apps/visappl/cus/11.5.0/bin

29. What is the use of FND_FILE

30. What are the server side and client side concepts in PL/SQL APIs

31. Using FND_REQUEST.SUBMIT_REQUEST we can call one concurrent program from other concurrent program. For testing in on sql prompt we have to set the SQL environment for Apps support by executing following procedure.

exec FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id,resp_appl_id,security_group_id).

(Parameter values will be available from help menu/examine tab.)

32. Value set can be registered as a Application Developer Responsibility.

33. When creating table based value, in the where clause we have to follow the following syntax

WHERE column_name =:$FLEX$.param_name (this useful to refer the above one parameter in the query).

What is ADDITIONAL COLUMNS fields (Which is after WHERE clause field) when we create the table based Value set.

34. What is context sensitivity, global fields, and reference flex fields in DFF.

35. In KFF only independent Value Sets can be used for different segments and all segments of type Varchar2.

36. What is Flex Field Qualifier, What is Segment Qualifier, What is Rollup Groups in ACCOUNTING KFF.

37. In DFF ATTRIBUTE_CATEGORY field is the column which stores the Structure of the DFF.

38. How to open new periods ? and how to create a new period.

n FILE 12

Reports Development and Customization:

 Customized purchase order summary report by category, created a vendor group.

 Customized inactive item status report added column rate.

 Created report on purchase order status like pending, rejected, completed against a particular supplier.

 Customized unbooked order report of order management.

 Created a report using key flex field for item categories.

Workflow:

 Customized workflow to send notification to the Approving Authorities regarding the urgency of the Purchase Requisition.

 Created a workflow to send a notification to the sales manager if the no. of orders in the order booked tables are more than X number. Got a list of orders whose amount is more than x.

 Created workflow when the customer information changes notification to sales manager.

Forms Customization:

 Aware of customization of Oracle applications form.

 Developed a Header detail form.

 Adding the Triggers in Form Level, Block Level and Item Level.

 Attached calendar to date fields.

Concurrent Programming:

 Use of AOL related tasks.

 Use of SQL* Loader utility to load data from legacy system to interface table to upload resource data in MFG Module.

 Writing SQL, PL-SQL.

 Writing Host (UNIX) programs

Interfaces:

 Created and implemented the interfaces for sub inventory transfer.

 Created interface for receiving transaction.

 Created WIP interface.

Thursday, 21 December 2017

Interview Question for Oracle Apps Technical

Set of book

Oracle Apps Question Answer

Values in 4 Levels(HIEARCHY WISE) :-

GE Industries

A. This user exit populates a lexical parameter that you specify with the appropriate SQL fragment at run time. You include this lexical parameter in the WHERE clause of the report query. This user exit is called once for each lexical to be changed.

21. Name the interface tables used for the customer interface?

REPORTS 6i

About User Exits

Writing a user exit call

Syntax

SRW.USER_EXIT

SRW.REFERENCE

SRW.MESSAGE

SELECT Clause

FROM Clause

WHERE Clause

GROUP BY Clause

HAVING Clause

ORDER BY Clause

Multiple Clauses

SELECT Clause

WHERE Clause

GROUP BY Clause

HAVING Clause

ORDER BY Clause

pl_id ParamList;

BEGIN

pl_id := Get_Parameter_List('tmpdata');

IF NOT Id_Null(pl_id) THEN

Destroy_Parameter_List( pl_id );

END IF;

pl_id := Create_Parameter_List('tmpdata'); Add_Parameter(pl_id,'EMP_QUERY',DATA_PARAMETER,'EMP_RECS');

Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');

Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);

END;

FORMS 6i

System Variables

Menu Item Types

Separator Menu Item :

Oracle Apps Questions Date 08/11/02

Segment Qualifier

APPS and Base Product Schemas

Apps

Oracle

Reports

Forms

The minimum of groups required for a matrix report are 4