Featured Bloggers
Lee Briggs
With more than 15 years of experience, Lee has helped organizations become more efficient through improvements in their Financial and Procurement operations. As Director of the Oracle Financials Practice at BizTech and as a Senior Financials Business Analyst/Project Manager, Lee responsibilities included full project life cycle support for Financials implementations from project preparedness through post-implementation support. With over 30 implementations to his credit, Lee has helped organizations in the Financial Services, Healthcare and Telecommunications sectors become more effective, and leverage their Oracle Applications to improve their Management decision-making. Lee is a seasoned presenter at both national and regional Oracle User Group Conferences.
R12 Report Manager – New Issues (and a Resolution) with FSG Drilldown
Date: September 23rd, 2011
Categories: Oracle E-Business Suite R12
With the release of R12, Oracle had retired Client ADI, a tool that had been used for many things, amongst which was making FSG reports look pretty, and allowing users to drilldown into the financial information displayed on the reports to get more detailed information.
With the retirement of Client ADI, Oracle began to push Report Manager, a Report Repository tool that allows users to drill-down into FSG reports, as long as they have a report-specific Excel template assigned to them. I’ve been using Report Manager for some time, and I think it is a great tool to provide Management with access to the financial reports they need, as well as allowing them to discover what is behind the numbers (without bothering the folks in Accounting).
» Read More
R12.2 Financials – New Functionality Added for Financials
Date: August 23rd, 2011
Categories: Oracle E-Business Suite R12
Although yet to be confirmed, Oracle is expected to release version R12.2 of it’s eBusiness Suite in October 2011. BizTech has analyzed the following modules, and has determined that significant functionality is expected to be added in R12.2. Some of the more significant functionality has been backported to older releases, and where appropriate, BizTech has identified the necessary patches.
» Read More
R12.2 Financials – Tax, Legal and Regulatory Updates
Date: August 23rd, 2011
Categories: Oracle E-Business Suite R12
Although yet to be confirmed, Oracle is expected to release version R12.2 of it’s eBusiness Suite in October 2011. BizTech has compiled a list of the Tax, Legal and Regulatory updates that are expected to be added, amended, or removed in this latest release.
» Read More
R12.2 Financials – Modules with No New Functionality
Date: August 23rd, 2011
Categories: Oracle E-Business Suite R12
Although yet to be confirmed, Oracle is expected to release version R12.2 of it’s eBusiness Suite in October 2011. BizTech has compiled a list, module by module, of the main features that have been added, amended, or removed in this latest release.
BizTech has analyzed the following modules, and has determined that at this time, no new functionality is expected to be added in R12.2
» Read More
View-Only Access to Key Flexfield Values (Part 2)
Date: August 16th, 2011
Categories: Oracle E-Business Suite R12
In my last post, I walked through the process for restricting specific responsibilities from creating or updating Key Flexfield Segment Values. For smaller companies with the same people doing multiple functions, this could be enough to meet this requirement. For my client, this restriction wasn’t enough. They needed to prevent specific responsibilities from seeing specific Flexfields, Titles, Structures, and Segments.
» Read More
View-Only Access to Key Flexfield Values (Part 1)
Date: August 9th, 2011
Categories: Oracle E-Business Suite R12, Oracle Supply Chain Management
Many of my clients were initially surprised that, while Oracle provides a form to create and edit segment values, there is no seeded method to provide view-only access. Some have been further surprised to find out there was no seeded method to restrict access to specific segments.
A client of mine, a global financial institution, had identified 80 individuals who would require view-only access to all the segments in 2 Charts of accounts, and I was able to meet this challenge using 2 separate forms personalizations. I’ll discuss restricting access to specific modules, flexfields, structures, and segments in a follow-up blog entry, but for now, let’s look at preventing specific responsibilities from creating or editing segment values.
» Read More
E-Business Suite Release R12.1.3
Date: April 8th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12
R12.1.3 has been released for some time now. BizTech has compiled a list, module by module, of the main features that have been added, amended, or removed in this latest release.
R12.1.3: No New Functionality Added for the Following Financials Modules
BizTech has analyzed the following modules, and has determined that no new functionality has been added in R12.1.3.
- iProcurement
- Assets
- Advanced Global Intercompany Systems (AGIS)
- Payables
- Payments
- Profitability Manager
- Property Manager
- Receivables
R12.1.3: Tax, Legal and Regulatory Updates
Date: April 7th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12
R12.1.3 has been released for some time now. BizTech has compiled a list of the Tax, Legal and Regulatory updates that have been added, amended, or removed in this latest release.
» Read More
R12.1.3: New Functionality Added for Financials
Date: April 6th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12
BizTech has analyzed the following modules, and has determined that significant functionality has been added in R12.1.3. Some of the more significant functionality has been backported to older releases, and where appropriate, BizTech has identified the necessary patches.
» Read More
ADI and Desktop Integrators – Collaborate Presentation
Date: April 4th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12
In 11i, the go-to tool of the financial analyst was Application Desktop Integrator (ADI) – from here, an analyst could format financial reports, drill down on the numbers produced to get journal line detail, enter and upload a journal entry or an entire budget.
With the changes in architecture in R12, ADI is no longer supported, and the functionality provided by ADI has been replaced by other modules. BI Publisher has become the primary report formatting tool, Report Manager delivers report repository functionality (as well as drill-down functionality for FSG reports),and many white-papers and presentations exist for these areas.
I’ve found that there isn’t much documentation around Oracle’s solution for the upload process – Desktop Integrators. Desktop Integrators allow you to load data from Excel into ANY Interface or API, using the same validation as if you were entering data through the forms. The tool allows you to build Lists of Values that will reach back to the database to ensure all entered data is correct before you import into the database.
To learn more about the tool, please come to my session at Collaborate 2011 – I’m presenting “Desktop Integrators – You mean I can load data from a spreadsheet straight into an interface??” on 4/13 at 2:15pm. The ADI Special Interest Group (of which I’m the chairperson) is also meeting at Collaborate on 4/10 at 1:30pm.
ADI ALM Analytics BI Implementation BI Publisher Business Intelligence Cloud Computing Collaborate 2011 CRM CRM On Demand Dashboards Disaster Recovery ETL Financial Analytics Forms Personalization GL Golden Gate Informatica Interface iPad iPhone iSupplier IT Management IT Trends KPIs LDAP Managed Services MapViewer Metadata Mobile Computing OAUG OBIA 7.9.6.3 OBIEE 11g ODI Oracle Business Intelligence Applications Oracle EBS R12 Oracle Financials Oracle Projects Order Management R12 Upgrades Reports Single Sign On Supply Chain Tax & Regulatory Vision Instance
