How to check concurrent list all in oracle EBS

select concurrent_program_id, program_application_id, printer,

        program_short_name, argument_text, print_style,

        user_print_style, save_output_flag, row_id,

        actual_completion_date, completion_text, parent_request_id,

        request_type, fcp_printer, fcp_print_style, fcp_required_style,

        last_update_date, last_updated_by, requested_by,

        has_sub_request, is_sub_request, update_protected,

        queue_method_code, responsibility_application_id, responsibility_id,

        controlling_manager, last_update_login, priority_request_id,

        enabled, requested_start_date, phase_code,

        hold_flag, status_code, request_id,

        program, requestor, priority

from fnd_conc_req_summary_v

where 1=1

    and phase_code = 'P' 

    and status_code in ('I', 'Q') 

    and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))

order by request_id desc-- check Concurrent All

select concurrent_program_id, program_application_id, printer,

        program_short_name, argument_text, print_style,

        user_print_style, save_output_flag, row_id,

        actual_completion_date, completion_text, parent_request_id,

        request_type, fcp_printer, fcp_print_style, fcp_required_style,

        last_update_date, last_updated_by, requested_by,

        has_sub_request, is_sub_request, update_protected,

        queue_method_code, responsibility_application_id, responsibility_id,

        controlling_manager, last_update_login, priority_request_id,

        enabled, requested_start_date, phase_code,

        hold_flag, status_code, request_id,

        program, requestor, priority

from fnd_conc_req_summary_v

where 1=1

    and phase_code = 'P' 

    and status_code in ('I', 'Q') 

    and ((decode(implicit_code, 'N', status_code,'E', 'E', 'W', 'G') = status_code or decode(implicit_code, 'W', 'E') = status_code))

order by request_id desc

How to set Default OU oracle EBS in tools Query data

Set Default OU

--after run alter seesion

alter session set nls_language = american

--and next run script

BEGIN

        mo_global.set_policy_context('S', 94); -- 94 is ID in Operation_unit 

END;

Select test data show by OU, Enjoy

How to enable Diagnostics in oracle EBS

 How to enable Oracle apps Diagnostics-> Examine

Steps 1

Navigate to System Administrator responsibility> Profile> System>

Steps 2

Enter profile name: Utilities:Diagnostics

Enter Application User for whom you want to enable Diagnostics-> Examine

Steps 3

Give Yes at User level and Save the Changes

Note –

You can set Yes at Site level also if you want to enable this option for all Oracle application users

How to Create Web Service in Oracle EBS (Integrated SOA Gateway)

Step I

create one process package to deploy to database server ex. to XXTEST_INTERFACE_PKG.pls

in package test 1 PROCEDURE INSERT_AP_INTERFACE and 2 parameter in 2 parameter out

in package to add script 

CREATE OR REPLACE PACKAGE XXTEST_INTERFACE_PKG AS

/*#

 * This is the public interface for the AP Physical Invoice. 

 * It is provided to insert interface data from external system.

 * @rep:scope public

 * @rep:product AP

 * @rep:lifecycle active

 * @rep:displayname XXAP Physical Invoice Interface

 * @rep:compatibility S

 * @rep:category BUSINESS_ENTITY XXAP_INTERFACE

 */

--

-- Insert AP_INTERFACE (PUBLIC)

--   Insert interface data.

-- IN:

--          P_ORG       - Location

--          P_NUMBER       - Invoice Number

--          P_RESULT    - out parameter

--          P_ERROR_MESSAGE    - out parameter

/*#

 * Insert interface data

 * @param P_ORG Location

 * @param P_NUMBER Invoice Number

 * @param P_RESULT Import Resurt

 * @param P_ERROR_MESSAGE Error Message (if result is not OK)

 * @rep:scope public

 * @rep:lifecycle active

 * @rep:displayname XX Insert interface data

 */

PROCEDURE INSERT_AP_INTERFACE (

          P_ORG                IN  Number,

          P_NUMBER            IN  VARCHAR2,

          P_RESULT          OUT VARCHAR2,

          P_ERROR_MESSAGE   OUT VARCHAR2

);

END XXTEST_INTERFACE_PKG;

/

Step II

save package space to XXTEST_INTERFACE_PKG.pls and copy file space to program path in Oracle EBS

Step III

Run command 

$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=asadmin SQLAP:patch/115/sql:XXTEST_INTERFACE_PKG.pls:12.0=XXTEST_INTERFACE_PKG.pls

check error and fix. this command to gennarate .ildt to completed

Step IV

run next script

$FND_TOP/bin/FNDLOAD apps/apps_cps 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct XXTEST_INTERFACE_PKG_pls.ildt

Step V

log in Oracle EBS by ASADMIN to check and deploy service

connect repose "Integrated SOA Gateway"

check service by search or check by a module in package script

to set Service name and deploy, check service to avaliable

FInish