I am working in form 6i, EBS 11i. I have below requirement to achieve.
I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.
I Require to Fetch the Group of Value in Item Block Selected through the User Selected LOV Value in Master.
Through Loop i Fetch the Records in Item Block.
When User Change the Selected LOV Value Require to Clear the Item Block.
BEGIN
FOR NRM IN (SELECT MTRLTYPE,STATUS,
MTRL_NO,MTRL_ID FROM JAWOADMIN)
LOOP
GO_BLOCK('NRMTRL_ITEM');
:NRMTRL_ITEM.NRMTRL_TYPE := NRM.MTRLTYPE;
:NRMTRL_ITEM.REMARKS := NRM.STATUS;
:NRMTRL_ITEM.NRMTRLREF_NO := NRM.MTRL_NO;
:NRMTRL_ITEM.NRMTRLREF_ID := NRM.MTRL_ID;
NEXT_RECORD;
END LOOP;
END;
How to Clear the Block before the above loop.
i have 4 blocks in one form.my requirement is this that can i user the clear_block or any other built-in for clear the specific block....
View 2 Replies View RelatedHow can we design a form with header level and line level. here i need to place a button in header section.when we press that button, line level values should be populate.
View 1 Replies View RelatedI am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.
how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.
When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.
What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.
I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.
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.
I am working on form builder 6i.I have FIND widnows and MAIN window.
FIND Window: contains field1 and field2, FIND Button.
block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.
If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.
:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2
In Block B--> When-New-Block-instance(Block Level)
select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;
and populating data in block B.It's working fine.
REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)
CLEAR_BLOCK('NO_VALIDATE');
But it's not working.In which trigger i have to write code to clear block.
I have two blocks.In header 2 columns are there same columns in line how to populate default values in line level based on header?
View 1 Replies View RelatedAfter running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!
View 4 Replies View Relatedi 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.
I am creating a form with 3 blocks.
Control block,
Header Block,
Detail Block.
First i have entered a record in the control block.
Then i navigate to header block,entered the first record for Header Block.
Then i navigate to Detail block,entered the first record for detail Block.
then i again navigate to Header Block..
Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".
Condition 1:i dont want that message to appear for every header record i enter.
Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.
I have a master detail based transaction form, i want to create three check boxes on header block, based on selection sorting must happen on detail block which has three fields, for example there are three fields item_code,item_name,item_qty, if user selects first check box then sorting will be on item_code, if he presses second then sorting should be based on item_name, likewise if he presses check box three then sorting will be based on qty, if choses two or more fields then sorting will according to that combined order.
View 4 Replies View Relatedhow to display check box selected records in one column of form when push button is pressed.
View 1 Replies View RelatedI need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..
the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....
I need to reset the line number for each header values.
create table header_table(header_value varchar2(100));
create table line_table(header_value varchar2(100), line_number number);
insert into header_table values('ALAOF');
[Code]....
But My line table output looks like below
LINE TABLE:
header value line_number
ALAOF 1
ALAOF 2
ALAOF 3
[Code].....
I am trying to create standby with oracle 10g R2 from Solaris 5.10 (sun ultrasparc X86-64 bit) to Solaris 5.10(Intel Xeon 64 bit). All the mount points are the same as primary server. All the data files are at location as specified in control file. I created standby control file from primary. All the control files are at location specified in pfile.
When I am trying to mount database I am getting following error.
ORA-00202: control file: '/oracle/BP1/ctl1.dbf'
ORA-27047: unable to read the header block of file
ORA-205 signalled during: alter database mount...
I try to open database with trace file also but got following error..
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/oracle/BP1/sapdata1/system_1/system.data1'
ORA-27047: unable to read the header block of file
I want to delete records from block in the form.could you explain where(in which trigger) should i write set_block_property.
View 9 Replies View Relatedis there any way other than this way to retrieve the number of record displayed in the block ?
last record ;
l := :system.cursor_record
I have 2 blocks, namely addsubject3rd and chosensubjects. I'm copying the selected records(this comes with checkboxes) from the 1st block to the second block. But what happened is that it copied all the records that are on the addsubject3rd. How can I copy only selected records(checkboxes) from addsubject3rd block to chosensubjects blocks?
View 5 Replies View Relatedi have a cursor which selects the codes based on the school records now i have a multi record block b1 the requirement is that if no of records selected in cusor is 10 then in block b1 10 records should be displayed and if it is 15 then 15 records should be displayed. Is there any way that i can set the no of records displayed in a block dynamically.The block b1 is non database block i am only using a create_record to populate the block.
View 2 Replies View RelatedI 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.
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.
i want to retrieve records of empno from SCOTT.EMP talbe in form but without data block wizard using ..how .. and what logic will be in coding
DECLARE
TYPE EROC IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
E1 EROC;
NO_EMPNOVARCHAR2(2000);
[code]....
just caling here EMPNO and :v_empno is fields on form...
Version information:
Forms [32 Bit] Version 10.1.2.3.0 (Production)
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
When an user enters a value in a field of a Screen, I want to query up the next screen records based on that user input value in the previous screen.The previous screen is based on a control block i.e.
Q_EMP
items- Q_EMP.emp_id, Q_EMP.FY, Q_EMP.hire_flag.
I'm using Oracle forms 10g. In the form i have this multiple records under one block. After performing the query, all records are cannot be updated. And i have this buttons at the right side that will enable the certain item that can only be updated. My problem is i cannot enable the item in the first record,instead of first record all records in that item was enable.
View 8 Replies View RelatedI need to filter records in a datablock based on Yes or No criteria.So i created a listitem(INCLUDE_ZERO_QTY_ITEMS) for that and i am using following code in WHEN-LIST-CHANGED trigger.
BEGIN
IF :XGEC_SW_ITEM_LOAD_ITEM_DETS_V.INCLUDE_ZERO_QTY_ITEMS = 'Y'
THEN
GO_BLOCK ('XGEC_SW_ITEM_LOAD_ITEM_DETS_V');
SET_BLOCK_PROPERTY ('XGEC_SW_ITEM_LOAD_ITEM_DETS_V',
default_where,
'1=1');
[code]....
I am able to filter the records but the list item is not displaying initial value and the value that i am selecting from poplist.
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.
In a master and detail relation ship block..When a cursor is placed in the details and enter some thing and giving back space..once value is cleared a empty record is saved in the database with the header values , but in details customer didn't enter anything.
how to clear the detail record in pre insert or when validation ?
I have 2 text fields as search criteria and a push button to search. When the user enter any on first field (or in any text field) and press ENTER key, I want to execute the search.
I tried the key-next-item trigger, but it's firing when I press TAB key.
How can I detect ENTER key?
I have got a form with 3 buttons and when these are pressed determine who is logged in, what role they are and if they are a certain role go to another block, if they are not that role flag up a message. I think I need to create a function in the database along the lines of -
create function user_has_role (p_user in varchar2 default user, p_role in varchar2)
return boolean
as
select * from dba_role_privs where p_user = GRANTED_ROLE;
end