Oracle Apps Technical and Functional
Dedicated blog for the Oracle Apps. This blog is for Oracle apps consultants,employers,trainers,students,job seekers,recruiters etc. You can find Oracle apps Interview Questions,SQL queries,forums,interview questions,training institutes, jobs,oracle apps openings,sourcecode for interfaces,reports,forms. This also helps freshers, trainees to gain knowledge on Oracle applications (11i/apps).
Unable to see the concurrent program request
Details: A User has submitted a Concurrent program request from XXX responsibility later when other user wants to see the same concurrent program request submitted by the earlier user. But, he unable to see the request in the same responsibility (Querying with Request Id in SRS view request screen)
Reason: When User submits the concurrent program from "others-->request --> run” screen others cannot see the concurrent request when they are in the same responsibility with the same request id
If user submits the concurrent program from SRS (STATDARD REQUEST SUBMISSION) window then we can see the request with out any issues.
If user submits the concurrent program from Request --> Run in the Menu of responsibility then others cannot able to view the concurrent program request even though they are in the same responsibility.
Oracle Apps Very Important Technical Questions
http://easyapps.blogspot.com
OverLoading concept in Oracle PLSQL
Overloading concept in Oracle PL/SQL
Overloading concept means, it allows you to overload procedures or functions in package with same name but different in data type and order of the parameters. When you call an over load subprogram, compiler determines which subprogram to call based on the data type which used in subprograms.
Single sub programs cannot be overloaded.
Example:
create or replace package testpack
is
Procedure test1(p_num NUMBER, p_name VARCHAR2);
Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER);
end testpack;
/
show error
create or replace package body testpack
is
Procedure test1(p_num NUMBER, p_name VARCHAR2)
IS
BEGIN
DBMS_OUTPUT.put_line('Test1');
END;
Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER)
IS
BEGIN
DBMS_OUTPUT.put_line('Test2');
END;
end testpack;
/
show error