Since this website receives lot of requests on ERP training institutes in India and in USA, I would like to create a section dedicated to this need. So if you or people you know have first hand experience with any institute please feel free to put the Name, address, website into the comments section of this post.
How to know which Discoverer sessions runs specific workbook, what application user ID and responsibility, what they are running?
Step 1:
======
/* Create funciton in Database base using APPS Schema */
Create or replace function disco_client_info
(workbook_name varchar2) return number is
BEGIN
--Set the client inforamtions
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(fnd_global.user_id||'~'||fnd_global.resp_id||'~'||workbook_name);
return 1;
--
END disco_client_info;
/* Grant execute privilege to Public */
Grant execute on disco_client_info to Public;
/* Grant execute privilege to Public */
Grant execute on disco_client_info to Public;
Step 2
=======
Register this function via the Discoverer Administrator
Step 3
=======
Call this function in Discoverer Desktop in all workbooks (which you want to monitor) as condition like below:
disco_client_info(’WORKBOOK_NAME’)=1
Since the function is always going to return 1 the condition will return true always.
Step 4
=======
If you run the below query you will get the information desired:
select module,client_info from v$session where module like 'Discoverer4';
Note: Module information ‘Discoverer4′ is set by Discoverer for Discoverer 4 version
using DBMS_APPLICATION_INFO.SET_MODULE. Change ‘Discoverer4′ to ‘Discoverer902′ for Discoverer 9.0.2 ,
‘Disco9′ for discoverer 9.0.4 and ‘Disco10′ for discoverer 10.1.X.
The draw back is, you are required to hardcode the workbook name in the condition since you can get workbook information dynamically only in title.
-submitted by Rajan
Quickbooks is a very popular “micro ERP” application and dominates the Small Business Market. One of the benefits of using Quickbooks for my own business is the simplicity and ease of use. You can run a report and from the report you can drill down straight to the transactions. I learnt a lot of things using quickbooks just by running reports, finding the reported amount in the wrong account, I would then drill down straight to the transactions, change the account, and when I refresh the report …boom.. I can see my changes. Instant productivity!
In one of the surveys it was mentioned, most of the new Small business’s fail not because of their execution or anything else but because the owner never realized where the problem is. To keep track of your business, you need to actively monitor who is your top customer, what is your open account receivables, what is your inventory etc.
Sure, all of this information is available right in Quickbooks but the problem is you need to run seperate reports to get all these informations. So lets say it typically takes 5 mins to run a typical report and if the business owner where to run say 10 different reports on a daily basis that itself accounts to a precious 50 mins of his/her time.
This is a big pain and the most painful part is that this is a tough part to comprehend, understand and implement for a small business owner.
My company produces this Dashboard Designer for small businesses but never realized the fact or the thought never occurred until one of the clients asked us the question “Can you create Dashboards on top of Quickbooks?”
Then the journey began…some research…and after few technical hickups we finally managed to create some sample dashboards on top of Quickbooks with Real time data.
The below screenshot is for Expense Analisys Dashbaord
The above dashboard is very dynamic. You can change the period type to Year,Quarter, Month, week or Days. The first chart shows the Expense trending by period, instantly tells you how you are managing your expenses.
The 2nd chart tells the Average Expense/Day which is an interesting KPI and the remaining two charts show the expense by payee (vendor) and by Account.
Now take a look at the below Sales Dashboard
here is the chart listing
“Sales by Period” (Year, Quarter, Month, Week, Days)
“Average Sales/Day”
“Top 10 Customers”
“Top 10 Products”
“COGS by Period”
Dashboards for Small Business – Solution and Price perfect