Hi. How can I include DATE RANGE search criteria in Faceted Search? (while I was trying, I am getting the following error. Facet is not supported for DATE or TIMESTAMP columns.) Thanks,
Discy Latest Questions
I am creating a collection in page1 and saving the collection name into a page item . Now I have to pass this collection to page 3 and use there. I used the page item where I stored the collection name as a parameter to page 3 and trying to use in page3 , but somehow it does not work. can you give some guidance Thanks George Thomas
Dear Vinish i want to create a login page with new user and old user authentication.. for eg if a user has user id and password he can login from login page. but if a user is new to he has to create login credentials.. currenty i have already created custom authentication as shown in your link 'https://www.foxinfotech.in/2019/09/create-custom-authentication-in-5-easy-steps-in-oracle-apex.html' i have also placed a link on login page 'to create new user press here' and redirected the link to another page in application but as i have created autentication i'm not able to redirect to other page from login screen thanks in advance can anyone help me out?
I am having form and interactive grid on same page in my apex application like header and detail part if i do change in Header and Detail both and press apply change buttton it shows me following error: No Primary Key item has been defined for form region INV_HDR. if i do change in only header part and perss apply change button changes get saved .
i am displaying image in my region i want to move to the left how can do it means on top of column yymm
I have a report in my apex app in which in report i have kept page items as parameters through which report gets displayed In which there are page items 1) id 2) image i'm trying to display image based on page item id , my image column gets image through "blob column return by sql statement" i'm not getting Image based on id i tried all dynamic action like refresh page item image when id is changed can any one help me out?
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 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?