May 10th, 2012 by Ian Boyling
A new feature within Release 12 of Oracle General Ledger is the ability to copy previously created journals. You can now copy entire journal batches with any status by using the AutoCopy button which is strategically placed on the Journals Workbench, Journal Batches and Journal forms. When copying Journals, you are prompted to create a batch name, select a period and/or the effective date.
Clicking OK will then submit a concurrent request called ‘Autocopy Journals’. Once this is complete, you can modify and update the batch, journal and lines in the normal way.
This is useful functionality and will reduce the amount of effort required to re-create common journals should the recurring journal functionality not be suitable.
I hope you find this useful.
Ian
Tags: Copy Journals, E-Business Suite, EBS, General Ledger, GL, Journals, R12, Release12
Posted in E-Business Suite, Functional | No Comments »
May 8th, 2012 by James Walsh
In a recent training session for Oracle 10g, requests were used to present information for the “Top N” most expensive projects. During the session a delegate asked whether it was possible to present a row in the table that shows the value of all the other projects. The change would result in information being presented as shown in the table below, with the row highlighted in yellow being a summary of all the other records not in the Top N:
| Fiscal Year |
Project Number |
Project Name |
Cost |
| 2007 |
ATZ Services |
ATZ Services |
|
| 2007 |
PC201 |
Percent Complete – Operations |
26,359 |
| 2007 |
FP201 |
Fixed Price – Operations |
19,541 |
| 2007 |
CS419 |
Redwood City 419 Construction |
18,000 |
| 2007 |
Bldg Renovation |
Bldg Renovation |
13,314 |
| 2007 |
AD201 |
Administrative |
11,340 |
| 2007 |
100123 |
New Store 100123 |
8,153 |
| 2007 |
B200 |
Building 200 Construction |
4,858 |
| 2007 |
Corp Srvcs |
Corporate Services |
4,793 |
| 2007 |
SS2349 |
Redwood City Selection |
1,200 |
| 2007 |
All Other Projects |
All Other Projects |
###### |
| Total Cost |
162,574 |
Two methods to achieve the result will be described in this article, these methods can also be used with Oracle BI 11g. The first method is slightly easier to implement as all the work is done in a single request. However this method is not ideal for a large volume of rows that is to be ranked.
Tags: Answers, Dashboards, OBI, rank, TopN
Posted in Business Intelligence, OBIEE | No Comments »
May 8th, 2012 by James Walsh
During a training session I demonstrated a technique used to present users with a Clear Prompts button. This article will provide the information to replicate the same feature in your dashboard development.
This example uses a dashboard prompt with some Oracle BI Applications sample data. The dashboard prompt has been setup to display the Fiscal Year with a default value of 2012 and Operating Unit Organization Name of Vision Operations.
Read the rest of this entry »
Tags: 10g, Dashboard, Dashboard Prompt, Oracle BI
Posted in Business Intelligence, OBIEE | No Comments »
May 4th, 2012 by Robin Harris
After an upgrade to E-Business suite R12.1.3 on one of our test servers we encountered an issue with the Invoice Workbbok form (APXINWKB.fmb).
When trying to enter an invoice line it would error when saving or performing other tasks which involved validating the data. (e.g. Calculate Tax)
The error encountered was:
ERROR
———————–
Invalid argument to LINE_SUM_FOLDER_ITEMS_ITEM.ASSET_BOOK: EVENT=’WHEN-VALIDATE-ITEM’
Read the rest of this entry »
Tags: APXINWKB, E-Business Suite, FRM-40735, Payables, R12.1.3
Posted in Apps DBA, E-Business Suite, Functional, Technical | No Comments »
May 1st, 2012 by Robin Harris
As a follow up to my last blog post on Informatica no longer supporting 8.6.1, I have completed a test upgrade on one of our internal development systems. This system is an installation of Oracle BI Applications 7.9.6.2 on Oracle Enterprise Linux 5 (64-bit) with the data warehouse and repositories being stored in an Oracle 11.1.0.6 database.
In case of any doubt Informatica 9.0.1 is now certified with BI Applications 7.9.6.0, 7.9.6.1 and 7.9.6.2 and 7.9.6.3. Details can be found in the ‘System Requirements and Support Platforms for Oracle Business Intelligence Applications version 7.9.6, Rev. N’ which was released in December 2011.
The upgrade ran smoothly and quite painlessly and this post will breifly cover the steps I took to perform the upgrade.
Read the rest of this entry »
Tags: Informatica Upgrade 8.6.1 9.0.1
Posted in BI Applications, Business Intelligence | No Comments »
