Archive for the ‘Oracle’ Category

Failure of Web Server bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.

February 2nd, 2025, posted in Oracle EBS Application
Share
$ ps -ef | grep falcon-sensor
root 1081 1079 0 May13 ? 00:22:23 falcon-sensor
    $ cd $EBS_DOMAIN_HOME/servers/forms_server1/data/store/default
    $ ls -altr
    total 1028
    drwxr-xr-x 4 user group 40 Sep 13 2023 ..
    -rw-r--r-- 1 user group 1049088 May 13 20:51 _WLS_FORMS_SERVER1000000.DAT
    drwxr-xr-x 2 user group 42 May 13 20:56 .
    $ rm _WLS_FORMS_SERVER1000000.DAT
    $ADMIN_SCRIPTS_HOME/adstrtal.sh
    Or
    $ADMIN_SCRIPTS_HOME/admanagedsrvctl.sh start forms_server1
    Share

    Steps To Run Gather Statistics For A Schema In R12.1.3

    January 15th, 2025, posted in Oracle EBS Application
    Share
    1. Log on to Oracle Applications with
        Responsibility = System Administrator
    2. Submit Request Window
        Navigate to: Concurrent > Requests
    3. Query for the Gather Schema Statistics
    4. Enter the appropriate parameters. This can be run for specific schemas by specifying the schema name or entering  ‘ALL’  to gather statistics for every schema in the database
    5. Submit the Gather Schema Statistics program
    Share

    Oracle R12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request ’

    November 17th, 2024, posted in Oracle EBS Application, Oracle Queries
    Share
    SELECT fcp.concurrent_process_id
    FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp
    WHERE concurrent_queue_name = ‘FNDCPOPP’
    AND fcq.concurrent_queue_id = fcp.concurrent_queue_id
    AND fcq.application_id = fcp.queue_application_id
    AND fcp.process_status_code = ‘A’;

    Output example:

    CONCURRENT_PROCESS_ID
    ———————
    93557
    93558
    select name from APPLSYS.AQ$FND_CP_GSM_OPP_AQTBL_S ;

    Output example:
    NAME
    ——————————
    OPP35562
    OPP35563
    OPP35564
    OPP35565
    exec fnd_cp_opp_ipc.unsubscribe(”);
    Example:
    exec fnd_cp_opp_ipc.unsubscribe(‘88933’);
    exec fnd_cp_opp_ipc.unsubscribe(‘92625’);
    Share

    Output Post Processor (OPP) – An Overview By Author – A.Kishore/Sach

    October 12th, 2024, posted in Oracle EBS Application, Oracle Queries
    Share
    SELECT service_id, service_handle, developer_parameters
    FROM fnd_cp_services
    WHERE service_id = (SELECT manager_type
    FROM fnd_concurrent_queues
    WHERE concurrent_queue_name = 'FNDCPOPP');
    SERVICE_ID SERVICE_HANDLE DEVELOPER_PARAMETERS

    Profile Option : Concurrent:OPP Process Timeout
    Internal Name : CONC_PP_PROCESS_TIMEOUT
    Description : Specifies the amount of time the manager waits for the OPP to actually
    process the request.
    Share