Posted on May 10th, 2008 by Sanjit Anand || Email This Post

Posted in Oracle Application | No Comments »
Posted on May 10th, 2008 by Sanjit Anand || Email This Post
Posted in Oracle Application | No Comments »
Posted on May 9th, 2008 by Sanjit Anand || Email This Post
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 backward compatible. Technically means that there are no code or procedural changes if MOAC is not implemented (i.e. The user is assigned one operating unit for a responsibility).
Posted in R12, Release12, Technical | 4 Comments »
Posted on May 9th, 2008 by Sanjit Anand || Email This Post
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 tie these access rights to your department assignments, to employees, or can build your own.
The report manager reports are stored in the database and can be published to a wider audience. The good is that you can manage access/availability to multiple groups of people. This is run as a menu option from the main menu of a specific application (AP, AR, etc.).
Report Manager benefits
R12 Report Manager
The Report Manager seeded functions need to be assigned manually by the System administrators to appropriate responsibilities based on the types of reports a user submits and publishes in their job. For example, a system administrator might assign the Financial Report Template Editor and Financial Report Submission functions to an existing General Ledger responsibility already used for submitting Financial Reports by General Ledger users.
The seeded Report Manager functions are:
Release 12, ADI & Report Manager
In Applications Release 12, WebADI and Report Manager must be used instead of ADI, as client/server ADI is not supported for that release. Also in Release 12 the WebADI functionality for GL is integrated into the standard GL menu structures. These functions are ‘Launch Journal Wizard’, ‘Launch Budget Wizard’, and the spreadsheet upload of Currency Rates, via ‘Currency Rates Manager’.
When To Use Report Manager(Implementation consideration)
This is very important to understand when offering to customer for this product. Oracle Report Manager you need to:
Posted in Finance, Oracle General Ledger | 9 Comments »
Posted on May 9th, 2008 by Sanjit Anand || Email This Post
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.
Posted in Web ADI | No Comments »
Posted on May 9th, 2008 by Sanjit Anand || Email This Post
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 load different types of information. However, you can do setups new, custom spreadsheet can be created to load different types of information into Oracle.
Basic User Procedure we have seen for a webADI is
Posted in Oracle General Ledger, Web ADI | 14 Comments »
Posted on May 7th, 2008 by Sanjit Anand || Email This Post
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 post with a case of R12.
1. Responsibility: As mention earlier WebADI User linked to the correct Set of Books for your business. In R12 , the starting point would be responsibility called Desktop Integration
Posted in Oracle General Ledger, Web ADI | 2 Comments »
Posted on May 6th, 2008 by Sanjit Anand || Email This Post
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.
Posted in Oracle General Ledger | 31 Comments »
Posted on May 2nd, 2008 by Sanjit Anand || Email This Post
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.
Subledger & General Ledger
Those who are not having accounting background should understand , every accounting system will have a number of subsidiary ledgers (called subledgers) for items such as cash, accounts receivable, accounts payable, inventory , purchasing like wise. All the entries that are entered (called posted or booked) to these subledgers will transact through the general ledger account. For example, when a credit sale posted in the account receivable subledger turns into cash due to a payment, the transaction will be posted to the general ledger and the two (cash and accounts receivable) subledgers as well.
There are instances when items will go directly to the general ledger without any subledger.These items will be linked to your balance sheet but not to your profit and loss statement.
The Concept is more or less addressed same in newly R12 SLA accounting , therefore you should note:
More Reading on SLA
Posted in Subledger Accounting | 4 Comments »
Posted on May 2nd, 2008 by Sanjit Anand || Email This Post
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 for Applications Desktop Integrator, and is an Excel based interface through which users can upload and view data in the Oracle system.To access the database, users must use their standard Oracle User name, and password.
Web ADI is a Browser based application, which enables users to log in to the Oracle Database, and upload ADI spreadsheets, without having to have the ADI application loaded locally on the users machine, or having it set up on a central server and users accessing it through Citrix.
For Web ADI to work, interfaces are set up. These interfaces are Macro driven spreadsheets, in which specific cells are linked to database table columns, and match to fields in the Standard Oracle Forms. Through them data is fed into the database, which can subsequently be viewed in the Core Oracle Forms.
The difference between ADI and WebADI
The main big between ADI and Web ADI, is that Web ADI is now based out of framework for building Desktop Integration applications in the EBS.That means we can designed and extend with a combination of meta-data and java. There is no requirement for these teams to know Visual Basic for Applications or the techstack requirements to get Office to interact with the Oracle Middle Tier or any of a hundred different nuances in the desktop environment.
Posted in Oracle General Ledger, Web ADI | 16 Comments »
Posted on May 2nd, 2008 by Sanjit Anand || Email This Post
Following are the main ebusiness tax tables that will contain the setup information that will help support in troubleshooting ebusiness tax in formation.
Debugging tax , use these queries :
SELECT * FROM zx_regimes_b WHERE tax_regime_code = <tax_regime_code>
SELECT * FROM zx_taxes_b WHERE DECODE(‘&tax_name’,null,’xxx’,tax) = nvl(‘&tax_name’,’xxx’) AND tax_regime_code = <tax_regime_code>
SELECT *
FROM zx_status_b
WHERE tax = <tax_name>
AND tax_regime_code = <tax_regime_code>
SELECT * FROM zx_rates_b WHERE tax = <tax_name> AND tax_regime_code = <tax_regime_code>
SELECT * FROM zx_jurisdictions_b WHERE DECODE(‘&tax_name’,null,’xxx’,tax) = nvl(‘&tax_n ame’,’xxx’)
AND tax_regime_code = <tax_regime_code>
Posted in Oracle E-Business Tax | No Comments »