How to Manage Rebuildable Assets in Oracle eAM

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

There are many reasons for having high-value parts sitting on shelves in your maintenance shop. The parts may be critical to the production line or are part of configurations that allow you to produce multiple lines or sizes of product from the same machine. They might even be essential parts that are no longer produced by the machine maker and have no (more...)

Collecting Data for Planning on a Nightly Basis is Good Enough

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Without fail, I am asked the same question every time I give a training session on the Oracle Advanced Supply Chain Planning (ASCP) application.

In explaining how ASCP uses data collections, I share a planning data collection summary based on yesterday’s information that was collected overnight. Then I pause and wait for it… Within 60 seconds I always hear the question: (more...)

How to Use Oracle Projects Suite for Engineered-to-Order Companies

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Abstract: In an engineered-to-order (ETO) manufacturing company—where every product is custom-built to customer specifications—Oracle Projects Suite serves as the data repository for all phases of planning (i.e. design, engineering, manufacturing/production, and delivery).

Posted on January 15th, 2015 by Sameer Raleraskar

By effectively tracking progress, Projects Suite enables more control over time and budget from design to delivery. Projects Suite can provides (more...)

Leveraging Subledger Accounting in R12 Implementations

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Abstract: Oracle E-Business Suite Release 12 includes enhancements that assists large enterprises to facilitate the centralization of their backend operations (e.g. processing invoices, and general accounting). This new functionality simplifies the way processes and policies can be implemented across multiple legal entities and lines of business, providing standardization across an enterprise.

Posted on January 13th, 2015 by Sameer Raleraskar

Subledger Accounting (more...)

Part 2: Test Drive of User Defined Attributes in Order Management from R12.2

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Note: This is a continuation of my previous post on User Defined Attributes in Order Management for R12.2. If you have not done so already make sure to check out Part 1 of this series, here.

Getting UDA Information onto the Sales Order Record

There are two basic options here: the first one is to enter the data directly in the sales order entry forms; and (more...)

Part 1: Test Drive of User Defined Attributes in Order Management from R12.2

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

 Note: This is a continuation of my previous post on this specific subject matter. If you are not familiar with User Defined Attributes (UDA), we recommend you first read  the proceeding article from November 2013—The rise of User Defined Attributes through Release 12.2—where we discussed the history of User Defined Attributes (UDAs), the basics of their functionality and how they compare (more...)

Navigating the New Waters of R12.2 Development & Customization Part III

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

 

Prepare and Package Lesser Impacted Customizations

The third episode of this series is where you catch your breath with R12.2 changes. With the latest edition there are a few objects that still work the good old way or have minimal changes in the way they are packaged.

Posted on December 31, 2014 by Dinesh Babuji

Custom Java Code

1.  If your customizations include (more...)

Navigating the New Waters of R12.2 Development & Customization Part II

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Below is a continuation of my previous article titled: “Navigating the New Waters of R12.2 Development & Customization Part I“.

Introduction-

In this second part of the series, I will discuss the technical details of the Significantly Impacted Database Objects in R12.2. Your take away from this blog will be the steps and/or syntax:

New Labor Cost Features in Oracle R12.2

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

– Multiple Cost Rates to Support Federal Davis-Bacon Act Requirements

The wait is finally over… after years of complex custom forms, custom tables and very intricate extensions, Oracle R12.2 Projects can now provide functionality to support the Federal Davis-Bacon Act Requirements.

First, we need to start with what the Davis-Bacon Act is to fully understand the implications of the new functionality. (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...)

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