Forms :: FRM-30085 / Unable To Adjust Form For Output

May 20, 2013

"SUM_TOTAL_RECEIVED" ,this is Item name and i set all Calculation Properties correctly and when compile the form , i got an error

FRM-30405: Datatype for Sum/Avg/Variance/Stddev summarized item must be Number.
Item: SUM_TOTAL_RECEIVED
Block: RHCLANDEDCOSTDET_PROMPT
FRM-30085: Unable to adjust form for output.

View 20 Replies


ADVERTISEMENT

Forms :: Invoice Processing - Unable To Adjust Form For Output

Aug 2, 2011

I've created a form that is working on the basis of Invoice Processing. There I want to get the sum of all the total of the products * quantity..I'm getting this error

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.
Item: TOTAL
Block: SBM_SALES_PRODUCTS
FRM-30085: Unable to adjust form for output.

View 4 Replies View Related

Forms :: Can't Able To Adjust Output Of The Form

Jun 16, 2011

I am re-developing some forms which were designed before on some other machine.

I cant able to run the form and not even to compile them. I am getting an error message like THE OUTPUT OF THE FORMS ARE UNABLE TO ADJUST.

I have checked the canvas dimensions like height and width that they are matching with that of windows of the form. I have also checked the values in formweb file. Everything is correct up to my knowledge. I have also ckecked the setting of LCD screen like it is 1024 X 768 resolutions.

View 2 Replies View Related

Forms :: Unable To Get Whole Form On Screen

Mar 22, 2011

i am not able to get whole form on the screen. some part of the part is missing and even there is no scroll bar to slide the form. I have also change the form applet parameter..my screen size is 1024 x 768 and this is same as of the size of form applet.

View 1 Replies View Related

Forms :: Unable To Put A Check For A Form?

Jul 5, 2010

I have a leave form where I need to put a check which prevents the user from entering 'sick leave' if the employee hasn't completed 3 months in the company.This is the code I've written:

SELECT ABS(MONTHS_BETWEEN(t.start_date,sysdate)) INTO l_date
FROM hrp_per_all_people_f t
WHERE t.company_id = :parameter.p_company_id
AND t.employee_number = :parameter.p_employee_number

[code]...

The absence_type_id = 21 is for 'sick leave'. I can't figure out why this is not working. When I do enter 'sick leave' for a new employee I do not get any checks and neither am I able to save the changes.

View 6 Replies View Related

Forms :: Unable To Open Form Which Is Created In Another PC

Feb 21, 2012

one of my friend created a form in his PC(which is having the same configuration as my PC) and sent me that .fmb file. when I'm opening that form, it is throwing "FRM-11009 : Failed to load in the color palette" error..

I have checked the CAUPREFS.ORA where Forms.color_mode = 1 and I haven't found 'forms.color_pallete' entry in that file.

View 3 Replies View Related

Forms :: Unable To Make The Form Fields Available To Edit

Jan 30, 2013

My requirement is to call a form through special menu icon from one main form and display some information. Whenever i open a new form it should fetch a record and display where some of the fields should be available to edit. I am displaying a record based on a view.

For that i have used below code in when-new-form-instance

- GO_BLOCK('Block name');
- DO_KEY('Execute_Query');

After executing the query my block status is becoming 'QUERY' where i am not able to set the block/item property "Update allowed" to true.

I have added below piece of code

set_item_property('block_name.item name',insert_allowed, PROPERTY_TRUE);
set_item_property('block_name.item name',UPDATE_ALLOWED,PROPERTY_TRUE);

in almost all the triggers and tried. I could still see all the fields are read only.

View 4 Replies View Related

Forms :: Clienthost - Unable To Block Form When Working On Google Webpage?

Apr 25, 2011

I am trying to open the url from the form and block the form when working on the url.I am able to block the form when working on notepad, adobe and word doc by using the below code

CLIENT_HOST('CMD /C NOTEPAD '||fname);
CLIENT_HOST('cmd /c "c:/web_util[1].pdf"');

and when I use CLIENT_HOST( 'cmd /C "C:/Program Files/Internet Explorer/iexplore.exe" www.google.com'); it is opening the www.google.com but unable to block the form when working on google webpage.

I am using oralce forms 10.1.2.3 and the browser is IE8.

View 1 Replies View Related

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

Client Tools :: Unable To Print Query Output On TOAD

Jan 24, 2012

When i run the below mentioned query(similar query)on TOAD. It will run without any errors and i can see "PL/SQL Procedure successfully completed" in the task bar.....

However i am unable to see the output for the query.

print the the query output on TOAD ....

**** Sample Query Starts *****
DECLARE
i PLS_INTEGER;
BEGIN
SELECT NVL(i, 93)
INTO i
FROM DUAL;
--print i;
--dbms_output.put_line('i1: ' || i);
END;
**** Sample Query Ends*****

**** Actual Query Starts *****
-----------------------------------------------------------------
DECLARE
UnxDate number(6);
MyResult number(6);
Todaysdate date := TO_DATE('17-01-2012 00:00:00','dd-mm-yyyy hh24:mi:ss');
BEGIN
SELECT ROUND (Todaysdate - TO_DATE('01-jan-1970','dd-mon-yyyy') ) INTO UnxDate FROM dual;
[code]......

View 9 Replies View Related

Does Shrink And Move Both Adjust The High Water Mark

Nov 4, 2013

I am trying to discern the difference between Shrink and Move and their impact on the High Water Mark of a table. 

My understanding is that MOVE in effect rewrites every row of a table ( hence why it can deal with row chaining ) whereas SHRINK basically moves existing rows in a table 'down' the table into any available free space. This is why MOVE takes a table lock whereas SHRINK takes a row lock. What I am trying to discern is - does MOVE and SHRINK effect the high water mark and does both reallocate space and give it back to free space for the tablespace ? I believe MOVE does reduce the HWM and give freed space back to the tablespace. I am not so sure about SHRINK. 

View 2 Replies View Related

SQL & PL/SQL :: Adjust 2900 Against Certain Amount From Table On FIFO Basis?

Jun 16, 2010

I want to adjust 2900 against certain amount from table on fifo basis.

DROP TABLE ABC
CREATE TABLE ABC(ID NUMBER PRIMARY KEY,AMT NUMBER);
INSERT INTO ABC VALUES(1,1000);
INSERT INTO ABC VALUES(2,2000);
INSERT INTO ABC VALUES(3,3000);

Can i do it using SQL. I know that it can be done using PL/SQL but i just wanted to confirm if its possible using SQL.

View 9 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Application Express :: Unable To Delete Row(s) From Tabular Form?

Jan 28, 2013

I created report with row selector, when I select one row I get tabular form regarding to the selected row from report. I can insert and update data from tabular form, but I have problem with deleting them. Error I get is

ORA-01403: no data found (Row 207589)

My tabular form is created by wizard and primary key is managed by database rowid, I use apex 4.1 an 10g database.

View 3 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Application Express :: Unable To Bind Error In Tabular Form

Jul 5, 2013

I have an application which includes a certain page with a tabular form.After I copied this to a second schema, Apex threw an error

'Unable to bind ':126_ENG_PROJ_ID' 

It took me quite a while before I found out that one of my fields in that tabular form has a Popup Key LOV.The SQL for the LOV was: 

select dv, rv from (select loop_short dv, cmpnt_id rv from SPI_MAIN_TAG where eng_proj_id in (:P126_ENG_PROJ_ID, -:P126_ENG_PROJ_ID) ) order by dv

 Turned out that the view SPI_MAIN_TAG didn't exist in the second schema.Apex error message would have been more clear, like a simple 'Table or view does not exist' error, where possible even with the table name.I had Debug turned on, but in the debug window there was no reference to above SQL,

View 0 Replies View Related

Forms :: 2 Different Form To Pass Values From One Form To Another

Mar 11, 2010

is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.

View 1 Replies View Related

Forms :: Any Way To Load A Form Within A Form

May 21, 2010

I have a requirement, is there any way i can achieve the following User Interface using oracle forms

Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.

The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.

View 2 Replies View Related

Forms :: How To Open Another Form Within A Form

Dec 20, 2012

I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.

In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.

This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.

View 2 Replies View Related

Forms :: Pre-form And When-new-form-instance?

Mar 1, 2010

What is the difference and significance of

1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?

View 5 Replies View Related

Forms :: Oracle Forms Output Embedded In HTML File?

Jun 15, 2012

i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).

(1) now the rest of the page will be covered by the third frame in which the fmx's will run.

(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.

View 1 Replies View Related

Application Express :: Unable To Set Default Date Value For Tabular Form DB Date Field?

Dec 3, 2012

Version : 4.1.1, I have a tabular form on a DB table. One of the columns is a date field. When the user hits the "add Row" button on the tabular form, I want the Date field to be defaulted to sysdate. Here is what I have tried so far,

1. Created a "hidden" item P1_SYSDATE and populated the default value with sysdate. After this, under the DB tabular report date field, I used default type - Item/application on this page and entered P1_sYSDATE

2. Instead of populating the default value of the P1_SYSDATE hidden item, I created a before regions process and added

:P1_SYSDATE := sysdate

and added P1_SYSDATE to default type of the tabular date field with default type as "ITem/application on this page.

I get the error

ORA-01790: expression must have same datatype as corresponding expression

I tried to_Char(sysdate,'dd-mon-yyyy') and then converting it back to to_date. still no luck.

View 1 Replies View Related

SQL & PL/SQL :: How To Print The Multiple Output Statements In Single Output

Jul 1, 2013

DECLARE
JOBSFILE UTL_FILE.FILE_TYPE;
-- TAKE ALL JOB TITLES FROM JOBS
CURSOR JOBSCUR IS
SELECT *
-- DDOCNAME,DDOCTITLE,DSECURITYGROUP,DDOCAUTHOR,DDOCTYPE,DINDATE,PRIMARYFILE,EXTRACTIONDATE,BATCH_ID
FROM TARGET_UCM ;
[code].......

this is my plsql here to print table values i am using many utl_file.put_line statements is there any way to print all table values in a single utl_file.put_line.

View 2 Replies View Related

Forms :: Different Output In 6i And PL/SQL

Jan 12, 2012

Here i have one PL/SQL block which will returns the age of an employee using his id.

SET SERVEROUTPUT ON;
DECLARE
v_num NUMBER;
v_days NUMBER;
[code]...

It will returns an output of 27..I tried the same in Forms 6i using a text field and a button with a trigger "when_button_pressed". when i am entering the same id of employee i am getting a totally different answer

DECLARE
v_num NUMBER;
v_days NUMBER;
BEGIN
SELECT to_date(sysdate)-to_date(dob)
INTO v_num
FROM customer_details
WHERE application_id=:block3.day;
v_days :=floor(v_num/366);
MESSAGE(v_days);
MESSAGE(v_days);
END;

It is giving me a result of -73...i cleared my problem. but i cound not understand the internal work happening inside the forms and pl sql machine.

View 10 Replies View Related

Forms :: Setting Output Path

Feb 1, 2010

Recently i faced with a situation of redirecting a report output to a particular path in my server, and then opening the output by using web.show_document.

I was successful in redirecting it too a path , however i am not able to open the file using URL. We should setup virtual path in orion-web.xml and proceed further.

I pointed the output to an existing virtual path as below in my orion_web.xml file.

D:OraHome_2 oolswebhtml

and tried opening the output through the url

<<<server_name>/forms/html/filename.extn>>>

however i was not able to add new virtual path here .

View 3 Replies View Related

Forms :: To Output Query In Vertical Way

Dec 27, 2011

i have output query in 1 row, for example

Id Name Salary
100 John 2000

i need to output the same query in vertical way like:

100
John
2000

View 3 Replies View Related

Forms :: Add Sub Form To A Form

Apr 26, 2011

I have a main form of "sales contract". I want to add sub form to take input for commission & shipment details in separate sub forms.

When I click a button on main form, system should open sub form, in which I enter the detail.

View 4 Replies View Related

How To Create Cross-tab / Matrix Style Output In Forms

Sep 16, 2011

I am essentially trying to reproduce an extremely complex spread-sheet with an engineering mathematical model in it and that has been in use for 5 years now. The Excel spreadsheet was a good environment for tuning the model, but now I have been asked to design an Oracle Form that incorporates their mathematical model and shows their final and intermediate data so they can validate my app against their proven spreadsheet.

To do that I have to create a matrix style table for use as a child data-block in my Oracle Form.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved