pl sql - How to set Oracle Concurrent Request Status = Error

I registered a custom pl sql block as an Oracle Concurrent Request. I want to raise an EXCEPTION that will make the job end in an ERROR status if a condition is met. How can I do this? Here's an excerpt of the code I have:EXCEPTION WHEN v_nodata THEN <what command can I put here? I want the concu ...

Oracle Concurrent request starting lately

We have a concurrent program which will be started after 30 to 45 seconds after submission. But we have to run this program more than 1000 times a day, so we have a requirement to reduce this waiting time. Even though no concurrent request is running in parallel this program is taking this much time ...

Oracle Concurrent Request

Need help from you folks!I was asked to list out long running concurrent request and its program name in the specified time say like 4:00pm to 5:00 pm..How could i fetch the results??Can anyone give me that SQL query?The reason was for that hour submitted request count was high and consumed resource ...

Oracle Concurrent Request - Requester

Can we change the Requester name when we submit the Concurrent Request.Actually, the request runs automatically, So I need to run taht from the buyer's Name and not the requester...Plz advice ...

Oracle Concurrent request

When i fire a concurrent request its run, but when i try to schedule to run at time the time text not higlighted, whats the reason ? Thk. ...

how do I submit an Oracle concurrent request from inside a page within Apex

Have an app that basically loads an interface table.I want to call a concurrent job from the page within my apex app that will submit the concurrent job in Oracle when I press the submit button. The only parameter is group id and typically end user enters 101010.I am unsure of the syntax..... the db ...

Oracle concurrent request noprint with 1 copies

we had clonned from prod to testin test instance we are facing a problem when we submit a request by default its taking noprint with 1 copybut we need it to be noprint with 0 copyplz help me out in this issue ...

Oracle concurrent request issues

i want to know how to find out the concurrent requests which taking more than a hour to run. ...

Need to determine if request set running and parameters

I can query table FND_CONCURRENT_REQUESTS to determine if a certain request step is running.select description, status_code, number_of_arguments, argument1, argument2, argument3, argument4 from FND_CONCURRENT_REQUESTS where description = 'XYZ_YEAR_END_GL_VERIFY (30)' and status_code != 'C' but the c ...

Column Headings Missing when SQL report run through Oracle Conc Request

Why do the column headings for a sql report disappear when I try to run the job through Oracle Concurrent Request Manager? If I copy and paste the job in SQL*plus and run it, the headings show on the report. Is there a setting I can update to allow these column headings to show?Example of what I get ...

Oracle Purge Concurrent Request and/or Manager Data

I got an error when execute Purge Concurrent Request and/or Manager Data after upgrade the Application from R12.1.1 to R12.1.3The log file : ---------------------------------------------------------------------------Application Object Library: Version : 12.0.0Copyright (c) 1979, 1999, Oracle Corpora ...

Loading XML File in Oracle Tables through Concurrent Request

I am posting a working program which reads an XML File and loads in Oracle database table through Concurrent Request. Input parameter for this program is file name. I have added directory name ASPEN_DIR as /interface/inbound in ALL_DIRECTORIES table. /* This is a sample program reading an input xml ...

Oracle Execute Concurrent Request from workflow

I need to know how to execute a concurrent request from a workflow and make the workflow wait till the concurrent request is completed and continue further.There is a function called FND_WF_STANDARD.EXECUTECONCPROGRAM (This will wait until Program is complete before continuing.)However, I do not kno ...

Oracle View concurrent request output through WF?

In my custom wf process I am submitting a concurrent program. How can I design the custom wf process, so that when a user sees the custom wf process through status monitor, he would be able to also see the concurrent request file output?Is this possible? ...

Oracle Not able to cancel concurrent request

I am not able to cancel a concurrent request from front end and also from back end if i try to update fnd_concurrent_requests table it is hanging for a long time.How to cancel the requests. ...

Oracle Viewing/printing paperclip attachment in concurrent request output

We're developing a new process for producing and storing invoices. Currently a concurrent program is run with certain parameters which in turn submits an rdf which produces xml output for a single or range of invoices.We use Pasta to run jfmerge to ultimately produce a pdf output file which will hav ...

Oracle Finding a trace file using Concurrent request id

Is it possible to find a trace file using concurrent request id?If not possible how to find a trace file for a particular concurrent request? ...

Oracle in which table the concurrent request's output will be stored

Can u please tell me in which table the concurrent request's output will be stored(the path of UNIX)PLZ help me. ...

Oracle Cannot run a concurrent request.

I've been trying to execute a concurrent request, with no luck.It's a concurrent request that calls a procedure within a package and then that called procedure will execute itself two more concurrent request.First 'child' request runs well and ends as Completed Normal.and the second one is just not ...

Oracle R12 Payment submit concurrent request during process

We are currently upgrading from 11i to 12.1.3 and I am trying to work through setting up our payments so they are as effecient as they are in 11i. Currently we have to programs that when they format the file in 11i they kick off a concurrent program that uses custom code to create the payments the w ...

Oracle Submitting a concurrent request set through an API call

Gurus,I'm very familiar with utilizing APPS_INITIALIZE and FND_REQUEST.SUBMIT_REQUEST to submit jobs from the back end, however, I have a request set that I need to submit. Anyone familiar with the API used to submit concurrent request sets?I'm trying to avoid having to use FND_REQUEST.SUBMIT_REQUES ...

shell script called from .sql fie in oracle concurrent manager

HiI am running a request set through Oracle concurrent manager.The manager calls a .sql file. The sql file internally calls a unix shell script.v_body VARCHAR2(10000); v_body is set as followed in the sql program.v_body := 'ATTENTION :' || CHR(10) || CHR(10) ||'Your invoice number ' || r_error_rec.i ...

Oracle Application Request number information

Can you show me a pl/sql procedure to see all informations about a specified concurrent request, giving your request_id number ? @c:\show_request 31810589 I´d like see an Oracle Application Request number, in a line command. In Oracle Application forms I issue a "view details" in a specified job, b ...

Oracle Application Request number informations

Can you show me a pl/sql procedure to see all informations about a specified concurrent request, giving your request_id number ? @c:\show_request 31810589 I´d like see an Oracle Application Request number, in a line command. In Oracle Application forms I issue a "view details" in a specified job, b ...

Oracle https request problem

I am trying to get oracle to request https , but have had no luck. (I did the same test using https://www.paypal.com same results) These are my steps:I access Oracle Wallet Manager via Windows and I import the trust certificate I exported from IE to the Oracle Wallet Manager's trusted certificate. I ...

Oracle Concurrent Manager :Different in Tagret and actual column

Today We have submitted few concurrent request which usually runs in standard manager.Normally those requests will complete in 5 to 10 min.Today even after 30 miniutes,it shows phase pending status:normal. We checked the actual and target process for standard manager.Target process is 7 ,but actual ...

how does a service proxy handle concurrent request

how does a service proxy in DP (WS proxy, XML Firewall proxy or Multi-Protocol Gateway) handle concurrent request?1> does DP create multiple instance of the service proxy to handle concurrent request. if so is there a way to define min/max numbers of instance of the service proxy.2> does it bu ...

how to check that oracle application server is running?

i have installed oracle 10g r2? does that mean oracle application server is running? how can i check the status of the oracle appliaction server... whether it is running or not? ...

Oracle Concurrent program Do not Insert Data Into Interface Tables!

I am facing a problem with my concurrent program whenever I execute my stored procedure in SQL/PLUS it's work fine data load into the AP_INTERFACE/LINES.Whenever I try to load data through my concurrent programs it doesn't load into AP_INTERFACE/LINES and concurrent request successfully completed bu ...

Using parameter values in SQL Script for Oracle Concurrent Program

I wrote a very simple sql script and I want to register it as an Oracle Concurrent Program. I included a parameter field in the sql script to allow the entry of value to determine the number of days prior for the script. The script runs successfully in SQL*Plus, but when I try to register it as an O ...

Oracle concurrent programs

12.0.4 on Solaris 10Is it mandatory to schedule the below concurrent programs after live ?Workflow Background ProcessPurge Concurrent Request and/or Manager DataPurge Logs and Closed System AlertsPurge Concurrent Request and/or Manager DataSynchronize WF LOCAL tablesWorkflow Work Items Statistics Co ...

Oracle Concurrent Program - SQLPLUS - Request ID

I have registered a concurrent program calling SQLPLUS.My Program is process data and dump the data in custom table. Before starting data will be deleted from the custom table.The issues is as follows.At a time only one time this concurrent program should be submitted. If not the data will be delete ...

Oracle Concurrent running very slow in production cloned data base

There is one custom concurrent for creating employee and import resources and build hierarchy for Incentives and compensation.This concurrent running in almost 7 minutes in test instance for 1400 employees.Yesterday DBA has cloned the production instance to test instance. Now this concurrent created ...

Oracle Not able to view Concurrent Request Output and Logfile.

I have upgraded Oracle Applications from 12.0.6 to 12.1.1 on Microsoft Windows 2003. Apache and forms are working fine. But when I run any request and trying to view the logfile and output file I am getting the below error:============================================================================= ...

Oracle Sql Loader - Concurrent request id issue!

I want to load request id in my sql loader script please advice how can I do.Below is my scipt file.LOAD DATAINFILE '${CINT_TOP}/uploads/f_cost/inprocess.dat'BADFILE '/tmp/inprocess.CFL.bad'INTO TABLE cost_temp REPLACEFIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'"(ITEM_COST DECIMAL EXTERNAL,CUR ...

Oracle Using a SQL script to make the Status of a Concurrent Request 'WARNING'

We have a SQL script based Concurrent Program. How to show the STATUS as 'WARNING' in the SRS screen based on a user defined Flag.What we are trying is similar to RETCODE = 1 in any standard package OUT variable, but just by using SQL or PL/SQL.Please let me know if more details are needed to explai ...

Oracle passing parameters in pl/sql concurrent request

i want to add parameters in the code of concurrent programe that we are registering from the back end..IF p_status = 'CL' THEN*/v_id := FND_REQUEST.SUBMIT_REQUEST('AR','XRAXINV_SEL','',SYSDATE,FALSE,'TRX_NUMBER','Yes','' ,'' , p_trx_number, p_trx_number, p_cust_trx_id,'' ,'' ,'' ,'' ,'' , 'N', 'N', ...

Oracle Completed Request's Request_Id not viewable in Concurrent Manager Window

I created one procedure in which I have submitted one concurrent through FND_REQUEST.SUBMIT_REQUEST and completed normally.The user who has defined main concurrent programme and submain concurrent programme is able to view all the concurrent requestIDs relates to main and submain concurrent. But whe ...

Oracle Administrative request queue freezes forever

We are building a scenario for master / master replication with two servers and one instance each..The API is used to execute this operation. First time this was executed in LAN (2 M) and all the process has completed successful in 15 minutes. Same process needs to be done in WAN (64K), and now (in ...

Oracle Agent is not running

I installed Oracle Database 10.2.0.1.0 and I gave emctl start agent but said that the agent is not running.So when I attempt to access the EM and manage users I got java.lang.Exception: Exception in sending Request :: nullHelp me, please ...

Oracle Bad Request (On Report Creation)

HiI have coded up a SQL report and attempted to paste it into the report region and I get this error:Bad RequestThe HTTP client sent a request that this server could not understand.I get this error on Interactive reports and SQL reports.Running on:Oracle 11g StandardAPEX 3.1.2.00.02PL/SQL Gateway fo ...

Oracle concurrent manager status inactive every application services restart

ebs: 11.5.10.2os: AIX 5whenever im restarting application server i mean to take coldbackup or for any workaroundthe concurrent manager are down i checked with command ps -ef|grep fndlibr|grep APPLMGR|wc -l it shows only one concuurent manager is running so i have to go for a Conccurent manager recov ...

Oracle Concurrent program returned no reason for failure - Standard Concurrent Man

- We are getting the "Concurrent program returned no reason for failure" message for all schedule concurrent programs.The program thorowing following messages in Internal Concurrent manager log file Starting STANDARD Concurrent Manager : 16-JUL-2011 13:50:05Starting STANDARD Concurrent Manager : 16- ...

Oracle Concurrent program incompatibility setup

Environment: 11.5.10.2I have a custom concurrent program that has been setup to be incompatible with itself.Per my testing, 2 instances of the program still run concurrently.In this forum and in Metalink, I came across these 3 notes which state 3 different things for the same issue:ID 107224.1 - Set ...

Oracle Concurrent Manager Issue

Apps and database are on same node.i copied the appstier /appshome/PROD/* and dbtier /orahome/PROD/* cold backup fille from node A to B with the same location like in node A. i also created the same user at node B which are owner of /appshome and /orahome as well i put the same IP address at B which ...

Oracle Concurrent managers are not starting & Actual/Target count is not same

After Restarting the applications Concurrent managers are not Starting up and Actual &Target Count is not sameOur Environment is :R12:12.1.3 and DB is 10.2.0.5 OS is RHEL:5.5Error message in the manager log file: List of erros (1)Routine AFPCAL received an incorrect number of arguments you passe ...

Oracle Concurrent program with the output type as XML and has eText template fails

Concurrent program with the output type as XML and has eText template ends in warning. Ir is generating zero byte etext file.I see the following in log fileBeginning post-processing of request 12319438 on node FINAPPCODEV1 at 02-DEC-2011 12:12:12.Post-processing of request 12319438 failed at 02-DEC- ...

Oracle 'Bad request' message when attempting to download program

When navigating from:"http://otn.oracle.com/software/htdocs/devlic.html?/software/products/oracle9i/htdocs/linuxsoft.html" to the next page, after checking all the checkboxes and agreeing to the licensing agreement, I am directed to "http://otn.oracle.com/software/htdocs/devlic.html?bject HostObject ...

Oracle Concurrent connections

What is the maximum number of concurrent connections allowed in Oracle 8.x ? ...

Oracle 7.3.3 running on Win2000?

We have server running WinNT 4.0 Service Pack 6 and Oracle 7.3.3. We planning to upgrade this server to Win2000 (Service Pack 2). Could Oracle 7.3.3 continue to work after this upgrade?In general, could Oracle 7.3.3 be installed and work on Win2000 (Service Pack 2)? ...