If you are, like the company I work at, a user of both Oracle Payables and Oracle Internet Expenses you'll realise that the line between then is incredibly blurred. Especially if you have the situation where some departments/ areas use i-Expenses but other areas have an Excel-based expenses system (that is then sent to Finance who enter the data directly into Payables).Oracle have made the situation a little worse by licensing Internet Expenses separately to Payables and it looks very much like Noetix have continued the trend.What makes the Noetix...
Friday, January 27, 2012
Monday, January 23, 2012
This blog post gives simple step-by-step instructions on how to create your first e-Petition on Cambridgeshire County Councils (CCC) e-Petition website.Go to the website;http://epetition.cambridgeshire.public-i.tv/epetition_core/community/page/indexCambridgeshire County Council's e-Petitions WebsiteSelect the "Register" link (top-right, highlighted above);CCC e-Petition Website Registration Pages As an alternative to creating an account you...
Friday, January 20, 2012
If you find yourself writing reports for a truly international audience (i.e. US and EU) then you'll know about the nightmare of paper sizes when your users want to hit "Print" but a larger, and much more significant, issue is the blank pages that sometimes get printed either between or at the end of your reports.This blog post lists a few things you might want to check to make sure your report is printing on as few pages as possible.NOTE: If you...
Thursday, January 19, 2012
The purpose of this blog post is to put together a simple guide to producing a "test" report. I'm doing this as a separate post so that I can re-use it in Other Posts (rather than having to include basic setup information every time).Other Report Builder 3 and select "New ..." to trigger the New Report of Dataset wizard;Report Builder 3: New Report of Dataset Wizard"New Report" report will be automatically selected on the left, on the right select...
Wednesday, January 18, 2012
This blog post covers an example of how to add a simple calculated field to a Dataset in SQL Server Reporting Services using Report Builder 3 (against SQL Server 2008R2). It isn't a massively complicated process except that Microsoft seem to be assuming absolutely no-one does this as all the "nice" features of expressions when working with Reports (i.e. being able to select fields by double-clicking a list) seem to be unavailable.The easiest thing...
Monday, January 16, 2012
So that's it, I've just migrated the last one of my Google Knols back to Blogger (where I started creating posts many many years ago). To be honest it's a great shame - I can't see how with Googles goals to get the whole of human knowledge online they can justify closing that service. It was convienent, easy to use, and gave me the feeling that I was contributing to something bigger than, say, a blog.The bit I find most surprising is the lack of...
NOTE: Don't do this on a production environment. Did that need saying? Apparently one person who submitted a comment seemed to think so ... You really can completely mess it up. Run it on a test environment and MAKE SURE IT WORKS before you run it anywhere else.The script below was written against 11i, I would be loathe to run it against a different version. The point of this post is to allow you to script a change to 11i - you might be better off...
Saturday, January 14, 2012
First of all this is a MASSIVE security hole if you choose to enable it - anyone getting their hands on your machine will have full control over everything (logged into you bank? your Facebook account? your photos? the lot).There are, however, very good reasons to actually do this; for example I have setup a Windows 7 machine which just runs iTunes because that's all I need - clearly it's pointless to password protect this as all my data is on (non-protected)...
Friday, January 13, 2012
We use the following cloning script to clear down email addresses on each of the cloned systems we create from our production EBS system. In exchange we have setup a mailbox which all the test systems feed into and each tiem we create a new clone we add an email address to the mailbox so that it receives emails from the new clone (this way you can filter the messages in the mailbox to get the ones you're interested in for the clone system you are looking at).The script itself sends an email with what it's done to the mail box (so we know when the...
Tuesday, January 10, 2012
This problem has been vexing me for the last 30 minutes. After I found the solution I thought I'd post it here just in case other people are experiencing the same issue!The first thing to do is to open the file for which you aren't seeing a logfile and check to make sure that the first line begins with;@utlspon <filename>Where the name of the file is the same as the file you're running without any extension.Assuming everything in your file is correct then you need to open the *previous* file in XU2/XU5 and make sure that it ends with;@utlspoffIf...
Monday, January 9, 2012
We use Oracle E-Business Suite to manage our (pharmaceutical) production facility. Because of the nature of the work we do we create items, batches, and lots every single day of the week. Normally this isn't a problem but in Noetix views item information is cached in the N_KFF_SYS_Item table and is only refreshable by using a supplied concurrent processes.Clearly as we're creating multiple items every day it's just not practical for us to add a "Now...
Friday, January 6, 2012
Wednesday, January 4, 2012
If you are one of Oracles (few) Process Manufacturing module customers like us you will already have noticed that there are substantual changes to Noetix when you go from Release 11 to Release 12. One of the most significant is the change from using the GMI_Month_End_Inventory view (which has been rendered obsolete by Oracles changes) to using the INV_Period_Close_Details template.The first thing you'll notice when running against R12 is that if you do;SELECT * FROM INV_Period_Close_Details;In your test system you will get ZERO rows (unless...
Subscribe to:
Posts (Atom)
