|Authorization scheme remove all fields in form||16.01.2015 09:01|| Hi,
I have a Field Container within an Item Container Form. I have an Apex Authorization Scheme which I apply to one of the fields within the container. When the Authorization scheme condition is not met, instead of just the one field to which it is applied not being displayed, ALL fields in the container are not shown. This is not what I would have expected.
|Resize Viewport within Desktop||15.01.2015 15:01|| Hi,
How do I chnage the default height of my viewport when it's displayed within a Foex Desktop component. Version 1.2.4.
|FDA Chrome Webstore Blocked||03.12.2014 22:12|| Hi Matt
If I install the 22.214.171.124 FDA in my Firefox browser (to build the test case on your demo system), will this work with my existing 1.2.4 FOEX setup here? I can't use Chrome as add ons are blocked. |
|FOEX Combo No Data Found on Form refresh||02.12.2014 09:12|| Hi,
I have page with a Item Container Form which has amongst it's items a Foex Combo. The form fields are populated from a DA on click of a button, and all is OK at that point. However when I refresh the form region (again from a DA), I get a FORM PLUGIN excepetion Ora 1403. Any idea what I might be doing wrong? |
|Close Desktop window||19.11.2014 17:11|| If I open a page from a FOEX Desktop (using an Apex list URL), how do I close that "window" from a button and DA, rather than using the X in the top right hand corner. |
|Can I resize/reposition Desktop Shortcut Icon text?||31.10.2014 15:10|| Hi Matt,
Is there any way I can resize and reposition the text associated with the Desktop shortcut icons?
|Mac Book Scroll bars missing||30.10.2014 17:10|| Hi Matt,
We have a user using a Mac Book with Browser-Version: Chrome 38.0.2125.104
IOS-Version: 10.9.5, and FOEX 010101. They are accessing a page which shows horizontal and vertical scroll bars under Chrome / Firefox on Windows, but the scroll bars are missing on teh Mac Book.
Is this a know issue?
|1.2.4 upgrade||29.09.2014 22:09|| Hi Matt/Peter
I've just upgraded one of our dev apps to v1.2.4 from v1.1.0 using private synonyms. When I try and run a page, it does "loading page layout" for a while then just shows a blanks screen. The firebug Console Errors show
TypeError: c.menu is undefined
ext-all...v=1.2.4 (line 15, col 712133)
Do you have any ideas what's going on?
|FOEX 010204 upgrade||26.09.2014 12:09|| Hi Matt / Peter
I'm trying to install 010204 as a non SYS/SYSDBA user, using the privs which are specified in the install guide. I've come across a number of issues with this (one of which I've already raised around v$_tablespaces etc). the other issues are
The user needs to be granted:
CONNECT with ADMIN OPTION
CREATE PUBLIC SYNONYM with ADMIN OPTION
Execute on SYS.UTL_HTP is required by the FOEX_010204 user, but this (according to out DBA) can only be granted by SYS, so the point of using a non SYS/SYSDBA user for the install becomes a little pointless.
|1.2.4 upgrade instruction||18.09.2014 15:09|| Hi Matt,
The 1.2.4 upgrade instructions state that a a SELECT Grant on SYS.V_$TABLESPACES is required if not using SYS as SYSDBS. I'm assuming this is a typo. DO you mean v$TABLESPACE or DBA_TABLESPACES?
|GRID gives ORA-01031 insufficient privileges||17.07.2014 21:07|| Hi Matt,
I've got a grid (read only) which has previously been working OK but after a data change is now giving this internal error
Error Error in PLSQL code raised during plug-in processing.
ORA-01031: insufficient privileges
Technical Info (only visible for developers)
ora_sqlerrm: ORA-01031: insufficient privileges
component.id : 28277012654297936
component.name: Annual Solution Bridge
ORA-06512: at "FOEX_010101.FX_P_GRID", line 5010
ORA-06512: at line 4
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830
ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1058
I can find no reason for this, the page is working fine in another WS on same DB, and worked OK before the data change. The backtrace shows FOEX_010101.FX_P_GRID", line 5010. Any ideas what this is doing, and why I'm getting this error?
|Ext.getCmp removeClass not working||08.07.2014 09:07|| Hi Matt,
to grey out an input field on a form which works fine, but when I subsequently try to remove this class with
I get TypeError: Ext.getCmp(...).removeClass is not a function
|Maximized window within desktop||03.07.2014 11:07|| Hi Matt,
Is there any solution to this question asked by Darren Atkinson last year yet?
|Using FOEX Grid Row Select Set Item Values to set Grid Combo||17.02.2014 13:02|| Hi Matt,
I'm using FOEX Grid Row Select Set Item Values plugin to set values on a FOEX Form region. I then click a button to show the form region. Four of the items I'm setting are FOEX Grid Combos, and I can't get these to show me the value I've set. The other two items on the Form are not Grid Combos and their values appear OK. The Grid Combo return items are being set OK in Session State.
When I use Grid Row Bind, this works OK, but for various reasons I don't want to use that method.
Do you have any suggestions as to what I might have missed or done wrong (or another way to do this)?
|1 error has occurred Context Men u SQL Query gives ORA-01461: can bind a LONG value only for insert into a LONG column||24.01.2014 14:01|| Hi Matt,
I have a context menu SQL query which is fairly large (see below), when I try to apply changes to this I get the above error. If I remove one of the Union Alls (e.g. menu_id 4) it's all OK. It seems I'm hitting a query size limit, but surprised that LONGs are being referenced. Any ideas?
select * from (select * from (
with comment_id as (select forecast_comment_id
from gcf_forecast_comment where reporting_name=:P50_CONTEXT_REPORTING_NAME and solution_set=:P50_CONTEXT_SOLUTION_SET
and solution_detail=:P50_CONTEXT_SOLUTION_DETAIL and fiscal_year=:P50_FORECAST_YEAR)
select -1 menu_id,null menu_pid, 'Edit comments for '|| :P50_CONTEXT_SOLUTION_DETAIL text,
,0 display_seq,'fx-icon page-white-text' css_class ,'View existing comments for this solution' info,null custom from comment_id
select 0 menu_id,null menu_pid, 'Add new comments for '||:P50_CONTEXT_SOLUTION_DETAIL text,
'f?p='||:APP_ID||':115:'||:APP_SESSION||'::'||:DEBUG||'::P115_FORECAST_COMMENT_ID,P115_REPORTING_NAME,P115_SOLUTION_SET,P115_SOLUTION_DETAIL,P115_FISCAL_YEAR,P115_JAN_COMMENT,P115_FEB_COMMENT,P115_MAR_COMMENT,P115_APR_COMMENT,P115_MAY_COMMENT,P115_JUN_COMMENT,P115_JUL_COMMENT,P115_AUG_COMMENT,P115_SEP_COMMENT,P115_OCT_COMMENT,P115_NOV_COMMENT,P115_DEC_COMMENT:'||NULL||','||:P50_CONTEXT_REPORTING_NAME||','|| :P50_CONTEXT_SOLUTION_SET||','||:P50_CONTEXT_SOLUTION_DETAIL||','||:P50_FORECAST_YEAR||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL||','||NULL url
,0 display_seq,'fx-icon page-white-text' css_class ,'Create new comments for this solution' info,null custom from dual
order by display_seq)) where rownum=1
select 1 menu_id,null menu_pid,
'Dec: '||dec_comment text,
|FX_T_DOC triggers||09.01.2014 19:01|| Hi Matt
Came across a whole stack of triggers called FX_T_DOC_.... in an app I'm fixing. Can you tell me what these are, and how they get created plaese (and do I need them).
|Grid combo without a Search||03.12.2013 10:12|| Hi Matt,
Is there a way to display a Grid Combo without the search fields? The docs suggest that this is possible.
|Add percent to grid cell||20.11.2013 16:11|| Hi Matt,
How do I add a percent sign to grid column entries but still preserve to sorting, I would do this with Column Formatting/Html Expression = #COLUMN_NAME#% outside of FOEX, but this does't seem to work with FOEX.
|Blob Download in grid - Prmary Key with "+" Symbol Issue||11.10.2013 16:10|| Hi Matt,
Thanks for pointing me in the right direction. Does this method rely on using the ROWID as the primary key column? I set it up that way, but I'm getting invalid ROWID errors when I click the download link. When I change to the real primary key, Strangely I get the same error.
|Blob Columns in reports don't seem to work as standard Apex||10.10.2013 10:10|| Hi,
I've created a non-FOEX page (I also tried this with a FOEX Grid) with a simple Classic Report on a table which contains a BLOB column. I can't get this to work in the same way as under vanilla Apex, where it renders a download link for the BLOB. Is there a way to do this?
|Page Loading overlay only on first tab||08.10.2013 08:10|| Hi Matt/Peter,
I'm taking over from Darren Atkinson on Apex/FOEX development, so this may be the first of many...
I have a page with a centre pane, and three Grids which are rendered as tabs. When the first tab is selected, and the report is run (Loading Grid Data is On Demand) I get the loading overlay with the Loading spinner until the report is rendered. However, when I select one of the other grid tabs (which are Load when Grid is Shown), I get no overlay or spinner and the page is just blank until the data renders. This is a slightly odd user experience!
Is there anything I've missed coding to get the over and spinner?