Hi Sir, I have a question about a function that I call in a before-header process to redirect to the appropriate page. create or replace function redirect_page(p_user_name in varchar2) return varchar2 as v_redirect_url varchar2(100); branch_page table_1.PAGE%type; v_state table_1.STATE%type; v_finalpaper_id table_1.fpid%type; begin begin select fp.state, fp.page,fp.id into v_state, branch_page,v_id from table_1 fp left outer join users u on u.uuid=fp.uuid where lower(u.username)=lower(p_user_name); if v_state ='REQUESTED'then v_redirect_url:='f?p=100:95:&APP_SESSION.::NO::P95_ID:'||v_id; elsif v_state ='APPROVED'then v_redirect_url:='f?p=100:92:&APP_SESSION.::NO::P92_ID:'||v_id; end if; exception when no_data_found then v_redirect_url:='f?p=100:1:&APP_SESSION.::NO::'; end; return v_redirect_url; end; Now, when I call the function in the page, I get the 500 Internal Server Error DECLARE v_redirect_url VARCHAR2(100); BEGIN v_redirect_url:=redirect_page_finalpapers(:session_user_name); htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; I don't quite understand why this happening and would appreciate some help on here?
how to set column at end of report in interactive report.if user add more column from action then which we set column at end remain at end ????
Hi! I am trying to trim spaces in the IG column - Popup LOV search, for instance, when I copy and paste text with space before the first letter I can't get results, without space it works. How to trim spaces in the search box? Thanks in advance!
In Oracle Apex, in master-detail form, my detail is interactive Grid I want calculation on runtime like when I give some value in the amount column in the first row then add a row and again I input some value in the amount column both rows some show in page item in master on runtime
HOW TO FIX COLUMN OF INTERACTIVE GRID, IF QUERY HAVE 20 COLUMN IM DISPLAYING 10 COLUMN .AND COLUMN 9 AND 10 FIXED ,IF I DISPLAY REAMING COLUMN THEN COLUMN REMAIN FIX . AT LAST , ANY IDEA ?
Hi Vinish i'm trying to create master detail form manually in Oracle Apex 21.1 There is a physical relation between two tables in Database . 1- i have created master region (type : Form)and switch on Primary key Column 2- after that i added a new region(type : IG) , but here in Master Detail property i can not see other region shown in list ... Please tell me what is missing ,
I have an Editable Interactive Grid and a Classic Report in my page. Requirement : A classic report region should be shown when the compliance_code value is selected as "ESCALATION" in the Interactive Grid. Note: Unless and until the compliance_code value = "ESCALATION" exists in the Interactive Grid list, the Classic Report region should be visible. Once it is changed or not in list, the Classic Report region should be hidden. On clicking a Add Row button a new row will be displayed with 4 columns.(compliance_code(Select List value), Reason, Notes, Remarks) By selecting the below values, Row 1. Compliance_code = "Testing" Row 2. Compliance_code = "ESCALATION" Now the classic report region gets displayed. On clicking Add Row for the next record, Row 3. Compliance_code = "Performance" The region should still be displayed. On changing the 2nd Row (2. Compliance_code = "ESCALATION") value to some other value The region should be hidden.
Hi Vinish, We have created interactive grid and now we want to display Child report as Nested Report if i click on ID then child report will be display. So that I have used Plug in "Pretius APEX Nested Reports" . I have created it first with my Workspace account and working fine but when I implement it in our customer application then it's not working fine . workspace Details: DEMO_RESTFULL mano80kaushik@gmail.com Testonly Can you please prepared one demo how to add Nested Report in Interactive Grid Thanks Manoj
Hello, I have a requirement to call Oracle forms (.fmb) from Oracle Apex form button click. Can you please suggest how to do this? Thanks, Supriya Jain
Hi, I am trying to show a extra value with Text Field as Filed Number, How it can be achieved. for more detail see the below image. See yellow box with numbers. Thanks