Unable to see the concurrent program request

Issue: 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

The below link has Oracle Apps Technical Interview Questions in purchasing, HRMS etc which are very rare.

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

Find the link for oracle apps interview questions.

http://easyapps.blogspot.com

Customizing Report: Standards for Oracle apps


http://oraclehere.googlepages.com/ReportsTechnicalStandards.pdf

An Oracle Apps Forum for all Queries

Hi,

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

Oracle Applications 11i (Technical)
 
ERP INTRODUCTION
ORACLE APPLICATIONS ARCHITECTURE
APPS FILE SYSTEM
DESIGNING CUSTOM APPLICATION
* Create & Register DB User
*Create Base Path
 
TABLE CREATION & REGISTRATION
*WHO Columns
 
APPLICATION DEVELOPER
* Form Design & Registration
* Define Functions
* Create Menus
 
SYSTEM ADMINISTRATOR
* Create Application Users
* Create Responsibilities
* Create Data Groups
 
MAINTAIN APPLICATION SECURITY
* Non Form Function
* Menu Exclusions
 
IMPLEMENTING LOV
IMPLEMENTING ROW LOV
IMPLEMENTING QUERY FIND WINDOW
IMPLEMENTING MASTER DETAIL
 
CONCURRENT PROGRAMS
* Requests
* Define Request Groups
* Request Sets
* Value Set
* Reports
 
CONCURRENT PROCESSING
* Overview of Concurrent Processing
* Life Cycle of a Concurrent Request
* Concurrent Managers
* Parallel Concurrent Processing
 
CUSTOMIZE SUBMIT REQUEST WINDOW FLEXFIELDS
* Descriptive Flexfields (Enable Existing DFF)
* Descriptive Flexfields (Creation)
* Key Flexfields Concepts
 
INTERFACES
* Inbound Interface
* Outbound Interface

ORACLE 11i ALERTS

PROFILE OPTIONS
MESSAGE DICTIONARY
DOCUMENT SEQUENCES
MULTI ORG CONCEPTS
WORK FLOW CONCEPTS