Finding the focus of your business and monitoring your success in that particular area is the key to success in today’s diverse market. You can monitor how well your company is maintaining strategic focus by defining your Key Performance Indicators and investing in a business intelligence software program that will help you keep track of [...]

Data problems can severely affect the quality of your business intelligence analysis, but they are often hard to detect. Because they don’t stop your analysis process right away, they can slowly become more and more of a detriment until they finally destroy your BI project. Because of how destructive unreliable data can be, one of [...]

Companies large and small can benefit from a well thought out business intelligence strategy, but developing that strategy can sometimes be more challenging than implementing a business intelligence program.  To make sure that your company is getting the most out of your BI program, make sure that you define your goals and have a plan [...]

If your Discoverer reports are not returning data in R12 then here are the steps R12 uses new Security Policies and for Receivables, it uses Views starting with ARFG Please follow the following steps : 1. Create a new responsibility with Accounts Payables/ Accounts Receivables as Application. (skip this if you already have custom responsibilities) 2. Set the profile [...]

This topic is shared to provide an overview of Data Conversion for Oracle ERP. Approach used for Data Conversion 1. Conversion Data Mapping ( map to specify the data of legacy system –> data of oracle ERP system ) 2. Download Programs ( programs to extract data from database and insert into the Flat file ) 3. ASCII Flat [...]

Q1. What are the billing cycle requirements for invoice generation? A: A project must meet the following billing cycle criteria before it can generate an invoice: a. No pending (unreleased) invoices exist b. At least one bill cycle past the bill through date (or creation date if no bill through date exists) of the last non crediting invoice c. [...]

01. In order to print XML Publisher reports in PDF format directly from the concurrent manager to a printer you will need to: a. Have a Postscript ready printer. b. Install Pasta c. Install third party software to convert the PDF file to another graphical format that the printer understands, such as Postscript by way of GNU utility [...]

In Oracle Apps, each transaction id, Document numbers etc is derived from Database sequences. These sequences increment in value everytime you use them. When you are in Oracle Apps, it fetchs 20 or so sequences in bulk when you are in the process of creating invoices or any kind of transactions. For e.g if you [...]

If you are a blogger and use wordpress then you might find this plugin very interesting “DashboardZone is proud to present a brand new plugin to monitor your Blogging goals. This plugin will help you and your readers to keep you on track for reaching your targets. We created this wordpress plugin that monitors the various [...]

If you happen to install Discoverer seeded apps EUL and use the seeded GL workbooks then there are chances that your workbooks may not show any data. (seeded means that comes pre-installed or with a patch from Oracle) The cause for this no data in workbook issue is incomplete BIS setups The “FII: GL BIS Discoverer access” [...]

I get lot of emails asking questions about career with ERP. For example, one of our readers asked the question below “Hi, I have done MBA in Finance and willing to work in ERP, which modules would be better suited for my skillset” The beauty of any ERP system, is you need both functional and technical people [...]

A customer is the most important visitor on our premises. He is not dependent on us. We are dependent on him. He is not an interruption in our work - he is the purpose of it. We are not doing him a favour by serving him. He is doing us a favour by giving us the opportunity to [...]