Download Spawned Concurrent Program
Concurrent Program Executable Window. We recommend that you use spawned concurrent programs instead. Concurrent Program Executable Block.
Hi all, I hope this post finds you all well img class='emoticon' src='images/emoticons/grin.gif' border='0' alt=' width='16' height='16' / I have been asked to modify a standard Oracle EBS Financials report (Cross-Validation Rule Violation Report). On viewing the Concurrent Program Executable I was surprised to find it had an Execution Method of Spawned. Now I'm aware that a Spawned program is typically a C or Pro.C program.
I've located the executable I'm interested in ($FNDTOP/bin/FNDFFRXR) but is there any way I can view the source code of the compiled C code? I'm interested to know if the process is doing any configuration set up and if it then calls a.rdf file. Any help or advise greatly appreciated. Kind Regards, Gary. Hi Pedro, Unfortunately, to the best of my knowledge, you can't add fields to the available field list in RX reports without trying to meddle with the supplied packages. Believe me when I say that I wish you could!
If the field you want is not available, a custom report is your best option. I've done that with the Receipt register and one of the aging reports. Are you using Oracle Sales? There might be a compatible report available there that you could look. I don't know anything about Sales so can't help there. Good luck, - James.
Hello Friends,Currently, I am automating the AP-GL Flow and once the AP Invoice is created and validated, we are running Payables Accounting Process to transfer the entries to AP to GL. Now, the problem is that Automation tool is not able to read the Batch name from Journal Import program output. So, the question is: Is there a way to find out the batch AP has created in GL which I can search for and post it to GL?
One option is there to use Concurrent program id but Journal Import program is spawned process and it's not possible to get the program's Concurrent ID. Apart from this, is there any other way to find out the Batch in GL?
Hi, We have a custom interface which was designed to retrieve data from a linked database. At design time, all the data in this database was input by series of online forms (Oracle Forms or Java forms). Recently, we are also accepting data into the same database from an OCR source - this was sensible as the data is for the type of transaction and meant not re-engineering/duplicating anything.
The custom PL/SQL interface to download all this data from the database is run from a concurrent program in EBS, associated to a specific 'user' for that process e.g. Everything works fine but the end-user would like to see whether the data was souced from an online form or an OCR scan.
We already hold this distinction on the linked database. I suspect theoretically I should be splitting the concurrent program into 2 programs; one for the online input and one from the OCR input and tweak each to retrieve the pertinent input types. However, this seems like unnecessary replication. My question is therefore can I toggle the current user context from within my PL/SQL process between the user associated with the concurrent program and a new user I will create for OCR sourced data? If so, how would I do this? This would enable the end-user to see either EFORM or OCR when viewing 'Created By' in the EBS application.
Hi friends, I have one doubt. So many concurrent requests are taking long time.at last the result is Completed with error. I checked log file and i saw that error.
But i did not understand.please help me. This is urgent. Log file: - Purchasing: Version: 11.5.0 - Development Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
XXPOPRNT module: IPL Purchase Order - Current system time is 15-FEB-2010 14:18:59 - +- Starting concurrent program execution. +- Arguments - PORGID='103' PITEMVALIDATIONORGID='104' pstructnum='50269' PFromPoNo='70859866' PToPoNo='70859866' - Current NLSLANG and NLSNUMERICCHARACTERS Environment Variables are: AmericanAmerica.US7ASCII '.,' Spawned Process 29972 XIO: fatal IO error 232 (Connection reset by peer) on X server '128.212.3.45:0.0' after 24 requests (23 known processed) with 0 events remaining.
Report Builder: Release 6.0.8.24.0 - Production on Mon Feb 15 14: (c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter Username: - Start of log messages from FNDFILE - - End of log messages from FNDFILE - Program exited with status 1 Concurrent Manager encountered an error while running Oracle.Report for your concurrent request 7193200. Review your concurrent request log and/or report output file for more detailed information. Executing request completion options. Finished executing request completion options. Concurrent request completed Current system time is 15-FEB-2010 16:20:52 - regards, chadnu. Why would you ever want to deploy a web application with an HTA. It cannot be run as an HTA from teh web.
Using aspx or HTML will ger you just as far. You cannot interact with an HTA using Ajax. I see absolutely no advantage in using an HTA.
If a user downloads an HTA it will likely not run correctly until the blocking bit is cleared. It must be run from the local computer to be able to access files on the local computer. Ro do this any other way would require installing modules on the users computer. Look into XAML applications as they may be able to give you what you want without resorting to an old and obsolete technology (HTA) compared to PowerShell (Forms). I want to be able to run the concurrent program 'Catalog Bulk Load - Items Price Lists' for iProcurement.
I have been able to run concurrent programs in the past using the fndrequest.submitrequest API. But I seem to be having problems with the item loading concurrent program. For one thing, the program is stuck on phase code P (pending) status. When I run the same concurrent program using the iProcurement Administration page it runs ok. Has anyone been able to run this program through the backend?
If so, any help is appreciated. Hi, I am using the following code to call the above concurrent request to transfer the data from AR interface table to the base table. Reqid:= FNDREQUEST.SUBMITREQUEST('AR','RAXMTR',',',FALSE, '1', '1023', 'CONTRA', '2009/10/30 00:00:00',',',',',',',',',',',',',',',',',',',',','Y',','103',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',','); if appform.quietcommit then MESSAGE(reqid); MESSAGE(reqid); end if; The request gets completed with error.
The diagnostic shows the following error 'This request finished with an error and produced the following completion message: Usage: program oracleid requestid Y The processing began on 30-OCT-2009 17:53:13 and ended on 30-OCT-2009 17:53:14. You may find more information on the cause of the error in the request log or the concurrent manager log.'
I have used similar method to execute AP interface import program and it worked. The above request is a spawned request. Any help would be appreciated. Regards Deepak. Reddy, You can use below script.pass the request id to it.
Asu Concurrent Program
November 11, 2009 9:37:53 AM GMT-06:00 Problem Description: Program: Update Posting Control Short Name: ARGUPC Application: Receivables Description: Update ARPOSTINGCONTROL.status to DONE Executable Name: ARGUPC Method: Spawned The 'Update Posting Control' job is stuck in Phase: Pending and Status: Scheduled Diagnostics: This request will begin processing on 09-NOV-2019 16:27:41, as requested by user. No action required. However, you may modify the start date and time of this request. Navigate to the View Requests form, Concurrent Request Details zone, and update the Requested Start field of this request record. When I modify the start date and time of the request to 'As Soon As Possible', then click OK, the date and time goes back to the original date and time. This is a spawned job and I need to know how to change the request date/time to as soon as possible.
Hi Hussein, I am running a Concurrent Oracle Report Program but I got Error: Spawned Process 2527344 REP-0788: Warning: The value of restricted LOV parameter PSCHED is not among the selectable values. Report Builder: Release 6.0.8.25.0 - Production on Tue Oct 27 17: (c) Copyright 1999 Oracle Corporation.
All rights reserved. Enter Username: +-+ Start of log messages from FNDFILE +-+ +-+ End of log messages from FNDFILE +-+ Program exited with status 1 Concurrent Manager encountered an error while running Oracle.Report for your concurrent request 310075. Review your concurrent request log and/or report output file for more detailed information.I can see that the error is just a warning, so it should have still produce and output, but it did not, its just conpleted ERROR. Where can I see the real error log that cause the problem?
Thanks a lot. Hi, I am using the following code to call the above concurrent request to transfer the data from AR interface table to the base table. Reqid:= FNDREQUEST.SUBMITREQUEST('AR','RAXMTR',',',FALSE, '1', '1023', 'CONTRA', '2009/10/30 00:00:00',',',',',',',',',',',',',',',',',',',',','Y',','103',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',',','); if appform.quietcommit then MESSAGE(reqid); MESSAGE(reqid); end if; The request gets completed with error. The diagnostic shows the following error '.This request finished with an error and produced the following completion message: Usage: program oracleid requestid Y.The processing began on 30-OCT-2009 17:53:13 and ended on 30-OCT-2009 17:53:14.
You may find more information on the cause of the error in the request log or the concurrent manager log.' I have used similar method to execute AP interface import program and it worked. The above request is a spawned request.
Any help would be appreciated. Regards Deepak. Dear All, We are having problem to run concurrent process for all module at PROD. The processes always shows Pending Standby status. Refer to Note:150519.1 - We had kill all pending process using kill -9 command restart the concurrent manager.
However, the problem still nor resolved but the status now shows Inactive No Manager. Using System administrator Responsibility: System Administrator Responsibility Concurrent Manager Administer There are some new 'Name' appeared at PROD which is not appear at TEST. I finded Concurrent Program Executable of 'Actual Cost Worker' - Concurrent Program Executable Information - Executable:CMCTCM Sort Name: CMCTCM Apllication: Oracle Bills of Mateial Description Unified: Cost Manager Execution Method: Spawned Excution File Name CMCTCM Subroutine Name:cmltcm - I want to view script source for CMCTCM. Before I have not view 'Spawned' script source. I only have tech PL/SQL, Form, Report source.
How to confirm script source of Spawned type? Message was edited by: roseok77 Message was edited by: roseok77.
Hi, I have a OAF page using which I am submitting a concurrent program (an XML publisher report). After the program is submitted the system navigates to 'View Requests' page. Now if on the request page, if I click on the browser refresh button, the concurrent program is submitted again. The concurrent program is submitted as many times the refrsh button is clicked. How do I handle the browser back button functionality in my code so that when the user clicks on that the concurrent program is not submitted again. Thanks in advance for your help. Thanks, Saikat.
Hi, We are loading Customers through 'Customer Interface' with the requirement that for each customer a seperate Customer Interface program will be run. Now when we are uploading a bulk of data e.g. 10000+ records similar number of concurrent requests spawned and remains in the state of Pending Normal/Standby even after the successful loading of all records in the base tables. Now the status is as follows: 'Conflict Resolution Manager'= Actual Process 1 Target Process 1 Running requests 0/1 Pending 9991 'Standard Manager'= Actual Process 6 Target Process 6 Running requests 0/1 Pending 9991 however when after few minutes I will see in the customers form for the records being inserting, it will be there. Can I change anything in concurrent manager setting such that it can be refreshed at certain time and show us the right status of Concurrent Requests? Regards, Umair.
Hi all, I had written the interface for povendorsitesall.The data is loaded perfectly into interface table APSUPPLIERSITESINT. Now while running standard interface program on SRS(Supplier Sites Open Interface Import).it is giving following error. Spawned Process 24209 REP-1419: 'beforereport': PL/SQL program aborted. And it is not showing any reject code or status on back end on table APSUPPLIERSITESINT. And it is printing IMPORTREQUESTID as request code in the table.now how many times i will run the SRS it is showing in the table APSUPPLIERSITESINT the MPORTREQUESTID is not changing. And Can any body suggest good document for writing interface program Thanks in advance Goutham Message was edited by: goutham konduru. The same situation i am also facing everything almost same.
Hi, We have a AR form(ARXSUBAA.fmb) called CREATE AUTOADJUSTMENTS through which we can paas the parameters and submit the concurrent program called ARXAAP.This concurrent program is using the executable ARXAAP whose execution method is SPAWNED.I need to craete a customized concurrent program with additional parameters from the existing seeded AR concurrent program (ARXAAP).As it is very first time for me working on SPAWNED executable i do not know from where to get the source code and how to make the changes in the ProC code so that i can meet the requirement. Thanks for the reply. Hi, I have a strange problem. As part of Standard Collections, we are launching custom concurrent requests on the Source side (via dblinks) using FNDREQUEST.SUBMITREQUEST. Then the FNDREQUEST.WAITFORREQUEST is called, to check for the completion of these requests.
The requests are spawned successfully and they complete successfully on Source Side, but the FNDREQUEST.WAITFORREQUEST on the Planning Side, waits forever over dblink, for the program on the Source side to complete. I am not sure why it is not able to see that the program has completed.
The same program is working fine in another instance, whereas it is not working in one instance. I am at my wits end. Any pointers will be realllyyyyyy helpful please. Cilkscreen reported a data race in our code. The data race was between the dereference of a struct pointer so that we could pass a struct to a spawned cilk strand, and a modificaton to the struct through the pointer after the spawn. We thought that the arguments to a spawned cilk strand would be evaluation before the strand is created.
We found that cilkscreen reports the data race in the deref.cilk program but not the derefworks.cilk program. The difference is that we force the struct pointer dereference before the cilkspawn rather than in the cilkspawn function call. When are the arguments to a spawned cilk strand bound? If the arguments are bound before spawning the cilk strand, then the deref.cilk program is correct. However, cilkscreen says that we have a data race between the creation of the arguments to the spawned function f and the zero of the element on the subsequent line. This indicates a bug in either the cilk compiler or in cilkscreen. If the arguments are bound after spawning the cilk strand, the the deref.cilk program is not correct.
However, the cilk programmer's guide is not specific about when pass by value arguments are evaluated. If one changes the argument type from a 'struct p' to an int, then cilkscreen does not find any issues. This indicates that the cilk compiler does not handle struct arguments correctly. This is captured in the derefint.cilk program. Cilk evaluates all function arguments before the spawn. I've looked into your example briefly and I believe you have found a bug in the compiler.
Internally, gcc on x8664 passes all structs by reference, but should make necessary copies in pass-by-value examples. My guess about what is happening here is that the compiler discovers that f does not modify its argument and that, therefore, it can avoid an extra copy of the struct. This would be a valid optimization for a serial call, but is incorrect for the cilkspawn case. I don't have time to test it right now, but I suspect that if you were to modify the argument to f within if, that the compiler would turn off the optimization and cilkscreen would stop complaining.
If you have a moment to test this, we'd be interested in the results. Thanks, - Pablo. Hi, There are reports in Oracle Applications Manager:Concurrent Request Statistics by ProgramConcurrent Request Statistics by UsernamePrograms Usage Statistics To have this data available CM 'OAM CP Charts and Reports Collection' must be run.This program is Java concurrent - oracle.apps.fnd.oam.concprogs.cpchartDoes anyone know what is data source of this program and where collected data is stored?Does above OAM statistics programs include information about concurrent programs purged by 'Purge Concurrent Request and/or Manager Data' program?Kind regards,Marcin.
Hi, There are reports in Oracle Applications Manager:Concurrent Request Statistics by ProgramConcurrent Request Statistics by UsernamePrograms Usage Statistics To have this data available CM 'OAM CP Charts and Reports Collection' must be run.This program is Java concurrent - oracle.apps.fnd.oam.concprogs.cpchartDoes anyone know what is data source of this program and where collected data is stored?Does above OAM statistics programs include information about concurrent programs purged by 'Purge Concurrent Request and/or Manager Data' program?Kind regards,Marcin. Purchasing: Version: 11.5.0 - Development Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. ADPOREPORT module: ADPOReport - Current system time is 18-JAN-2011 14:14:11 - +- Starting concurrent program execution. +- Arguments - PPONUMBER='32456' - APPLLCSP Environment Variable set to: XMLREPORTSXENVIRONMENT is: /u03/applvis1/vis11iora/8.0.6/guicommon6/tk60/admin/Tk2MotifUTF8.rgb XENVIRONMENT is set to /u03/applvis1/vis11iora/8.0.6/guicommon6/tk60/admin/Tk2MotifUTF8.rgb Current NLSLANG and NLSNUMERICCHARACTERS Environment Variables are: AmericanAmerica.UTF8 '.,' Spawned Process 27177 X connection to db01:0.0 broken (explicit kill or server shutdown).
Report Builder: Release 6.0.8.25.0 - Production on Tue Jan 18 14: (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter Username: - Start of log messages from FNDFILE - - End of log messages from FNDFILE - Program exited with status 1 Concurrent Manager encountered an error while running Oracle.Report for your concurrent request 2739184.
Review your concurrent request log and/or report output file for more detailed information. Executing request completion options. 1) PUBLISH - Beginning post-processing of request 2739184 on node DB01 at 18-JAN-2011 14:57:53. Post-processing of request 2739184 failed at 18-JAN-2011 14:57:54 with the error message: One or more post-processing actions failed. Consult the OPP service log for details. Finished executing request completion options.
Concurrent request completed Current system time is 18-JAN-2011 14:57:54. Hello, Concurrent program GLCCON - Consolidation is spawned from Run Consolidation form as a concurrent process when you select to consolidate all unconsolidated batches. This process works fine when run from the form. However, we don't want to run the process from the form, but from a standalone concurrent request which runs automatically every day. I have defined a new concurrent program to run this: PL/SQL script runs with all the necessary details and passes into GLCCON the same parameters that were being passed in when it was being called from the Run Consolidation form. When I submit a concurrent request my concurrent program runs fine and it calls the GLCCON concurrent program. But the GLCCON concurrent process fails with the following: CCON0081: glcut1.getglobal - Could not find run currency code Cannot get global data.
Hello, Concurrent program GLCCON - Consolidation is spawned from Run Consolidation form as a concurrent process when you select to consolidate all unconsolidated batches. This process works fine when run from the form. However, we don't want to run the process from the form, but from a standalone concurrent request which runs automatically every day.
I have defined a new concurrent program to run this: PL/SQL script runs with all the necessary details and passes into GLCCON the same parameters that were being passed in when it was being called from the Run Consolidation form. When I submit a concurrent request my concurrent program runs fine and it calls the GLCCON concurrent program. But the GLCCON concurrent process fails with the following: CCON0081: glcut1.getglobal - Could not find run currency code Cannot get global data.
Hi Hussein: We schedule a concurrent program to process PO as early as 2.00 AM. Every day it process about 6000 PO's. Every time a PO is processed, it spawns another PO Output for Communication Program.
So in total roughly about 12000 jobs at 9.30 AM. This puts an extensive load on the system.
What I wanted to do is to change the status of the PO Output for communication Program as soon as it is spawned. I want to create a new program which will run the following script to change the status. Update fndconcurrentrequests set phasecode='C',statuscode='C' where requestid IN (select requestid from fndconcurrentrequests where phasecode='P' and statuscode='I' and requestedby=2137 and concurrentprogramid=45109); commit; What is the best way of creating this program and add that as a child of PO Output for communication. Regards, Bala.
Hi joseph, Welcome to SDN. SEUED001 We can make use of this enhancement, and the FM EXITSAPLS38E001 (inside this enhancement) 2. Inside this u can give error message so that se38 does not proceed further to even display the source code! One can use like this: eg.- Data DATA: terminal LIKE usr41-terminal. DATA: BEGIN OF itab OCCURS 0, myprog LIKE sy-repid, END OF itab.- My prog itab-myprog = 'ZAMTEMP174'.
Itab-myprog = 'ZAMTEMP173'.- Check CALL FUNCTION 'TERMINALIDGET' EXPORTING USERNAME = SY-UNAME IMPORTING terminal = terminal EXCEPTIONS MULTIPLETERMINALID = 1 NOTERMINALFOUND = 2 OTHERS = 3.- Detect LOOP AT itab. IF program = itab-myprog. IF terminal CS '10.101.8.101' AND operation = 'EDIT'. MESSAGE e999(yhr) WITH 'Not Allowed'.
Regards, amit m. There is one requirement in which we have to add some condition in the Concurrent Program.But the Type of that concurrent Program is,'Spawned '. Please suggest me, how can i check the Source code for this type of Concurrent Program and how can i make the changes to satisfy the requirement.Please see old threads, it should answer your question - Thanks, Hussein. You're better off posting issues of concurrent programs on the EBS forums; Also, every concurrent program is associated with an executable, which can be a pl/sql procedure, ProC or unix shell script, so after logging on to the Java console you can view the concurrent program and the executable.
If it is a procedure or package.procedure, then you can view the source code in SQL Plus using the following query; set pagesize 5000 select text from usersource where name = 'PROCEDURE NAME LISTED IN JAVA CONSOLE ASSOCIATED WITH CONCURRENT PROGRAM'. I'm working on R12 and I'm trying to create and test eText template. My problem is that I don't know how to get XML data that will be used as data source for this template. When I was working with tipical RTF templates I would first define concurrent program that I will use as data source (output type would be xml).
And I would ran this report once to get the XML file out. But here I don't know how to get this XMLdata. I tried to read documentation and search this forum and metalink but was unable to find. Also I noticed that it's not the same deal with eText templates as it is with RTF templates regarding Data Source definitions.
With Data Source definitions in CODE I would write short name of concurrent that would give me xml data. But I looked in one example (Belgian EFT that came with instalation) and code that was written in there wasn't defined in EBS as concurrent. Thanks, Tomislav. I'm working on R12 and I'm trying to create and test eText template. My problem is that I don't know how to get XML data that will be used as data source for this template. When I was working with tipical RTF templates I would first define concurrent program that I will use as data source (output type would be xml). And I would ran this report once to get the XML file out.
But here I don't know how to get this XMLdata. I tried to read documentation and search this forum and metalink but was unable to find. Also I noticed that it's not the same deal with eText templates as it is with RTF templates regarding Data Source definitions. With Data Source definitions in CODE I would write short name of concurrent that would give me xml data. But I looked in one example (Belgian EFT that came with instalation) and code that was written in there wasn't defined in EBS as concurrent.
Thanks, Tomislav. Hi, I created a concurrent request with a package.procedure1 as the executable.
This calls another concurrent program which has the executable as package.procedure2. This calls by passing one argument, the 2nd program was called but inside the procedure2, the arugument value is null. Before passing the arugument value is 1 and also in the 2nd program concurrent request parameters also its showing the value as 1. But inside the 2nd program procedure, tha value is becoming null. Can you please help me in this. Hi, I created a concurrent request with a package.procedure1 as the executable.
This calls another concurrent program which has the executable as package.procedure2. This calls by passing one argument, the 2nd program was called but inside the procedure2, the arugument value is null. Before passing the arugument value is 1 and also in the 2nd program concurrent request parameters also its showing the value as 1. But inside the 2nd program procedure, tha value is becoming null. Can you please help me in this. Depends on the VI.
All the shipping examples (HelpFind Examples) have a block diagram (the code part) that can be viewed. Some of the functions on the functions palette are VIs with block diagrams and some a basic functions that you cannot view the code. Programs written by someone else may have the block diagram password protected or removed. Your question is a little like 'how high is up?'
Based on your question, you may not know what a block diagram or function palette is. You really should start at at the very least, take the 3 hour introductory class so you can ask the correct question and understand the answer. Hi Harish, Doesn't matter what you need to do all you need is the hook! Force the request to print and use print driver to call CONCSUB to submit your new 'child' request - Since the Consolidation Trasnfer concurrent request could only be submitted through Consolidation Trasnfer Form only, I am not sure how we can do Force Print for this request. GR: Set printer and style on concurrent program definition.
Set profile option 'Concurrent:Report Copies' to 1 (even by Forms Personalization if you want to). Still think this is the best option. C) Abstraction. Replace the C executable with a shell script that takes arguments and calls the C program and then submits new 'child' request via CONCSUB - Appreciate, if you can elaborate this option. I think we can try this, with the help of your detailed input.
GR: Change the executable on the concurrent program to a host shell script under your mods application. Initially just get the shell script to capture program call and arguments. Run the program to get arguments. Next iteration, change shell script to call the C program from your shell script with correct arguments. Next iteration do the same plus call CONCSUB to submit request / set.
Trigger on fndconcurrentrequests to call new 'child' request via fndrequest.submitrequest - NB: very unsupported! Make sure trigger doesn't raise an exception. On completion of the Consolidation Transfer concurrent request, we tried to submit the request set using the Trigger on Consolidation History table and/or fndconcurrentrequests table.
But it is entering into infinite loop. GR: Need to use trigger condition to capture update of statuscode to C (Completed) and other codes e.g.
Personally I'd avoid this option because you have others! Although once I did use this method when I wanted absolute transparency:-) Update: Changed 'Print: Copies' to 'Concurrent:Report Copies' Regards, Gareth Edited by: gareth.roberts on Dec 8, 2008 4:55 PM. Dear all: after cloning the database, the concurrent manager cannot startup. I have been followed the note to do,but no effect: After Doing a Clone All the Concurrent Managers Do Not Start ID 555081.1 my environment is: oracle ebs 11.5.10.2 HP-UNIX oracle 9.2.0.6 I check the CM log, the log file show the error: Found dead process: spid=(28621), cpid=(6881), ORA pid=(10), manager=(0/1) +-+ Application Object Library: Concurrent Processing version 11.5 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. Internal Concurrent Manager started: 11-OCT-2010 17:20:46 +-+ Spawned Process 23787 Process monitor session started: 11-OCT-2010 17:20:59 Spawned Process 23788 Spawned Process 23789 Spawned Process 23790 Spawned Process 23791 Process monitor session ended: 11-OCT-2010 17:20:59 Process monitor session started: 11-OCT-2010 17:22:59 Spawned Process 23811 Spawned Process 23812 Spawned Process 23813 Spawned Process 23814How can I fix the problem? Regards Terry.
HiWe have a big problem, We can't create internal orders, when I run the CREATE INTERNAL ORDER, it finish with ERROR:Concurrent Manager encountered an error while running SQL.Plus for your concurrent request 134980682.Review your concurrent request log and/or report output file for more detailed information.this is the log:+-+Purchasing: Version: 12.0.0Copyright (c) 1979, 1999, Oracle Corporation. HiWe have a big problem, We can't create internal orders, when I run the CREATE INTERNAL ORDER, it finish with ERROR:Concurrent Manager encountered an error while running SQL.Plus for your concurrent request 134980682.Review your concurrent request log and/or report output file for more detailed information.this is the log:+-+Purchasing: Version: 12.0.0Copyright (c) 1979, 1999, Oracle Corporation. Hi, We have a requirement to customize the seeded concurrent program 'Receiving Transaction Processor'.
This is spawned type executable so I'm assuming it was written in Pro.C. Unfortunately we have no way to decompile it. We've tried but unsuccessful. I'd like to know if anyone had a similar requirement. Our requirement really is to prevent the program from spawning the concurrent program 'Payables Open Interface Import'. This happens when ASBN (Advanced Shipment Billing Notice) information are provided in the interface tables. Any help will be appreciated.
Thanks, Allen. Hi, We have a requirement to customize the seeded concurrent program 'Receiving Transaction Processor'. This is spawned type executable so I'm assuming it was written in Pro.C. Unfortunately we have no way to decompile it. We've tried but unsuccessful. I'd like to know if anyone had a similar requirement. Our requirement really is to prevent the program from spawning the concurrent program 'Payables Open Interface Import'.
This happens when ASBN (Advanced Shipment Billing Notice) information are provided in the interface tables. Any help will be appreciated. Thanks, Allen. Hello All, I have to import Journals using Journal Import Program, but when I am trying to submit this program manually from the general ledger responsibility, I am not getting the program.
I checked in the system administrator responsibility - Concurrent Program Window. I am getting the program name but there are no parameters for this program Program Name: Journal Import Short Name: GLLEZL Executable Method: Spawned no parameters are available.
Oracle Apps Version:12.1.1 11.5.10 (Checked in both the instance) Thanks Regards Aboothahir. Hi I need Some help here. User DO NOT have any issues running the concurrent Programs (11.5.10.2) with 10.2.0.4 database on HPUNIX. But have issue only with validating invoice batch.
I followed metalink ID's 605542.1, 167990.1,261693.1,1088553.1,749491.1, 461271.1 and few more. Not sure what's going on here.
Below is the error message. Spawned Process 24395 MSG-00001: After SRWINIT MSG-00002: After Get Company Name MSG-00003: After Get NLS Strings MSG-00101: Error occured in BATCHAPPROVAL MSG-00102: Error Code: -20100 MSG-00103: Error Message: ORA-20100: File o0298639.tmp creation for FNDFILE failed. You will find more information on the cause of the error in request log.
ORA-06512: at 'APPS.FNDFILE', line 396 ORA-06512: at 'APPS.FNDFILE', line 499 ORA-06512: at 'APPS.APAPPROVALPKG', line 7268 MSG-00001: EXCEPTION: INITFAILURE: User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. Report Builder: Release 6.0.8.28.0 - Production on Tue Feb 15 15: (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter Username: Program exited with status 1 Thank You. Hi all, I hope this post finds you all well.
I have been asked to modify a standard Oracle EBS Financials report (Cross-Validation Rule Violation Report). On viewing the Concurrent Program Executable I was surprised to find it had an Execution Method of Spawned. Now I'm aware that a Spawned program is typically a C or Pro.C program. I've located the executable I'm interested in ($FNDTOP/bin/FNDFFRXR) but is there any way I can view the source code of the compiled C code? I'm interested to know if the process is doing any configuration set up and if it then calls a.rdf file. Any help or advise greatly appreciated. Kind Regards, Gary.
HI EXPERTS os-hpunix Db-10g(2node rac) APPS-11.5.10.2 Im getting below error on conncurrent manager logfile.please suggest. Hi, can someone help me with the following problem?: When I run the concurrent program JTYSTAR (Synchronize Territory Assignement rules) obtain the next error message: This request finished with an error and produced the following completion message: Concurrent Manager encountered an error while attempting to start your immediate concurrent program JTYSTAR. Routine ROUTINE received a return code of failure. Contact your support representative. I review the roles and responsibilities and are well, but when I request this concurrent program ends with error. Thanks in advance. Edited by: Aztaro on 10:34 AM.
The report completed with a warning without generating output. The log says - Current system time is 30-AUG-2006 14:38:03 - +- Starting concurrent program execution. +- XMLREPORTSXENVIRONMENT is: /data/apps/PROD/prodora/8.0.6/guicommon6/tk60/admin/Tk2MotifUTF8.rgb XENVIRONMENT is set to /data/apps/PROD/prodora/8.0.6/guicommon6/tk60/admin/Tk2MotifUTF8.rgb Current NLSLANG and NLSNUMERICCHARACTERS Environment Variables are: AmericanAmerica.UTF8 '.,' Spawned Process 12859 Report Builder: Release 6.0.8.24.0 - Production on Wed Aug 30 14: (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter Username: - Start of log messages from FNDFILE - - End of log messages from FNDFILE - - Executing request completion options. 1) PRINT - Printing output file. Request ID: 2642231 Number of copies: 0 Printer: noprint - Finished executing request completion options.
Concurrent request completed successfully Current system time is 30-AUG-2006 14:38:08 - Can someone say what exactly is wrong? Hi, I am submitting WIP Mass Load concurrent program to get the data from WIPJOBSCHEDULEINTERFACE table in to base tables. The concurrent program is completed with Warning status. My Package inserts the data into wipjobscheduleinterface table to create a WIP Job. After inserting the data in to wipjobscheduleinterface table, it submits a concurrent program (WIP Mass Load) (Standard concurrent program) to create a WIP job automatically from the data inserted into wipjobscheduleinterface table. Hi, I am submitting WIP Mass Load concurrent program to get the data from WIPJOBSCHEDULEINTERFACE table in to base tables. The concurrent program is completed with Warning status.
My Package inserts the data into wipjobscheduleinterface table to create a WIP Job. After inserting the data in to wipjobscheduleinterface table, it submits a concurrent program (WIP Mass Load) (Standard concurrent program) to create a WIP job automatically from the data inserted into wipjobscheduleinterface table. I have a program running in R12 that checks the statuscode of a concurrent request and then checks the statuscode of any child processes that may have been spawned.
It works great when the child processes have the parent request ID populated in fndconcurrentrequests.parentrequestid. However, sometimes the value for parentrequestid = -1 and my program can't find the child processes.
What causes the value of fndconcurrentrequests.parentrequestid to be -1? I only have 2 test cases so far.
Fndload Concurrent Program
Case #1 works where the parent request runs in our Custom Application and spawns children in our Custom Application. Case #2 gets parentrequestid = -1 where the parent request runs in our Custom Application and submits a child concurrent process running in the BOM Application.
Concurrent Program Return Code
Does switching applications cause it to lose the parentrequestid? I have concurrent program parameter which has valueset with validation type pair. And it uses FND POPIDR user exit to get flexfield data. I need to disable flex field value set security for on concurrent program parameter that people could enter any code combinations they need, but I can't disable valueset security, because it will affect other concurrent requests in application. As I know there is no option in FND POPIDR to disable security. Is there any other way how to preserver flexfield popup in parameter form and force it to ignore valuset security rules? Hello I included below code in my procedure which will get called from a concurrent program from Oralce Application (11.5.10.2).
When I run this refresh command from SQL/TOAD it is working but erroring out (Error: ORA-00900: invalid SQL statement) when the same getting called from a concurrent program. Please suggest me how to refresh a Materialized View through a concurrent program. Lchrtext:= 'execute dbmssnapshot.refresh ('tklegacyacctstg','C');'; execute immediate lchrtext; Thanks!! Hello all,I have recently applied a patch on apps tier, after which the concurrent manager is not up running,while viewing the internal logim getting the below errorCheck that your system has enough resources to start a concurrent manager process. Contact your system administrator to: 25-NOV-2013 13:02:02Starting AVAILMGR Concurrent Manager: 25-NOV-2013 13:02:02Could not start Service Manager FNDSMtesttest. The TNS alias could not be located, the listener process on test could not be contacted, or the listener failed to spawn the Service Manager process.Routine AFPEIM encountered an error while starting concurrent manager AVAILMGR with library /d01/apps/testappl/fnd/11.5.0/bin/FNDLIBR.Check that your system has enough resources to start a concurrent manager process.
Contact your system administrator to: 25-NOV-2013 13:02:02 Process monitor session ended: 25-NOV-2013 13:02:02 Starting test1125@test Internal Concurrent Manager - shell process ID 25362 logfile=/d01/apps/testcomn/admin/log/testtest/test1125.mgr PRINTER=noprint mailto=appltest restart=N diag=N sleep=60 (default) pmon=20 (default) quesiz=1 (default) Routine ROUTINE has attempted to start the internal concurrent manager. The ICM is already running. Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FNDDCP.RequestSessionLock. Routine FNDDCP.REQUESTSESSIONLOCK received a result code of 1 from the call to DBMSLOCK.Request.Possible DBMSLOCK.Request resultCall to establishicm failedThe Internal Concurrent Manager has encountered an error.Review concurrent manager log file for more detailed information.: 25-NOV-2013 13:03:01 -Shutting down Internal Concurrent Manager: 25-NOV-2013 13:03:01List of errors encountered. 1 Routine AFPCSQ encountered an ORACLE error.Review your error messages for the cause of the error.
Download Antique Shop today, or play this and 2400+ other top games online. Try the free download version or play the full unlimited version of Antique Shop. Antique Hunter. This game is in early access. It's still in development and the current version may be buggy or incomplete. 
Jan 30, 2013 Antiques Hunter: Portobello Road official website and links to play Antiques Hunter: Portobello Road online / offline.
Hi,Please let us know what is the patch you applied, and also provide us your environment details.In addition to the above please see if the following notes help you:Why are the Concurrent Managers Failing with 'CONC-System Node Name not Registered' Error After Applying Patch 6461517? (Doc ID 1108452.1)Known issues on Top of 11i.ATGPF.H. Delta.6 (RUP6) - 5903765 (Doc ID 459353.1)Concurrent Managers Fail to Start, No Service Manager Process Spawned OR Fails with: ORA-01427, ORA-06512 (Doc ID 470100.1)Concurrent Manager Fails to Start; FNDSM Could not Establish Database Connection (Doc ID 1439853.1)Thanks Best Regards.
Hi I done the register of custom report to Oracle e-Business Suite 11i got the below error +- Starting concurrent program execution. +- Current NLSLANG and NLSNUMERICCHARACTERS Environment Variables are: AmericanAmerica.AR8MSWIN1256 '.,' Spawned Process 4579 REP-3000: Internal error starting Oracle Toolkit. REP-0788: Warning: The value of restricted LOV parameter P1 is not among the selectable values. Report Builder: Release 6.0.8.24.0 - Production on Tue Apr 14 10: (c) Copyright 1999 Oracle Corporation.
All rights reserved. Enter Username: Program exited with status 1 Concurrent Manager encountered an error while running Oracle.Report for your concurrent request 715975. Review your concurrent request log and/or report output file for more detailed information. Executing request completion options. Finished executing request completion options.
Please anyone help on this. Regards, sva.
This is happening because of large number of receiving processes being spawned at the same time.