Oracle Forms 6i – Execute query
Execute_query is not refreshing the data from a currently active block but Execute_query is refreshing a different block. I have given go_block pointing to one block. But execute_query is refershing a differnt block. Please suggest.

Answer Question   |  January 23, 2009  10:09 AM
Execute_Query, Oracle development, Oracle Forms 6i

Oracle 10g Reports not running
Hi Gurus, We are trying to migrate from form and reports 4.5 to 10g and while migrating them we were able to find the way to work with forms 10g but not with reports 10g from within forms. can any one give me the procedure to make reports 10g to work within forms . with [...]

Answer Question   |  January 23, 2009  6:02 AM
Oracle 10g, Oracle 10g migration, Oracle Developer 2000, Oracle development, Oracle Forms & Reports Developer 10g, Oracle Forms 4.5, Oracle migration

Oracle – Deleting a row from a complex view
why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

Answer Question   |  January 23, 2009  3:53 AM
DELETE statement, Oracle administration, Oracle Complex View, Oracle development

Query for tab canvas block
I have a Form with a tab canvas for the detail and a multi row master block. when scrolling through the rows in the master block the detail block (tab canvas) isnot executing the query (only by steping on the detail block is the query preformed)

Answer Question   |  April 24, 2009  12:12 PM
Oracle development, Oracle Forms, Oracle Forms Tab Canvas

32 bit to 64 bit Oracle 10g
Our company is having 32 bit applications (client/server(powerbuilder/oracle) and web (asp.net/php)) connecting to 32 bit server (oracle 10g) . We are thinking of migrating to 64 bit server . Will it be any problem connecting to a 64 bit application with our existing applications(32 bit) Thanks

Answer Question   |  November 9, 2012  8:27 AM
Oracle 10g, Server migration, Servers

Hyperion Planning: Problem with web form for data entry: dynamic entry
Hi everyone, I have a problem by creating a web form in Hyperion® Planning – System 9 Version : 9.3.1.1.5 : There’s one dimension called “Period” (Members: M1 … M12 for the months) which is to be displayed in the column. I defined a variable called “current period” whose value is entered by the administrator, [...]

Answer Question   |  March 7, 2009  8:19 AM
Hyperion Planning 9.3.1, Hyperion Planning Reports and Forms, Oracle Hyperion, Oracle Hyperion Planning

Oracle Enterprise Manager login password error
We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on “google”, solution was “ocijdbc10 file has to be placed in [...]

Answer Question   |  January 16, 2009  5:05 AM
Oracle 11g, Oracle 11g error messages, Oracle 11g security, Oracle administration, Oracle Enterprise Manager, Oracle security, SQLPlus, Windows Server 2003

SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
My procedure is shown below. When I execute it, it gives me the title error. Field3 is identified as a CLOB. Any / all help would be greatly appreciated. Running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 CREATE OR REPLACE PROCEDURE xxx IS FileHandle SYS.UTL_FILE.FILE_TYPE; FileName VARCHAR2(2000); FileText VARCHAR2(2000); vField1 TABLE.field1%TYPE; vField2 TABLE.field2%TYPE; vField3 TABLE.field3%TYPE; [...]

Answer Question   |  January 15, 2009  3:07 PM
ORA-06502, PL/SQL, PL/SQL error messages, PL/SQL: numeric or value error

PL/SQL Insert
Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error for primary [...]

Answer Question   |  January 20, 2009  11:00 AM
INSERT statement, ORA-01400, Oracle development, Oracle error messages, PL/SQL, PL/SQL procedure

What is the Oracle Application Object Library?
what is object library ?

Answer Question   |  September 6, 2011  8:58 AM
Oracle AOL, Oracle Application Object Library, Oracle developers

Oracle connectivity with Oracle Forms 6i
I am a new Oracle Form6i user. i ve installed Oracle form 6i in d:Orant. now i need to work on form builder. there when i go with the wizard then i browse the table name it ask me with username :scott password : tiger database: so i have the problem what database name should [...]

Answer Question   |  January 14, 2009  9:48 AM
Oracle connectivity, Oracle Forms 6i, Oracle Forms and Reports 6i

How to determine Receipting tables linked to PO Line
What are the receipting tables linked to PO Line (Header, Shipment, Distributions)?

Answer Question   |  January 13, 2009  7:54 PM
Oracle Financials, Oracle Financials PO Line

Lotus Notes to Oracle
i have a field (date)i want to insert date(field) in oracle table .i used”+doc.date(0)+”but date is not inserted in oracle table . how can it possible .pls suggest me.

Answer Question   |  January 13, 2009  11:20 AM
Lotus Domino interoperability, Lotus Notes, Oracle development, Oracle interoperability

oracle log for table update infimation
I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. in last 10days 1 user connected to oracle database other than regular forms 6i program and modified one table record column value by update. How can i [...]

Answer Question   |  January 12, 2009  1:22 PM
Oracle 10g, Oracle administration, Oracle security, Windows 2000 Server

INSTR ()
Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg || sqlerrm); END IF; where v_lm is a local [...]

Answer Question   |  January 16, 2009  12:02 PM
InStr function, PL/SQL, PL/SQL block

oracle 10G Enterprise Manager
I have a oracle 10g database running on unix 64 bit. For some reason the enterprise manager GUI console suddenly stopped working. Trying to finout the reason behind it and bring it back up. I have looked at the log files (emoms). the agent is up and running. Can someone let me know how to [...]

Answer Question   |  January 27, 2009  2:52 PM
Oracle 10g, Oracle 10g Enterprise Manager, Oracle Enterprise Manager, Oracle Management Server

Sales Order Detail
The F42199 file is enormous and never gets any deleted records. How do you purge old records – or close to get deleted records.

Answer Question   |  January 28, 2009  9:38 PM
F42199, JD EDWARDS, JDE

What should our next contest be on ITKnowledgeExchange.com?
We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. [...]

Answer Question   |  January 11, 2009  4:02 PM
AS/400, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP

Hyperion Planning Delivered Reports
Straight off the shelf, what reports and forms come already configured for Hyperion Planning and Hyperion Planning ETL?

Answer Question   |  January 7, 2009  1:47 PM
Hyperion Planning, Hyperion Planning ETL, Hyperion Planning Reports and Forms

How to write a test case in PL/SQL
Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code thanks n advance

Answer Question   |  January 9, 2009  10:59 AM
Oracle SQL, PL/SQL, Procedural Language/Structured Query Language