R12.2 : Transforming EBS Financials with Fusion Accounting Hub

In R12.2 , there is one important enhancement which transform EBS Financials with Fusion Accounting Hub. The Oracle Fusion Accounting Hub provides integration for the Oracle General Ledger . This new enhamcement in term of integration provides you with the opportunity to leverage the Oracle Fusion Accounting Hub with minimal implementation effort and without disruption [...]

Oracle EBS 12.2 Online Patching – First Glance

Anyone that’s been following the release of 12.2 knows that Online Patching is the BIG feature that everyone is talking about.  I’ve had the opportunity to utilize this new functionality and it’s been quite interesting.  Online Patching is based on the Oracle Database 11.2 feature called (more...)

Bursting in One Step from R12.2: Users in the Dark on Request Status

In the latest release of EBS R12.2, Oracle has introduced the ability to burst in a single concurrent request. Although we predicted this was coming, we weren’t sure what it would mean for users and support admins. What we have found is that the new feature actually creates (more...)

Printing Attachments in Oracle 12.2: How does it Stack Up?

With the release of EBS 12.2, Oracle is making the claim that they have improved the attachment printing process. After reviewing the integration, I completely disagree; they have not given users a better solution.  No matter how you slice it, Oracle EBS customers are no further ahead with (more...)

Oracle BI Applications (OBIA) 7.9.6.4 released

Good News Oracle Business Intelligence Application new version 7.9.6.4 is available to download.

Highlights of the Oracle BI Applications 7.9.6.4 Release:

  • New Application – Oracle Manufacturing Analytics with pre-built adapters for EBS Process Manufacturing R12.x and EBS Discrete Manufacturing R12.x and 11.5.10
  • New Application – Oracle Enterprise Asset Management Analytics with pre-built adapters for EBS R12.x, EBS 11.5.10 and IBM Maximo 7.5
  • Universal Adapter to extend the capability to other source systems
  • Certified for OBIEE 11g
  • Certified for Exalytics
  • Certified for DAC 11g including support for Exalytics / Times Ten, (more...)

TASK_GROUP_Load_PartyDimension “Duplicate Keys Found”

While Running Full load on Oracle Business Intelligence Applications 7.9.6.3, when using Source system R12 TASK_GROUP_Load_PartyDimension failed with error Log says the issue is because “duplicate keys found”

Extract from the Log

**********************************************************************************************************************

CREATE INDEX:W_PARTY_D:W_PARTY_D_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_PARTY_D:W_PARTY_D_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception

**********************************************************************************************************************

For Resolution:- Download and (more...)

Build an E-Business Suite 12.1.3 sandbox in VirtualBox with one hour of work

[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]

Self-directed learning about a product as complex as Oracle E-Business Suite can be challenging. Oracle helpfully provides a pre-built environment (called 'Vision') for training purposes. Configuring a viable training or "sandbox" environment on a workstation can be pretty daunting, however, considering:

  1. The memory and storage resources required to run a "small" Vision instance
  2. The need to install and configure the OS and a list of pre-requisite patches and packages
  3. Learning about the (more...)

R12 Federal Financials Subledger Accounting Teardown Webinar, 10-Aug, 9:00am ET

OAUG has invited me to present as part of their upcoming Best of COLLABORATE ’12 Educational Series.  I’ll be delivering the R12 Federal Financials Subledger Accounting Teardown presentation via Webinar on Friday, August 10th, starting at 9AM EDT.  This presentation is a deep-dive into most of the key SLA concepts that support the R12 Federal Financials SLA accounting engine.  My goal is to share what I’ve learned through 1 1/2 years of supporting one of the most complex Federal R12 upgrades to-date, now live for 5+ months.

Here’s the presentation agenda:

This is free for all OAUG (more...)

Bursting EBS Documents in a Single Step Available in R12.2?

I came across Bug 12927519 on Metalink today that suggests that EBS R12.2 may include an enhancement to allow for bursting of BI Publisher/XML Publisher documents in one step (it says it was ‘fixed in product version 12.2.0.20X’)!  I do not see anything about in the 12.2 Release Content Documents, but that’s nothing new.

Currently, to burst you have to run 2 concurrent requests.  The actual concurrent request to generate your output and then a second concurrent request to actually do the bursting (XML Publisher Report Bursting Program).  This is not (more...)

Important R12 FV PO Commitment Accounting Attribute Assignment Updates identified in patch 13610367

Patch 13610367, released earlier this year, provided an update to the seeded Federal Purchasing AAD that is important for all R12.1 Federal PO Customers to understand, even if not using the seeded Federal SLA definitions.  The AAD change included updates to a couple of the key Accounting Attribute Assignments for the FV PO Commitment JLT. 

The changes were:

Accounting Attribute Assignment: Allocated to Distribution Type, changed to source: Allocated to Main Document Distribution Type
Accounting Attribute Assignment: Allocated to First Distribution Identifier, changed to source: Allocated to Main Document Distribution Identifier

The SLA configuration we’re using at my current gig is non-seeded and agency-unique but modeled (more...)

Oracle Spring ’12 Federal Development Update

I didn’t attend, but there was an Oracle Federal Financial Briefing on 17-Apr in Reston where information was shared about some of the upcoming GTAS enhancements and target patch release dates.  Personally, besides focusing on our Fed R12.1.3 stabilization efforts on my current gig, I’m working to get smart on some of the basics associated with GTAS, the upcoming 6-digit USSGL standard and new Federal Accounting/System process changes associated.

As soon as we can get our hands on these new GTAS patches, we need to jump on them to start understanding some of the impacts to our (more...)

True Excel Templates for EBS – An Introduction

Excel based output from BI Publisher has been around for some time, however it wasn’t really Excel data (essentially XHTML that Excel knows how to read) and was created with a RTF template.  Mid-2011, Oracle released a patch for EBS that would allow what they labeled as ‘True’ Excel output.  It is considered ‘True’ in that it creates a binary Excel file and allows you to create the template in Excel.

As an introduction to Excel Templates in EBS, here are some things to keep in mind and a quick list of resources to get you started.

Things (more...)

Fun with EBS APIs, part II: Users and responsbilities (FND_USER_PKG)

In my previous post, I demo'ed some simple scripts to make changes to E-Business Suite profile options, using the API provided by the FND_PROFILE package. This post will look at the FND_USER_PKG package (no relation to the "ABS brake system"). While my examples only reference user creation and responsibility assignment, it's really worth reviewing the contents of the rest of the package; there's lots of useful stuff in there.

First things first

Disclaimer time! Are you surprised? I hope you're not surprised. Am I really copying this section from the previous post? Yup, I am!

  1. The example code presented (more...)

Fun with EBS APIs, part I: Profile options (FND_PROFILE)

The E-Business Suite APIs are not just the realm of developers and data migration specialists. There are a number of APIs, particularly in the FND module, that can make life a lot easier for Apps DBAs. In my next two (maybe three, if I'm feeling ambitious) posts, I'll provide some examples of how to use PL/SQL to perform tasks that normally require slogging around in the EBS Forms interface.

First things first

Disclaimer time! Are you surprised? I hope you're not surprised.

  1. The example code presented in this series of blog posts uses APIs written by Oracle to manipulate data (more...)

XLA/SLA AMB Components Underlying Data Structure

For anyone dealing with R12 Subledger Accounting (SLA) configuration and troubleshooting, it can be helpful to understand how the SLA Accounting Methods Builder (AMB) Components are organized within the XLA schema of the R12 database.  Here’s an Entity Relationship Diagram (ERD) I’ve put together as a tool to utilize when needing to build queries of most SLA configurations.  This doesn’t encompass every type of SLA component (e.g. it doesn’t include Business Flow data), since I focused it on just the AMB Components I deal with the most, but includes the major components.

Here’s a PDF copy of (more...)

Finally Cool: @OracleFedApps is on Twitter

If you haven’t visited the actual blog lately and are just keeping up via  a blog reader or some other type of subscription, you might have missed that I incorporated a Twitter feed a couple months back.  I admit, my tweets aren’t going to be as entertaining as @CharlieSheen and I don’t expect to have 8 million+ followers like @BarackObama, but I’m trying to share a few experiences from the R12.1.3 Federal upgrade I’m working through.  Hoping the short info may benefit others going through the same.  Tweets are a great quick, simple way to (more...)

R12 SLA Sources Breakdown

One of the most fundamental components of the R12 Subledger Accounting Architecture (SLA) is the concept of SLA Sources.  There is a good bit of documentation on many SLA components, including my prior OAUG Presentations on SLA, but good explanations of SLA sources are a bit harder to find.  So I thought I’d take a shot at helping spread better understanding with this post.

SLA Source values play critical roles in XLA event processing and R12 GL journal creation such as:

  • fundamental data elements that drive how Journal Line Type (JLT) and Account Derivation Rules (ADR) are (more...)

Be aware of R12 Data Model changes to properly assess R12 upgrade rework

Any entity upgrading to R12 should sufficiently understand the data model changes between 11i and R12.  Based on an entities’ dependence on the existing 11i data models that change, there can be a significant level of rework required to ensure that existing custom RDF/BI Pubisher Reports, Discoverer Reports, outbound interfaces, custom views, custom SQL & PL/SQL, etc. will function properly in the R12 environment.  Analysis of custom objects relative to the data model changes can’t just be limited to whether objects will compile or run in R12, but should also include analysis of whether the proper data is (more...)

Taking the edge off implementing SLA…

Are you struggling w/SLA burnout??  Looking for something to fill the time during a potential government shutdown??

Fully understanding and implementing SLA for Federal Financials continues to be quite a challenge in a current upgrade I’m working on.  This is especially true when trying to ensure all the proper Upward/Downward accounting is properly done, but at the same time ensuring the PYA adjustments are not overstated as part of document revisions.

So, we thought we’d have a little fun and honor Colorado’s Microbrewing heritage with a nice new little home-brewed special for our team to help us enjoy (more...)