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

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

http://www.freebookspot.es/ - free books

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)

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

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).

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!