Oracle PO_REQAPPROVAL_ACTION.RESERVE_DOC Error:User Defined Exception

Can you please tell me why this error occurs:
PO_REQAPPROVAL_ACTION.RESERVE_DOC

Error:User Defined Exception

Oracle error 1User-Defined Exception

I created this procedure , and when I execute it , there is this error :create or replace procedure importer_remise_transac(p_fichier varchar2)is v_file UTL_FILE.FILE_TYPE; v_buff varchar2(100); v_affect varchar2(25); v_long_fichier number; v_fichier_char char(1); v_position_last_bar number; nb_bar ...

Oracle ERROR- User defined Exception

When i run the following piece of code, it sqlerrm is "User defined Exception". how can i resolve it?BEGINl_f_path := "c:\example";l_f_name := "example.csv";l_f_fileDesp := UTL_FILE.FOPEN(l_f_path,l_f_name,'r',c_n_max_linesize);l_n_line_no := 0;<<read_file>>LOOP-- Read the line from the ...

Oracle ERROR- User defined Exception

when i run the following code, the sqlerrm is "User-Defined Exception". How can i resolve it?Thanks in advance BEGINl_f_path := 'c:\example';l_f_name := 'example.csv'; l_f_fileDesp := UTL_FILE.FOPEN(l_f_path,l_f_name,'r',c_n_max_linesize);l_n_line_no := 0;<<read_file>>LOOP-- Read the lin ...

Oracle OEM 10.2.0.3 Error" java.lang.Exception

Does anyone have an idea of why I would receive error "java.lang.Exception: IOException in sending Request :: Connection refused" when I log into OEM Database Control??? ...

Oracle RMAN + ORA-06510: PL/SQL: unhandled user-defined exception

We are taking a backup for 9.2.0.5.0 database through RMAN. There are no error messages in the log file. However, when I try to run restore database validate I am getting ORA-06510: PL/SQL: unhandled user-defined exceptionI checked the alert log file it turned out that there is a corrupted block:cor ...

Oracle JAVASCRIPT: Getting $x_Class(pThis, 'error') not defined error

I am getting the error (displays in Firebug in Mozilla browser) when validating a tabular report region in APEX. The screen is using a table and apex.collections very much like the recently released time sheet example on the APEX ORACLE page of examples. For that reason, I decided to model some of t ...

Oracle doc error: getNumVal() should be getNumberVal()

On page 24-8 in A96616-01 (9iR2 XML API Reference), function getNumberVal() is described. However, it is erroneously named getNumval() here. ...

Oracle DOC error: getNumval() should be getNumberVal()

In A96616-01 (9.2 XML API Reference) p. 24-8 XMLTYPE member function getNumVal() is described. The actual function name, however, is getNumberVal(). ...

Oracle PO Approval workflow error

I customized POAPPRV (PO Approval Workflow) and uploaded it successfully to DB. Now when I try to view the workflow for a new PO it gives following error Failed Activity PO Approval Top Process (Custom) Activity Type Process Error Name WFENG_ACTID Error Message 3121: Activity ID '185096' is invalid ...

Oracle impdp append action with error

I try to use impdp to appens data in target table. The query works well in sqlplus. But I got error for were condition during imp.my systax asimpdp dev/dev@sale tables= t_c query:"where TO_CHAR(RECEIVED_DATE,'DD-MON-YYYY HH:MI:SS') > '17-OCT-2009 02:28:05'" NETWORK_LINK=mylink table_exists_aciton ...

Oracle FDM Batch Action script error-No Process Started loading HFM

I have a batch action script that is using this API API.MaintenanceMgr.fProcessStatus(strBatchLocation, strBatchCategory, strBatchPeriod). When I run the load for the first time I get this error: No Process Started. I am assuming the process not started in HFM, but that does not seem to be it, that ...

Oracle PO contracts getting error - Enter Valid PO Business Unit (10400,670)

I am using FSCM 9.1 and testing out the PO contract functionality. When I save the contract using the Demo values I get the following error message:Enter Valid PO Business Unit (10400,670) The Value entered in the PO Business Unit does not match with the allowable values. Please choose a value from ...

Oracle PO Entry: ERROR - APP-PO-14040

Bug: When executing Purchase Order Entry using the standard Professional Purchase Order forms, when navigating to the distribution to enter a charge account, an APP-PO-14040: Please enter a valid charge account error occurs, even before a user can click into the charge account field. Users can just ...

Oracle PO Approval stuck in error without any Error message

we have few notifications for PO Approval where they are stuck in error without any error message. they are also not showing in the worklist of the approver nor in the wf_notifications table. please help on this on how to solve this. we have done various options to solve the issue like skip/rewind/s ...

Oracle Download doesn't work No error message

I am trying hard to download oc4j release 2 and how-to-jazn sample .Site doesn't provide any error message if there is any error message if server is down . There is no problem if I dowm load from other sites.Can some one answer my question ...

Oracle Download always giving "Next Hop" error

I have been trying for couple of weeks to download 9iAs but it is always failing with "Next Hop Connection Failed", and I have seen same message for other downloads too. I tried right click and then save the target and that fails too. It is no different in non peak hours!! ...

Oracle 10.0.2.1 Installation error in Aix 6.1(6100-01-03)

While installating Oracle 10.0.2.1 in Aix 6.1(6100-01-03)we get error at prerequisite check. But we have installed all the filesets required. Is there any guide to install Oracle 10.0.2.1 in Aix 6.1(6100-01-03). Please find the full details of the error in attachments............. ...

Oracle TechTracks signup page -> HTTP 500 error

From: http://otn.oracle.com/software/content.htmlAccess "Sign up" link (https://www.oracle.com/jsp/otntt/index.jsp)produces an internal server error (HTTP 500)browser is IE 6.0.2800.1106 ...

Oracle How resolve the ORA-00600 error?

My server works fine before Feb. 17 PM, then everyone can not connect it, SQL*PLUS display the following message: ORA-01033: ORACLE initialization or shutdown in progress(but the server has started), I find a TRC file in udump directory, it reports following message:......*** SESSION ID:(14.100) 200 ...

Oracle jdeveloper 9.0.3.1 : error on download page

hithe page http://www.oracle.com/start/jdevelopereap/intro.html?src=855007&Act=127for the download of the maintenance release of jdeveloper 9.0.3.1 does not work. ...

Oracle PO 9i and designer 6i

I can't run Designer 6i with personal Oracle 9i.What can i do ? ...

Oracle OTN Main page with Javascript Error

Please observe that the OTN main page generates these Java script errors when it loads: Perhaps, that is one reason the page load is so slow.RegardsFlemming G. Jensenhttp://otn.oracle.com/Event thread: onmouseoverError:name: ReferenceErrormessage: Statement on line 1: Reference to undefined variable ...

Oracle Can't view EUS Doc

When I click on this link, I can't view the paperhttp://otn.oracle.com/deploy/security/aso/pdf/EUS901.doc ...

Oracle DBW0: terminating instance due to error 600

The Oracle8i Server located at web server gest disconnected due the following err(displayed in Alert Log File & DBWR Trace File):1) Alert Log File: Corrupt block relative dba: 0x02002628 (file 8, block 9768)Fractured block found during preparing block for writeData in bad block -type: 6 format: ...

Oracle Table Creation halted by misleading error message

When creating a table, the action was not allowed with error 01950 - no priviledges on tablespace NAME.The JDeveloper GUI front end provides many "priviledges", none of which corrected the situation.It was not until I went to orafaq.com and did a searchdid it show me that the error was in the Quota. ...

oracle 9i database installation (xp pro) error.

I had unzipped the 3 disk files in one folder, upon installation the oracle installer asked me for disk2, neglecting the fact that the folder had all the 3 files unzipped, I again unzipped the disk2and disk3 in a different folder and the directed the installation to disk2 folder. Strangely the insta ...

Action Pages -get error msg

Since I haven't found a free CF hosting site I've been doing development on my PC using CFExpress and PWS. I don't have any other mappings than the original one put on there by CFExpress.I'm developing a Listing, Add, Search, and Update Manager. All is working with the exception of the Action pages. ...

Oracle ORA-00333: redo log read error block 65538 count 8192

I wanted to alter user hr's password, but I couldn't open the database first. What should I do? Here is my demo: Thank you for your response.*******************************C:\>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on Sun May 16 12:12:43 2004Copyright (c) 1982, 2002, Oracle Corpor ...

Oracle PO Inbound ACKPO XML Message Confirmation

Can we get any documentation on the seeded workflow mentioned in the subject. Its internal name is PO_ACKPO.I tried to search for it on Metalink, OTN...everywhere...but couldn't find it. ...