I'd like to know, if there is a capability to create a Master/Detail Form with two ore more Detailregions on one page. I use APEX 4.1.
View 1 RepliesI 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 RelatedI have created a master-detail form. The detail columns are created as report columns instead of getting created as Items. I need to make a column non-editable.
View 1 Replies View RelatedI have created a master detail form , in which many validation etc is done ,the MASTER is a FORM and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:
,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where
Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---
i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ).
In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items ( here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..
I am using the Master-Detail wizard in APEX, but am not able to pass the existing Master KEY to be used in my Detail part. and I receive error:
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process.
I am using APEX 4.0. I have created a master detail page , the business logic is “ We can save master record only if there is at least one detail record exist.”
But current wizard developed page has functionality that I have to save master first then only I can add detail record. I want to save them together.
I have master and detail table , in detail table i want to build tabular form manual , i want to insert , delete and update in detail manual tabular.
tables i use :
CREATE TABLE "DISTRB_PLAN"
( "PLAN_ID" NUMBER NOT NULL ENABLE,
"PLAN_NAME" VARCHAR2(200),
"PLAN_DESC" VARCHAR2(2000),
"PLAN_NOTES" VARCHAR2(2000),
CONSTRAINT "DISTRB_PLAN_PK" PRIMARY KEY ("PLAN_ID") ENABLE
[code]....
i am try to build master and detail i use Edit detail on separate page , but when i want to create new record in detail page the master column is display and not retrieve the value .
the example in my workspace
http://41.41.94.126:8080/apex/f?p=102:10:2106214435268201::NO::::
user login : ahmed
pass : 123
workspace : spark
user : saied
pass : 123
When i create report in master detail. When detail record end on the page, the second record show on same page. Problem is that detail show on other page. I want that if record is completed on that page then ok. Otherwise it show on next page.
View 3 Replies View RelatedI have a master detail form. I have one column in master, which is a free text field and one in detail block which is a LOV. When I enter data in the master block and select say A,B,C records in LOV in detail block and saved it. These A,B,C records in LOV shouldn't appear in the detail block when a new record is entered in the master Block.
View 3 Replies View RelatedI 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 RelatedI have a master-detail form, before filling up all the item in master cursor should not go to details, if user clicks in detail he should get a message.
When I am pressing ENTER to navigate from one item to another is asking'do u want to save the changes'.how to control this message and when pressedenter cursor should go to next item.
I have a contact table that will be used for more than one entity (Customers, Sites, Suppliers, etc.) Using APEX, when we define the master-detail, we need to add a FK to the Detail table -- otherwise the Master-Detail Forms can not be implemented.
I am looking for a way to defined/implemented tables so that I can utilize the same table (Contacts) for more than one Master-details relationship.
I am new to the Oracle Forms.
I need a Master Detail oracle form for Oracle EBS.
The form should use only one table.
I need the form should look like User Form in EBS.
I created 2 data blocks and designed. When I run the form and key in some data, I notice multiple records stored.
like
Empno Ename Sal Comm
101 null null null
null John 2300 500
Empno is in Master Block.
And remaining are in Detail block. How to remove the duplicate records so that my required output should be like
Empno Ename Sal Comm
101 John 2300 500
MASTER-DETAIL FORM HAVING AN LOV IN THE MASTER .LOV SELECTS THE PRIMARY KEY FIELD FROM THE MASTER TABLE AND IN LOV PUSHBUTTON HAVING A TRIGGER WHEN BUTTON PRESSED
Declare
bool boolean;
begin
bool := show_LOV('PURCHASELOV');
[code]...
WHEN SELECTING THE ITEM THROUGH LOV IT EXECUTES ALL VALUES BUT AFTER CHANGING ANY DATAS THEN NEW RECORD IS CREATED IN THE MASTER TABLE AND NO CHANGES OCCURED TO THE CHANGED RECORD.
how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.
View 6 Replies View RelatedI 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.
I have a master detail screen where the detail region is a tabular form. I want to create a new master and detail records at the same time. The master uses a get PK process on submit that gets the PK from a sequence.
Obviously I need to set this value in the FK column on the new detail records on submit also, but I just cannot see how this is done. Fine for updates etc, but this is when the master is new as well. A two stage process is not an option here.
I have stacked into something: if there is a way to define a single row form page based on table in which I could query and update without using a tabular page (to call the single row form). I want only to use only one page. Does APEX has this functionality?
View 5 Replies View Related1. I m building a form in which students will file some data (name, address, etc) but i want to send a parameter on the URL i send them (their student ID number), which will be saved together with the data the end-users save.
e.g the form i m building is [URL]
can i add in the end of the URL the student_id of the end of the URL?
so it will be something like [URL]
So when student #10 will hit the URL on his browser, once he inputs hsi data and press SAVE button, on the database i can save STUDENT_ID=10 and the rest info he just entered?
2. Which is the login URL for end users? i have only the workspace login now..
How to make fields on form-page more accurate? I want make fields one under another one, and control the distance between them.
View 3 Replies View RelatedI have to create a tabular form, in which I have each row having an address information in it. I need to individually geocode each of these addresses and process it from the page (I have a web service to do the geocoding) .
How can I process each row of a tabular form individually from a page?
my 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.
I 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 .....
After setting up a data entry page,The logic in my page requires that all the records in my tabular form should be displayed .The tabular form is based on a collection, and the user selects rows through a checkbox.Any reload of the page due to pagination will break the logic, as some calculation and display events occur during page load, based on the previous page.
I need to display about 25 rows.I have changed the report attribute to display 50 rows, but it displays rows only up to the bottom of the screen, i.e. 11 rows.
Unfortunately I only just added some new rows and saw this behaviour else I would not have gone that way, as I expected APEX to display all rows if required.
I am not able to refresh tabular form region on close of the modal page.
View 6 Replies View RelatedI have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.
I am using apex 4.1
I have a report that contains a name that I want to pass in to a field in a form on a different region on the same page. My button located on the report is has its own column called ADD_LINK. Here is the button.
<button id="apexir_btn_ADD" class="apexir-button" type="button" value="Add" onclick=""><span>Add</span></button>
Once that button is clicked, I have the form region fade in. The region is called Add Tag to Employee, which has P4_ROWID, P4_EMPLOYEE_ID, and P4_TAG_ID. Once the region is displayed, I want the #NAME# to show in the P4_EMPLOYEE_ID.
I did copy this form from another page, where I had it working before. It made more sense to move it to this page for interface purposes, so maybe that tidbit will work as well.
I am using Skilllbuilders modal page 2.0 to edit the form. Sometimes, the end user clicks on the edit link to trigger the modal page and sees the form , but he/she could not do any changes. Thus, when clicking Apply Changes button, we will be redirected to the page 102 ( the empty page ). How can I get around and make the page 102 to close automatically in case I am redirected to it ?
I put this in a JavaScript a dynamic action to be fired as page loads:
$(document).apex_modal_page('close');but nothing happen.
I have 20 item fields in same form. i need to align them in sequential manner. For example x y z abcl m o p q r s xyzabclmopqrs are the items to achieve this what i have to do...
View 2 Replies View Related