Hello:) I have a very general question. I am creating a process in which the user and other users have to go through several process steps. First step: User fills out and submits a form. By submitting a form, it should trigger an action which inserts data into a table. One Table is the described process step ("FORM_SUBMITTED", in here all relevant information will be stored, who submitted a form and when etc.) When the user logs in next time , he then sees that now another process step is initialized (for example another user must proceed an action). Question: For inserting data into the table, I thought of using a trigger, but I am not quite sure if this is the right way to go in APEX. When the user logs in next time, how can I display the current situation of a process to him (like in the picture, for example he sees that the second step in the process is initialized). I here thought of one solution: Creating a table which has following columns: the user-id and the different process steps. When a process step is done, the corresponding column in the table is set on true. When the user logs in next time, ...
Discy Latest Questions
Hello everybody, I am in the process of creating a confirmation page in which all of the user's previous input data will be stored and displayed on this page. For this I use APEX_COLLECTIONS, which temporarily save the input data on submit. Since I also use radio group return values, which usually return a numeric value, I store them in the collection numeric values. But I want that the Confirmation Page does not show me a numeric value, but the text which stands for it. Can someone give me a hint how this can be achieved?
Hi everyone, I have a function on DB with code below as: begin -- Call the function :result := WFL_PKG.Check_Validate_Action(P_TRAN_ID => :P_TRAN_ID, P_User_Name => :P_User_Name, P_Action_Type => :P_Action_Type, P_DAYS => :P_DAYS); end; When I test it by my parameter, it returns 'TRUE'. It is right for me. But when I check it on the web with the same parameter, it returns FALSE. Now I see when P_DAYS is interger like 1.0, 2.0, 3.0,.. DB and web return same value, when P_DAYS is float like 0.5, 1.5,... DB returns right value while web return false value. I use the function on server-side condition and I test many type of server-side condition, ...
For example: I’m having an item :P1_SALES And I want to enter 1000+2000-1000 And it will give me 2,000 on the same item :P1_SALES Note I’m using a plug-in(AutoNumeric) for my input format
Hello, when I modify a query in Form, IG, Interactive report, Classic report page Apex clear all query and leave null value in Sql Query field. If I choose as Source Type Table/View Apex save and runs page fine. Attached: the problem image files: before and after saving the page. Also the 2 file of the debug error. Have someone idea of how to solve this issue? Thanks. Dario
Hi, I want to capture the column level changes of particular table. Is there any way or workaround to access the old and new values for particular table as number of columns in a table can be more than 50 and we want to audit all the columns and I'm thinking of storing the audit of all the tables in one table. Any help would be highly appreciated.
I have two regions one form and one interactive grid like a master detail. how i can make the interactive grid mandatory ,the user can't submit page ,he/she need add at least one row in interactive grid
Hello, I am trying to create waterfall charts using Oracle Apex 20.1 with two series. One as a stack bar chart grouped by month and the second series for the increase resp. decrease of the values over the month. Please see the attached media for more details. In Oracle Apex 20.1 I didn't managed to combine the bar chart with a range bar. In the second series (i.e., range bar) the series isn't shown in the chart. Moreover, the increase resp. decrease should get its high from the previous sum value. Is there any possibility to do with a lag() function or something similar. The range bars don't have to be stacked(see picture 2) Any idea on how to get this done? Any help is appreciated. Thank you. Kind regards