Since SpottyMail went live I have been expanding the number of preset templates available in the application and noticed an Internet Meme going around where you “Share Your Playlist with your Crush”. I am off that age where you recorded your compilation of music onto cassette whcih I think was immortalised in the Nick Hornby book and John Cusask movie High Fidelity. SpottyMail will help you make that Playlist a bit more personal rather than just a link to Spotify. There is a ready made template available
Spottymail is accessible from here http://www.spottymail.co.uk if you want to make your compilation that bit more special
SpottyMail
SpottyMail is now finally live and I am now in the process of advertising the site and hopefully expanding the service. SpottyMail should allow you to share your music so you can advertise your festival, concert or simply share your playlist with your friends. SpottyMail makes use of the 30 second preview API in Spotify so that the music can be shared on Twitter or via HTML Email. If you share via Twitter your tweet will include a link to a web page that is publicly available from the SpottyMail Web Server. If you share this via email the email will be forwarded to your own email address and from here you can share this to other users.
The Email and Web Page can be changed using an editor than can be used to change the fonts, colours, spacing, layout and images contained within the web page.
SpottyMail also includes a number of prebuilt templates so that you do not have to start from scratch and it will give you an idea of what the tool is capable of. I have also included a number of stock images which you can use as well as links to some other sites that allow you to use banners and images for your own public and personal use.
To ensure the HTML Emails can be viewed correctly no matter what email reader or browser is used an OpenSource Markup Framework MJML is used to reduce the amount of testing required to ensure your creation will be viewable by the recipients. MJML allows you to Banners, Headers, Table Layout and Text Fields which gives alot of freedom when creating your design. The Basic Spotify application does allow you to share you a preview of a track but this share is a basic link which is not suitable for producing a promotional email or advertisement. If you think this would be useful you can give Spotify a Trial and if you like it enough you can pay a small annual subscription. Spottymail is accessible from here http://www.spottymail.co.uk
EBS Validation in Concurrent Jobs
Some more interesting tips with Oracle EBS Validation Set in R12. A Frequent Request is to Filter some of the other valuesets by Date e.g. only Purchase Orders between two date. To Do this we need to Create a From Date Value Set of type FND_STANDARD_DATE.
The list of Purchase Orders in the Validation Set need to be filter by this date. You would think that the value returned by FND_STANDARD_DATE would be a date but it is not. It is a character that needs formatted e.g. TO_DATE(, ‘YYYY/MM/DD HH24:MI:SS’),
So in the Validation Table Information screen do the following
l_reqid := fnd_request.submit_request
_date >=
TO_DATE(:$FLEX$.FIN_PO_FROM_VS, 'YYYY/MM/DD HH24:MI:SS')
(application =>
,program => 'XX...' -- child prg short name
,description => ''
,start_time => SYSDATE
,sub_request => TRUE
,argument1 => xx.xx1 -- child prg arguments
);
fnd_request.wait_for_request ...
How to Wait for a Concurrent Request To Complete
I recently put together a Concurrent Request that queried the database and used the result to create a number of folders named after the customers in the database. This concurrent routine was called from within Oracle Reports Builder in the after_report event. It needed to be called before the FTP Burst concurrent routine so I have to use the fnd_request.wait_for_request command. However it did not seem to wait for me and which had not been mentioned anywhere I checked on the web.
This thing I missed was the commit statement. It needs to be run after your submit_request and before the wait_for_request. See below
l_reqid := fnd_request.submit_request
(application =>
,program => 'XX...' -- child prg short name
,description => ''
,start_time => SYSDATE
,sub_request => TRUE
,argument1 => xx.xx1 -- child prg arguments
);
fnd_request.wait_for_request ...