Forms :: Insert Record Into Lov Through Oracle Custom Forms?

Oct 8, 2013

I have a LOV in a custom oracle forms.this lov is linked to a record group.

Presently the column on which lov is created does not contain any value.

I want to insert value into the lov through the forms.

I am not able to insert data into it through forms

View 12 Replies


ADVERTISEMENT

Forms :: Custom ORDER BY In Multi-record Data Block

Jun 15, 2011

I have data block that has hundreds of records. On a screen I display 20 records at a time. On that same screen I have "find badge" function where user types badge/employee id and presses a button to find the record in a data block. I have no problem finding the records in a list and pointing the curser to appropriate record. My question is (which is a user request) if the badge/employee id is found to make that record to be the first record in a list.

View 2 Replies View Related

Forms :: FRM-40508 / ORACLE Error / Unable To INSERT Record

Jan 14, 2013

I have an interface composed of five elements:

1.display_item (primary key)
2-list_item (foreign key) / / dynamic list :this is the cause of the error
3-lis_item (foreign key) / / dynamic list
4-text_item
5-button (insert commit)

when I click the button, an error is displayed:

FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated - parent key not found

Note:

-the elements of two lists already exist in the parent table!!

-I use a block based.

-button

commit_form();

View 17 Replies View Related

Forms :: Develop A Custom Form Which Is Not Related To Oracle Apps

Oct 15, 2010

I wanted to develop a custom form which is not related to oracle apps. I don't want to login to oracle and use the form. I wanted it to be like standalone form (use it as a tool) where I can automate the process of migrating the code from one instance to another, on click of button. Can I create standalone form and run without logging to oracle?

View 1 Replies View Related

Forms :: Enable Insert Button For 1 Record Only?

Apr 3, 2013

I have a form with a block at header level. Once you save your header, there is a second block at line level. I want to be able to enter only one record at header level and line-level.

Also if you search on an instance which already has a record at line-level then i want the insert button to be greyed out.

Similarly once you create your first record at line-level the Insert button should be greyed out.

View 1 Replies View Related

Forms :: Two Blocks - Unable To INSERT Record

Oct 16, 2012

I have this error. To put it simply I have two blocks.

Block1 contains two drop down list with PL/SQL statements for queries.
Block2 contains tabular form created from block wizard (I tried already in manual)

that will catch the result in Block1 queries.

Now I have a button with a trigger when-button-pressed that contains

BEGIN
INSERT INTO dummy1
VALUES ('hello',1,2,3);
COMMIT;
END;

My goal is to add into dummy1 values from :block2.item_name1, :block2.item_name2, :block2.item_name3 but to put it simply I tried these values but I received the same error.

When I run it and first things first click the button, the values will be added into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error.

View 10 Replies View Related

Forms :: INSERT Record - Update Columns Of Table

May 31, 2010

I would like to UPDATE the columns p1 and p2 of my table student (studentid:pk,name,p1,p2,...) for a given studentid.and I have a when-button-pressed trigger with this

UPDATE student
SET student.p1=:validation.proj1,
student.p2=:validation.proj2
where UPPER(student.studentid)=UPPER(:validation.studentid);commit_form;

when I run my form with a correct studentid, I got this error: FRM-40508: ORACLE error: UNABLE to INSERT record

but it is cworking correctly in sqlplus; and I have all priveligies.

View 4 Replies View Related

Forms :: How To Insert Records Checked In Multi Record Block

Jun 29, 2011

I am working on forms 6i.

I have datablock 'EMP', it's multi record block. I have a button 'CREATE', I have 'commit_form' in 'When button pressed' trigger, to commit records. It's working fine.

Now, i have a check box in the same block, i want to insert records which are checked only.

View 7 Replies View Related

Forms :: Insert / Update And Delete Single Record At A Time?

Aug 10, 2005

I have multirecord block and I want to disable Inserting/Updating/Deleting more then one record at a time.

View 32 Replies View Related

Forms :: Display Alert When Click On Insert Record In Tool Bar?

Jun 26, 2013

I want to display an alert when we click on Insert Record in tool bar. I put allow update->yes and insert->no.

but when i click on the insert record in tool bar it showing message only.

Instead of message I need an alert using triggers. I added the image also.

View 1 Replies View Related

Forms :: Insert Unchecked Records After First Insertion In Multi-record Block?

Aug 31, 2011

I am working in form 6i, EBS11i. I have a multi record data block, i am inserting checked records only using below logic.

ON-INSERT Trigger:

if checkbox_checked('block.checkbox') THEN
insert_record;
end if;

Requirement: Let us say, i have 4 records, i checked 2 records.. inserted them. Now if i want to insert other 2 unchecked records, it's not accepting, is it possible to insert records which are not checked after insertion.

View 5 Replies View Related

Forms :: Insert Record In Table When One Of Item In Database Block Is Filled?

Sep 11, 2012

i want to insert a record in table when one of item in database block is filled..from which property i knw my one of field in block is filled or not.

View 2 Replies View Related

Forms :: Navigation Between Forms Via Custom-menu?

May 23, 2011

what is the basic workaround to provide to switch from one form to another form via custom-menu at runtime?

I attached a menu-item to every of my forms and I can call them seperately from the forms builder. But I am not able to switch between the forms then. If I am clicking on a menu-item, I get frm-40010.

P.S. I'd prefer to close the current form, if the new form has been opened. Do I have to control this seperately or is the closing of the last form default?

View 3 Replies View Related

Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database

Apr 12, 2013

I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.

So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.

-more details

I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.

COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column

Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.

View 1 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

Forms :: Add Some Custom Image On A Button?

Dec 7, 2010

Is it possible to add some custom image on a button?

If so, How to do it?

View 8 Replies View Related

Forms :: Change Block Status In Custom.pll?

Mar 9, 2010

I have a requirement to get decrypted value of national_identifier from database and display in Social Security number, when user queries for employee in employee form of HRMS. Also, National_identifier should be in encrypted format in database table always.

To meet above requirement, I am using custom.pll. In WHEN-NEW-BLOCK-INSTANCE I am getting decrypted value of national_identifer from database and assigning it to :person.national_identifier(database block) by using COPY function, so far it is working as expected.

When user query for employee, he/she able to decrypted value. but if user closes the form it is asking 'Do you want to save changes you made' as there is a change in :person.national_identifier.

Do we have any property to reset record/block status to something like unchanged, so we will not get 'Do you want to save changes you made message'.

View 15 Replies View Related

Forms :: Where To Set Auto Refresh On Custom Form

Dec 14, 2010

How and where to set Auto Refresh on Custom Form ...?

View 1 Replies View Related

Forms :: Compare Value Which Is Taken In Custom Block By User

May 26, 2010

i have created one custom block in that i am taking one value in text_item and on 2nd form i have data block on that block i want filter by using WHERE clause

in that where clause i want to compare value which is taken in custom block by user..what need to write in where clause?

View 1 Replies View Related

Forms :: Test Custom Jar Files With 6i From Desktop?

Dec 18, 2010

I want to test custom Jar files with Forms 6i from my desktop, but I cannot get the Run Form->Web to work. Is it possible for the run time to load the just jars for PJC when you do Run Form -> Client/Server? So far, when I have done this, it does not execute any PJC.

View 2 Replies View Related

Forms :: How To Implement Custom Lov Button Without The Standard Template.fmb

Jul 4, 2010

i am developing a application using oracle forms 10g. i can't use the standard template.fmb because my application does not run in ebs. there comes the problem: i want to implement the lov button function like the template does, such as :

1. when the text item get focus, lov button display.

2. when the text item lost focus, lov button disappear.

3. when scrollbar scrolls, the position of lov button adjust accordingly.

4. there is only one lov button in one form and the lov button was created dynamically.

View 2 Replies View Related

Forms :: FRM-47023 - No Such Parameter Exists In Custom Form XYZ

Mar 6, 2012

Getting error FRM-47023: No such parameter named CHART_OF_ACCOUNTS_ID exists in our custom form XYZ

View 5 Replies View Related

Forms :: Using PIPELINED Return Inside Custom Library

Jun 5, 2013

I would like to know if it's possible to use PIPELINED return inside a custom library with Oracle Forms Builder? For now, i try to use it, but i get error about client side.

my code.

PACKAGE TEST IS
TYPE measure_record IS RECORD(
l4_id VARCHAR2(50),
l6_id VARCHAR2(50),
[code].......

the body compile, but not the other part. I would like after call the select * from test.get_ups(0); with a cursor into another function.

View 3 Replies View Related

Forms :: How To Print Next Record Value In Oracle 10g

Jun 28, 2010

I am using oracle forms10g here i have next button. So when i click the next button it will show the total volumn of record count and each record value for example 1/10 like that.

View 9 Replies View Related

Forms :: How To Focus On Current Record In Oracle

Jul 4, 2011

How to focus on current record in oracle forms.

for ex:- I have 10 records in line level.i want to focus my cursor on particular like (5th record) how to possible in form.

Is there any built-in like current_record?

View 4 Replies View Related

Oracle Forms 10g Insert Pie Chart In Excel Sheet?

Mar 9, 2012

I have been requested to create an excel sheet report in my Forms application (10.1.2.0.2) with data grouped in a pie chart, something like the attached pic (if you cant open go to this link: [URL]

I'm able to create the excel sheet by using OLE2 tool, but I dont know how to insert my pie chart from code.

Attached File(s)

piechart.jpg ( 251.88K )
Number of downloads: 1

View 1 Replies View Related

Forms :: How To Check Syntax Of Resulting Insert In Oracle 6i

May 23, 2013

I have a package,

PACKAGE PK_EXCEL_TO_DB IS
TYPE tKeyValue IS RECORD (
CROUTE VARCHAR2(255),
VROUTE VARCHAR2(1000),

[code]...

Package body is

PACKAGE BODY PK_EXCEL_TO_DB IS
PROCEDURE PR_DO_INSERT(i_lData IN tDataList) IS
vcInsert VARCHAR2(3500);
BEGIN

[code]...

what i want is: 'output vcInsert to a forms-item and check the syntax of the resulting insert'. How can I do this

View 7 Replies View Related

Application Express :: Display Custom Message For Report When Record Count Returned

Nov 8, 2012

Our application has a homepage that displays results of several SQL statements that are defined as reports. One report in particular should only display a custom message when Count of Invoices having a particular status > 0, and not the actual invoice count itself.

I have gotten the layout to not display the count but I need to be able to display a custom message that says "Problem Invoices exist. Please see Invoices Report for more information." I've looked over the Report Attributes definition page but I cannot find how to display this custom message.

View 2 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

Forms :: Oracle Unable To Update Record - Unique Key Violation Error

May 10, 2011

I have the search screen in my form so after searching if i select the row by using the button it will navigate the first tab page that is "gas" screen here if i tried to change the value like update and save the form it is not allowing me to update the value raising the error message "oracle unable to insert the record". if i see the "display error" in menu it is having the select statement with error "unique key violation error ora-00001".

In save button containe "commit_form"

View 15 Replies View Related







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