Forms :: Applying Serial Number In Detail Block
Sep 5, 2011
I 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)
View 5 Replies
ADVERTISEMENT
Jun 2, 2010
I have created simple data block by wizard and taken tabular layout 10 rows and 6 columns
i want to generate serial number on first column .....
what need to use..?
View 11 Replies
View Related
May 5, 2012
i 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.
View 2 Replies
View Related
Aug 23, 2011
how do you generate serial numbers? i have an invoice where i have to add items, so i want the numbering to start from 1 everytime i start a new form and increment by 1 as i i enter a new record. For this i have put my code in when-new-record-instance but problem is if i delete a record and enter a new one, the serial number starts from the nex number.
For ex. if i have 4 items with serial numbers 1, 2, 3, 4 and i delete the item at no. 3 and add a new item , the serial number comes as 5.
proper code to generate the serial numbers?
View 7 Replies
View Related
Apr 24, 2012
I have a sale invoice form with 3 data blocks.
Data block 1- master_blk : For date/customer of sale invoice
Data block 2- detail_blk1 (detail of the master block - For products and qty)
Data block 3- detail_blk2 (detail of DETAIL_BLK1 For entering serial numbers of products)
My requirement is that whatever quantity user enter in data block 2 against each product he must enter equal number of serial numbers of that product in data block 3.
For this I have created on item (cnt_iteml : to count product's serial numbers in block3 ) in data block 2, and on summary item (t_serial_no ) in block3.
Whenever user changes in quantity, cnt_iteml: item is populated with t_serial_no in block3 of that product by following trigger on quantity column.
POST-Change Trigger ( quantity column )
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
Following trigger is written on block level at data block-3 to populate cnt_iteml with t_serial_no.
PRE-RECORD
IF GET_BLOCK_PROPERTY('SERIAL_NUMBERS',STATUS) IN ('CHANGED') THEN
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
END IF;
Above triggers are fulfilling my requirement except following condition.
If user after entering serial numbers in block 3 and without saving goes back to block2 and try to navigate to another record he gets a message asking him to save changes by forms. At this time if user presses no then cnt_itl item is not been populated with t_serial_no item's value.
What I want in above condition is that if user was inserting new record cnt_it item should be populated with 0, so that he shouldn't be able to save this record. And If he was updating then cnt_itl item should be populated with actual no of records in database against that product.
View 2 Replies
View Related
Dec 21, 2011
i want to get serial numbers in oracle forms. i have one data block with 10 rows and a non database display item with corresponding length as that of the original data block .
when ever i am executing the form i want to see the serial number generated in the display item and when i inserted a new item or row it should show the corresponding rownum.
eg:
empno name serialno
5 tom 1
4 tinil 2
6 sofy 3
7 john 4
1 albert 5
2 michel 6
i want to get the above answer using forms.
View 7 Replies
View Related
Feb 9, 2010
I need Sequence generate in each row in tabular style form
Like
FA0015
FA0016
FA0017
(I dont want to use sequence because when i delete the row its conceder delete row in sequence )
View 4 Replies
View Related
Jun 22, 2011
I 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
View 1 Replies
View Related
Nov 26, 2010
I'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
View 8 Replies
View Related
Feb 20, 2012
I 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.
View 1 Replies
View Related
May 4, 2011
i 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.
View 3 Replies
View Related
Mar 2, 2010
how 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.
View 10 Replies
View Related
Dec 26, 2011
I 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.
View 6 Replies
View Related
Feb 8, 2013
KEY_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
View Related
Apr 22, 2010
My 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
View 12 Replies
View Related
Sep 14, 2010
We 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)
View 5 Replies
View Related
Aug 16, 2011
Is 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.
View 6 Replies
View Related
Dec 20, 2012
can we use set_block_property to program to switch multiple relationships. for example
if true then use relationshipA
else relationshipB
end if;
View 9 Replies
View Related
May 30, 2010
I 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.
View 1 Replies
View Related
Aug 9, 2010
I'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.
View 9 Replies
View Related
Jul 29, 2010
I 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 Related
May 11, 2010
I 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.
View 8 Replies
View Related
Jun 10, 2013
I 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.
View 1 Replies
View Related
May 21, 2012
ora-00000 normal successful completion error while populating data from Master block to Detail block in Oracle Forms 11g.
View 6 Replies
View Related
Nov 10, 2010
1. My detail form has part number as one of the fields and I want to make sure the user can enter a part number only once. How can I make sure user cannot enter it more than once?
2. I want to limit number of detail records for every parent record to 8. How can I accomplish this?
3. I have approval flags at both master and detail. If the user tries to approve the master with some/all detail records unapproved, system should display error message and make the user approve the detail before approving the master.
View 2 Replies
View Related
Mar 12, 2013
I have following table.
CREATE TABLE ABC
(
DPT_NUM NUMBER,
LOT_NUM NUMBER,
ASSOCIATED_WITH_LOT NUMBER
);
SET DEFINE OFF;
Insert into ABC
[code]......
Now i run follwoing query and result is
select * from abc
DPT_NUMLOT_NUMASSOCIATED_WITH_LOT
1501
1502501
1509501
1511
1503
1516
1522
1565
1569565
2601
2602
2604602
2607
2508
I need following result
DPT_NUMLOT_NUMASSOCIATED_WITH_LOT Serial_Number
1501 1
1502501 2
1509501 2
1511 3
1503 4
1516 1
1522 2
1565 3
1569565 3
2601 1
2602 2
2604602 2
2607 3
2508 3
Note that serial number must reset after each 4 lot_num againt dpt_num. Not that where lot is associated in associated_with_lot there serial number must be same as serial number is for associated lot.
View 7 Replies
View Related
Aug 4, 2012
I have one table as per the attachment, with id(Primary key),level,name and Srno.Now I want to maintain Sr. if user transfers level 2 of one block (level 1) to another block.is it possible through any oracle function.
View 8 Replies
View Related
Jun 30, 2012
I have two tables,
CREATE TABLE TBL_ID(
SERIAL NUMBER(3),
ID NUMBER(5));
CREATE TABLE TBL_ID2(
ID NUMBER(5));
[code]...
I want translate id from TBL_ID2 to TBL_ID, and make new serial as max serial + 1 I tried
insert into TBL_ID(serial,id)
select (select max(serial) + 1 from ),id from TBL_ID2
Desired Output after insert
select * from TBL_ID
SERIAL ID
------ --
1 10
2 20
3 50
4 60
5 90
View 3 Replies
View Related
Jul 31, 2013
I have follwoing Table
create table abc( prd_cod number,tax_num number, tkt_num number,shd_cod number,cnt_num number,ctn_num number);
Insert into ABC(PRD_COD, TAX_NUM, TKT_NUM, SHD_COD, CNT_NUM, CTN_NUM) Values (1, 1, 1, 1, 1, 1);
Insert into ABC(PRD_COD, TAX_NUM, TKT_NUM, SHD_COD, CNT_NUM, CTN_NUM) Values (1, 1, 1, 1, 2, 1);
Insert into ABC(PRD_COD, TAX_NUM, TKT_NUM, SHD_COD, CNT_NUM, CTN_NUM) Values (1, 1, 1, 2, 1, 1);
[code]...
Now i have following data
PRD_CODTAX_NUMTKT_NUMSHD_CODCNT_NUMCTN_NUM
111111
111121
111211
112111
151211
211111
I need to query above data with a column "Srl_Num". Its serial number and serial should like 'AA1','AB1'. In serial number is last digit 1 is "Ctn_Num" Column Value. First Letter 'A' of serial number is 'A' and second letter of serial number will change. When it reaches till 'Z' Then first letter will change.I mean if serial number is 'AZ1' Then next serial number will be 'BA1','BB1','BC1' and so on.
I need query to show data like
Srl_Num PRD_CODTAX_NUMTKT_NUMSHD_CODCNT_NUMCTN_NUM
AA1 111111
AB1 111121
AC1 111211
AD11 12111
AE1 151211
AF1 211111
View 3 Replies
View Related
Mar 27, 2007
How can i print serial no of records in sql query? I know I can achieve this with selecting rownum but it gives wrong data if used with group by like below
select rownum,deptid from emp group by rownum,deptid order by rwnum
View 2 Replies
View Related
