Oracle

As you probably already know, a portal is typically used as an information dissemination tool. One that exposes content and small units of functionality from disparate sources in a clean, unified manner. So how does WebCenter Portal fit into the domain of content management? Why should it, and to what degree should it? This post […]

Enterprise Design in EBS is one of the first things you tackle when beginning a new client engagement. It will likely include chart of accounts design, number of business groups, ledgers, legal entities, operating units (OU), and inventory organizations. This document will brush lightly on a few of these areas but will focus primarily on […]

The intent of this document is provide the reader with a fundamental understanding of Oracle’s Secondary Ledgers, enriched with lessons learned from actual implementations. Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient. Feel free to ask him any questions in the comments section below the […]

The intent of this document is provide the reader with a fundamental understanding of Oracle’s Cross Validation Rules, enriched with lessons learned from actual implementations.  Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient.  Feel free to ask him any questions in the comments section below […]

In a previous post I outlined two techniques for building mobile-ready Oracle WebCenter portals. In this post I demonstrate how one of those techniques (Responsive Web Design – RWD) could look and also call out 5 high level steps to implementation. To implement the responsive portal shown in the video, I adopted a hybrid approach […]

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert […]

This post explains the process to unload an error message from ODI repository log tables SNP_LPI_STEP_LOG, SNP_LPI_EXC_LOG to .txt file and attach it to a Load Plan failure notification email. Process: Create ‘Error_Notification’ package which uses ODISqlUnload utility to unload error message from log tables and write into text file, OdiSendMail utility to send email […]

Whenever a Full load is executed, all target tables are truncated and reloaded. This can result in missing historical data in Aggregate or Snapshot tables. Once erased, such historical data cannot easily be replaced. In order to preserve Account Payables (AP) and Account Receivables (AR) Snapshot data from aging invoice tables W_AP_AGING_INVOICE_A and W_AR_AGING_INVOICE_A, OOTB […]

Oracle just published a three-page white paper that does a pretty good job describing the landscape and drivers for digital marketing. The author focuses on: The changing journey from linear journeys to adaptive journeys How the marketing context has changed Multiple challenges you have to address.  This include the plethora of marketing technology choices Some things […]

This post will explain steps to Start and Stop ODI Server, ODI Agent in BIAPPS using Web Logic Server Admin Console. Log into WebLogic server http://<hostname>:7001/console Click on Environments on left side under Domain Strucuture

The most common problem with ODI incremental loads: whenever a prior incremental load fails, we have to manually inactivate the load plan schedule and update the agent schedule to stop executing the next load. Once the prior incremental load’s issue is fixed and its execution completed successfully, we have to activate the load plan schedule […]

The intent of this document is provide the reader with a fundamental understanding of Oracle’s Journal Entry Approval Workflow enriched with lessons learned from actual implementations.  Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient.  Feel free to ask him any questions in the comments section […]