Wednesday, December 30, 2015

Nottingham Half Marathon

Nottingham Half Marathon will be on 25th September next year. Time to enter!
There are until Sunday 25th September 2016
This is actually a test of a snippet over at www.weeksuntil.com

Wednesday, July 22, 2015

This months favourites



In case these aren't already in your bookmarks; here's six new ones that I've found useful...  I thought everyone had these but talking in the office today seems not..

https://www.screenr.com/ - instant screen recording
https://www.udemy.com/ - courses including Java, Swift, Oracle, etc - only buy when there is a sale on..
https://www.dropbox.com  Storage in the cloud  
http://www.it-ebooks.info  free IT books
https://www.filmon.com/group/uk-live-tv watch UK TV without a Proxy (outside the UK)

Friday, February 20, 2015

Mass Close Workflow Notifications



We will use personalisation on the work list table to show 1000 records at a time, rather than 25 per page which you can then use to close old FYI type notifications.

Steps

Set the following options to enable personalisation.

Use System Administrator Responsibility 
Go to Profile >  System
Enter your username in the user field and query back each of the following and set as shown:

1              FND: Personalization Region Link Enabled Yes
2              Personalize Self-Service Defn Yes
3              Disable Self-Service Personal No

Logout of Applications.

Log back in (this makes sure the new profile option values get picked up)

Click on Personalize Page (top right)
Scroll down to “Table: Notification List”
Click on the ‘Edit’ (Pencil)
Scroll down to “Records Displayed”
Change the value from Inherit to 1000 in the Responsibility column.
Click on Apply at the end of the table
Click on Return to Applications at the end of the page
You will now see 1-1000 records.
Do your stuff. Use Select All and deselect records as appropriate.  Click on the Close button at the top and follow the steps to close.


Turn Off and Reset back to defaults

To Remove Change:
Click on Personalize Page (top right)
Scroll down to “Table: Notification List”
Click on the ‘Edit’ (Pencil)
Scroll down to “Records Displayed”
Change the value to Inherit from 1000, click on the Inherit arrow icon.
Click on Apply at the end of the table
Click on Return to Applications at the end of the page
You will now see 1-25 records.

Turn off Personalisation:

Use Responsibility System Administrator
Go to Profile >  System
Enter your username in the user field and query back each of the following and set as shown:

1              FND: Personalization Region Link Enabled No
2              Personalize Self-Service Defn No
3              Disable Self-Service Personal No



Monday, February 16, 2015

Developing with your local Oracle Release 12 VM


Quick Access details for the Release 12 VM we got running in an earlier post.

Unix
Use Putty to telnet to ebs.example.com
login as applmgr (password as you set on first boot)
Source the environment file /u01/install/VISION/EBSapps.env (. ./u01/install/VISION/EBSapps.env)
All the Application Top's will now be set-up and you can access the database
sqlplus apps/apps

Desktop 
You will need to install
Oracle Instant Client
Oracle Forms
Oracle Reports
Oracle Workflow
Oracle BI Publisher Desktop
Oracle jDeveloper

I run these on a windows 7 VM; the main thing is to run in compatibility mode (with XP) and as administrator when installing.  If you want a Release 11 toolset too, install those first (Forms 6,  Reports 6).



Wednesday, February 11, 2015

How to get Release 12 Virtual Machine running on a Macbook - the fastest Apps you've ever seen


Oracle have made available almost ready to run Virtual Machines for Oracle Applications 'Vision' databases; (Vision is the demo instance with data and set-up already done).  Ideal for developing against and learning.  Some background and details here: https://blogs.oracle.com/stevenChan/entry/oracle_vm_virtual_appliances_available

The following is my steps to get running on a Mac host.  I was amazed at the speed, especially at database level.  Fastest Apps I've ever seen!

Updated with notes for Mac VMware.  Also tested against Virtual Box on Windows host.  Added login defaults and apps URL.

Download
Download the zip files from the Oracle website https://edelivery.oracle.com/oraclevm
For 12.2.4 use https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=18255187
Download the 16 zip files under the name:
Oracle E-Business Suite Release 12.2.4 Single Node Vision Install X86 (64 bit)
I use firefox and the add-on DownloadThemAll - it allows restarts on downloads.
Once you have all the zip files, move them to your mac and unzip them, then concatenate them together.
You now have a big OVA file ready to run inside Virtual Box (or VMWare)

Oracle Virtual Box
Download and install Virtual Box (For Mac for me).
You could also use VMWare - it works too.

Get Running
Open the ova file and let it import. Will take 1 to 2 hours.

I had a few goes at this to get the networking correct.  I wanted to be able to access the DB from a windows VM (running in parellels), run Oracle Applications on the Mac (native).  To do this I got some advice from this Article http://www.lecloud.net/post/52224625343/the-ultimate-setup-guide-ubuntu-13-04-in

First define networks in Virtual Box Preferences; then add the following adapters to your R12 VM.  This bit took a few attempts to get right...
  1. Adapter 1 NAT
  2. Adapter 2 Host
  3. Adapter 3 Internal
If you're on VMWare add 'Shared with Mac'  (NAT) 'Bridge' (Host) and 'Private' networks.
If you're on Windows, use Host, Nat, Internal as adapter 1,2,3.  Strange - but it works.

Now start up your R12 VM.

You will be promted with the username prompt.  Take a snapshot at this point in case you need to change any settings later.

Follow the prompts, setting passwords for accounts and watch it build the database and config.  Take a snapshot now so you can go back to it if needed.

Up and Running
Your R12 VM should pick up 192.168.56.101
Add this on the mac to /etc/hosts (sudo vi /etc/hosts)
192.168.56.101 ebs.example.com ebs
On your Windows VM add the same line to
c:\windows\System32\drivers\etc\hosts (You may need to alter the permissions on this file to edit it)
Add a tnsnames entry:
EBS=
        (DESCRIPTION=      
                (ADDRESS=(PROTOCOL=tcp)
                (HOST=ebs.example.com)(PORT=1521))
         (CONNECT_DATA=
                (SID=EBSDB)
          )
        )
     

Apps Login
http://ebs.example.com:8000

Logins are defaulted as follows:

- SYSADMIN/sysadmin
- MFG/welcome
- OPERATIONS/welcome
- SERVICES/welcome
- MRC/welcome
- HRMS/welcome



Enjoy the fastest Apps install you've ever seen!

Wednesday, September 10, 2014

How to Fix Yosemite + Itunes 12 + ios 8 = iTunes Unexpected Error - Quit

Yosemite + Itunes 12 + ios 8 = iTunes Unexpected Error - Quit

iTunes 12 is the problem, so we need to revert back to 11 to perform update

1) Copy the iTunes 12 library file -/home/youruser/Music/iTunes/iTunes Library.itl to Previous iTunes Libraries in the same diretory and rename to iTunes Library 12.itl

2) Copy the latest .itl file from Previous iTunes Libraries to /home/youruser/Music/iTunes/iTunes Library.itl (my latest was iTunes Library 2012-12-01 1.itl) 

3) Uninstall itunes 12.  I used appzapper.  Download, install, goto preferences, untick 'Protect Apple Applications' then drag itunes from the Applications fold into appzapper.  Zap itunes 12.

3) Install itunes 11 from Apple site

4) Restore your phone to ios 8 using the iOS 8 file - Hold option key and press 'Restore iphone' in itunes.

5) Let itunes update your phone to ios 8

6) Do not restore or anything else.  Disconnect phone. Quit itunes and install itunes 12 (from Software Update in System Preferences)

7) Now copy back the /home/youruser/Music/iTunes/Previous iTunes Libraries/iTunes Library 12.itl  to /home/youruser/Music/iTunes/iTunes Library.itl 

8) Open itunes 12 and restore from backup. Alternatively you can restore from icloud on the phone.