1.
How to checks the request states?

ü FND_CONCURENT.GET_REQUEST_STATUS
ü FND_CONCURRENT.WAIT_FOR_REQUEST
ü FND_CONCURRENT.GET_REQUEST_STATUS



Syntax à Function
FND_CONCURRENT.GET_REQUEST_STATUS
(request_id in outnumber,
Application in varchar2 default
null,
Program in varchar2 default null,
Phase out varchar2,
Status out varchar,
dev_phase out varchar2,
dev_status out varchar2,
Message
out varchar2) return BOOLEAN;


dev_phase dev_status
Pending normal, standby,
scheduled, paused
Running
normal,
waiting, resuming, terminating.
Complete normal, Error,
warning, cancelled, terminated
Inactive disabled, on-hold,
No-manager, suspended
Ø FND_REQUEST.WAIT_FOR_REQUEST


Syntax àFND_CONCURRENT.WAIT_FOR_REQUEST
(
request_id in number default null,
interval
in number default 60,
max_wait
in numbe default 0,
phase
out varchar2,
status
out varchar2,
dev_phase
out varchar2,
dev_status
out varchar2,
message
out varchar2) return BOOLEN;
Ø FND_CONCURRENT.SET_COMPLETION_STATUS


Syntax à function
FND_CONCURRENT.SET_COMPLETION_STATUS
(
status in varchar2,
message
in varchar2) return BOOLEAN;
normal
status warning message à
any message Error
2.
How to generate fmx at OS level?


Syntax à $F60 gen
userid=apps/appsp module=<form_name>. Fmb
Output_file=<schema_top>/forms?<language>/<form_name>.fmx
Module_type=form bath =no
compile_all=special
3.
How to convert a form from 4.5 to 6.0?



4.
How to call a form from another form?






Syntax à procedure
APP_NAVIGATE.EXECUTE
(Function_name in varchar2,
Open_flag in varchar2 default ‘y’
Sesson_flag in varchar2 default
‘SESSION’
Other_params in varchar2 default null,
Activate_flag in varchar2 default
‘ACTIVATE’
Pinned in Boolean default FALSE);
Syntaxà
Procedure FND_FUNCTION.EXECUTE
(Function name in varchar2,
Open flag in varhcar2 default ‘y’
Session_flag in varhcar2 default ‘session’
Other_params in varchar2 default
null,
Activate in varchar2 default
‘Active’
Browser_target in varchar2 default
null);
5.
What is the reason for not getting any data when a multi org view
is queried?







6.
How do you find that Multi-org is installed?




Select
multi_org_flag
Form
fnd_product_groups)

7.
What are the triggers that fire on item?
1.
Pre_Text_Item
2.
when_New_Item_Instance
3.
post_text_Item
4.
post_Change
5.
When_validate_Item
6.
key_Next_Item


8.
Transactional triggers in forms




1.
ON_LOCK
2.
ON_UPDATE
3.
ON_INSERT
4.
ON_DELETE
9.
Which triggers will fire when censor moves from one block to another
block?
Trigger
Firing Order Level
1. Post_Test_Item Item
2. Post_Record Block
3. Post_Block Block
4. When_Create_Record Block
5. Pre_ Block Block
6. Pre_Record Block
7. Pre_Text.Item Block
8. When_New_Block_Instance Block
9. When_New_Recrd_Instance Block
10. When_new_Item_Instance Form
10.
What is the difference between PRE_COMMIT and POST_COMMIT triggers?


(i)
PRE_COMMIT (ii) ON_COMMIT (iii) POST_COMMIT
Pre –
Commit Trigger









Post
– Commit Trigger









11.
What is Recode function?






Ex: - Select last_name, job,
alary,

‘ST_CLERK’, 1.15*SALARY,
‘ST_REP’, 1.20*SALARY,
SALARY) REVISED_SALARY from
employees;
12.
How to call a Report in two applications?

1
SRW.Break 2.
SRW.Context_Failure
3
SRW.Do_SQL 4. SRW.Do_SQL_Failure
5
SRW.Get_Page_Num 6
SRW.Message
7
SRW.Program_Abort 8 SRW.Refrence
9
SRW.Run_Report 10
SRW.Run_report_Failure
11
SRW.Set_Altr 12
SRW.Integer_Error
13
SRW.Set_Field_char 14
SRW.Set_Field_Num
15
SRW.Set_Maxrow 16
SRW.Trace_Add_Option
17
SRW.Trace_End 18
SRW.Trace_Start
19
SRW.User_Exit 20
SRW.User_Exit_Failure
SRW.Run_Report:
ü SRW.Run_Report
(command_line, char);
ü Executes
specified R25 RUN Command
ü SRW.RUN_REPORT_FAILURE;
ü Stops
report execution when failure of SRW.Run_Report occurs.
ü By
using SRW.Run_Report, another report can be called to the screen from a button within
one report.
ü If
this is used from a Report Trigger, BATCH=YES must be passed.
ü DESTYPE
can only be FILE, PRINTER or MAIL.
Ex: - Function F1 return
Boolean is
Begin
SRW.RUN_REPORT
(‘Report=Rep_A P_Param1=20’);
Calls Report Rep-A
and displays to screen
Passes a parameter
20 to the param_1
Exception
When
SRW.RUN_REPORT_FAILURE Then
SRW.Message
(100, ‘Error Calling Report’);
Raise
SRW.Program_Abort;
Return
True;
End;
ü SRW.DO_SQL
(SQL statement char);
Executes
specified SQL statement
ü SRW.DO_SQL_FAILURE;
Stops
report execution upon SRW.Do_SQL failure.
ü SRW.Message
(msg_number number, msg_text char);
Displays
a specified message and message number
ü SRW.Program_Abort;
Stops
execution of report when raised.
ü SRW.Set_Altr
Applies
attribute settings, such as font, color to lay out objects.
This procedure
applies formatting attributes to the current frame, repeating frame, field or
boiler plate object.
ü SRW.Set_Altr
(object_id number, altr SRW.Generic_Altr);
Object
_id is always zero.
Altr
is SRW.Altr (that is, the attributes to change)
SRW.set_Field
ü The
procedures in this package are very useful in format triggers.
ü They
are used to change data that will be displayed ion a particular item based on a
specific condition.
SRW.Set_Field_char
(Object_id, text char);
SRW.Set_Field_Date
(Object_id, date date);
SRW.Set_Field_
Num (Object_id, number number);
13.
Can a Report contain more than one template?








14.
How to add a template to the predefined templates list?
i. In
a text editor open the Preferences File
ii. Scroll
down to the template descriptions identified by Reports. Xxx – Template_Reso
(who xxx specified a Report style) (Tabular, Break Above)
iii. For
each Report style for which the template is defined
ü To
the Reports.xxx – Template_Disc list, add the description that should be
appeared on the template page of the report wizard.
ü To
the corresponding Reports. XXX_template_file list, add the file name of the
template in the same position as the addition that is made to the description
list.
iv. copy
the template file (file name.tdf) to
ORACLE_HOME/REPORT
60/ADMIN/TEMPLATE/US
Preferences file:-
Windows à
ORACLE_HOME\CAUPREFS.ORA (user preferences)
ORACLE_HOME\CAGPREFS.ORA (Global Preferences)
UNIX
à
HOME_DIRECOTRY/Prefs.ora (User preferences)
$ORACLE_HOME/tools/admin/prefs.ora
(Global Preferences)
15.
How to pass a parameter in a request set for three concurrent
programs which are having same parameter?
i). For
the first report in the Report set, click on the parameters button and ender
the parameters that are to the shared by all reports in the Request (Report)
set.
ii). Go
to the nest report and click the parameters button and list the same shared
parameters.
iii). Do
the above step for each and every report in the request set
iv). ’Modify’
check box can be used to allow the users to change the values of the parameters
in the ‘lower ’reports at submission time..
v). ‘Display check box can be used to allow the
users to see the parameter values at submission time.
vi). Request
set wizard can be used to quickly create a new Request set in which all of the
request run sequentially or the entire request run in parallel.
Sequentially à One after another
Parallel à
All at once.
vii). The
action can be set whether to continue processing or abort processing. If a
request ends with the statues ‘Error’.
16.
What are Global variables in Reports?
Global variables
are the variables that ca n be assigned to parameters in reports and those parameters
can be used in reports
create_parameter_list (------)
add_parameter (----:Global_var);
run_product (….);
17.
What are Handlers?




2) Event Handlers
3) Table Handlers
4) Business Rules

Adding Table
handler Logic
ü Coding
logic for window and alternative region control.
ü Adding
fin-windows and/or ROW-LOV’S and enables query-find.
ü Coding
logic for item relations such as dependent fields.
ü Coding
messages to use message dictionary.
ü Adding
FF logic if required.
ü Adding
choices to the special mince and logic to modify choices the default menu and
tool bar behavior is necessary.
ü Coding
any other logic.
ü Creating
a form function for the developed form and registering any sub functions.
ü Testing
the form by itself.
ü Registering
the form with AOL.
ü Adding
the form function to a menu or creating custom mence.
ü Assigning
the menu to the responsibility and assigning the responsibility to the user.
ü Testing
the form within Oracle Applications.
18.
Registering of Application, form and a concurrent program through
Application developer Responsibility
Application:-
Responsibility à Application Developer
<Application /
Register >
Form:-
<Application /
Form>
<Application /
Function>
Menu:-
<Application / Menu>
Messages:-
<Application / Messages>
Table:-
<Database /Table>
Sequence:-
<Database / View>
Concurrent
Program:-
<Concurrent / Executable>
<Concurrent / Program>
Application Developer
(Responsibility):
ü Flex field:
+Key
+Descriptive
-Test
ü Concurrent
-Program
-Executable
-Library
ü Application
-Register
-Form
-Function
-Menu
-Messages
+Database
+Lookups
+Validation
Profile:
Attachments:
ü Document
Entities
ü Document
Categories
ü Attachment
Functions
Other:
Requests:
-
Run
-Set
-Profile
-Concurrent
-Change
Organization
-Running
Jobs
![]() |
+Key +Descriptive
-Register -Register
-Segments -Segments
-Aliases -Values
-Cross Validation
-Values +Lookups
-Groups -Application
Object Library
-Accounts -Common
+Database +Validation
-Table -Set
-View -Values
-Sequence
ü Lexical
references cannot be made in Pl/SQL statements.
ü Bind
references can be done in PL/SQL statements.
ü Lexical
parameters can be referenced by entering an ampersand ( ) followed immediately by the column name
or parameter.
ü Before
creating the query, a column or parameter in the data model should be created
for each lexical reference in the query.
ü For
lexical parameters, initial value must be defined so that report builder uses
this value to validate the query with a lexical reference.
Token
ü If
Oracle reports are executed by a concurrent program, (for Oracle Reports
Program), then a keyword or a parameter with the same name as in the report
builder, should be defined which for each parameter, which is known as taken.
ü This
is used to pass the parameters to the reports from the application (SRS Window)
Request Set
ü Request
set is the group of requests, that can be submitted regularly using a single
transaction.
Incompatibility
ü These
are the list of programs that can be defined as incompatible with a pertain
program.
ü If
any program is defined as incompatible to a particular program, then that
program should not run simultaneously with the concurrent program, because they
might interfere with its execution.
Application Developer
Responsibility:
Various Screens
Different Executable Methods:
1
Host
2
Immediate
3
Java Stored Procedure
4
Java Concurrent Program
5
Multi Language Function
6
Oracle Reports
7
PL/SQL stored Procedure
8
Request set stage function
9
Spawned
10
SQL*Loader
11
SQL*Plus
<Concurrent/Library> Concurrent Library
Library types
Transaction
Library
<Lookups> User
Access Levels
Extensible
System
<Validation/Set> List of values
List types
Long List of
Values
Pop list
No security Security type
Hireaxhial
Security Non-hireaxhial
Security
Char
Format type Date
Date time
Number
Standard date
Standard date time
Time
Validation types à Respondent
Independent
None
Pair
Special
Table
Translatable Independent
Translatable Dependent
<Attachments /
Attachment Functions>
Function type
Form Report
19.
What is a Data Group?



20.
What is a Responsibility?







No comments:
Post a Comment