Activity Stream


2 days ago
new user registration
Diane Edwards joined our community! Welcome!

new user registration
Manas Ray joined our community! Welcome!

5 days ago
new user registration
Prashant Kalantri joined our community! Welcome!


new user registration
Vineet Verma joined our community! Welcome!

new user registration
Thijs Janssen joined our community! Welcome!

General E-Business Suite
Open Account AP Balance Listing - Excel version
( 0 Votes )
XML Publisher
Written by Jouke de Groot   
Monday, 06 April 2009 16:32

The AP Trial Balance has been replaced by the Open Account AP Balance Listing in R12 (see Note 604739.1). This report is a variation on the more general Open Account Balances Listing, and shows basically the remaining amoutn for all open AP invoices. The balance should match your AP liaility account(s) in General Ledger.

Read more...
 
Is there still a reason to use ADI ?
( 0 Votes )
Other
Written by Jouke de Groot   
Thursday, 21 August 2008 15:56

No, there's not. Even stronger: ADI is not supported for R12 anymore. WebADI combined with Report Manager cover the same functionality as the original Applications Desktop Integrator. See Note 223223.1 on Metalink for the official announcement.

Read more...
 
Viewing Standard Reports in Excel
( 0 Votes )
System Administrator
Written by Jouke de Groot   
Monday, 30 June 2008 17:05

... even without using XML Publisher!


Excel 2003 (and higher) has the possibility to open XML files immediately using the report's plain column structure. So if your customer is not using XML Publisher, or you simply want a quick workaround, it is possible to open the Oracle output directly into Excel 2003 (and higher).

Read more...
 
Database connection file for iSetup
( 0 Votes )
iSetup
Written by Jouke de Groot   
Monday, 26 May 2008 08:35

I was triggered by the article of Uma Prabhala on Steven Chan's weblog, called Ten Ways of Using iSetup to Streamline E-Business Suite Implementations. To be honest, I thought that iSetup was decommisioned (see the message on https://isetup.oracle.com), but it appears that it is still alive and in fact it looks more promising then ever. When I tried to do the setup I encountered an issue on creating a .dbc file, which is a mandatory setup step.

Read more...
 
Profile Option values script
( 0 Votes )
SQL Scripts
Written by Jouke de Groot   
Monday, 10 December 2007 12:01

Profile Option values are extremely important ... and difficult to extract from the system. As far as I am aware, the only standard report is the 'User Profile Option Values' report.

So a while ago I created a SQL script to extract them from the database. I usually export the output to Excel to do the actual analysis.

Read more...
 
<< Start < Prev 1 2 Next > End >>

Page 1 of 2