Orcale ERP

Reports

How can you grey out/ highlight/hide some records based on conditions in a report?

Use Conditional formatting

What is the diff. between normal report and XML report? give me atleast 4 differences?

What is pick slip report and customizations of the report

What is sales order DFF

waht is Data conversion?

How do you call a concurrent program or another report from a report?

Use FND_SUBMIT.REQUEST() to call a concurrent program or a report. Use SRW.RUN_REPORT() to run a report directly without registering it as a concurrent program.

How do you mail the output of a report?

1. Use UTL_SMTP (refer to Scripts tab for more details) 2. Use MAILX called in a shell script registered as a concurrent program with parameters File name and path.

Where in reports do you set the context information (like org_id)?

SRW.INIT

What is Anchor in reports?

Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their positions relative to its parent.

How do you write the report output to Excel file or text file?

1.Use TEXT_IO package 2.Use SPOOL in After Report trigger 3.Use UTL Package

How do you resolve the following layout issues in reports?

Give an example of the implementation of "between pages trigger" in reports.

The total printed at the bottom of first page has to be carried to the top of the next page.

The total printed at the bottom of first page has to be carried to the top of the next page. How do u do this technically?

What is the difference between Conditional Formatting and format trigger?

How do you display only one record on each page in a report?

Give Page Break in the Format trigger of the repeating frame.

How do you print barcode in the reports?

By installing the Barcode Font and using the Chart field in the Layout.

What are the different sections in the Layout?

Header, Main, Trailer

What is SRW package and some procedures in SRW?

It is the standard reports package and it has many procedures like USER_EXITS, DO_SQL, RUN_REPORT, MESSAGE,TRACE, BREAK, SET_ATTR.

What are bind parameter and lexical parameter used for?

A bind reference replaces a single value or expression.To create a bind reference in a query, prefix the parameter name with a colon (:). A lexical reference is a text string and can replace any part of a SELECT statement, such as column names, the FROM clause, the WHERE clause, or the ORDER BY clause. To create a lexical reference in a query, prefix the parameter name with an ampersand (&).

What are user exits in reports and name a few?

User exits provided a way to pass control from Reports Builder to a program you have written, which performs some function, and then returns control to Reports Builder. Ex: SRW.DO_SQL, SRW.USER_EXIT

Name the report triggers.

1. Before Parameter 2. After Parameter 3. Before Report 4. Between Pages 5. After Report

How many minimum fields are require to develop the Matrix, Matrix with Group Reports?

What is the mandatory parameter in mutli org report?

If we have two data models then how many frames we need to design?

What is the difference between "AFTER PARAMETER FORM" trigger and "BEFORE REPORT" trigger?

AFTER PARAMETER FORM trigger is fired immediately after the report parameter form is submitted. BEFORE REPORT trigger is fired after the report queries are parsed and data is fetched.

How do you resolve the following layout issues in reports?

What are the mandatory parameters given in Reports

P_CONC_REQ_ID, P_ORG_ID

Report is not displaying data present in database, what could be the reason?

Is it possible to change the margins for oracle report?

Yes.

What is Report Busting?

Reports bursting offers you to deliver a single report to multiple destinations simultaneously. It offers you to create multiple reports out of one single report model. For example, you can create just one employee report for all your departments and send an email with a PDF-attachment containing the report to each manager. Each report would contain only the relevant department information for that particular manager. Using the reports bursting functionality will reduce the overhead since you will only have a single data fetch and report format.