Oracle EBS: Java "Freezing" When Starting An Oracle Form

This is a very tricky problem and certainly not something you'd want to see when rolling out the Java update across your company. The error manifests itself by a "Warning - Security" dialog appearing and not allowing the user to click on anything on it;"Frozen" Warning - Security Java DialogThe only way to proceed beyond this point is to kill the Java process using Task Manager;Windows Task Manager - Showing the java.exe processRight-click the java.exe...

Read More

Oracle PL/SQL: Working With Oracle Jobs (Showing/ Deleting/ Adding)

Showing All Oracle JobsTo see a list of the currently configured Oracle Jobs use the SQL;SELECT job,       schema_user,       last_date,       last_sec,       next_date,       next_sec,       broken,       interval,      ...

Read More

Configuring Wireless Networking On Dell Latitude D600 (Under Windows XP)

I'm not sure if it's incorrect configuration on the Dell website but solving this one seems to be massively more complicated than it needs to be. The solution below worked for me but I'm afraid the "pick the correct wireless driver" part of the solution just seems to be based on a guess (unless you want to unscrew your laptop and read the version information off the physical card!).Anyway, the problem is that under "Network Connections" on Windows...

Read More

Apple TV (2nd Generation) Buyers FAQ

Q: It says it does HD, is that 1080p?A: No. It does 720p. There has been a lot of speculation recently about Apple launching "HD+" which would be 1080p content in the iTunes Store. At the moment (December 2011) this is just speculation and nothing has been released yet. It is unlikely that Apple TV will start doing 1080p before Apple has started selling content.Q: Does it work right out of the box?A: Yes - and no. You need to have a home network...

Read More

SSRS: Solving ORA-01795 (Maximum Expressions in a List is 1000)

This blog post shows a simple method of solving the problem of Oracle only allowing 1,000 records to be passed into an IN statement. When you try and pass in 1001 you get the error message;ORA-01795: maximum number of expressions in a list is 1000This is no way round this issue from an Oracle view point, the only solution lies in not passing in so many values.Now in SSRS the most common way this bug has exhibited itself is when you have a drop down...

Read More

Noetix: Manually Rebuilding Cached KFF Data

Sometimes it's necessary to rebuild the cached KFF data that Noetix uses to speed up it's queries. These are typically the tables under the NOETIX_SYS schema that start with KFF_ followed by a code representing the data to be refreshed (i.e. GL_ACCT for General Ledger Account Code Combinations).This refresh can take quite a time and it's useful (if you are in a highly controlled environment) to be able to hand over to people some statistics regarding the rebuild. Hence the script below.The script looks at the packages that have been built under...

Read More

Noetix: Obsolete Views at Release 12 (With Suggested Replacements)

Below is a list of the obsolete Noetix Views at Release 12 (along with their suggested replacements). We aren't using all the Noetix modules so there might be others but the list below covers the following roles (from the generated Noetix help);AOLAP_AOLXXNAO_NOETIX_ADMINFA_FIXED_ASSETSGL_LEDGERAP_PAYABLESAR_RECEIVABLESOE_ORDER_ENTRYPO_PURCHASINGXIN_INVENTORYGMD_PRODUCT_DEVELOPMENTGME_PROCESS_EXECUTIONGMF_OPM_FINANCIALSGMI_PROCESS_PLANNINGINV_INVENTORYXXK_KEY_FLEXFIELDObsolete views where tracked by looking for views with "obsolete" in their help...

Read More

Noetix: Expanding Basic Forecasting Functionality in R12

This blog post contains details of how to expand the basic Noetix Forecasting template (INV_Forecasts) to add in some of the nice new functionality in R12 such as grouping forecasts into Sets (i.e. all export forecasts could be in a set called EXPORTS and domestic forecasts one called DOMESTIC).Looking at the existing Noetix view it accesses the Forecast data in a single table (MRP.MRP_FORECAST_DATES). The MRP Forecasting schema contains the additional...

Read More

Oracle PL/SQL: Making All Tables in a Schema Read-Only

This article covers preventing casual users from writing data to some tables within an Oracle Schema. This routine will prevent the user writing data to ALL tables, but you can then just remove the constraints from the tables that you wish the users to still write data to (i.e. tables that audit the user logging in).Recently we wanted to migrate users from an old system to a new one giving them access to both systems at the same time but making the old system "read only". It's possible, in Oracle, to set either the whole Database or a complete...

Read More

Noetix: Generating a (XU2) Column-Addition Script

In order to use the code below you need to replace the values for v_ViewLabel and v_ColumnLabel in the block with values that are relevant to the column you are trying to add. This script uses the standard DBMS_OUTPUT package to output the script - depending on the nature of the column you're copying this could be quite big.If you want to include new tables in your column addition script then set the v_IncludeWhere clause to Y (otherwise only the new column script will be generated).The script is below;declare  v_ViewLabel   ...

Read More