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
Oracle apps Interview Questions and Report Standards
http://easyapps.blogspot.com
Customizing Report: Standards for Oracle apps
http://oraclehere.googlepages.com/ReportsTechnicalStandards.pdf
An Oracle Apps Forum for all Queries
There is a web site called http://www.orafaq.com this helps in finding almost every oracle related query.
Try it
Thanks
Rao
Oracle Apps Technical Curriculum
*Create Base Path
*WHO Columns
* Form Design & Registration
* Define Functions
* Create Menus
* Create Application Users
* Create Responsibilities
* Create Data Groups
* Non Form Function
* Menu Exclusions
* Requests
* Define Request Groups
* Request Sets
* Value Set
* Reports
* Overview of Concurrent Processing
* Life Cycle of a Concurrent Request
* Concurrent Managers
* Parallel Concurrent Processing
* Descriptive Flexfields (Enable Existing DFF)
* Descriptive Flexfields (Creation)
* Key Flexfields Concepts
* Inbound Interface
* Outbound Interface
ORACLE 11i ALERTS
PROFILE OPTIONS
MESSAGE DICTIONARY
DOCUMENT SEQUENCES
MULTI ORG CONCEPTS
WORK FLOW CONCEPTS