OracleApps Epicenter

Previous Post: Are seeking auditing ability in EBS…use ‘AuditTrail’ Steps by step: Enabling audit trial As per the below example the ‘Define An application user’ is a user table name for FND_USER,the same steps you can follow for your own tables.

What is an AuditTrail? An AuditTrail is one of functionality for retaining a history of changes to data. What ,who and when can be identified on a particular table or column if the functionality is enabled. When you enter or update data in your forms, you change the database tables underlying those forms. [...]

MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called “Multi-Org Preferences”. What is “Multi-Org Preferences”? Multi-Org Preferences allows you to control the list of operating units to which you have access. Lets say you have around 20 OU’s divided [...]

As we know in R12 , the existing Multiorg architecture includes a new feature Multiple Organizations Access Control (MOAC). Lot of queries and question were asked by my readers, therefore this post completely focus on some of technical Insight because of architectural change.The minimum you should suppose to know is that Access Control feature has [...]

What is Report Manager? In Oracle EBS “report manager” is a product that has been offered to manage your reporting needs. Report Manager is basically a secure point-in-time report repository offering centralized management and distribution of reports. There are different levels of access that you can assign to reports that are generated by the Report Manager. You can [...]

This is yet another extension of previous post, will discuss how to manage and define layout of the WebADI integrator. Managing/Defining Layout You can also manage /Define layouts, means you can build the spreadsheet by modifying the Layouts. You must be in responsibility with access to the integrator to define the layout. Responsibility: Desk Integration Menu Options : [...]

As mention in earlier post (#1,#2,#3 ) , WebAdi is tool that can be used to load many different types of data from spreadsheet based excel application into various application of Oracle APPS. There are number of Seeded Integrator comes with Oracle, but still Oracle provides the capability to its expandability. Various Integrators to [...]

In last two post we have seen , Web ADI is a Browser based application, which enables users to log into the Oracle database and upload ADI spreadsheets, without having the ADI application installed onto the users machine.We have already seen step by step setup in 11i , now this post is extension of previous [...]

This post will briefly Let you take quick step by step guide for uploading Journal through WebADI in 11i . Uploading a Journal using Web ADI The Web ADI screens are viewed in sequence, each one selecting an aspect of Journal to be uploaded. It start with selection of the ‘Viewer’ the Excel version to be used [...]

There is one white papers from Oracle in area R12 Oracle Subledger Accounting. This was released sometime in last year Sept 2007, seems this is updated with latest version of April 2008. The Business Benefits of Oracle Subledger Accounting An Oracle White Paper September 2007 (latest version is of April 2008 ) Subledger & General Ledger Those who are [...]

Lets take about one of the great office productive tool based application which is called “Web ADI” that being used within the E-Business Suite to provide end-users with a familiar user interface.Key end users are highly accepted this productive tool , because of there own advantages and great office capability. ADI & Web ADI… ADI stands [...]

Yes, that true, this is one of the functionality that Payable managers are expecting in EBS. The Oracle payable still requires enhancement in few area where this is one called is ‘Stale Cheque management. This is very common trends seen by APAC entities , forced to do customization to automate this process. What is Stale [...]

Do you know : Closing the accounting period within a specific timeframe for any business is Important Sometime failing to close the accounting period due to accounting exceptions will delay the overall fiscal close process Lets take a case, how many of us aware of these problem reported during month end or during normal daily activity by account [...]

Long time back , I got a complementary copy of EBS books from author Roel Hogendoorn. These six books, roughly have 175-200 pages each, covering some of key areas of EBS. System Administration Workflow Flexfields Alert Reporting in E-Business Suite BI Publisher I am so delighted with the content in these BOOK that I thought to share to rest of community people. “…Extremely well [...]

I found, one nice article on OTN, for Invoice processing within SOA environment . Moreover, SOA (Service-Oriented Architecture) is still a hottest topic since past couple of years. SOA is still have confusing term because it describe two different things. The first two word(Service-Oriented) describe a software Development Methodology, where as word architecture , simply represent [...]

Background Once the entries have been made and before any report are extracted from the accounts, a trail balance is drawn up.This is standard accounting practice. This is just what it says it is - a try at balancing the figure before the profit is worked out and the balance sheet drawn up. [...]

In POS & Oracle integration , there was a need to unapply and reapply receipts which are already reconciled in Cash Management . The older SAP system, does work differently thus requirement was to achieve the same in oracle EBS. Scenario input To explore API availability to unapply and re-apply receipts which are already reconciled in cash [...]

In last two post we have seen , Web ADI is a Browser based application, which enables users to log into the Oracle database and upload ADI spreadsheets, without having the ADI application installed onto the users machine.We have already seen step by step setup in 11i , now this post is extension of previous [...]

Lets take about one of the great office productive tool based application which is called “Web ADI” that being used within the E-Business Suite to provide end-users with a familiar user interface.Key end users are highly accepted this productive tool , because of there own advantages and great office capability. ADI & Web ADI… ADI stands [...]

This is bit off-line topic(DBA Track) for sizing process in new EBS installation. Line managers, infrastructure heads, IS team, DBA and Implementation Leads must have to understand some key points for sizing as: Sizing is a complex, iterative process and must be treated with care during the implementation. It should not get conflicted as Sizing a mere [...]