apps reports presentation

8/6/2019 APPS Reports Presentation

1/15

AgendaAgenda

OverviewOverviewApps reports V/S D2K reportsApps reports V/S D2K reports

ConceptsConceptsValue SetsValue Sets

User ExitsUser Exits

Tips & TricksTips & Tricks

Report Registration & Execution StepsReport Registration & Execution Steps

DemoDemo


2/15

OverviewOverview

Apps reports VS D2K reportsApps reports VS D2K reports

Not much difference with respect to technology andNot much difference with respect to technology andcomponents.components.

Apps database server will normally be running on UnixApps database server will normally be running on Unix

platform. Therefore, following things need to be taken intoplatform. Therefore, following things need to be taken intoconsideration while developing an Apps report:consideration while developing an Apps report:


3/15

OverviewOverview


Develop the Report in character modeDevelop the Report in character mode Open the report, Navigate to report properties and set theOpen the report, Navigate to report properties and set the

Design in character unitsDesign in character units property toproperty to YESYES

Navigate to Data ModelNavigate to Data Model --> System parameters> System parameters -->Mode and set>Mode and set

initial valueinitial value property toproperty to charactercharacter

Open the layout model, Navigate to FormatOpen the layout model, Navigate to Format -- > Layout Options> Layout Options --

> Rulers, set the> Rulers, set the unitsunits toto character cellscharacter cells


4/15

OverviewOverview


UseUse USER EXITSUSER EXITS in before report and after reportin before report and after reporttriggers to enable and complete the execution of reporttriggers to enable and complete the execution of report

in the apps environment respectivelyin the apps environment respectively


5/15

ConceptsConcepts

Value SetsValue Sets

Value sets are used to pass values to parameters createdValue sets are used to pass values to parameters created

in the reportsin the reports

Types of value SetsTypes of value Sets DependentDependent

IndependentIndependent

NoneNone Pair Pair

SpecialSpecial

TableTable

Translatable IndependentTranslatable Independent

Translatable DependentTranslatable Dependent


6/15

ConceptsConcepts

User ExitsUser Exits

Are standalone programs that can be called from formsAre standalone programs that can be called from formsand reports to perform a specific taskand reports to perform a specific task

SyntaxSyntax

SRW.USER_EXIT(FND SRWINIT); (Usage: Before report trigger)SRW.USER_EXIT(FND SRWINIT); (Usage: Before report trigger)

SRW.USER_EXIT(FND SRWEXIT); (Usage: After report trigger)SRW.USER_EXIT(FND SRWEXIT); (Usage: After report trigger)


7/15

ConceptsConcepts

Tips for executing apps reportsTips for executing apps reports

Create user parameter P_CONC_REQUEST_ID of numberCreate user parameter P_CONC_REQUEST_ID of numberdata type. This parameter is used to hold the request iddata type. This parameter is used to hold the request idgenerated when the report is submitted through SRSgenerated when the report is submitted through SRSwindow. This value is then used by the FND SRWINIT userwindow. This value is then used by the FND SRWINIT userexit to process the reportexit to process the report


8/15

ConceptsConcepts

Tips for executing apps reports...Tips for executing apps reports...

Execute the following PL/SQL code in order to retrieveExecute the following PL/SQL code in order to retrieve

data from views either from SQL PLUS or Toad or use thisdata from views either from SQL PLUS or Toad or use thiscode in the before report trigger of the report that is to becode in the before report trigger of the report that is to betested from report builder before registering the same intested from report builder before registering the same in

Apps.Apps.

BeginBegin

fnd_client_info.set_org_context();fnd_client_info.set_org_context();End;End;


9/15

ConceptsConcepts

Report registration stepsReport registration steps

Copy the .RDF file toCopy the .RDF file to -->> -->>

-->> folder on the serverfolder on the server

Logon to Apps in theLogon to Apps in the system administratorsystem administratorresponsibilityresponsibility

Navigate toNavigate to ConcurrentConcurrent -- > Program> Program -->Executable>Executable

Enter the details and save the formEnter the details and save the form


10/15

ConceptsConcepts


Navigate toNavigate to ConcurrentConcurrent -- > Program> Program -->Define>Define

Tips : The report (.RDF) name should be in uppercaseTips : The report (.RDF) name should be in uppercase

Enter the details and select the name of the executableEnter the details and select the name of the executablethat was saved in previous step in the executable field andthat was saved in previous step in the executable field and

save the formsave the form

Navigate toNavigate to SecuritySecurity -- > Request> Request


11/15

ConceptsConcepts


Query for the required Request group under which theQuery for the required Request group under which the

report has to be registered.report has to be registered.

Select the name of the executable to be registered andSelect the name of the executable to be registered andsave the form. This completes the registration stepssave the form. This completes the registration steps


12/15

ConceptsConcepts

Report Execution stepsReport Execution steps

Navigate toNavigate to ConcurrentConcurrent --> Run> Run

Select the name of the report to be executed from the LOVSelect the name of the report to be executed from the LOV

ClickClick SubmitSubmit. A request ID will be displayed, make a note. A request ID will be displayed, make a noteof the same.of the same.


13/15

ConceptsConcepts

Report Execution steps...Report Execution steps...

Navigate toNavigate to ConcurrentConcurrent --> View> View

Check theCheck the Specific RequestSpecific Requestoption, Enter the request IDoption, Enter the request ID

and clickand click FindFindbuttonbutton

The status of the report will be displayed in a new window.The status of the report will be displayed in a new window.


14/15

ConceptsConcepts

Report Execution stepsReport Execution steps

ClickClick refreshrefresh until the status changes tountil the status changes to CompletedCompleted

Click theClick the View OutputView Outputbutton to view the output of thebutton to view the output of thereportreport

Incase the report execution status shows Completed withIncase the report execution status shows Completed witherrors, clickerrors, click ViewLogViewLogbutton to view the errorbutton to view the error


15/15

DemoDemo

i

ro

oft

or

Do

me

t

apps reports presentation

Documents