Is it possible to have a Master Detail Interactive Grid using a View with Instead of Triggers so that in the Master I have records with INTERFACE_TYPE_CODE = 1 and in the Detail I have INTERFACE_TYPE_CODE = 2. For example I have MASTER based on Select TABLE_SK, VALUE_SK, ACTIVE_FLAG , INTERFACE_TYPE_CODE, TABLE_NAME from LOOKUP_TABLE_V where INTERFACE_TYPE_CODE = 1 Detail based on Select TABLE_SK, VALUE_SK, ACTIVE_FLAG , INTERFACE_TYPE_CODE, TABLE_NAME from LOOKUP_TABLE_V where INTERFACE_TYPE_CODE = 2 The Primary_Key is VALUE_SK. The Table_Name can change over time but only one Table_name would be active at any given time. In my application, I get an error saying that there must be the Table_Name defined for the Detail even though I do not have anything entered because I want to have the option of going back and adding the records at a later time. I used to be able to do this in Oracle Forms
hello, I want to show sum of (qty from detail block) in total_qty in master block just like Oracle forms in Oracle apex but dynamic action is not supporting me in this regards as dynamic affected item is also from same block but I want to affect item from master block not from same (detail) block what should I do ?
Figure 1 Figure 2 Figure 3 Hi guys! I would like to ask is it possible to update a field in another table using a form in Oracle? So my situation is like this: This is an equipment borrowing system. I have created a report and a form for my first table Record (figure 1 and 2), which saves the record of people borrowing the equipment. At the same time, what I wanted to do is when an equipment is being borrowed away, the availability will change from 'Y' to 'N' (figure 3) , and all these will happen when I click the 'Apply Change' button in Figure 2. May I ask if it is possible to do so? thankyou so much as this homework is super important for me!!
Hi Vinish and Team, We are using Forms 184.108.40.206 on Linux Platform. Here is what we have a requirement of the new column highlighted by me in the attached image. We have added the Exposure Time Diff column and exposed in Data Block and in respective Canvas. You can see that the first row of this column will always be blank and then the second row will be the exposure time of the second row minus the exposure time of the first row (2.25 – 2.00), and the same moving down the rest of the rows. Please help with the best approach to meet this requirement. Thanks, Babu N