Saturday, June 30, 2012

No entries found for list of values while running Purchase Order print report


One of the Inventory user was getting the below error "No list of values error" while running purchase order print report"



We have given the same responsibility to 3 users and 2 of them were able to run the report successfully but only one user was reporting the above error.

I checked responsibility and users every thing was looking fine but when i checked their EBS userids then came to know the user who is getting the error was not defined as an employee in Purchasing Super user ====> Setup===> Employee. Either to define employee in HR or in Purchasing and we are using purchasing to define the employees

Once i defined the employee and tagged the same employee name in User creation form like below screen , our issue was resolved :)



Tuesday, June 5, 2012

Oracle General Ledger Overview



The Oracle General Ledger is the central repository of accounting information. The main purpose of a general ledger system is to record financial activity of a company and to produce financial and management reports to help people inside and outside the organization make decisions.



Oracle General Ledger is a comprehensive financial management solution that enables you to:


·         Record and Review Accounting Information


·         Import data from subsidiary ledgers, or enter journals to record actual or budget transaction directly into oracle general ledger


·         Enter encumbrance journals to track encumbrances through the purchase process and to control spending against budgeted amounts.


·         Review account balances online or through reports.


·         Analyze, correct, and adjust accounting information.


·         Correct actual, budget, and encumbrance information.


·         Revalue and translate balances denominated in foreign currencies.


·         Consolidate balances from multiple ledgers.


·         Analyze Accounting Information


·         Integrate Oracle GL with Oracle Discoverer, or Web Applications Desktop Integrator to simply the budgeting and forecasting process.


·         Use FSG to build customized reports with reusable report objects.


·         Use Oracle Report Manager to submit and publish FSGs




      General Ledger Accounting Cycle


   
1- Open period
2- Create/reverse journal entries


3- Post


4- Review


5- Revalue


6- Translate


7- Consolidate


8- Review/correct balances


9- Run accounting reports


10- Close accounting period