Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

20 Minute Guide to get EBS Data Model Comparison

Posted on April 30th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

If you are technical consultant and working on Oracle Applications Upgrade projects (for any version >11.5.8 to 12.1.x) and have a large number of customized DB objects and reports (Tables, Views, Packages, ...etc), the biggest dilemma for you how and where to start. You know there lot many things changed conceptually but you are not really sure how DB objects changes in these latest and greatest version of your application affect your CEMLI's. Untill last last month, this was a really a lacking area but recently Oracle has documented(Note id: 1290886.1) all the table changes and published them via MySupport aka Metalink.

dgreybarrow EBS Data Model Comparison Tool

This tool is in form of Report , which provides the database object definition changes between two EBS releases to help to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

dgreybarrow What is in Coverage

All DB Objects are covered in this report as..

  • Regular tables ( also Partitioned tables, Global Temp Table, Queued Tables)
  • Views
  • Index
  • Sequnces
  • Materialized views & Logs
  • Packages
  • Triggeers
  • Types

dgreybarrow Oracle Version for Report output

Untill this post, this report is being used for these Oracle Version.

  • Release 11.5.9 to Release 12.1.3
  • Release 11.5.10.2 to Release 12.1.3
  • Release 12.0.4 to Release 12.1.3
  • Release 12.0.6 to Release 12.1.3
  • Release 12.1.1 to Release 12.1.3
  • Release 12.1.2 to Release 12.1.3

dgreybarrowBefore start for tool usage

  • You should know both(source and target) the version for Oracle EBS in order to get maximum benifit of the reports.
  • List out all your application module where you would like to see the changes.

dgreybarrowSteps for usage

  1. Download respective zip from metalink , presume you know your existing application and target application version.
  2. unzip the file into local directory.Open the file "DataModelComparisonReport.html" in your browser .EBS Comaprision Report1
  3. Select the Product from LOV for which you want to see .

EBS Comaprision Report2

Once you selected the product and navigate to the database object definition differences for each supported database object type which is displayed in the bottom frame. Uppar part of report will give you high level summary for all DB changes. EBS Comaprision Report2

If you can the details for any changes go to details and find in details sections , here is one for Pacakage .

EBS Comaprision Report4

Thats means , if you take a pacakge AP_CANCEL_PKG , that means one Function and one procudure is added and 6 existing procudure is taken out if you are coming from 11.5.10.2 to 12.1.3

You should also note , there is one product appear as "MISC" in the product LOV, this exclusive for this reports nothing to deal with Oracle modules. All the products that exist in common schema is mapped with 'MISC' short code .

dgreybarrow Reference

  • Metalink Note 1290886.1 :EBS Data Model Comparison Report Overview
  • Metalink Note 1104163.1 :Oracle E-Business Suite R12.1 Financials Pre-Upgrade, Setup, and Operational Tips
  • Metalink Note 987516.1 :Planning Your Oracle E-Business Suite Upgrade from Release 11i to Release 12.1
  • Metalink Note 889733.1: Upgrade Considerations by Product for Financials
  • Metalink Note 747735.1 :Oracle Financials and Oracle Procurement: Functional Upgrade Guide: Release 11i to Release 12
    Metalink Note 780989.1: Upgrade vs. Reimplementation for Financials

Posted in EBS Suite | No Comments »

Overview : Oracle Property Manager

Posted on April 29th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Property Manager streamlines and automates lease administration and space management, enabling you to more intelligently manage your real estate portfolio. Whether you are a corporate, commercial, or retail/ franchise operation.

Oracle Property Manager is part of the Oracle E-Business Suite, and is configured out of the box to fully integrate with the Oracle Financials suite.

Oracle Property Manager Functionality automates the full life cycle of a lease as follows:

  • Lease Abstraction and Execution:
  • Flexibility to capture unique aspects of properties down to room and office level.
  • Milestone Management:
  • Workflow monitoring of critical dates assures compliance and execution of negotiated terms, conditions, and obligations.
  • Transaction Processing and Rent Calculation:
  • Calculate, create, and process payable and receivable transactions. (out of box integration with ERP)
  • Space Definition and Space Assignment
  • Analyze and react to underutilized space. Integration with Computer Aided Design systems (CAD) for virtual space management.

Process Flow

The following list ( Fig 1) is a typical sequence of events that you might follow to abstract a lease in Oracle Property Manager:

  • Set up service providers, and define locations, regions and office parks, milestones, and reporting currencies.
  • Abstract the lease. (Later, amend and edit it as needed).
  • Assign employees to office space. (Later, move and reassign the employees as needed).
  • Authorize payment and billing schedules.
  • Export payments to Oracle Payables.
  • Export bills to Oracle Receivables.
  • Review online inquiries and/or produce reports.

Oracle property manager flow

Key Benefits:

  • Improve Process Controls
  • Reduce Capital Spend
  • Minimise Occupancy Costs
  • Maximise Space Utilisation
  • Lower TCO

Integration

Oracle Property Manager is integrated with other Oracle applications, including:

  • Oracle General Ledger
  • Oracle Subledger Accounting
  • Oracle Payables
  • Oracle Receivables
  • Oracle E-Business Tax
  • Oracle Human Resources
  • Oracle Enterprise Asset Management
  • Oracle Alert
  • Oracle Workflow
  • Oracle Projects

Oracle Property Manager also interfaces with third party applications, such as CAD and CAFM applications.

Property Management is of interest to any organization that wants to maximize its return on real property.

Companies that own or lease real estate can allocate the cost of ownership to the employees or cost centers that use the space. Companies that lease their property portfolios to tenants can—with minimal administration burden—record their leases, schedule payments for rent and service charges, and recover rent owed.

Next Post , we will take more deep dive on some more topics and Integeration with CAD and CAFM applications.

Posted in Oracle Property Manager | No Comments »

Generation of GL code combinations by Sql

Posted on April 28th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is workaround for automatic/mass CCID generation or insertion of new CCID’s in GL_CODE_COMBINATIONS Table, when new values in Accounting Flexfield Segment are created, EXCEPT “Dynamic Insert” option activated .

you can use the api (function) -> fnd_flex_ext.get_ccid to create the ccid.

If the combination already exists, it returns the existing ccid else creates a new one and returns the id. Explicit commit command needs to be executed after calling this function.

Use below function which returns the CCID if it is exist and create the CCID if it doesn't exist in the application

 

  1.  
  2. <pre>fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
  3. key_flex_code =>'GL#',
  4. structure_number =>l_coa_id,
  5. validation_date =>to_char(SYSDATE,apps.fnd_flex_ext.date_format),
  6. concatenated_segments =>l_account);
  7.  

Read the rest of this entry »

Posted in Technical | No Comments »

Oracle PIM Integration Capabilities: Business Events Availability by Oracle Product Hub

Posted on April 22nd, 2011 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

Following is a list of Business Events provided by Oracle Product Hub:

Event

Description

oracle.apps.ego.item.postAML.Change

Item AML is changed (such as a manufacturer part number is added, updated, or deleted)

oracle.apps.ego.item.postCatalogCategoryChange

Catalog category is changed such as when categories are created, updated or deleted

oracle.apps.ego.item.postValidCategoryChange

Category is added to or is removed from a catalog. This event is also raised when the attributes of catalog are changed.

oracle.apps.ego.item.postItemCreate

Item Creation

oracle.apps.ego.item.postItemUpdate

Item Update

oracle.apps.ego.item.postGTINAttributeChange

GTIN Attribute group row is created or updated.

oracle.apps.ego.item.postItemApproved

On Item Approval

oracle.apps.ego.item.postItemBulkload

Bulk Item processing (creation, update)

oracle.apps.ego.item.postXrefChange

Item cross-reference creation, update, or deletion

oracle.apps.ego.item.postRevisionChange

Item revision is created or updated

oracle.apps.ego.item.postItemRoleChange

An item role grant is changed (added, modified, or removed)

oracle.apps.ego.item.postCatalogAssignmentChange

Item Catalog assignment or removal

oracle.apps.ego.item.preAttributeChange

Item Attribute group row is created, updated, or deleted. This event is raised before the change is committed.

oracle.apps.ego.item.postAttributeChange

Item Attribute group row is created, updated, or deleted. This event is raised after the change is committed.

oracle.apps.eng.cm.changeObject.changeApprovalStatus

Approval status changes

oracle.apps.eng.cm.changeObject.changePriority

Priority changes

oracle.apps.eng.cm.changeObject.changeStatus

Status changes

oracle.apps.eng.cm.changeObject.changeWorkflowStatus

Workflow status changes

oracle.apps.eng.cm.changeObject.create

Creation of a change object

oracle.apps.eng.cm.changeObject.postComment

Posted comment on a change object

oracle.apps.eng.cm.changeObject.reassign

Reassignment of a change object

oracle.apps.eng.cm.changeObject.requestComment

Common request of a change object

oracle.apps.eng.cm.changeObject.submit

Submission of a change object

oracle.apps.eng.cm.changeObject.update

Update of a change object

oracle.apps.eng.cm.changeOrder.changeScheduleDate

Schedule date change

oracle.apps.eng.cm.import.complete

Import is completed

oracle.apps.eng.cm.revisedItem.changeScheduleDate

Revised item schedule date change

oracle.apps.eng.cm.revisedItem.changeStatus

Revised item status changes

[This blog post is contributed by Hub regular Visitor who worked almost 8 years in MDM and PDM area. You can reach them to author via email]

Posted in MDM | No Comments »

Oracle PIM Integration Capabilities : APIs/Web Services Availability by Oracle Product Hub

Posted on April 21st, 2011 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

As we aware, Oracle Product Information Management Data Hub is an enterprise data management solution that enables customers to centralize and master all product information from heterogeneous systems, creating a single view of product information that can be leveraged across all functional departments.

Oracle Product Hub provides a full set of business services and data services, both at granular level and at business object level. These include Items creation/update, item change management process support, Items data gathering and data federation.Following is a list of APIs/Web Services provided by Oracle Product Hub , feel free to add in case if anything missed out.

Oracle API/Web servics Description
EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data This API is used to access user-defined attribute data for a particular item
EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data

This API is used to copy all User-Defined Attribute data from one object instance to another object instance of the same type (e.g., from one EGO_ITEM to another or one PA_PROJECTS to another).

EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data This API processes User-Defined Attribute data for one object instance.
INV_ITEM_CATEGORY_PUB.Create_Valid_Category This API is used to for assigning a category to a category set
INV_ITEM_CATEGORY_PUB.Create_Category This API is used to create a category.
INV_ITEM_CATEGORY_PUB.Create_Category_Assignment This API is used to create an item category assignment
INV_ITEM_CATEGORY_PUB.Delete_Category This API is used to delete a category
INV_ITEM_CATEGORY_PUB.Delete_Valid_Category This API is used to delete category assignment to its category set
INV_ITEM_CATEGORY_PUB.Delete_Category_Assignment This API is used to delete an item category assignment
INV_ITEM_CATEGORY_PUB.Update_Category This API is used to update a category.
INV_ITEM_CATEGORY_PUB.Update_Category_Description This API is used to update a category description
INV_ITEM_CATEGORY_PUB.Update_Valid_Category This API is used to for reassigning the parent category of a category in a given category set
INV_ITEM_CATEGORY_PUB.Update_Category_Assignment This API is used to for re-assigning an item to a new category in the given category set.
EGO_ITEM_PUB.Assign_Item_To_Org This API is used to assign one item to an organization
EGO_ITEM_PUB.Implement_Item_Pending_Changes This API is used to implement pending changes (phase and/or status) for an item/item revision.
EGO_ITEM_PUB.Process_Item

The full parameter-list version of Process_Item

This API is used to create or update one item if you want to specify item attribute values that aren't exposed in the wrapper version of Process_Item, or to create or update an item revision.

EGO_ITEM_PUB.Process_Item (Convenience wrapper)

A convenience wrapper to Process_Item

This API is used to create or update one item by passing only the most important and/or commonly-used item attributes.

EGO_ITEM_PUB.Process_Item_Cat_Assignment This API allows user to assign/remove a catalog/category to/from an item.
EGO_ITEM_PUB.Process_Item_Descr_Elements This API allows user to give the values of item catalog category descriptive elements.
EGO_ITEM_PUB.Process_Item_Org_Assignments Use this API to assign multiple items to organizations.
EGO_ITEM_PUB.Process_Item_Phase_And_Status Use this API to either change the status of an item or promote/demote the lifecycle of an item/item revision.
EGO_ITEM_PUB.Process_Item_Role Use this API to create, update, or delete one role grant on one item, or on one existing instance set.
EGO_ITEM_PUB.Process_Items Use this API to create or update multiple items at once.
EGO_ITEM_PUB.Process_User_Attrs_For_Item Use this API to perform DML operations (insert, update, or delete) on one or more rows of user-defined attributes data for one item.
ENG_ECO_PUB.Process_Eco This procedure allows user to create, update Issues, Change Requests (CRs), and Change Orders (COs) in Product Lifecycle Management (PLM) Product
INV_ITEM_CATALOG_ELEM_PUB.Process_Item_Descr_Elements

[This blog post is contributed by Hub regular Visitor who worked almost 8 years in MDM and PDM area. You can reach them to author via email]

Posted in MDM | No Comments »

Oracle’s Imaging Solution for Invoice Processing Automation (A/P, T&E)

Posted on April 13th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle provides a complete enterprise imaging solution that can be deployed to eliminate paper and automate a variety of business processes. The main components in the imaging solution for invoice processing with E-Business Suite are:

  • Oracle Document Capture
  • Oracle Forms Recognition
  • Oracle Imaging and Process Management
  • Oracle E-Business Suite Adapter for Enterprise Content Management

With these four component you can turn your customers imaging solutions if you are using R12 with fusion middleware.

.... you are planning to implement , know high level flow ..

  • Invoices scanned centrally or remotely (Oracle Document Capture)
  • Data extracted and sent to Oracle (Oracle Forms Recognition)
  • Invoices stored in central repository [(Oracle I/PM ) -Oracle UCM | Oracle I/PM | Oracle BPM Suite ECM Adapter]
  • Invoice images & data accessed via Oracle [(Oracle I/PM ) -Oracle UCM | Oracle I/PM | Oracle BPM Suite ECM Adapter]
  • Exception Handling Workflows & Real-time Monitoring [(Oracle I/PM ) -Oracle UCM | Oracle I/PM | Oracle BPM Suite ECM Adapter]
  • Automated Approvals (Oracle ERP)

Will share some more insights on Oracle I/PM in next post.

Posted in Oracle Payable | No Comments »

Oracle Enterprise Repository (OER)

Posted on April 12th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

A couple of readers have asked clarification for confusion over the other Repository terminology Oracle Integration Repository IREP with Oracle Enterprise Repository OER, therefore this post will help to understand two different terminology.

What is it?

It is a metadata repository acting as a single source of truth for information surrounding SOA assets and their dependencies for:

  • Assets Category and Grouping
  • Relationship management
  • SOA governance.

Originally , this repository was part of BEA SOA Governance solution called AquaLogic Enterprise Repository(ALER) and came from the acquisition of Flashline. The Enterprise Repository you can get in Registry product bundle. Oracle offer a SOA Governance Suite bundle that includes a number of separate products.

Oracle Enterprise Repository

Together, the reg and rep provide three things: Visibility, control and analytics

  1. Visibility into all SOA assets (these are basically Business processes, Services, XML schemas, Components, Applications, Models, Frameworks, Policies, etc.) and their relationships
    • Catalogue and Categories assets and services
    • What’s planned, in development, and already exists
    • Human-friendly shop-window for your IT and Services Portfolios
    • Dependency and impact Analysis
  2. Control :Automated workflow for control of the life cycle in alignment with architecture and policy
    • Asset Registration Workflow
    • Automated lifecycle progression
    • Policy management
    • Architecture standards
  3. Reporting via Analytics : This helps to get reuse, ROI and compliance .

dgreybarrowOracle Enterprise Repository Components

As mention these are basically AquaLogic, there have component with there same name.

Oracle Enterprise Repository Components

dgreybarrow Further Reading

Posted in Emerging Technologies, Fusion | No Comments »

Oracle Application Testing Suite

Posted on April 10th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Application Testing Suite is very comprehensive and includes Load Testing for Applications, Functional Testing for Applications and Test Manager for Applications.

If you are looking for a product that fit for achieving higher quality and performance of their applications then Oracle Application Testing Suite is right tool. This integrated, full life cycle solution enables you to define and manage your application testing process, validate application functionality, and ensure that your applications will perform under load.

Oracle Application Testing Suite

  • Comprehensive Pacakge - covers functional testing, load testing and test management
  • Maximize application performance for peak loads - Delivers rigorous validation that protocol-based legacy testing tools cannot provide
  • Testing effort is greatly enhanced - Ensures functional reliability while reducing your testing effort by 50% or more
  • Simplify test process management - Provides integrated test management for functional and load testing but also includes defect and requirements tracking.
  • Come with Web-based interface - Enables remote access and multi-user, concurrent, collaboration

OracleTestingSuite

Oracle Application Testing Suite's also has Accelerators for Oracle E-Business Suite to provide a comprehensive solution for ensuring the quality and performance of Oracle E-Business Suite applications. The Functional Testing Accelerator for Oracle E-Business Suite extends Oracle Functional Testing to enable automated functional and regression testing of Oracle E-Business Suite applications. The Load Testing Accelerator for Oracle E-Business Suite extends Oracle Load Testing to enable load and performance testing of Oracle E-Business Suite applications. The Testing Accelerators for Oracle E-Business Suite are components of Oracle Application Testing Suite, the centerpiece of the Oracle Enterprise Manager solution for comprehensive testing of packaged, Web and service oriented architecture-based applications. The tool offers following benefits.

  • Automates complex Oracle EBusiness Suite transactions for both functional testing and load testing
  • Supports automation of both Web and Oracle Forms application interfaces and protocols
  • Provides custom test cases to validate application content
  • Enables parameterization of test scripts for data-driven testing
  • Simulates loads of hundreds to tens of thousands of concurrent users while minimizing hardware requirements
  • Gathers critical infrastructure performance metrics to identify bottlenecks under load
  • Provides an intuitive Web based console to configure and run load tests and share real-time results with distributed users

dgreybarrow Major Components for Oracle Application Testing Suite

  1. OpenScript :Easy-to-use solution to create automated test scripts that simulate end-user transactions and execute automated functionaland regression testing. These scripts can also be used in Oracle Load Testing for load and performance testing
  2. Oracle Load Testing : This enables to easily test the scalability and performance of your enterprise applications.Uses automated scripts created in OpenScriptcan simulatehundreds or thousands of concurrent usersto test application performance under load and identify bottlenecks.
  3. Oracle Test Manager : The are used to Plan, organize, document, and manage the entire application testing process. This document and run both manual and automated test cases, track defectsand manage test requirements
  4. Oracle Application Testing Suite Administrator :These are used to manage users, roles, projects, and fields

dgreybarrow Comparison Of Oracle Application Testing suite and LoadRunner for Performance Testing?

As you might know Oracle Application Testing suite is a reframed version of e-Test Suite of Empirix (which Oracle bought) and not a well known nor widely used tool compared to HP Loadrunner(earlier Mercury LR). Also it depends on the support that you get when you start the scripting and for Loadrunner you have lot of avaiable resources even if it is for testing Oracle components like Siebel. If you are coming from HP to OAT, can compare the products as

  • Oracle Test Manager is what you have HP Quality Center
  • Oracle OpenScript is what you have HP Win Runner HP QuickTest Professional
  • Oracle Load Testing is what you have HP LoadRunner

dgreybarrow WHo can use /Whom you can engage with This tool

  • Project manager
  • Performance test team lead
  • Technical analyst
  • Database administrator
  • Application administrator
  • System administrator
  • Network administrator
  • Business analyst /Business System Analysts
  • User representative
  • User emulation scripting resource

dgreybarrow Oracle Test Starter Kit

  • Sample test scripts from Oracle E-Business Suite QA group
  • Test scripts against an EBS Vision Demo database
  • Previous versions created forHP WinRunner and HP QTP testing tools

Oracle Test Starter Kit for E-Business Suite R12.1.1 for OpenScript Oracle Functional Testing Accelerator for Oracle EBS Test Starter Kits for R12.1.1, you can download from here

  • Financial Products:
    • Oracle Payables
    • Oracle Receivables
    • Oracle General Ledger
    • Oracle Assets
    • Oracle Internet Expenses
  • Manufacturing Products:
    • Oracle Purchasing
    • Oracle Inventory
    • Oracle Order Management
    • Oracle Cost Management
    • Oracle Materials Requirement Planning
    • Oracle Process Manufacturing Products
  • CRM Products:
    • Oracle Contracts
    • Oracle Service
    • Oracle Marketing
  • Human Resources Product:
    • Oracle Human Resources
    • Projects Product:
    • Oracle Projects
  • Technology Product:
    • Oracle Application Object Library

Posted in Tool | No Comments »

EBusiness Suite : Oracle Channel Revenue Management

Posted on April 9th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Do you know, In Release 12.1 Trade Management is now a suite of four products as below in a new product family called Oracle Channel Revenue Management that manages financially oriented channel processes.

  1. Accounts Receivable Deduction Settlement
  2. Advanced Rebates and Point of Sale Management
  3. Price Protection [This is new product in R12.1]
  4. Supplier Ship and Debit [This is new product in R12.1]

Adding these Products in Line of your Business will help you to :

  • Decrease in Deductions DSO and improved visibility into all processes
  • Improved Margins through process automation and accuracy with an integrated solution
  • Increased productivity through automation of traditional spreadsheet managed processes
  • Reduced revenue leakage

Typically these products are best suited for industry like High Tech, Life Sciences/HealthCare, Wholesale/Retail, that application are best suited if you are considering for "Invoice to Settlement" Business flow.

Lets have a brief introduction for these family products.

dgreybarrow ACCOUNTS RECEIVABLE DEDUCTIONS SETTLEMENT

This provides a central repository of all claims and deductions to claim analysts, giving them easy access to the information they need to resolve claims quickly, and to give management full visibility into outstanding claims and deductions. It integrates resolution of deductions and claims with receivable systems and accounts payable and validates that the correct general ledger accounts are assigned. Properly approved claims automatically spawn payments and credits in Oracle Payables and Oracle Receivables.

Some of key functionality for this products are :

  • Dispute/deduction handling
  • Rebates Settlement
  • Promotional Payments View
  • Complete AR processing that means you get high visibility into aging buckets and total amounts outstanding
  • Lockbox integration additional you have customer reason code mapping
  • Auto-write offs
  • Mass Settlements

This application is have Integration with Accounts Receivables, Accounts Payable, Order Management, General Ledger, Channel Rebate and POS Management ,Tax Engine and Oracle Collection.

Those who have high transactional volume of invoicing and disputes and currently using Oracle Financials and Order Management take take advantage of this products. This also help in order to meet your compliance regulations

dgreybarrowORACLE CHANNEL REBATE AND POINT-OF-SALE (POS)

Oracle Channel Rebate and Point-of-Sale Management provides functionality above and beyond that provided by Oracle Advanced Pricing for pricing scenarios including net accruals, retroactive pricing, complex volume pricing agreements, supplier ship and debit and the ability to update the correct general ledger accounts for all pricing situations including discounts. This is the only system in Oracle today that provides the correct accounting procedures for price reductions given on invoices. It also controls pricing in multi-tiered distribution.

This system addresses four critical areas related to the effective processing, POS data load, data validation & cleansing, dispute handling and Claims settlement.

dgreybarrowORACLE PRICE PROTECTION

Oracle Price Protection is a new module in Release 12.1 that provides distributors the ability to adjust and control their inventory valuations, purchasing costs and sales pricing based on pricing changes received from vendors. Price Protection automates the price protection processes when a vendor changes the price of a product and adjusts the GL records systematically.

More specifically, this product:

  • Generates and tracks price-protection claims for both on-hand product inventory and customer product inventory
  • Updates inbound prices lists and purchasing systems with new prices
  • Updates costing and financial systems to reflect new prices and its execution can be done by
    • Providing consolidated view of inventory across WMS and TM (Channel inventory)
    • Calculating accruals and generate debit claims for vendors
    • Calculating accruals and issue credits for customers
    • Integrating with Oracle Costing to adjust Cost of Goods and Services (COGS)
    • Integrating with Oracle Purchasing to adjust inbound price list and purchase orders
    • Integrating with Oracle Pricing to update inbound price list with new price
    • Integrating with Oracle Financials to handle deferred revenue recognition

Price Protection leverages Oracle Fusion Middleware and has service-oriented architecture to allow for rapid deployment into heterogeneous environments. Price Protection is designed to work out-of-the-box with Oracle E-Business Suite

This product is Integrates with Procurement, Warehouse / Inventory, Costing, General Ledger, Accounts Payable, Accounts Receivable.

This new products is targeted for Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.

dgreybarrow ORACLE SUPPLIER SHIP & DEBIT

Oracle Supplier Ship and Debit is a new module in Release 12.1 and a new flow introduced that enables Distributors to more quickly and intelligently respond to market conditions by automating special price requests to Vendors, in order to close more sales and increase profitability. Distributors are able to reduce the cost of managing the special pricing process as the execution and the more tedious claiming process are completely automated thereby providing greater visibility.

Oracle Supplier Ship & Debit

This products sound similar to Wholesalers/distributors specially for High Tech customers. This application is having dependency and perquisite of first two application discussed above.Supplier Ship & Debit application have Dependencies and perquisite with AR Deduction Settlement and Channel Rebate & Point of Sale Management application.

Posted in Oracle Receivable, R12 | No Comments »

Difference between reversing a receipt, unapplying a receipt, and deleting a receipt

Posted on April 3rd, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Its very simple ...

You reverse a receipt when no payment was received from the customer for the receipt amount.

Reversing the receipt creates reversal journal entries in the general ledger and reopens all of the debit and credit items that were closed by the original receipt.

You unapply a paid receipt either to return payment to the customer or to reapply a receipt applied in error to the correct transaction.

If you unapply a receipt to return payment to the customer, either with a refund or an on-account credit, you must create a credit memo against the original transaction that was closed by the receipt application.

You can delete manual receipts that were created but not yet applied to transactions.

You can delete automatic receipts belonging to an automatic receipt batch that has not yet been approved. When you delete a receipt from a batch, the transactions closed by the receipt become available for automatic receipt selection.

Posted in Oracle Receivable | No Comments »

Page 1 of 212

« Previous Entries