User Info

Rebecca

Name:

Website:

Location:

Last Seen:

Nov 27th, 2018

Description:

 

Avatar

RE

101 Questions

ThreadPostedQuestion
File size error in FOEX File Browse Item - FOEX 3.1.027.11.2018 13:11 Hi, We are encountering an issue in FOEX 3.1.0 when trying to upload larger files. Attaching the screenshot of the issue. I tried in the previous version , and it is working fine. Let us know if you are already aware of this issue and you have a hot fix for this.
FOEX Grid After Edit not working as expected03.07.2018 08:07 Hi Matt, We are encountering an issue in FOEX v3.1.0. I have created a test case in the trial workspace, but unfortunately its working fine. Not sure this was reported earlier and fixed in v4.1.0 https://trial.tryfoexnow.com/ords/f?p=1065:4:16827674077876::NO   So when i am trying to check the checkbox(in the eg ' isadmin') column, I have a JS (After Edit) which will concatenate all the employee id values of the checked records. But what we noticed is, it requires the check/uncheck to be done slowly. If it is done a little faster, the item in the session does not have all the values, but some random values. When we tried giving a FOEX Delay true action of 3000 ms or so, then it is working fine. Is this some thing you have encountered and have a fix already since it is working fine in your trial work space.
FOEX Form Item 'Source Type' settings.02.07.2018 05:07 Hi Matt, Would like to understand how the below options work since we are facing issues with the below setting. My understanding is For items with source type  Database Column , it should be Always  as the description mentions.   We are opening a form (another page) on a window, we could see the values for the items are getting set in the session but do not appear on the UI.
FOEX Chart Labels issue in FOEX 3.1.018.06.2018 09:06 Hi Matt, We have an issue while using charts in FOEX 3.1.0. We have a layout similar to the one that we have created on the trial instance. X axis labels are not displayed , its appearing only when its zoomed in to around 67% and less. https://trial.tryfoexnow.com/ords/f?p=1065:3: This was working fine in the previous version.  Our understanding is the charts are scalable and adjusted accordingly to the number of regions on the UI and data available.
Unable to save checkbox values Y/N in FOEX 3.1.004.06.2018 11:06 Hi Matt, We are not able to save checkbox values in FOEX v3.1.0, though the length of the field is 1 byte as stated in the below thread, https://forum.tryfoexnow.com/en/f?p=1111:20:5193299921930:::20:P20_THREAD:3806 This was working perfectly fine in the previous versions.  Please let us know if this will be fixed in the next hotfix.
Unable to upload file -FOEX 3.1.001.06.2018 05:06 Hi Matt, On our Apex 5 and  FOEX 3.1.0 instance we encountered an issue where we were not able to upload file. On debugging we found that its because of the below validation. Seems like the n001 is no longer storing the page_id. Was this intended. 
Blank values in Grid returning as 'null'18.05.2018 06:05 Hi Matt,   We noticed an issue after applying hotfix HFXP-3137. Through out the application, the columns in the grid for which value is not entered is returning 'null'. This was not the scenario before and it used to returned nothing. This is affecting the JS validations in the application. Please let us know if you have fix for this.
Display Extra Values in the FOEX Select List - Grid25.04.2018 15:04 Hi Matt, The 'Display Extra Values ' option is not working as expected.  The column is shown blank on the screen. This is reported in Apex 5.0.4 and FOEX 2.2.0. This is working fine in v2.1.1.
Cross site scripting issue15.02.2018 05:02 Hi Matt, As part of the penetration testing, we encountered an issue where&nbsp;when trying to save the following content in one of my field(e.g name) and save it ,&nbsp; XSS<img src = x onerror=prompt(1)>; And when trying to edit the form again, it is executing the JS and throwing an alert.&nbsp; Though we decided to validate the HTML tags before insertion itself, am posting this, since&nbsp; we noticed it is happening only at the DA where we using this field value for displaying on the window title. And not on the form load. Attaching the DA where this is triggering.
FOEX Invalid Objects-Oracle 12c and Apex 519.12.2017 05:12 Hello Matt, Our DBA were trying to install FOEX on the newly created environment with oracle12c with apex 5, we got 13 invalid object in FOEX.&nbsp; Can you please help us on this. I will forward the list of invalid objects and the errors to the support email.
Sorting issue on FOEX Tree Grid05.12.2017 10:12 Hi Matt, We encountered that sort on a tree grid works only on the current pagination and not for the whole data that is fetched by query. Is this something you are already aware of and fixed. Please let us know on the fix or workaround for this. This is on FOEX v2.1.1.
Report error when column named with 'FX'31.10.2017 12:10 Hi Matt, We have an issue, where we have a column named BLD_FX_DATE. When the dynamic query is getting formed, the UI errors out with 'BLD_DATE invalid identifier'. Seems like it is replacing the FX internally. Is this something that has already been reported or fixed. Please let us know if we have a fix for this.
Error Network Communication Failure -Tree Grid search25.10.2017 09:10 Hi Matt, We are encountering a weird issue on the tree grid search. We are launching the application from two different URLs i.e. SSO and non SSO. When trying to search from the SSO url, we are getting the error as in the below screen shot. The same scenario is working fine when launched through the non SSO URL. Can you please let us know what could be the issue. Let me know if you want more details on the same.
Remove the modified grid cell color21.09.2017 06:09 Hi Matt, Is there any way i can remove the red color of the modified grid cells for one particular page.
Issues after Foex upgrade21.08.2017 11:08 Hi Matt, We have upgraded our instance to FOEX v2.2.0 with Apex 5.0.4. The pages that were working fine with v2.1.1 are breaking. Following are the issues that we are facing: 1.)This was there in the comments , but we dont have anything like comments at column level in report in v2.1.1 ext${ ,"fxDefaultExpression":"V('P5226_TABLE_CONDITION')"}$ext 2.)Values are not getting saved in the grid that are setting using Javascript. For e.g. something like this. this.data.record.set("INDICATORS",'YYYYYYYYYNNNNNNNNNNN'); I will try to replicate in demo instance and let you know. Both the issues are through out the application. Please let us know on this.
Periods names are showing different in Export Excel sheet and in Report Data is not showing in Chronological order06.07.2017 18:07 Hi Team, Periods names are showing different in Export Excel sheet and in Report Data is not showing in Chronological order. Here with am attaching the details and exported file for your reference. url : http://demo.tryfoexnow.com/apex/f?p=700:1111:16810412191014::::: Please let us know if you need any additional details. Table Creation Script CREATE TABLE "EMPLOYEES" ( "EMPNO" NUMBER, "EMPNAME" VARCHAR2(455), "DEPTNAME" VARCHAR2(445), "START_DATE" DATE, "END_DATE" DATE, "ENABLED" VARCHAR2(1), "SEQ" NUMBER, "ID" NUMBER, "ID1" VARCHAR2(10), "END_DATE1" DATE, "END_DATE3" DATE DEFAULT (to_char(sysdate,'MM/DD/YYYY')), "EMP_ID" NUMBER(20,0), "PERIOD_NAME" VARCHAR2(240), "PERIOD_ID" NUMBER ) / Thank You Rajasekhara
Java script unique validation on foex grid is not working correctly, if the duplicate record is not available in first screen of the grid03.07.2017 10:07 Java script unique validation on foex grid is not working correctly, if the duplicate record is not available in first screen of the grid On click save we have the JS validation var v_grid = Ext.getCmp('PG5560_INT'); var src_arr = []; var valuesSrc = []; var v_err=''; var v_dup_cnt=0; if (v_grid) { v_grid.getStore().each(function (record) { if (record.get('DEST_COLUMN')) { var v_src_val = record.get('SOURCE_TABLE')+':'+record.get('DEST_COLUMN'); src_arr.push(v_src_val); } }); } for (var i = 0; i < src_arr.length; ++i) { var v_semt=src_arr[i]; if (valuesSrc.indexOf(v_semt) !== -1) { v_dup_cnt=v_dup_cnt+1; break; } valuesSrc.push(v_semt); } if (v_dup_cnt>=1) { v_err= v_err + 'Destination Column should be unique. '; } else { alert('hi'+v_dup_cnt); } $s("P5560_JS_ERR_MSG",v_err);
Increase height of Text Box28.06.2017 07:06 Hi Team, We need to increase the height of the text box. Could you please let us know how we can achieve it without using text area. For some reason we are not using text area.
Getting wrong excel name when export data14.06.2017 12:06 Hi Team, We are populating a value to an item using computation. We need to get the item value as a header in the exported file. We are using &P7_TITLE. in grid query. Using this we are not getting the expected result in the exported file. Please find the below link for the test case. http://demo.tryfoexnow.com/apex/f?p=700:7:288327624127:::::
Hyper Link in column08.06.2017 12:06 Hi FOEX team, I have a issue where i have saved hyper link in one of the database column and i am displaying it in the grid as a link, on click of which it should open the link. When the link saved has https:// then it is working fine. If no, for example, if it is saved as 'www.google.co.in', then on click of it, it is getting formed as below 'http://demo.tryfoexnow.com/apex/www.google.co.in'. When we try to give as below, it worked for www.google.co.in and blanked for the rest. Have setup a working example on http://demo.tryfoexnow.com/apex/f?p=700:500:. Can you please help on this.
Error while using grid search07.06.2017 10:06 Hi, We are getting the following error when we use search option in Readonly grid. Could you please help us to resolve this. "ORA-01489: result of string concatenation is too long"
Page performance Issue22.05.2017 12:05 Hi Team, We are on v2.1.1. One of our main pages that has around 9-10 content loader regions and one tree grid(dynamic query and dynamic headers) is taking considerable time to load(around 20 secs) but has around 10-15 records only. All the page processes look fine. Can you please guide us on anything that can be done to improve the performance.
Error "Network communication failure"11.05.2017 07:05 Hi Matt, We have installed our application on Apex 5 and database Oracle 12c. We are trying to upload a file using the file browse item. But we are getting File Upload Exception - Network communication failure. The solution mentioned in this link is already in place. http://forum.tryfoexnow.com/osqa/questions/4629/error-network-communication-failure-when-save-uploaded-image-file Can you please help on this.
Column header gets moved in FOEX Grid03.05.2017 12:05 Hi, In a FOEX page, I am having a FOEX grid in which the column headings are derived using PLSQL (Function returning colon separated values). The column heading for the first column is NULL. The grid looks fine in the page but while exporting , the header gets moved. Please refer the sample application having the same scenario in the below mentioned URL http://demo.tryfoexnow.com/apex/f?p=700:75 Right Click the grid -> Export to download the grid
FOEX chart - label issue17.04.2017 12:04 Hi We are having a foex chart plugin for which we have values displayed as y-axis label. The values are not sorted in an order as we have for normal chart. Please help us with this issue. Thanks in advance! Rebecca
Not able to get 'Not Equal to' symbol in export22.03.2017 10:03 Hi Team, If we have <> symbol in the grid, we are not able to get it in the export. Please find the test case in the below link. http://demo.tryfoexnow.com/apex/f?p=700:500:2369307096941::::: please do the needful at the earliest.
Unable to login to application in APEX507.03.2017 07:03 Hi, We have imported our application that was developed on APEX 4.2 and FOEX 2.1.1 into APEX 5. The login page itself did not come up and we are getting this error. A System Error Occurred During Processing. Contact Administrator Technical Info (only visible for developers) is_internal_error: true apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR original message: Error in PLSQL code raised during plug-in processing. original_additional_info: ORA-20001: The viewport must have at least one pane defined ora_sqlcode: -20001 ora_sqlerrm: ORA-20001: The viewport must have at least one pane defined component.type: APEX_APPLICATION_PAGE_REGIONS component.id : 180409351856917383 component.name: ViewPort error_backtrace: ORA-06512: at "FOEX_020101.FX_P_VIEWPORT", line 2048 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2107 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1033 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1047 ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_050000.WWV_FLOW_PLUGIN", line 1177 error_statement: begin declare begin wwv_flow_plugin_api.g_region_render_result := fx_p_viewport.render_plugin (p_region => wwv_flow_plugin_api.g_region,p_plugin => wwv_flow_plugin_api.g_plugin,p_is_printer_friendly => (:p_is_printer_friendly='Y') );end; end; Seems like issue is with just that particular application, since there are other FOEX applications in the same workspace and we are able to login into those. The difference between the application with issue and other application FOEX Developer Add-on details are as below: Other Application Developer Addon (FDA) APEX Enhancements: active - FOEX Enhancements: active - Version: 3.0.0.4 / 5789 / V2.1.1 / 5334 App 941 (Issue) Developer Addon (FDA) APEX Enhancements: active - FOEX Enhancements: active - Version: 3.0.0.4 / 5789 / unknown / 5334 It would be helpful if you would be able to give us inputs on what could be missing. P.S We also have tried to dro
Freeze column functionality on Tree Grid04.03.2017 18:03 Hi, Do we have freeze column on Tree grid. According to the below thread, its mentioned that it would be available from v2.1.0. We are on v2.1.1, but am unable to find it. can you let me know if am missing something. http://forum.tryfoexnow.com/osqa/questions/4198/foex-tree-grid-freeze-column
Formatting on a bar chart03.03.2017 14:03 Hi Matt, Am trying to use format on my chart query as below. The region comes up with no errors but the graph disappears. select id AS ID, NULL AS LINK, name AS LABEL, '#LABEL# - #VALUE#' AS TOOLTIP, to_char(SUM(amount),'999G999G999G999G990') AS VALUE1 from test Before adding the format After adding the format
Browser Compatibility Check03.03.2017 11:03 Hi Matt, There has been a check on the compatibility on different browsers. And we noticed that For one of the tree grid, the expand all functionality having 49 records - Chrome response was 45-60 sec and IE - 160+ sec. Since the standard browser for most of our clients is IE,we would like to know if there is something that can be done. I have also checked the compatibility matrix at https://www.tryfoexnow.com/en/foex/foex-plugin-framework We are on v2.1.1.
Refresh title of content loader region22.02.2017 16:02 Hi Matt, I have a Grid where I am opening another page using a content loader region as a tab. One of the process update in the child page requires the tab title of the content loader to be refreshed. Is it possible to do this. If so please let us know the required details.
Tree grid search clear issue20.02.2017 14:02 Hi, We have a tree grid for which clear search is throwing the below error Exception: Widget handler does not exist. Please help us resolve this issue. Thanks Rebecca
Page is taking time to load20.02.2017 07:02 Hi, In one of our client instances, some pages are taking time to load. When we tried debugging the issue we found that Initialise form meta data takes more time to load. We will forward the log file in mail. Thanks in advance! Rebecca
Colors on column chart02.02.2017 14:02 Hi Matt, We are trying to give different colors for column chart. We are not able to achieve it. Please help us on this. For Eg, We have 3 column chart in a page and using 2 different colors. We need to show alternative colors.
Unable to display more no of columns in a tree grid12.01.2017 15:01 Hi Matt, We are trying to display more no of columns in a tree grid but we are not able to display it. Getting exception message available in the image. Please help us to avoid this.
Insufficient privileges in fetching LOV query on grid.11.01.2017 11:01 Hi Matt, We are facing an issue while for an LOV in one of our editable grid which is same as the below thread. http://forum.tryfoexnow.com/osqa/questions/2416/grid-gives-ora-01031-insufficient-privileges It is working fine in all the other instances. When we run the query in the database its working fine. Not able to debug what is the issue. Would you please help us know the reason for the same. I can send the debug messages if you want.
Error in FOEX message box - Cancel action24.11.2016 11:11 Hi We have a FOEX message box in one of the forms. When we add a PL/SQL block to No/Cancel PL/SQL, we are getting the below error on page while cancelling whereas OK/Yes PL/SQL block executes fine. Message Box Plugin: ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol ";" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge The symbol "exit" was substituted for ";" to continue. Please refer http://demo.tryfoexnow.com/apex/f?p=700:71:1 Thanks in advance! Rebecca
Error in Tree Grid Search16.11.2016 12:11 Hi , We have used a tree grid plug-in which throws an error when we enter something in the default search. Please find the below screen shot of the error. Can you help us know the reason behind this issue?
FOEX Grid Metadata Error04.11.2016 12:11 Hi We have a grid with function returning query. It's behavior is random. Sometimes it is working and sometimes we are getting the following error. 0.51802 0.00004 ... Proc/Func: FX_P_META_DATA.get_grid_report_properties 4 0 0.51806 0.00056 ... Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small 4 1 0.51863 0.00008 ... Back Trace: ORA-06512: at "FOEX_020101.FX_P_META_DATA", line 1339 Same page is working in other instances, Please help us on this as it is very critical. Thanks Rebecca
Decimals not showing in Dynamic grid03.10.2016 08:10 Hi Matt, We have a Dynamic grid based on 'Function returning SQL query'. Though the table has decimal values,it is not showing in the grid. We tried to replicate the same sccenario in Demo http://demo.tryfoexnow.com/apex/f?p=700:112: But its working fine. Not sure if it is fixed in the latest version. But we are on v2.1.1. Can you please let us know what needs to be done?
Issue with dynamic headers and conditional columns13.09.2016 12:09 Hi, If we have a grid in which labels will be shown dynamically, and also some of the columns are conditional, then headers are missing for some of the columns in the export file. We have replicated this issue in demo instance, workspace : FX_WS_462 App : 700 Pg no 113. Can you please suggest a way to fix this issue. Thanks in advance Shyamala
Issue while sorting grid based on a hidden column24.08.2016 05:08 Hi, We are facing issue while sorting a grid based on hidden column. The column is basically of number data type but when it is hidden it is taking as varchar and sorting accordingly I have reproduced this issue in demo instance workspace FX_WS_462 app 700 Page no 111. Thanks in advance Shyamala
Download file issue when name has %29.07.2016 00:07 Hi, I have created a test case in the below link http://demo.tryfoexnow.com/apex/f?p=700:99:1 When i click on doWnload template button, it goes to 500- Internal Server Error page. Its because of the % in the file name that i have given in my 'Download Template' process. Is there any Way it can be fixed.
FOEX Shuttle - Display Extra Values15.07.2016 19:07 Hi, I am using a FOEX shuttle and have given 'Display Extra Values' as Yes. But then too the extra values that are not return by the list of values query but there in the table is not showing up. Please let me know if there is a way to achieve that.
Grid Sort option in FOEX V2.1.116.06.2016 10:06 Team, In grid, If we don't want to show the field, we can make either the field as 'Hidden' or we can uncheck the show checkbox available in Report Attributes. But for FOEX newer version V2.1.1, If we go by second option and using Grid Sorting, We are not able to see the fields under sorting. We remember, we have that option in FOEX V2.0.1. There is no issues if we make the filed as 'Hidden' and using Sort option. Could you please help us to get this feature in FOEX V2.1.1. Thanks, Rebecca
On close of content loader-refresh already opened tab16.06.2016 10:06 Hi, I have a requirement where on click of a button, I am dynamically closing a tab using the below solution provided by Matt:- http://forum.tryfoexnow.com/osqa/questions/2697/close-the-content-loader-page-dynamically On close of this tab, I set an item of parent page. and on parent page I have a DA on tab change checking if the tab become current active tab and this page item is set (i.e. I closed the newly opened tab dynamically on button click) This DA is not getting called. Not sure why as It used to work in FOEX 2.0.1. I created a test case as below for demonstration. please help on this:- http://demo.tryfoexnow.com/apex/f?p=172 Page 3002, 3007 From menu:- "Grid"--> Click on "Grid Readonly"--> Right click on the grid data and click on Overview context menu-> (1) Click on button "close currect and set item" it will close current tab and set item on parent tab from where we launched it. (2) Now on this tab, we have a DA where I am firing alert(to test). I want to refresh the grid in this, if the tab close by step #1. But the DA is not firing as my alert not coming.
Function returning report using Oracle collections in Grid28.04.2016 15:04 Hi Matt, I am trying to create a FOEX Grid - function returning query in which we are fetching data from some tables into different package level collections. From what i have understood , once a collection is intialized it will stay through the session, it works fine in the DB I have given a top grid which when loading, initializes the collection and returns the query which executes perfectly fine. declare p_ret varchar2(32767); begin RA_PKG.pop_data; p_ret:='SELECT * FROM TABLE (RA_PKG.disp_summ) '; return p_ret; end; And I have a content loader DA on click of the top grid, it returns a grid in the below layout. When i had given directly as below, it is erroring out with "Reference to Uninitialized Collection". SELECT * FROM TABLE (RA_PKG.disp_tab1) When i use the same way in the below grid as well, it is working fine. declare p_ret varchar2(32767); begin RA_PKG.pop_data; p_ret:='SELECT * FROM TABLE (RA_PKG.disp_tab1) '; return p_ret; end; I have a test case at http://demo.tryfoexnow.com/apex/f?p=700:11: Can you help me out? Not sure if i am missing something or i have misunderstood. THanks Rebecca
Not able to save the record by selecting the checkbox01.04.2016 11:04 Hi Matt, We have upgraded to FOEX v2.1.1. In editable grid, If we use check box as a field and selecting particular record to delete it, the below error message is coming even though we have given "NOT FX_P_GRID.processing". ORA-00904: "CKBOX": invalid identifier please help us to resolve this issue. Find the test case in the below link : http://demo.tryfoexnow.com/apex/f?p=700:7:4632172968386:::::
Page Error if pagination is not given01.04.2016 11:04 Hi Matt, We have upgraded to FOEX v2.1.1. One of our page that was already developed started breaking with the following error message. ora_sqlerrm: ORA-20001: The Grid does not currently support the combination of infinite/buffered scrolling and editing. Please either use a pagination scheme or set maximum rows to your page size in the report properties. The issue is happening when we use editable gird without selecting a pagination. For some reason we don't want to use pagination. Can you please let me know what needs to be done on this. Find test case in the below link. http://demo.tryfoexnow.com/apex/f?p=700:16:2652187676894:::::
Issue in DA with 'Is Not NULL' condition - V2.1.101.04.2016 09:04 Hi Matt, We have upgraded to FOEX v2.1.1. One of our pages that was already developed started breaking with 'lItemValue.search is not a function' in the Console. Based on the below thread I could see that it's an APEX bug when we use DA with 'Is Not NULL' condition, https://community.oracle.com/thread/2623227?start=0&tstart=0 When we made the DA as Never, then the screen began to work. I'm not able to replicate the issue in Demo instance. Please suggest what needs to be done. Our application is on APEX version 4.2.6.00.03 and FOEX v2.1.1. It was working fine in FOEX v2.0.1.
  • 1 - 50

48 Answers

AnswerThreadCorrect Posted
Hi FOEX Team, Unfortunately i am not able to replicate in your instance. Enabling the checkbox seems to be faster in your trial workspace. I have sent&nbsp; the test case from our instance, Let me know if it helps or you want any more details. In the&nbsp;example, i have checked 6 records, but only 5 are seen in the log. Also the only difference i could see between the trial workspace and our workspace is Apex version. We are on Apex 5.0.4. FOEX Grid After Edit not working as expected04.07.2018 10:07
Hi, The test case is exactly the one that&nbsp; I have provided in the trial work space. https://trial.tryfoexnow.com/ords/f?p=1065:1000:&nbsp; The form is on another page and it is opened on a window, hence it loads on the initial open of the window.&nbsp; FOEX Form Item 'Source Type' settings.03.07.2018 06:07
Please check the screen shot, browser is not zoomed too. FOEX Chart Labels issue in FOEX 3.1.021.06.2018 13:06
We also noticed that tooltips values are not coming properly for Line charts as well. For eg: In the attached image it should be 11290=74 FOEX Chart Labels issue in FOEX 3.1.021.06.2018 09:06
Actually validation is not the only scenario. We use it&nbsp; pass it to our API also directly. Attached the screenshots of the below, where it is passing the value as null, we are just using the below. &nbsp; var val = record.get(&#39;DFLT_VAL&#39;); The first highlighted is the issue and second highlighted is how it should work.&nbsp; Blank values in Grid returning as 'null'05.06.2018 13:06
This is how we are using it. Can you let us know when was this changed. Unable to save checkbox values Y/N in FOEX 3.1.005.06.2018 05:06
Hi Matt, &nbsp; Quick update on the button issue, we found that it started calling the &#39;x-button-default-medium&#39; class in the new version(i.e v3.1.0). We have over written this particular class in our customized CSS which we have used in some other places. But now since it has started calling&nbsp; for all the button types that are defined as Medium, its creating an issue. What we observed is, if we change the &#39;UI&#39; option in the button attributes to &#39;none&#39;, our button works fine.&nbsp; Is there an update script that can be executed to change the UI option of the Button type medium to &#39;none&#39; through out the application.&nbsp; Upgrade Issue V3.1.020.02.2018 13:02
I tried using the below in HTML Header and it works. #SCHDPARAM .x-grid-dirty-cell { background: none !important; } Remove the modified grid cell color21.09.2017 07:09
Hi Team, We tried with the above solution but it didn't work. We tried to replicate in FOEX Demo instance but we couldn't reproduce with the exact error. In FOEX Demo instance we are getting 'A System Error Occurred During Processing. Contact Administrator'. Here it is working fine if we give "fxExtendedSearch": false in grid additional config. We are in V2.1.1 FOEX version. Find the below link for the test case. http://demo.tryfoexnow.com/apex/f?p=700:200:2470930300279::::: Please help us to resolve. Error while using grid search08.06.2017 11:06
Hi Matt, Adding to this, there is one more issue on the tree grid search. When i search for the parent record,in the test case provided (for e.g. 'A'), it displays only that. It doesn't display the child within that. Can you let us know if this can be fixed. Tree Region in FOEX17.05.2017 04:05
Am just getting 'Failed to load response data.' as below. Am i missing something. Error "Network communication failure"11.05.2017 09:05
Hi, On debugging, we found that this is because of using the freeze functionality in the tree. "locked":"true" We would also like fixes for http://forum.tryfoexnow.com/osqa/questions/8321/freeze-column-functionality-on-tree-grid http://forum.tryfoexnow.com/osqa/questions/8409/sorting-is-not-happening-correctly-if-grid-column-is-having-negative-and-positive-values Tree grid search clear issue16.03.2017 17:03
There are no errors. We are trying to filter using the filter option in the grid. But its not returning the filtered result. It is returning all the rows. Screenshot for where we are referring to. Freeze column functionality on Tree Grid15.03.2017 12:03
Hi, Any idea why this should come as 'unknown' instead of v2.1.1 in the FOEX Developer Add-on details for that particular application. App 941 (Issue) Developer Addon (FDA) APEX Enhancements: active - FOEX Enhancements: active - Version: 3.0.0.4 / 5789 / unknown / 5334 let us know if there is any thing that we need to check. Unable to login to application in APEX507.03.2017 11:03
Hi Matt, Please ignore the above eg and consider this. We are using column chart in a page and we have 3 values. We need to give 3 different colors for those values. Please find the attachment and help us to achieve it. Colors on column chart02.02.2017 14:02
Hi Matt, Out of the columns displayed fine on the tree grid, while using search functionality system is again throwing an error: Action: Filter ORA-06502: PL/SQL: numeric or value error: character string buffer too small This has been reported as an issue since the records are getting displayed fine but search is erroring out. Can you let us know on this. Unable to display more no of columns in a tree grid01.02.2017 08:02
Hi Matt, We found that it is not exactly based on no of columns. It is based on data of the columns. Now we tried with 50 columns and it is throwing an error. We are able to display more than 50 columns if we choose different set of columns. Debug Message sent to requested mail id. Unable to display more no of columns in a tree grid13.01.2017 05:01
Hi Matt, Any updates on this. Error in Tree Grid Search23.11.2016 05:11
Hi We have a grid with function returning query. It's behavior is random. Sometimes it is working and sometimes we are getting the following error. 0.51802 0.00004 ... Proc/Func: FX_P_META_DATA.get_grid_report_properties 4 0 0.51806 0.00056 ... Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small 4 1 0.51863 0.00008 ... Back Trace: ORA-06512: at "FOEX_020101.FX_P_META_DATA", line 1339 Please help us on this as it is very critical Thanks Rebecca Issue with dynamic headers and conditional columns04.11.2016 10:11
Hi, Thanks for quick response! We tried to replicate the same scenario in APEX but we did not find any issue in the export file. Can you please suggest some workaround for this Thanks Shyamala Issue with dynamic headers and conditional columns14.09.2016 07:09
Hi Team, We have created a test case for export option on context menu using Dynamic Action. Our expectation is to achieve all the three options (Export Visible Rows Only,Export Filtered Data,Export) through Dynamic Action. Please help us to achieve this. Find the below link for the test case. http://demo.tryfoexnow.com/apex/f?p=700:7:21237670066811::::: Thanks, Nithya Export Option in a Grid13.07.2016 16:07
Team, In the below eg grid we have another 2 fields, deptname and start_date. In that deptname is 'Hidden' field and start_date is 'Display as Text(saves state)' with show unchecked(Please refer screenshot). As shown in the screenshot, we are not able to see the start_date field in Grid Sort whereas in older version we were able to see the field in grid sorting. We are not able to show the screenshot for FOEX V2.0.1 as we have latest version in forum. Thanks, Rebecca Grid Sort option in FOEX V2.1.117.06.2016 07:06
Hi , We have upgraded to v2.1.1 and the above additional config is not working and is not showing up any data. It was working fine in 2.0.1. Can you let us know what needs to be done? FOEX Grid - Default Filter24.05.2016 07:05
Hi Team, We are using some JS to concatenate the values of the checkbox and use it in our custom DML, we have modified the page in demo for your reference. On click delete we are concatenating the Empno and deleting the records based on that. For some reason we don't want crud processing and we want to do DML manually, so please let us know how we can fix this is in FOEX v2.1.1. Its very urgent. Thanks, Rebecca Not able to save the record by selecting the checkbox13.05.2016 05:05
Hi, This is the version from the console. Issue in DA with 'Is Not NULL' condition - V2.1.103.05.2016 18:05
Thanks for guiding us. Please find the below screenshot with the details. Issue in DA with 'Is Not NULL' condition - V2.1.106.04.2016 09:04
Hi Matt, Sorry for responding late on the same thread. As suggested by you, we greyed the original image, uploaded and refered it on the page. Default css for the checkbox .x-form-checkbox { width: 13px; height: 13px; background: url(images/form/checkbox.gif) no-repeat; } .x-form-cb-checked .x-form-checkbox { background-position: 0 -13px; } We have used the css as below on page when readonly is applied. The issue we are facing is, the readOnlyInputs is not getting called for x-form-cb-checked class. Only the first part works fine. So even when my value is checked, it doesnt reflect. .readOnlyInputs input.x-form-checkbox { width: 13px; height: 13px ; background: url(#WORKSPACE_IMAGES#checkbox.png) no-repeat !important; } .readOnlyInputs input.x-form-cb-checked{ background: url(#WORKSPACE_IMAGES#checkbox.png) no-repeat 0 -26px !important; } We have updated the example on demo for 'RO Checkbox' with the same. Can you please let us know if there is any way to fix this issue? Read Only Items CSS Styling29.10.2015 09:10
Hi Matt, Thank you for your response :) We saw the changes done on the test case. The items have been made read only using FOEX Form Item Action-Set Read Only and you have defined a class on the Page HTML Header where we set the background, which is fine. But if you see in the above screenshot, right now the value of checkbox is 'Y' but we are not able to see it, as the checkbox is totally greyed off. We tried to adjust the styling as well, but no luck :( For Radio button, it is readonly but appears to look the same. Our main concern is we want to differentiate the color of the read-only items from the enabled ones. For other items it is working fine. Can you please suggest a way to grey out the checkbox and radio items without affecting the value? Thank you. Read Only Items CSS Styling12.10.2015 10:10
Matt, The above works fine. Can I also disable the double click on the shuttle which adds and removes the records respectively? Disable options on FOEX shuttle28.04.2015 17:04
Hi Matt, Sorry for the late reply. We tried to replicate the error for a few times again in our application. This is the correct error we are seeing in the console when we get the 'parsererror syntaxerror unexpected token' alert on the page. Can you please let us know what needs to be done. parsererror syntaxerror unexpected token06.10.2014 06:10
Thanks Matt, I was able to replicate, when the application is left unused for some time, and when we come back and click. I saw the below in the console. parsererror syntaxerror unexpected token26.09.2014 18:09
Hi Matt, Thank you for your reply. And sorry for responding late. Initially i was not able to replicate the issue in demo, then i found out that the issue occurs only on a grid opened in a window. I have created a testcase for you to test on http://demo.tryfoexnow.com/apex/f?p=700:7: I can tell the steps to replicate this issue. Click on 'Open Window', enter some value in 'empname' textfield and directly go and apply changes. The value in empname disappears. If you are not getting the error, try for atleast 3-4 times, as the issue is not consistent and we are getting it the 2nd or 3rd time. It works perfectly fine, if i enter value in empname field, move out of the field(red symbol appears) and then hit the apply changes button. Let me know if you are able to replicate this issue. Value doesnt get saved in the grid for the first time11.08.2014 10:08
Matt, Thank you. It got fixed. We copied the /server to /foex on the http server again and bounced it. This took care of both the issues. Its working fine. FXP-835 Combo adding blank rows on form reset still not working14.02.2014 09:02
Thanks Peter. Plsql_warning is "ENABLE:ALL". I changed it to ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL','DISABLE:05018'; Still some messages when running PL/JSON. Let me try if DISABLE:ALL works. I'll get back. Installation error 1.2.1 while creating type(as object)09.01.2014 14:01
Peter, Actually, I tried multiple time with complete clean install, but getting the same error. Tried the CREATE TYPE alone and getting the below error. alter user FOEX_010201 account unlock; conn FOEX_010201/FOEX_010201 CREATE OR REPLACE TYPE FX_CRUD_REQUEST_T AS OBJECT ( CRUD_TABLE VARCHAR2(255) -- The table/view you are updating , CRUD_REQUEST VARCHAR2(50) -- CREATE,UPDATE,DELETE , PRIMARY_KEY_COLUMNS FX_STR_ARRAY_TT -- The primary key columns , OLD_RECORD FX_DATA_RECORD_TT -- The current record values , NEW_RECORD FX_DATA_RECORD_TT -- New new data values to be used ); / SP2-0816: Type created with compilation warnings SQL >show err Errors for TYPE FX_CRUD_REQUEST_T: LINE/COL ERROR -------- ----------------------------------------------------------------- 1/1 PLW-05018: unit FX_CRUD_REQUEST_T omitted optional AUTHID clause; default value DEFINER used SQL > If you want me to do clean full install again, I can just add the SHOW ERROR in the script, and run a full install. Installation error 1.2.1 while creating type(as object)09.01.2014 13:01
Sure Peter. I'll update with progress. Installation error 1.2.1 while creating type(as object)09.01.2014 13:01
Thanks Peter. Oracle DB version 11.2.0.3. FOEX 1.2.0 Trial version was earlier installed. Licensed version FOEX 1.2.1 is being installed now. Yes, I ran the uninstall, also made sure FOEX% schema is not there. I will just try running the CREATE TYPE for the one that errors out, and will get you the show errors. Installation error 1.2.1 while creating type(as object)09.01.2014 12:01
Hi Matt/Peter, When i commented like below, the statement runs fine. It's Oracle Database Server Enterprise Edition 11.2.0.1 THEN --FX_P_UTILS.AUTH_CONDITION_CHECK( CONDITION_TYPE_CODE , CONDITION_EXPRESSION1 , CONDITION_EXPRESSION2 , AUTHORIZATION_SCHEME_ID , BUILD_OPTION_ID ) 0 ELSE 0 AJAX communication failed when using multiple validation08.01.2014 05:01
Thanks Matt. Got it. :) FOEX 1.2.1 installation error31.12.2013 08:12
Great Matt. Thank you so much. Yeah i used a different ID. That's why it didn't work. It is working fine now :) Thanks again.. Will get back if i face any more issues. Default page using content loader06.12.2013 13:12
Thank you so much Matt :) Will get back if i face any more issues. Shuttle not getting refreshed on a form28.11.2013 00:11
Okay Matt. Thank you for your reply. But I am not sure if you got the issue. I can tell the steps to replicate the issue. Reset the employee2 form. Reload the page and now edit a record. The shuttle does not show values for the first time. Shuttle not getting refreshed on a form27.11.2013 23:11
Hi Matt, I have tried the same. it does get refreshed when i re-load the page or click on test button to create a new record and then come back again to edit a record. But it does not get refreshed the first time. But I see the value in the session. Shuttle not getting refreshed on a form27.11.2013 22:11
Okay. Thank you Matt. I will try it and let you know. Default tab in Window22.11.2013 04:11
HI Matt, Thank you. I tried the above in this example here. http://demo.tryfoexnow.com/apex/f?p=700:4: It does not seem to work. I have given it in the 'open window' Dynamic action. Am i missing something? Default tab in Window22.11.2013 04:11
Okay Thank you Peter. Content loader for GRID on the same page12.11.2013 23:11
Thanks Matt. Will test it in my form and get back if i have any other questions. Regarding FOEX Grid refresh07.11.2013 15:11
Got it Matt. Thank you for your quick reply. Rebecca FOEX Checkbox in a Form31.10.2013 20:10
  • 1 - 48

144 Comments

AnswerThreadPosted
Okay as you said, let me check for the grid. But i have also mentioned an issue on the form date picket. The form has default DML and has no such validations. Can you check and respond for that. Dirty flag not setting in FOEX Grid10.08.2018 06:08
System in the sense, same instance on different laptops(but same OS).&nbsp; We are also noticing one more similar&nbsp;issue in the FOEX date picker in form. When manually edited with the correct date format, it disappears on save and doesn&#39;t get saved. This also happens only for few users on their laptop. Dirty flag not setting in FOEX Grid10.08.2018 06:08
I don&#39;t understand, if my settings are conflicting why is it working on v2.2.0 with Apex 5. Also I can understand if it is happening for all users across all the systems, but its working perfectly fine on some systems and not on other.&nbsp; Kindly let me know&nbsp;what was changed. Dirty flag not setting in FOEX Grid09.08.2018 06:08
Hi Matt,&nbsp; It not only happens during add row, it also happens when we&nbsp;modify the grid cell value&nbsp;and directly hit on save.Either the changed value disappears or throws&nbsp;validation(that is given for the grid&nbsp;like not null ) which is irrelevant etc. Let me know if it is the same issue or you need a test case of this. Dirty flag not setting in FOEX Grid07.08.2018 05:08
Thank you so much for the quick turn around Matt.&nbsp; We will have it applied and tested. Select list LOV limitation06.07.2018 13:07
Hi Matt, Can we get a fix for this too included in the hotfix. I think 200 values is too less for an LOV. Default needs to be at least 500/1000, since most of our drops downs have atleast 250-300. It was working fine in the previous versions. Select list LOV limitation06.07.2018 12:07
For now, we have changed the design to make it work. I feel this also has to do something with some missing settings since the way checkbox behaves itself is different between the trial and our workspace. But we will try to find ways to debug and provide a test case. FOEX Grid After Edit not working as expected06.07.2018 05:07
Hi Matt, This issue still exists. FOEX Grid After Edit not working as expected05.07.2018 04:07
Replicated the issue on the demo page. It is happening when &#39;Use Generic Column Names&#39; is set to &#39;Yes&#39;. Report error when column named with 'FX'04.07.2018 06:07
It is disabled at the Shared Components level. And the settings at the form level is Inherit . FOEX Form Item 'Source Type' settings.02.07.2018 12:07
This is the version we are running on&nbsp;"3.1.0.3601.00". Do you mean the caching settings under the below navigation&nbsp;Or page level &#39;Browser Cache&#39; option. Shared Components ->Component Settings&nbsp; -> FOEX Application Settings FOEX Form Item 'Source Type' settings.02.07.2018 07:07
Below is the exact test case that we have in our application too but its working in your demo environment https://trial.tryfoexnow.com/ords/f?p=1065:1000:&nbsp; (Right click on the &#39;Readonly Grid&#39; and edit the window) FOEX Form Item 'Source Type' settings.02.07.2018 06:07
OS is Windows 10 and my chrome is on&nbsp;Version 67.0.3396.87 . FOEX Chart Labels issue in FOEX 3.1.022.06.2018 09:06
If you hover over the Europe region, you can see the tooltip cropped, i think its the same issue at both the places. FOEX Chart Labels issue in FOEX 3.1.021.06.2018 12:06
You can check it out in the demo application page 9020 (Multi Series Column Chart)&nbsp; FOEX Chart Labels issue in FOEX 3.1.021.06.2018 11:06
We noticed one more issue, tool tip on the gauge chart is not working as expected. You can see it in demo application itself https://trial.tryfoexnow.com/ords/f?p=1065:9050:14055959504950::NO FOEX Chart Labels issue in FOEX 3.1.021.06.2018 07:06
Thanks it worked. There is one more issue when there are negative values in the chart.&nbsp; The Label display (Bar & Column ) Outside seems to have been cropped.&nbsp; You can see the same in the first chart. FOEX Chart Labels issue in FOEX 3.1.018.06.2018 13:06
Below is the FOEX workspace details FX_WS_3221 FOEX Chart Labels issue in FOEX 3.1.018.06.2018 11:06
Thanks for responding. We tried to change but doesn&#39;t seem to impact. We have done it on the test case provided. Can you please check and let us know what we are missing. FOEX Chart Labels issue in FOEX 3.1.018.06.2018 10:06
We have replicated this in https://trial.tryfoexnow.com/ords/f?p=1065:3: For column " Name"&nbsp; on click of apply changes button. We have also sent the page_source from our application. Sure we will use the support portal next time in case of priorities Blank values in Grid returning as 'null'05.06.2018 12:06
This is the version "3.1.0.3601.00" Blank values in Grid returning as 'null'05.06.2018 11:06
Hi, So we are still getting this issue. Where ever the column value in the grid is left blank , it is returning as a string &#39;null&#39;, this didnt happen in previous versions. Because of which our validations / processes are failing. The main reason we upgraded to 3.1.0 is&nbsp;hoping that this issue would be fixed or would not occur, but seems like it is there.&nbsp; This is a priority issue for us. Blank values in Grid returning as 'null'05.06.2018 11:06
Initially we had just Y,N only.&nbsp; And then it broke in v1.2.3 as posted in the below link.&nbsp; That was when we reverted the change and added the STATIC2 to make it work.&nbsp; https://forum.tryfoexnow.com/en/f?p=1111:20:1240362716684:::20:P20_THREAD:2328 Unable to save checkbox values Y/N in FOEX 3.1.005.06.2018 06:06
We are still facing this issue in FOEX 3.1.0. Since most of our tables have a column like %_FX_%, it is impossible to replace at all the places in the UI. Can we please let us know if this can be fixed in the next hotfix? Report error when column named with 'FX'01.06.2018 11:06
Thanks Matt. Any latest hotfix that i would need to apply on v3.1.0? Blank values in Grid returning as 'null'21.05.2018 09:05
Hi Matt, So we planned to go for FOEX 3.1.0. We have few questions, before we&nbsp;upgrade. In a previous thread, it was mentioned that Oracle 12.2 is compatible with FOEX 3.1.0 only. Is FOEX 3.1.0 compatible with lower DB versions as well. Also if we upgrade to FOEX 3.1.0 , will you provide support for any outstanding issues reported, since we encounter new technical issues every time patch has been applied. Blank values in Grid returning as 'null'21.05.2018 08:05
Hi Matt, So we tested the reported issue after applying HFXP-3137. The issue still exists. Display Extra Values in the FOEX Select List - Grid18.05.2018 05:05
Thanks Matt. We will check&nbsp;out on upgrading to 2.2.1 , also i dont see the HFXP-3137&nbsp; in the support portal. Is it&nbsp;HFXP-2731.zip. Display Extra Values in the FOEX Select List - Grid26.04.2018 05:04
Also is there any immediate workaround without applying hotfix for now. Display Extra Values in the FOEX Select List - Grid25.04.2018 15:04
Hi Matt, We haven&#39;t applied any hotfix yet for FOEX v.2.2.0. Let me know which hotfix i can have applied. Display Extra Values in the FOEX Select List - Grid25.04.2018 15:04
Is there any other work around for this. The reason is, we are not able to do the changes manually since our Development is still not upgraded and the previous versions does not have 'none' in the 'UI' option. Because of which we are not able to fix in our DEV and move it to our upgraded testing instance.Upgrade Issue V3.1.021.02.2018 13:02
Hi Matt, Quick update on the button issue, we found that it started calling the 'x-button-default-medium' class in the new version(i.e v3.1.0). We have over written this particular class in our customized CSS which we have used in some other places. But now since it has started calling for all the button types that are defined as Medium, its creating an issue. What we observed is, if we change the 'UI' option in the button attributes to 'none', our button works fine. Is there an update script that can be executed to change the UI option of the Button type medium to 'none' through out the application.Upgrade Issue V3.1.021.02.2018 08:02
No, we save the encrypted text,but even then its showing the clear text in the Network tab.Cross site scripting issue15.02.2018 13:02
Would you be able to give us the fix for the password issue at least since we do not have a workaround for that. Right now most of our clients are on v2.1.1 and it would take time for them to upgrade.Cross site scripting issue15.02.2018 13:02
The issue was reported on v2.1.1.Cross site scripting issue15.02.2018 09:02
We encountered one more security issue with the FOEX Password Plug-in. When we create an user, though the password field is masked and it does not save in the session as well, we could see the password in the response of the network tab(Developer Console).Cross site scripting issue15.02.2018 09:02
Thanks for the response. So is there any temporary workaround or hot fix you will provide for this.Cross site scripting issue15.02.2018 09:02
Hi, Can you let us know if we have workaround for this. Report error when column named with 'FX'09.11.2017 11:11
Hi Team, We have tried as mentioned in the above, but still its not working. Sent you the latest html source in debug mode and page export for your reference. Issue replicated in foex instance as well. Application : 700 and Page No : 1112 Please do needful at the earliest. Thank You Rajasekhara Date format not recognized issue when the DATE_FORMAT is set to MM/DD/YYYY27.09.2017 06:09
Hi Team, Any update on this issue, as we shared the required details in mail. Thank You Rajasekhara Date format not recognized issue when the DATE_FORMAT is set to MM/DD/YYYY11.09.2017 09:09
Hi, This is regarding the 1st issue regarding comments section and update statement i have mentioned about is the below which you have already provided. UPDATE &APEX_SCHEMA..WWV_FLOW_REGION_REPORT_COLUMN SET COLUMN_COMMENT = regexp_replace(column_comment, 'ext${s ('||CHR(10)||'|'||CHR(13)||')?s ,("fxDefaultExpression". )$', 'ext${2', 1,0,'n') , COLUMN_DEFAULT_TYPE = NULL , COLUMN_DEFAULT = NULL WHERE REGEXP_INSTR(COLUMN_COMMENT, 'ext${s ('||CHR(10)||'|'||CHR(13)||')?s*,"fxDefaultExpression"') > 0 Issues after Foex upgrade30.08.2017 14:08
Hi Matt, Reg the update statement provided for issue 1, my understanding is it need to be updated on the upgraded instance(FOEX v2.2.0 with Apex 5.0.4). The reason for asking this is, our DEV application is still on Apex 4.2 and FOEX v2.1.1,so assuming this script needs to be part of the patch to the customers. Or will it work as expected if we run this script on apex 4.2 and FOEX v2.1.1 and import the pages to the upgraded instance. Issues after Foex upgrade30.08.2017 12:08
Thanks Matt. We have this scenario in almost every page in our application and fixing this through out the application may be time consuming. Can there be any other way/hot fix for this. Issues after Foex upgrade23.08.2017 13:08
That was just a test case to show that value was getting set but not getting saved. In the scenario in our application, it is an hidden column Issues after Foex upgrade23.08.2017 12:08
Thanks, please let us know on the second issue. Issues after Foex upgrade22.08.2017 12:08
We have replicated the 2nd scenario in http://demo.tryfoexnow.com/apex/f?p=700:7 Issues after Foex upgrade21.08.2017 13:08
Hi Team, We have sent you html source in debug mode and page export for your reference. Mail Subject : "Dateformat issue page source and page export" Thank You Rajasekhara Date format not recognized issue when the DATE_FORMAT is set to MM/DD/YYYY16.08.2017 12:08
Hi Yes, actually our requirement is for the comments field which should be big enough. But the reason, we do not want to use Text areas is since they are found exposed to XSS vulnerability. Thats why we would want to go with a text field plug-in with increased height. Increase height of Text Box28.06.2017 13:06
Hi Team, Any update on this issue, as we shared the page in debug mode and html source in mail. Thank You Rajasekhara Date format not recognized issue when the DATE_FORMAT is set to MM/DD/YYYY05.06.2017 10:06
Thank you Matt. Just to confirm on the above , so will apex 5.0.4 and FOEX 2.2.0 with hotfix work? Error "Network communication failure"18.05.2017 08:05
  • 1 - 50