We currently have a requirement on a Report Designer layout to convert a Number to a Word. So what I mean and as an example, a number of ‘100’ to be converted to ‘One hundred’. I have used the below SQL in a CF - which works fine. WITH cte AS( select '-100' AS num from dual)SELECT num AS old_value, decode( sign( num ), -1, 'NEGATIVE ', 0, 'ZERO', NULL ) || decode( sign( abs(num) ), +1, to_char( to_date( abs(TRUNC(num)),'J'),'JSP') ) || CASE WHEN INSTR (num, '.') > 0 THEN ' POINT ' || TO_CHAR (TO_DATE (TO_NUMBER (RPAD(SUBSTR(num, INSTR (num, '.') + 1) ,2,'0') ),'J'),'JSP') ELSE NULL END AS new_valueFROM cte; But, if the number if I enter a number of ‘-6313343’ I am getting this error message. ORA-01854: Julian date must be between 1 and 5373484 Is anybody aware of any else that I could use to get the ‘number to word’ conversation working to allow me to use i
Is anybody aware of a package that I could use that identifies what client (Aurena / EE) is being used by a user?
Is anybody aware of an easy way to grant ‘read only’ access to all IFS views to a permission set?
Apps 10 Is it possible to setup a ‘external facing’ proxy for use with the IFS B2b portal but also keep our current ‘internal’ URL for normal IFS use??The reason why I ask is when I run the installer (from the middleware) and it comes to ‘Web Server configuration’ stage, it seems we can only have one Proxy URL setting.Currently this is set to an internal URL but if I change it to the ‘external facing’ URL, our internal users will not be able to connect to this instancing using our internal URL.. The only URL that they could use is the ‘external facing’ which will push all users to the B2b portal.Any help would be greatly appreciated!
Is it possible to setup a ‘external facing’ proxy for use with the IFS B2b portal but also keep our current ‘internal’ URL for normal IFS use??The reason why I ask is because run I run the installer (from the middleware) and come to ‘Web Server configuration’ stage, we can only have one Proxy URL setting.Currently this is set to an internal URL but if I change it to the ‘external facing’ URL, our internal users will not be able to connect to this instancing using our internal URL.. The only URL that they could use is the ‘external facing’ which will push all users to the B2b portal.Any help would be greatly appreciated!
Hi,We are looking to enable SSO authentication which is fine for the bulk of our users but there are a number of IFS accounts that can only authenticate via the DB method.For those accounts, is the only way to log into IFS via the EE Admin access point?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.