Looking for API which can delete desired party record completely.. use this API which can be used to Purge the Party Information from TCA Architecture.The name of the API is apps.hz_purge.purge_party.

Read the rest of this entry »

Do You know, though R12 Oracle eBTax is New module , but this provides Half of the Tax Compliance Solution , as this lack these features as compare to Tax complete solution like Vertex:

1.Tax rates

2.Situs/Place of Supply rules (e.g., modified origin)

A tax can only be based on either the ship-to or the ship-from

In Texas, the district taxes are likely to be calculated and remitted to the wrong district

3.Tier tax & max tax rules

• A tax can only have a reduced basis
• In Florida, Tennessee, Arkansas and North Carolina caps cannot be calculated
• All taxes are calculated by the total line with no consideration to units

4.Product/services taxability rules

5.Returns or remittance capability

In addition, the functionality provided in EBTax may work for companies with very limited tax exposure or “nexus.”

Other functional limitation’s are

• eBTax does not provide master geography data for Address Validation (unless using a rate file)
• From an AP standpoint, EBS R12 does not have functionality to verify vendor charged tax against system calculated tax – it will only allocate the vendor
  charged tax over the lines and compare to a tolerance that is set
• eBTax does not provide flexibility around tax actions for vendor undercharge, overcharge, etc.
• eBTax does not work with disparate systems – Oracle R12 only
• Building, maintaining and testing rules can be time consuming (must write rules 3 times state, county & city)
• Only receive jurisdictional level tax when address validated at that level
• No reports out of eBTax to provide configuration (e.g., listing of all condition sets, rules, etc.)
• eBTax has limited fields available for use in tax decisions
• Performance issues encountered when the number of condition sets per rule reach the thousands (which can happen using GL accounts as a taxability driver on the procurement side)

Lets hope Oracle can add some of the missing link in future releases.

If your company is doing Consol and you have to see results across all SOB’s for timely investigation and resolution during close, use this query .(11.5.10.2)

select sob.name from_sob,

sob1.name to_sob,

gc.name,

gc.description,

gc.from_currency_code,

gch.from_period_name,

gch.to_period_name,

gch.to_currency_code,

gch.status,

gjb.name batch_name

from apps.gl_consolidation gc,

apps.gl_consolidation_history gch,

apps.gl_sets_of_books sob,

apps.gl_sets_of_books sob1,

apps.gl_je_batches gjb

where gc.consolidation_id = gch.consolidation_id (+)

and gc.from_set_of_books_id = sob.set_of_books_id

and gc.to_set_of_books_id = sob1.set_of_books_id

and gch.je_batch_id = gjb.je_batch_id (+)

In Procure to Pay (P2P) mainly 4 application Payable, Iexp, Iproc, and PO and Projects Module heavily producing Financial events for Tax , which is mostly Input in Nature.

• Oracle Payables Invoice
• Payables Credit/Debit Memo
• Purchase Order
• Purchase Transaction Quote
• Purchase Requisition
• Purchase Prepayment

whereas in Order to Cash (O2C) four main application like OM, OKS, Quote and AR using and producing Financial events for Tax with these transactions.

• Sales Transaction Quote
• Receivables Invoice
• Sales Credit/Debit Memo
• Sales Adjustment

First enhacement is Contracts in any OU can be accessed w/o changing responsibility

• Approvals:Flag a contract if it requires approval based on renewal type
• Manual contract creation
  • New negotiation status “Draft”
  • Create New HTML contract search form (Swan) with more flexibility to search
• Billing:
  • Suspend billing functionality
  • Multi price list usage on the same contract (single currency only)
• Pricing:
  • Service Contract request type has been seeded in advanced pricing:
    • Leverage DFF’s
    • Other fields can map to Pricing entities like qualifiers/modifiers, etc. In 11i it was limited to OM and Quoting forcing to write PLSQL to grab DFF’s from SC.
  • Discounting can be applied on the contract header, lines and sublines. Earlier it was only at Subline level.
• Other Module Integration:
  • Install Base terminations and Transfers are tied to Service contracts. Whenever an install base record is transferred to a new owner, a new service contracts can be created. Earlier in 11.5.10, it worked similarly only for terminations.
  • New profile for these install base transferred contracts is OKS: Transferred Contract Identifier.

These are major enhancement in R12 Advance Collection.

• Multi Org Access Control:(MOAC) enabled.
• Uptake of Cross-Operating Unit Initiative: Collections activities such as strategies and work items, dunning letters, and collections calls can incorporate transactional and customer data from different operating units if needed.
• Consolidation of Collections Functionality into Advanced Collections: Collections Workbench in AR is obsolete.
• New Implementation Checklist and Setup Screens: New implementation tool designed to ease setup and provide a single place to record and manage implementation decisions.
• Improved Payment Processing and Customer Funds Capture: Seamless integration with Oracle Payments’ make payment formatting and end-to-end electronic payment processing features very efficient.
• Use of Oracle Territory Management to Define Collections Territory Hierarchy.
• XML Publishing Technology for Collections Correspondence.
• Configurable Metrics: A new configurable Metrics tool allows managers to define metrics formulas that are automatically calculated and displayed on the Profile tab for collections users.

You can find the details in these post.Major Enhancement in R12 Receivables are:

• Partial Period Revenue Recognition: Partial Period Revenue Recognition enables the generation of revenue recognition schedules that respect the start and end dates of contractual obligations.
• Revenue Deferral Reasons: Event-Based Revenue Management allows users to define revenue deferral reasons and corresponding revenue recognition events.
• COGS and Revenue Matching: new COGS and Revenue Matching feature satisfies this matching principle by synchronizing the recognition of revenue with the recognition of associated COGS.
• Enhanced Payment-Based Revenue Recognition: Feature achieves payment based revenue recognition by associating transaction lines with revenue impacting contingencies.
• Line Level Cash Applications
• Refunds Enhancements: Oracle Receivables is fully integrated with Oracle Payables to deliver a seamless, automated process to generate check and bank account transfer refunds.
• Balance Forward Billing: enhanced version of the existing consolidated billing functionality for industries where customers are billed for all their account activity on a regular, cyclical basis. You see more details here.
• Late Charges: enhanced Late Charges functionality enabling the creation of standard late charge policies that can be assigned to customer accounts or account sites.
• Multi Org Access Control(MOAC) enabled.
• Integration with Subledger Accounting
• Receivables Reconciliation Enhancements: Easily reconcile your receivables using enhanced reporting.
• Collections Workbench Obsolescence: Features moved to Oracle Advanced Collections.
• Bills of Exchange Obsolescence: The Bills of Exchange feature is obsolete and replaced by the Bills Receivable feature.
• Trade Accounting Obsolescence: The Oracle Trade Accounting feature is obsolete and replaced by Oracle’s Deduction Management solution.

Those you are using ORACLE IRECEIVABLES or planning to use , can find major enhancement in R12 as:

• Trading Community Architecture: TCA Integrated.
• Oracle Payments: Integrated with Oracle Payments.
• Multi Org Access Control(MOAC) enabled.
• Enhanced User Self Registration: Feature has been enhanced.
• Cross Customer Site Payments: Oracle iReceivables has enhanced the payment functionality to allow the selfservice users to pay their bills and review their payments across customer sites

The Oracle PLM solution is comprised of the following elements:

• Agile Product Collaboration :Provides stakeholders in the extended design and supply chain secure access to critical product record data for initiation and approval of design, manufacturing, customer, and supplier driven changes.
  • Key Points of this application are
    • Product Definition
    • Change Collaboration
    • Document Management
    • Manufacturer Management
    • Multiple Organizations
• Agile Product Governance and Compliance :Manages product and program compliance against industry standards and environmental / regulatory requirements such as the Waste of Electronic and Electrical Equipment (WEEE) directive and the Restriction of Hazardous Substance (RoHS) regulations.
• Agile Product Cost Management :Enables companies to manage product costs and make informed sourcing decisions early on, synchronizing product cost intelligence and processes across design, sourcing, manufacturing and supplier tiers throughout the product lifecycle.
• Agile Product Quality Management :Drives improved product quality and customer satisfaction by tightly integrating customer, product, quality, and regulatory information within a closed-loop corrective action system.
  • Key Points of this application are
    • Product Quality
    • Closed Loop Corrective Action
    • Design for Quality
    • Supply Chain Quality Management
• Agile Product Portfolio Management :Optimizes companies’ product development investments. Provides tightly synchronized program and product information and achieves cross-program, multi-enterprise visibility and decision support to maximize resource utilization.
• Agile Engineering Collaboration:Addresses the specific requirements of the engineering organization. Provides comprehensive product IP management across multiple CAD tools and disciplines in a central product record. Optimizes internal and external collaboration and IP reuse
• AutoVue Electro-Mechanical Prof. for Agile:Provides native document collaborative visualization across the global enterprise, and the ability to leverage native design files directly from the enterprise product record. Enables direct visual access to files without requiring the original authoring tool or translators.
• Agile Product Lifecycle Management Data Mart
• Agile Product Lifecycle Management Business Intelligence

Oracle (Agile) PLM Integration Products

• Oracle (Agile) ERP Adapter

This is New Product in R12 which provides the infrastructure for transaction tax knowledge management and delivery using a global system architecture that is configurable and scalable for adding country specific tax content.

• Modules Integrated with EB Tax:
  • Oracle Purchasing
  • Oracle Internet Procurement
  • Oracle Receivables
  • Consigned Inventory
  • Oracle Payables
  • Oracle Intercompany Invoicing
  • Oracle Order Management
  • Oracle Trade Management
  • Oracle Services Contracts
  • Oracle Order Capture/iStore/Quoting
  • Oracle Internet Expenses
  • Oracle Project Accounting
  • Oracle General Ledger
• Configuration Options & Provider Service Subscriptions: Users using a subscription model can share the tax setup. The owner of tax setup data is defined as a Configuration Owner and can be an Operating Unit or a Legal Entity.
• Events and Configuration Owner Options: Tax Events model allows E-Business Suite applications to map their various documents and actions across applications into corresponding tax event classes and tax event types.
• Tax Configuration Manager: This component is responsible for creating and maintaining the structural foundation of tax, the building blocks.
• Tax Determination Services: This component calculates transaction taxes based on transaction details and tax setup information.
• Centralized Tax Record Repository for Audit and Reporting
• Tax Reporting: Tax Reporting is flexible enough to provide data in a user-friendly format that allows the standard and identified country specific requirements to be met.
• Tax Simulator: This user interface help the tax manager simulate the effect of a new rule or new ‘incremental’ setup data, such as a new tax rate.
• Guided Configuration: Enables a tax manager, i.e., an expert in the domain of tax, to configure the system to meet the tax requirements in one or more countries.
• Additional Enhancements:
  • Deferred Tax in Payables
  • Enhanced handling of Tax on Freight
  • Sales and Use Tax in procurement
  • Enhanced exemptions and exceptions
  • Multiple Tax Registrations
  • Multiple Recovery types
  • Tax reporting codes
  • Cash as well as Accrual Basis reporting for tax
  • Enhanced handling of Tax on Intercompany Movements

You can apply all or part of a receipt or on-account credit memo to a single debit item or to several debit items.

For example, a customer may send a single check to pay all of one invoice and part of another invoice.

The customer may also have an on-account credit memo to use with the check to close an open debit item.

Usually , these points to consider when applying receipts and on-account credit memos to transactions:

• Credit Memo Search
• Transaction Balance for Applications Always Used profile option
• Receipt Application on Cross-customer Transactions
• Foreign Currency Receipts
• On-Account Credit Memos
• Balance Forward Bills