garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Audit Trail Must Do: Bank Accounts
http://garethroberts.blogspot.com/2007/08/audit-trail-must-do-bank-accounts.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Wednesday, August 15, 2007. Audit Trail Must Do: Bank Accounts. If you are paying suppliers and other parties out of the Oracle eBusiness Suite via Oracle Payables and haven't performed the steps documented in Part 1. Of this post, do it now. Even if you don't fully understand . The impact of performing these steps is:. There will be a very sm...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Enhancement Requests and Bugs for Oracle eBusiness Suite
http://garethroberts.blogspot.com/2010/09/enhancement-requests-and-bugs-for.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Tuesday, September 21, 2010. Enhancement Requests and Bugs for Oracle eBusiness Suite. If you like the looks of one of the Enhancement Requests noted below, log a Service Request (SR) on My Oracle Support. MOS) and ask for your MOS Customer record to be attached to the ER / Bug. Enable use of recursive with clause. Need the DeliveryManager API...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: R12 E-Business Suite Suppliers Query - SQL to join Suppliers, Contacts, Banks
http://garethroberts.blogspot.com/2011/10/r12-e-business-suite-suppliers-query.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Monday, October 03, 2011. R12 E-Business Suite Suppliers Query - SQL to join Suppliers, Contacts, Banks. In the Oracle E-Business Suite (EBS) Release 12 the data model of Suppliers has become much more complex. The base tables have changed (Suppliers, Sites, Bank Accounts, Contacts) and some of the fields have become obsolete. Just a quick ema...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: NZOUG 2013 Conference: Agenda online - register while Earlybird Pricing still here!
http://garethroberts.blogspot.com/2013/02/nzoug-2013-conference-agenda-online.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Friday, February 22, 2013. NZOUG 2013 Conference: Agenda online - register while Earlybird Pricing still here! The New Zealand Oracle Users Group - NZOUG Conference 2013. Is open for registrations. And Earlybird pricing is still available! NZOUG 2013 is being held in Wellington at the iconic Te Papa Museum. On the 20th March. I'll be co-presen...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Would the REAL Excel please stand up?!
http://garethroberts.blogspot.com/2008/03/would-real-excel-please-stand-up.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Saturday, March 01, 2008. Would the REAL Excel please stand up? One of the considerations of using Microsoft Excel is the underlying format of the data you're looking at. Lets say you're viewing output from an Oracle eBusiness Suite concurrent request, and Excel is automatically opened like here (SYLK). And here (BI Publisher). PPPS If anyone ...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Clearing Email Notifications and manually setting the Workflow/Java Notification Mailer Override/Test Address via SQL for the Oracle eBusiness Suite
http://garethroberts.blogspot.com/2008/05/clearing-email-notifications-and.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Wednesday, May 28, 2008. Clearing Email Notifications and manually setting the Workflow/Java Notification Mailer Override/Test Address via SQL for the Oracle eBusiness Suite. 14-Mar-2012 Added supported back-end method to update Workflow Notification Mailer attributes. Warning. And now here's a very unsupported. Note this will update all Maile...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Email Address validation by Forms Personalization, Profile Options and Regular Expressions (regex) in the Oracle eBusiness Suite
http://garethroberts.blogspot.com/2008/12/email-address-validation-by-forms.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Thursday, December 18, 2008. Email Address validation by Forms Personalization, Profile Options and Regular Expressions (regex) in the Oracle eBusiness Suite. Lets take a look at the regular expression I'll use for email address validation. This regular expression is a consolidation from a variety of sources, considers IPv4 and IPv6 addres...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Null XML elements and no NVL function BI Publisher RTF? Try xdofx decode
http://garethroberts.blogspot.com/2007/12/null-xml-elements-and-no-nvl-function.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Thursday, December 13, 2007. Null XML elements and no NVL function BI Publisher RTF? Where did that nvl() function go when creating BI Publisher Templates? Lets say you've got this data:. Xml version=1.0 encoding=UTF-8? Rowset row g1 1 /g1 g2 /g2 g3 3 /g3 g4 /g4 /row /rowset. And in your template you put:. G1 G2 G3 G4? Oh here it is:. Wed Jan ...
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Query: Concurrent Programs by User and Responsibility
http://garethroberts.blogspot.com/2007/09/query-concurrent-requests-by-user-and.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Monday, September 10, 2007. Query: Concurrent Programs by User and Responsibility. PS This was my response to a question posted on Oracle Forums, a very handy place for information, and if you're searching for something, worthwhile doing a "site:forums.oracle.com xxxx" on Google! Posted by Gareth Roberts. Subscribe to: Post Comments (Atom).
garethroberts.blogspot.com
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: Environment Variables from database table - Oracle E-Business Suite
http://garethroberts.blogspot.com/2010/04/environment-variables-from-database.html
In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. Oracle eBusiness Suite/Applications technical news, views and developments - and other abstract ramblings! Tuesday, April 06, 2010. Environment Variables from database table - Oracle E-Business Suite. Are you running Oracle E-Business Suite (EBS) / Applications and want to get an operating system level environment variable value from a database table, for example for use in PL/SQL? Or perhaps to default a concurrent program parameter? Added example...