Thursday, August 16, 2018

Vertex & Oracle

VERTEX is a Philly based corporate tax technology company and has been the industry leader in indirect tax technology for four decades. It works closely with SAP, Oracle & Microsoft Dynamics to provide Cloud based Tax solutions.

Vertex is Oracle Platinum Partner and once you license Vertex for Oracle ERP Cloud, it will load all tax related setup files and tax automated for AR/AP. Real time link to Vertex maybe formed from the application and instant tax rates calculated. Also supports Oracle Batch processing.

We've been seeing monthly Vertex Payroll Tax Update on our Oracle Cloud.

Tuesday, February 9, 2016

Q&A - Oracle Purchasing

PO q&a

Q1. How to mass finally close POs?
- Not finally close. Program Mass Close of Purchase Documents to mass close (not finally close) POs.

Q2. How to uncancel / reopen cancelled POs?
- Cancel status is permanent and can't be reversed.

Q3. 

Saturday, September 12, 2015

Auto Allocation


Thursday, September 10, 2015

Business Intelligence (BI)

Oracle Business Intelligence (BI) Application extracts, transfers and load Oracle Systems (Sales, Service, Marketing, OM etc) data to a pre-mapped data warehouse schema.

From that, we are able to interact with that data through dashboards, reports, ad hoc analysis, proactive detection and alerts, disconnected analysis, MS Office Plug-in or some of the other Web Services.

Key components:

  1. Prebuilt data warehouse with conforming dimensions
  2. Prebuilt extract, transform, and load (ETL) to extract data from Oracle and non-Oracle sources
  3. Premapped metadata embedding best practices form metrics and KPIs
  4. Best practice library of dashboard and reports

Deployment Options:

  1. Stand alone dashboards
  2. Portal integration
  3. Embedded directly in Oracle EBS
Action links allow you to drill from an analytical report directly to the transnational detail.

Tuesday, September 8, 2015

Deal Management

Introduced in R12 and built to be part of the quote and order process, Oracle Deal Management provides essential decision support tools and scenario modeling to help sales people achieve maximum profit on every deal.
You get real-time access to pricing data for up-to-the-minute decision-making and a centralized repository of deal information for historical reference and "rearview" aggregated analysis. With automated movement of data, the process becomes more efficient and profitable—with less risk of mistakes.
With Oracle Deal Management you can:
  • Enforce price policies
  • Analyze deal profitability
  • Review customer price history
  • Review deal metrics and waterfall
  • Perform "what-if" comparisons

Friday, July 24, 2015

Invoicing Rules

Invoicing and accounting rules let you create invoices that span several accounting periods. 

Accounting rules determine the accounting period or periods in which the revenue distributions for an invoice line are recorded. You can assign a different accounting rule to each invoice line.

Accounting rules of Fixed Duration span a predefined number of periods. Accouning rules of Variable Duration let you define the number of periods during invoice entry.

Invoicing rules determine the accounting period in which the receivable amount is recorded. You can only assign one invoicing rule to an invoice.

Receivables provides the following invoicing rules:
  • Bill In Advance: Use this rule to recognize your receivable immediately 
  • Bill In Arrears: Use this rule if you want to record the receivable at the end of the revenue recognition schedule.
With Cash Basis Accounting, you only recognize revenue when payment is received. Invoices with rules are therefore not applicable for this method of accounting.


You can assign invoicing and accounting rules to transactions that you import into Receivables using AutoInvoice and to invoices that you create manually in the Transactions window.

Tuesday, July 21, 2015

Sub Ledger Accounting

Oracle Subledger Accounting (SLA) is a rule-based accounting engine that centralizes journal entry creation across the E-Business Suite. Acting as an intermediate step between a subledger application (such as Oracle Cash Management or Oracle Accounts Payable), and the Oracle General Ledger, Oracle Subledger Accounting creates journal entries for subledger transactions and transfers them to Oracle General Ledger.