Forms :: KEY_DUPREC Is Not Working In A Detail Block?
Feb 8, 2013KEY_DUPREC is not working in a detail block.What description should i write and where to enable duplication of columns while pressing F3.
View 2 Replies
ADVERTISEMENT
Forms :: Distribute Master Block Total Amount In Detail Block Line Wise
May 5, 2012i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example
Cheque amount in master block = 291
Invoice wise receiveable amount is as follows
Invoice No , receivable amount , Received amount
10, 196 , 0
20 , 95 , 0
30 , 54 , 0
Result should be as follows:
Invoice No , receivable amount , Received amount
10, 196, 196
20 , 95 , 95
30 , 54, 0
Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.
Forms :: Enabling In Detail Block
Jun 22, 2011I have an existing form which i need to customize..In the form in the query block whatever strings we enter..and press the search button..it sets the where clause and use execute query.which populates the detail block which is read only and only 1 column is enabled.
For the Enabled column X I need to enable a button.It has to be done only if the cursor go in the column X
Forms :: Primary Key In Detail Block?
Nov 26, 2010I've a master detail form. I detail form there is no primary key. When it is executed the following error displayed :
FRM-30100: Block must have at least one primary key item.
Block: ASSETS_ISSUE_DTL
Form: FORM_ASSETS_ISSUE_DTL
Forms :: Master Detail Block
Feb 20, 2012I have face a problem with master detail block,
we have two tabular block first one is master and sencond one is detail when we insert detail item it proper work and when when move next record in master block then it ask for save, I want to user enter all record and when he save with button then it save other wise no. but when he move any record in master block all realted record show in detail block.
Forms :: To Move Data Block Detail
May 4, 2011i made a master-deatil data block and when i completed all field on master-data block i can`t move to data block detail.
when i press (TAB OR ENTER) on last field, the cursor go back to first field.
Forms :: How To Integrate Excel To Get Detail Block
Mar 2, 2010how to integrate exel with oracle forms ? so that it looks like a detail block.
and how to change the number of records displayed in a detail block at run time?
if i give 20 in text item and if i click on a button then the detail block should display 20 records.
in set_block_property there is no property for records_displayed. but in get_block_property we have it.
Forms :: How To Perform Search Detail Block
Dec 26, 2011I have detail block in my form and i need to give option to user to search item in that block.
For example I display 100 items from item master and user need to search particular item by either code or name.
Forms :: Delete Detail Block Single Record
Apr 22, 2010My form consist two datablock cust_mstr,cust_dtls, each customer code consists two or three contact details records, when i delete the single detail record instead of deleting single record it deletes all the details records from cust_detail table.
Here by i attaching my form for your reference pls find the code in delete button
Forms :: Filling List Item In Detail Block
Sep 14, 2010We have a master detail form block A (master) contains an item, this item is in the record group's where-clause used to fill a list item on block B (detail block) (database item) we fille the list item in a pre-record trigger on the master block this works fine but when we navigate through the records in block a we intermittently get the following error : FRM-41337 : cannot populate the list from record group;
how should we filll our list item, in which trigger (when-new-record-instance of master block doesn't work correctly, the list item only gets filled after clicking it twice)
Forms :: Applying Serial Number In Detail Block
Sep 5, 2011I have form with master detail relation ship (invoicing form) the detail block is tabular, displaying upto 7 records...
Now my clients wants to show the serial number along with each record while feeding the data (this includes when insert, editing, deleting / clearing records) he wants to see the serial number as in MS access / MS techniques.
I tried to use the system variable to use :system.cursor_record; but this dose not works.(in insert/edit/delete/clear record)
Forms :: 6i To Show Detail Block When Button Pressed?
Aug 16, 2011Is it possible to display the detail block (different canvas) in the master block canvas, but when finished entering data into master block and a button is pressed? And i want to use some conditions in the when-button-pressed trigger. based on that it should show different canvas.
simply speaking, my aim is to use the upper part of the screen to show master block and the lower part for a detail block from the different detail blocks based on condition checked in when-button-pressed trigger.
Forms :: How To Programmatically Change Relationship In Master-detail Block
Dec 20, 2012can we use set_block_property to program to switch multiple relationships. for example
if true then use relationshipA
else relationshipB
end if;
Forms :: Query Records Of Detail Block Displayed In Single Row
May 30, 2010I have a Master block and a Detail Block. They are related using two columns, Document_ID and Page_no. I want to display all the records in master table with corresponding detail records beside them in single line. i.e., as shown below:
MasterItem1 DetailItem1 DetailItem2 DetailItem3
I created the relation between them and executed query. When I execute query in the form, I can find that all the Master Items are displayed in vertical records, but i can only see one record of detail fields. They are displayed as shown below:
mitem1-value1 ditem1value1 ditem1value2 ditem1value3
mitem1-value2
mitem1-value3
mitem1-value4
When the navigate down in master items, then the corresponding detail values are being shown on the same first record.
Forms :: Hangs When Scroll Bar Reaches Last Record In Detail Block
Aug 9, 2010I'm having a multi-record detail block in my form and after querying the form, when I scroll through the scroll bar, it is hanging (freezing) just before reaching the last record.
I have noticed that it never hangs if I use arrow keys to scroll between the records. It only hangs when I use scroll bar or page down key.
Regardless of the number of records fetched, it only hangs when I click the scroll bar (or press page down key) to fetch the last record.
It happens to all my custom forms and I'm developing this for Oracle EBS Apps 11.5.10.2. Oracle JInitiator Version is 1.3.1.21 and my form builder is Forms 6.0.8.28.0.
Forms :: Stop Responding When Pass From Master To Detail Block?
Jul 29, 2010I have problem with the form when i pass from the master to detail block the form stop working and it stops responding even if i am in the next detail block and i press tab to change from one record to another the form will say working and it stops responding.
View 2 Replies View RelatedForms :: Display Data In Master-Detail Block Structure
May 11, 2010I have a master - details block relation where I have to display all the records in the details block based on the selection criteria made in the master block. Earlier we didn't have any selection criteria and hence used to do a execute_query behind the detail block to just retrieve all the records.
But now the master block contains fields where I can input the selection criteria and once I hit the find button it will retrieve the records based on those criteria and display in the detail block.
Forms :: Calling From Other Data Block Into Current Master / Detail Form
Jun 10, 2013I got the following scenario.
- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-
Begin
go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......
When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.
Forms :: ORA-00000 Normal Successful Completion Error While Populating Data From Master Block To Detail
May 21, 2012ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.
View 6 Replies View RelatedForms :: Go Block Not Working?
Sep 18, 2012In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).
If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.
I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.
Forms :: Clienthost - Unable To Block Form When Working On Google Webpage?
Apr 25, 2011I 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.
Forms :: Oracle - Date Field In Detail Part Of Master Detail?
Jul 13, 2011I have to date field in detail part of master detail Form. In detail part i have field of From_date and To_date. I want when i go to next record in detail part ,,,from date is initiaze by previous to date+1....eg.like
1.record: From date=01-jan-2011, To_date=10-jan-2011
2.Record: From_date = 11-jan-2011;
I have Attached calender to two feild...and calender is the different block... In Detail block when_record_instance i handled the;; From date=previous to-date +1;
but when i double click the feild calender is open and when_new_record trigger is fired agian. calender called ...the when_new_record is not callled .....
Form Trigger - Master And Detail Block
Dec 9, 2008I have a Oracle Form which has 2 blocks, master and Detail.I have a pre-Insert Trigger on master block which has a sequence that acts as the id of the primary key column. Now, when I populate the master block and dont save then go to detail block and save(after populating detail block's data) it gives me an error that can not insert null into detail block foreign key column.I understand that his is happening because in the above scenario pre-insert is not firing for the master block.Am I writing the the sequence generation code in a wrong trigger?
View 1 Replies View RelatedReports & Discoverer :: Master-detail Report ( 3 / 4 Columns Detail To Be Printed)
Jul 19, 2013my report is based on two tables.master and detail. i am using GROUP ABOVE style.displaying master tables columns up and detail table columns down.
my problem is ...i want 3 columns from master table (i.e)RECEIVER ID,RECEIVER NAME and RECEIVE DATE to be printed at the bottom of the page.
and also i want only 4 records from detail table to be printed on each page.
Forms :: Multi Data Block And Checkbox Field Based On Control Block
Nov 19, 2010i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field
e.g
item11 item21 item31 chkbox1
item12 item22 item32 chkbox2
Scenario like this :
My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field
when i checked chkbox1 , my cursor goes to item31...not item32
Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)
Jul 24, 2010I 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".
Forms :: New Visual In Oracle Forms (Master / Detail)
Feb 1, 2012I have created a simple master/detail form which is in easy navigation for user. The form have master/detail block with tabular style showing 5 records, When user click on master record the detail will show the opposite as master record point.
See attached file.
Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?
Oct 31, 2013I 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 RelatedForms :: First_record At Detail Level
Jun 24, 2010I have created one master detail block..Master having form layout only one record and detail block is of tabular type having 10 record set
I need to do that .as master block enters entry and switch to detail block at the detail block 1st record should come with some default values which property need to use..
Forms :: Master Detail From One Table
Jun 9, 2011Is there any way to design a form to act like Master Detail from one table which is not normalized?
View 2 Replies View Related