Standard Reports and Processes in Purchase order

Reports and Processes

Accrual Reconciliation ReportAccrual Write-Off Report
Advanced Shipment Notice Discrepant Receipts Report
ASL Upgrade Process
Backordered Internal Requisitions Report
Blanket and Planned PO Status Report
Buyer Listing
Buyer's Requisition Action Required Report
Cancelled Purchase Orders Report
Cancelled Requisition Report
Contract Status Report
Create Internal Sales Orders Process
Create Releases Process
Encumbrance Detail Report
Expected Receipts Report
Fill Employee Hierarchy Process
Financials/Purchasing Options Listing
Internal Requisition Status Report
Internal Requisitions/Deliveries Discrepancy Report
Invoice Price Variance Report
Invoice Price Variance by Supplier
Item Detail Listing
Item Summary Listing
Location Listing
Matching Holds by Buyer Report
New Supplier Letter Report
Open Purchase Orders Report (by Buyer)
Open Purchase Orders Report (by Cost Center)
Overdue Supplier Shipments Report
Overshipments Report
Payment on Receipt
Printed Change Orders Report (Landscape)
Printed Change Orders Report (Portrait)
Printed Purchase Order Report (Landscape)
Printed Purchase Order Report (Portrait)
Printed RFQ Report (Landscape)
Printed RFQ Report (Portrait)
Printed Requisitions Report
Purchase Agreement Audit Report
Purchase Order Commitment by Period Report
Purchase Order Detail Report
Purchase Order Distribution Detail Report
Purchase Order and Releases Detail Report
Purchase Price Variance Report
Purchase Requisition Status Report
Purchase Summary Report by Category
Purchasing Activity Register
Purchasing Database Administration
Purchasing Documents Open Interface
Purchasing Interface Errors Report
Quality Code Listing
Quotation Action Required Report
RFQ Action Required Report
Receipt Accruals - Period-End Process
Receipt Adjustments Report
Receipt Traveler
Receiving Account Distribution Report
Receiving Exceptions Report
Receiving Interface Errors Report
Receiving Transaction Processor
Receiving Transactions Register
Receiving Value Report
Receiving Value Report by Destination Account
ReqExpress Templates Listing
Requisition Activity Register
Requisition Distribution Detail Report
Requisition Import Process
Requisition Import Exceptions Report
Requisitions on Cancelled Sales Order Report
Reschedule Requisitions Process
Savings Analysis Report (by Buyer)
Savings Analysis Report (by Category)
Send Notifications for Purchasing Documents
Standard Notes Listing
Substitute Receipts Report
Supplier Affiliated Structure Listing
Supplier Price Performance Analysis Report
Supplier Purchase Summary Report
Supplier Quality Performance Analysis Report
Supplier Service Performance Analysis Report
Supplier Volume Analysis Report
Suppliers on Hold Report
Tax Code Listing
Uninvoiced Receipts Report
Unit of Measure Class Listing
Unit of Measure Listing
Unordered Receipts Report
Upgrade Notifications to Release 11 Process

Standard reports and listings IN APPS

Standard reports and listings

• Account Analysis Report
• Account Analysis Report with Payables Detail
• Account Analysis Report with Subledger Detail
• Account Analysis Report with Subledger Detail II
• Account Hierarchy Report
• Archive and Purge Audit Report
• Assign Budget Account Ranges Execution Report
• AutoPost Execution Report
• Average Balance Trial Balance report
• Budget Assignments AutoCopy Execution Report
• Budget Hierarchy Listing
• Budget Journals by Flexfield Report
• Budget Organization Range Listing
• Budget Spreadsheet Upload Execution Report
• Budget Trial Balance Report
• Budgetary Control Transactions Report
• Carry Forward Execution Report
• Chart of Accounts Listing
• Column Set Detail Listing
• Column Set Summary Listing
• Consolidation Audit Report
• Consolidation Exception Report [2]
• Consolidation Journals Report
• Consolidation Rules Report
• Content Set Detail Listing
• Content Set Summary Listing
• Create Journal Entries Execution Report
• Daily Conversion Rates Listing
• Delete Journal Import Data Execution Report
• Detail Trial Balance Report
• Dual Currency Journals Report
• Encumbrance Trial Balance Report
• Error Journals Report
• Expanded Trial Balance Report
• Foreign Account Analysis Report
• Foreign Account Analysis Report with Payables Detail
• Foreign Currency Detail Trial Balance Report
• Foreign Currency General Ledger Report
• Foreign Currency Journal Report
• Foreign Currency Summary 1 Trial Balance Report
• Frozen Budget Accounts Listing
• Funds Available Analysis Report
• General Ledger Report
• Historical Rates Execution Report
• Historical Rates Listing
• Intercompany Transactions Detail Report
• Intercompany Transactions Trial Balance
• Intercompany Transfer Program Execution Report
• Journal Batch Summary Report
• Journal Day Book Report
• Journal Entry Report
• Journal Import Execution Report
• Journal Line Report
• Journals - Voucher Report
• Journals by Document Number Report
• Journals Report with Subledger Detail
• MassAllocation Formula Listing
• MassAllocations/MassBudgeting Execution Report
• MassAllocations/MassBudgeting Validation Report
• MassApproval Journal Execution Report
• Master/Detail Budget Report
• Open Encumbrance Balance Report
• Period Rates Listing
• Posted Journals Report
• Posting Execution Report
• Recurring Formula Listing
• Recurring Intercompany Transactions Execution Report
• Report Detail Listing
• Report Set Detail Listing
• Report Set Summary Listing
• Report Summary Listing
• Revaluation Execution Report
• Rollup Detail Listing
• Rollup Range Listing
• Row Order Detail Listing
• Row Set Detail Listing
• Row Set Summary Listing
• Running
• Segment Values Listing
• Summary 1 Trial Balance Report
• Summary 2 Trial Balance Report
• Summary/Detail Budget Report
• Suspense Accounts Listing
• Tax Journals Report
• Translation Trial Balance Report
• Unapproved Intercompany Transactions Listings
• Unbudgeted Master/Detail Accounts Report
• Units of Measure Report
• Unposted Journals Report
• Value-Added Tax Report
• Where Used Report

Trial Balance Reports IN APPS

Trial Balance Reports

Average Trial Balance ReportBudget Trial Balance Report
Detail Trial Balance Report
Encumbrance Trial Balance Report
Expanded Trial Balance Report
Foreign Currency Detail Trial Balance Report
Foreign Currency Summary 1 Trial Balance Report
Summary 1 Trial Balance Report
Summary 2 Trial Balance Report
Translation Trial Balance Report

Retirement of Oracle Application Implementation Method (AIM) Advantage and Oracle AIM for Business Flows Planned for January 31, 2011

Retirement of Oracle Application Implementation Method (AIM) Advantage and Oracle AIM for Business Flows Planned for January 31, 2011

COMMON GLOSSARY USED IN ORA APPS

COMMON GLOSSARY USED IN ORA APPS

Overview of Multi-Currency Accounting

Overview of Multi-Currency Accounting

   To set up multi-currency accounting:

1. Define the conversion rate types you want to use to maintain daily exchange rates and to enter foreign currency journals. General Ledger comes with four predefined conversion rate types: Spot, Corporate, User, and EMU Fixed. See: Defining Conversion Rate Types.

2. Define and enable the currencies you want to use. General Ledger predefines all ISO currencies, but you can define as many additional currencies as you need. See: Defining Currencies.

3. Assign a functional currency to your set of books. General Ledger records all transactions and maintains all of your account balances in the functional currency. See: Defining Sets of Books.

4. If you use Multiple Reporting Currencies, assign reporting currencies to your reporting sets of books. See: Multiple Reporting Currencies Overview.

5. Define a Cumulative Translation Adjustment account for your set of books. Set the account type of your Cumulative Translation Adjustment account to:

• Owner's Equity: to create a translation adjustment on your balance sheet.

• Revenue or Expense: to create a translation gain/loss on your income statement.

General Ledger automatically posts any net adjustments resulting from currency translation to this account in accordance with SFAS #52 (U.S.).

6. Define an account to use to record unrealized gains and losses that arise when you revalue account balances that are denominated in a foreign currency. See: Defining Accounts and Revaluing Balances.

7. Enter the daily rates you will need. Typically, you will enter rates to convert foreign currency journal entries into your functional and reporting currencies. See: Entering Daily Rates.

If you do not want to predefine daily rates, you can use the conversion rate type User to enter daily rates at the time you enter journals.

Note: If you have average balance processing enabled in your set of books, you must define a daily rate on or before the first day of the first year for which you want to translate balances.

8. Enter period rates for running foreign currency revaluation or translation. See: Entering Period Rates.

9. Enter historical rates or amounts to translate balances in your owner's equity accounts in accordance with SFAS #52 (U.S.). General Ledger also uses historical rates and amounts to remeasure selected account balances for companies in highly inflationary economies. See: Entering Historical Rates.

   To work with multiple currencies in General Ledger:

1. Update your daily conversion rates regularly.

2. Enter or import foreign currency journals. If you use the conversion rate type User, enter the currency conversion rate when you enter journals. See: Entering Foreign Currency Journals.

3. Post your foreign currency journal entries to an open period. General Ledger stores the foreign currency amount associated with each journal line, in addition to the converted functional currency equivalent. See: Posting Journal Batches.

4. Revalue asset and liability accounts whose balances are denominated in a foreign currency. General Ledger creates a journal entry to adjust the balances for exchange rate fluctuations in accordance with SFAS #52 (U.S.). Note that General Ledger creates the revaluation adjustments in your functional currency. See: Revaluing Balances.

5. Post the revaluation journal batch to adjust your unrealized gain/loss account for exchange rate fluctuations. See: Posting Journals.

6. Translate account balances before consolidating sets of books with different functional currencies, or to report account balances in an alternate currency. You can translate actual or budget balances. See: Translating Balances.

Note: If you use Multiple Reporting Currencies, you can report account balances in an alternate currency directly from your reporting sets of books. See: Multiple Reporting Currencies Overview.

7. Review entered and converted foreign currency balances online using the Account Inquiry window. You can also review translated amounts online using the Account Inquiry window. See: Performing an Account Inquiry.

Note: You must have previously translated your account balances to the foreign currency before you perform the translated account balance inquiry.

8. Run foreign currency Trial Balance reports. Use the:

• Detail, Summary1, Summary2, or Translation Trial Balances to view translated account balances after you run translation.

• Foreign Currency Detail, Foreign Currency Summary1, or Summary2 Trial Balances to view balances entered in a foreign currency.

• Foreign Currency General Ledger Report to reconcile revaluation journals after you run revaluation.

See: Running Standard Reports and Listings.

9. Produce foreign currency financial statements. Use the Financial Statement Generator to build custom reports to report on actual and budget translated account balances, as well as amounts entered in foreign currency. See: Overview of Financial Statement Generator.

Standard Reports and Listings in GENERAL LEDGER

Running Standard Reports and Listings

General Ledger gives you a complete set of standard reports such as journal reports, general ledgers, account analyses and trial balances. You can also request standard listings to review key non-financial information, including your chart of accounts, row sets, column sets and content sets, reporting hierarchies, consolidation definitions, recurring journal formulas, and more. All of the information in these reports and listings is also available online.You can combine standard reports, listings and programs into a request set to submit them as a group. In addition, if the Financial Statement Generator program is assigned to your responsibility, you can include FSG reports in standard request sets.
General Ledger provides the following categories of standard reports and listings:

• Account Analysis: These reports list the accumulated balances of a range of accounts and all journal entry lines that affect that range.

• Budget: These reports and listings contain information about your budgets and budget organizations, including account assignments and budget hierarchies.

• Chart of Accounts: These reports and listings provide information about the accounts in your chart of accounts, including segment values, rollup ranges and suspense accounts.

• Multi-Company Accounting and Consolidation: These reports and listings provide information about your multi-company accounting and consolidation activities. You can request reports about intercompany transactions made using General Ledger's CENTRA feature.

You can also request reports about a specific consolidation, including how your subsidiaries' accounts are mapped into your parent accounts. You must use the audit mode run option in order to request the Consolidation Audit Report and the Consolidation Exception Reports, and you can only request the Consolidation Journals Report for consolidations using the Transactions method.

• Currency: These listings show the daily, period and historical rates you defined for foreign currencies.

• Financial Statement Generator: These listings provide summary or detail information about the definitions of your Financial Statement Generator report components, reports and report sets.

• General Ledger: These reports list beginning and ending account balances, and all journal entry lines affecting each account balance in your functional and foreign currencies.

• Journals: These reports provide journal information in functional and foreign currencies, including posted, unposted and error journals. You can also review journal activity for particular periods and balancing segments.

• Trial Balance: These reports list account balances and activity for functional and foreign currencies, budgets, encumbrances and actuals. You can request this information by currency, accounts, and so on.

• Other: These reports and listings provide information about MassAllocation/MassBudget definitions, actual or budget recurring journal formulas, statistical units of measure and value-added taxes received and paid.

• Execution: These reports are automatically generated when you submit and complete a concurrent process.

   To run a standard report, listing, or request set:

1. Navigate to the Submit Requests window.

2. Choose whether to run a request or request set, then choose the request or request set you want to run.

3. Enter the necessary request parameters.

4. Submit your request.

5. Review the status of your request.

You can review all of your requests at the same time, or you can review only certain requests, based on the Request ID, phase or status you specify. General Ledger provides detailed information about your request, including request time, start time, report options, priority, status and much more.