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

Oracle XML Gateway

Posted on September 21st, 2011 by Sanjit Anand ||Email This Post Email This Post

XML Gateway is a set of services that allows for easy integration with the Oracle e-Business Suite to create and consume XML messages triggered by business events.

Oracle XML Gateway supports both Business-to-Business (B2B) and Application-to-Application (A2A) initiatives.

Typically used to integrate with trading partners using XML Document formats that conform to OAG standards

With Oracle XML Gateway services, you are assured consistent XML message implementation when integrating with the Oracle E-Business Suite, thereby lowering integration costs and expediting message implementation while supporting corporate e-business initiatives.

It integrates with Oracle Advanced Queuing to enqueue/dequeue a message which is then transmitted to/from the business partner via any message transport agent.

dgreybarrow The Oracle XML Gateway performs the following functions:

  • Define trading partner and trading partner locations
  • Enable transactions for trading partners
  • Provide general code conversion between trading partner codes or standard codes and the codes defined in Oracle Applications
  • Define mapping files for data conversion from XML to relational table formats and vice versa
  • For inbound transactions, receive XML files (typically in OAG format), parse them and import data into application open interface tables so that application program interfaces (API) can validate and update Oracle application tables
  • For outbound transactions, extract data from Oracle application tables generate XML messages and dispatch them to trading partner applications (using OTA)

dgreybarrow Features of XML Gateway

  • XML Gateway is Event Based, real-time system
  • Messages/Information are based on a single transaction.
  • Oracle XML Gateway supports all DTD (Document Type Definition) based XML standards.
  • Oracle XML Gateway processes or sends standards compliant XML messages without the use of a 3rd Party translator.

dgreybarrow Oracle XML Gateway Architecture

The services supported by Oracle XML Gateway are grouped into three major components as follows:

  • Message Designer – used to Create ‘Message Maps’ between Oracle e-Business Suite and XML standard of choice
  • Message Set Up -used to Configure message implementation by Trading Partner and message
  • Execution Engine -Create or consume well-formed and valid XML messages based on trading partner message map

Figure 1 shows the relationship of these three components:


It interfaces with the following Oracle products:

  • Oracle Transport Agent for message delivery
  • Oracle Advanced Queuing for message propagation, and queue management
  • Oracle Workflow Business Event System to publish and subscribe to business events. Workflow also provides an active e-mail notification to report errors detected by the XML Gateway Execution Engine, Advanced Queuing (AQ), or the transport Agent

Design Time Components

  • Message Designer – is a wizard-guided, repository-based tool used to define message maps which defines mapping between Oracle Application data to OAGIS DTD XML documents. A message map represents the relationship between the source and target data elements.
  • XML Gateway Setup – To implement a message with a trading partner, XML Gateway setup features is used to define the Trading Partner or hub, code conversion values, and internal-to-external transaction name cross-references (Domain value maps)

Run Time Components

  • Execution Engine
    The XML Gateway Execution Engine is responsible for interacting with several Oracle technologies to process and transport XML messages to and from Trading Partners for B2B integration, or other information systems both within and outside the enterprise for A2A integration.
  • Engine run time engine for validate TP in case of B2B integration, create consume XML messages, Interacts with Advanced Queuing (AQ) to enqueue / dequeue messages and used to transform XML documents to Oracle applications. It communicates through AQ. It has Transport agents which can expose using XML gateway services over http or web services

Oracle XML Gateway leverages the Oracle Workflow Business Event System to publish and subscribe to application business events of interest to automatically trigger message creation or consumption.

The XML Gateway Execution Engine interfaces with the Oracle E-Business Suite via business events and event subscriptions to retrieve data from or populate data into the Oracle e-Business Suite tables. The XML Gateway Execution Engine interfaces with Oracle Advanced Queuing to stage outbound XML messages or receive inbound XML messages for processing.

The Oracle Transport Agent interfaces with Oracle Advanced Queuing to deliver outbound messages and to receive inbound messages.

Message Queues
The XML Gateway uses queues specifically at two points in the process as well as employing a general error queue. The first point is at the transport agent level between the transport agent module and the XML Gateway. The second point is at the transaction level between base Oracle Applications products and the XML Gateway.

  • Inbound Queues
    Inbound message queues are used for XML messages inbound into Oracle Applications. Inbound message queues are positioned between the Transport Agent and the Oracle Workflow Business Event System.

The messages must be formatted according to the XML Gateway envelope message format. The envelope message format is discussed under XML Gateway Envelope. Oracle Workflow Business Event System copies the inbound messages to the proper inbound Transaction Queue.

  • Outbound Queues
    Outbound message queues are used for XML messages outbound from Oracle Applications. The outbound Message Queue is positioned between the XML Gateway and the Transport Agent.

The XML Gateway creates XML messages, then enqueues them on this queue. The Transport Agent dequeues the message and delivers it to the Trading Partner

Web Services
Oracle XML Gateway uses Web Services Description Language (WSDL) to inform trading partners how to communicate with the Oracle E-Business Suite. The Suite also publishes the WSDL to a URL for customers to access. Partners can use any third party
Web service tools to call for Web services.

dgreybarrow Integration Flow

The following diagram illustrates the process flow of XML messages through the XML Gateway Execution Engine using all the components mentioned above.

Inbound Integration Flow

  1. The XML Gateway Inbound listeners are actively polling for interested events. The Execution Engine will be triggered once Oracle Workflow Business Event System detects that an inbound message has arrived on the Inbound Queue.
  2. It then Dequeue Message from Inbound Queue
  3. Uses the XML Parser to validate the inbound message to determine if it is well-formed and valid
  4. If the inbound message is both well-formed and valid, the Execution Engine proceeds to validate that the Trading Partner and document are defined in the XML Gateway Setup
  5. It then retrieves the Message Map from Repository
  6. Execute the message Map – If the Trading Partner is valid and the message map exists in the repository, the Execution Engine maps the data in the XML message to its target data fields in Oracle e-Business Suite tables and columns identified in the message map. These are often the Application Open Interface tables.
  7. Raises an Business Event when inbound document is successfully processed, which triggers the corresponding oracle workflow to process the data within oracle e-business suite

where as for outbound Integration Flow

  1. The XML Gateway listeners are actively polling for interested events. The Execution Engine will begin processing once Oracle Workflow Business Event System detects an outbound transaction to be processed
  2. Validate Trading Partner or Hub
  3. Get Message Map from Repository
  4. Execute the Message Map – If the Trading Partner is valid and the message map exists in the repository, the Execution Engine gathers the application data from the Oracle e-Business Suite using the database views and columns identified in the message map.
  5. Create XML message using the message map and the application data
  6. Uses the XML Parser to validate the newly created message to ensure that it is well-formed and valid. Enqueue well-formed and valid message to the Outbound Queue.
  7. Oracle Transport Agent will dequeue the message from the Outbound Queue and deliver it to the trading partner

dgreybarrow XML Standards and supportablity

Many standards bodies (for example, EbXML, Rosettanet, SOAP, iFX) exist with published Document Type Definitions (DTD) each claiming to be better than the other. Some standards are strong at managing the message content while others excel at managing both the message content and its related processes.

As a provider of software to support all industries, Oracle has chosen to align with Open Application Group’s (OAG) XML standards for broad based message implementation. OAG is also the standard most widely adopted by the Oracle customer base.

There are over 150 OAG implementations involving the key functional areas.

  • Procurement
    • Add / Create / Change / Cancel / Show Requisition
    • Add / Change / Cancel / Process / Sync PO
    • Acknowledge PO
    • Sync Supplier
  • Sales
    • Sync/Show Sales Order
    • Show Shipment
    • Show/Update Delivery
  • Work in Process
    • Create/Change Production Order
    • Sync Production Order
  • Planning
    • Show/Sync Planning Schedule
    • Sync Shipping Schedule
  • Financials
    • Show Payment
    • Show Payment Error
    • Process Invoice
    • Process Payment
    • Sync Chart of Accounts
    • Sync Exchange Rate
  • Inventory
    • Sync Item
    • Sync UOM Group

Apart from above, there are an additional 30+ non-OAG implementations. Non-OAG implementations exists for two primary reasons; the required BOD is not supported by OAG or a proprietary BOD better describes the required functionality.

  • Rosettanet
    • 3A4
    • 3A6
  • IFX
    • Bank Statements
    • Students
    • Transcripts
  • US Dept of Education
    • Financial Aid (Grant/Loan)
  • PESC
    • Degree Audit
  • Proprietary
    • Lease Booking
    • Lease Quote
    • Lease Restructure
    • Loan Booking
    • Loan Restructure

dgreybarrow XML Vs eCommerce Gateway

Comparing within two, here are some differences .


XML Gateway
eCommerce Gateway
XML Messages EDI Transactions
Event based processing Batch Processing
XML Standard Compliant ASCII file format
No translator required EDI Translator required


Posted in API Integration, Integration | No Comments »

eCommerce Gateway

Posted on September 21st, 2011 by Sanjit Anand ||Email This Post Email This Post

There are are the two out-of-box integration capabilities for E2E available in Oracle Applications:

  • Oracle E-Commerce Gateway (formerly EDI Gateway)
  • Oracle XML Gateway

if you are new about EDI , refer to this post

dgreybarrow Oracle E-Commerce Gateway

eCommerce Gateway enables to expose internal business objects in a standardized format thus the trading partners integrate with the external business objects to send/receive information to/from Oracle E-Business Suite”

  • Support EDI Transactions
  • Executes Batch Processing
  • ASCII file format
  • Interface Files are EDI Standards Independent
  • EDI Translator is required
  • eCommerce Gateway interface is a Concurrent Program Packaged ‘Out of the Box’ key business transactions

A typical Transactional Flow can be best understood as in context of Ecommerce Gateway is as below:



Oracle e-Business Suite in conjunction with Oracle e-Commerce Gateway supports 23 EDI transactions. Oracle e-Business Suite generates and consumes ASCII flat files.

The ASCII flat files are sent to/received from a third party EDI translator who transforms the flat file content into the ASC X12 or EDIFACT equivalent. ASC X12 is the EDI standard for North America and Canada. EDIFACT is the EDI standard for Europe and Asia.

  • Purchasing
    • Outbound 850/ORDERS
    • Outbound 860/ORDCHG
    • Inbound 832/PRICAT
    • Inbound 843/QUOTES
    • Inbound 856/857/DESADV
    • Outbound 824/APERAK
  • Order Management
    • Inbound 850/ORDERS
    • Inbound 875/ORDERS
    • Outbound 855/ORDRSP
    • Inbound 860/ORDCHG
    • Outbound 865/ORDRSP
  • Shipping
    • Outbound 856/DESADV
  • Inventory
    • CUSDEC (No ASCX12 equivalent)
  • Payables
    • Inbound 810/INVOIC
    • Outbound 820/PAYORD-REMADV
    • Outbound 824/APERAK
  • Receivables
    • Outbound 810/INVOIC
    • Outbound 812/DEBADV-CREADV
  • Supplier Scheduling
    • Outbound 830/DELFOR
    • Outbound 862/DELJIT
  • Release Management
    • Inbound 830/DELFOR
    • Inbound 862/DELJIT
    • Inbound 866 (No EDIFACT equivalent)

Next we will have a look on XML gateway.

Posted in EDI, Integration | No Comments »

Understand “Integration Types”

Posted on February 25th, 2010 by Sanjit Anand ||Email This Post Email This Post

The benefits of an ERP application are limited unless it is seamlessly integrated with other information systems. Organizations face many challenges in ERP integration viz

  1. The challenges of integrating various functional ERP modules
  2. The challenge of integration with other e-business software applications
  3. The challenge of integration with legacy systems.

To fully leverage the power of integration, its imperative that you understand the various types of integration possiblity. Integrations can be broadly classified into the following categories:

  1. Synchronous Integrations: In synchronous Integration a request response mode of operation between two systems.

In short, the calling application expects a response from the provider when a method on the latter is invoked in the same thread.

2. Asynchronous Integrations: Asynchronous Integration are mostly good when enterprise applications take an indeterminate amount of time to respond to a calling application.

In this case, the initiating application sends the request and proceeds with its own actions without having to wait for the provider application to process in the same thread. The provider application picks up the request at a later stage and processes the message.

3.Batch Integrations: Batch integrations allow you to import or export large batches of data that are collected over a period of time into the system.

Typical end-of-day transactions or scheduled data synchronization routines utilize this technique.

4. Process Oriented Integrations: Process Orchestration takes application integration to the next level by using an application independent state engine to manage business processes that span multiple applications.

Process Orchestration can involve system-to-system integration, system to human task integration, or human task to human task integration.

Posted in API Integration, Integration | No Comments »

Oracle Transportation Management(OTM) integration with Oracle Purchasing

Posted on August 18th, 2009 by Sanjit Anand ||Email This Post Email This Post

OTM-PO Integration enable you to manage inbound freight from your suppliers.

The integration of Oracle Transportation Management enables you to plan and track the progress and status of inbound purchase order-related shipments.

Purchase orders created in Oracle Purchasing are communicated to Oracle Transportation Management after approval, enabling you to execute (rate, route, track, and reconcile) the related shipment.

Purchase order changes are also communicated to Oracle Transportation Management upon re-approval in Oracle Purchasing.

As part of the shipment process, Oracle Transportation Management enables suppliers to submit “ready to ship” information.

After shipping takes place, purchasing agents access carrier-provided shipment status updates within OTM. After goods are delivered, invoices for freight payment are collected and processed for payment.

This figure shows the integration of Oracle Transportation Management with Oracle Purchasing, including PO creation and PO close:

Oracle Transport Managment

This get called soon after a Standard Purchase Order or a Blanket Purchase Release is approved, the Approval process(POXDOCON) or the Create Release process (porelgeb.pls) will call PO_DELREC_PVT.create_update_delrec.

  • PO_DELREC_PVT.create_update_delrec then calls
  • PO_OTM_INTEGRATION_PVT.handle_doc_update
  • PO_OTM_INTEGRATION_PVT.handle_doc_update then calls
  • PO_BUSINESSEVENT_PVT.raise_event

Posted in Integration, Oracle Purchasing | No Comments »

Integration and Information Flow from OIC to Oracle E Business Suite

Posted on June 25th, 2009 by Sanjit Anand ||Email This Post Email This Post

OIC is fully integrated with following Oracle E Business Suite modules:

Transactions are primarily collected from Oracle Receivables and Oracle Order Management. Oracle Incentive Compensation transactions can originate from a sales order, a customer billing, a customer payment, or other business functions.

  • Oracle Order Management is used to collect booked orders and adjustments to booked orders
  • Oracle Receivables is used to collect invoices, credit/debit memos, Payment postings and take back postings etc
  • Oracle Payables is used to pay people who are not full-time, regular employees.Oracle Payable recognizes resources for payment only if they are activated as suppliers.
  • Oracle Payroll is used by application to pay the employees
  • Oracle Human Resource / Resource Manager is where you must first create employees in order for them to be paid compensation in Oracle Incentive Compensation. After creating employees in Human Resources, you then import these records into Resource Manager to create resources
  • Oracle Territory Manager provides integration with the Territory Assignment Engine for Sales Credit Allocation
  • Oracle Quoting uses Oracle Incentive Compensation to project commissions for resources and for Sales Credit Allocation. Oracle Incentive Compensation receives data through an API and then sends back projected commissions to Oracle Quoting
  • Oracle Workflow is a workflow management system that is used by Oracle Incentive Compensation to integrate business processes. It can be used to notify individuals that action is required, a process is complete, or that a concurrent process has run into a problem. Workflow is already configured for use in Oracle Incentive Compensation and does not require any setups.

Posted in Integration, Oracle ICM | No Comments »

Change Data Capture

Posted on December 7th, 2008 by Sanjit Anand ||Email This Post Email This Post

Typically, the traditional tracking methods provides different levels of change information for data and these are the how how developers typically doing CDC Requirement:

  • Trigger based tracking
  • Time stamp columns
  • Join queries
  • Additional table to track deletes

dgreybarrow What is CDC

Change Data Capture (CDC) is an innovative integration technology, which is based on the identification, capture, and delivery of only the changes made to enterprise data sources.

dgreybarrowWho need CDC

  • BI , because of Increasing demand for up-to-date/real-time data
  • Increasing data volumes
  • Shrinking batch windows
  • Demand for event driven processing
  • Reduce cost may be you can say saving in processing large amounts of data

dgreybarrowWhere to use

  • Data Warehousing & ETL/ELT
  • Operational Reporting and Data Integration
  • Data Replication, Propagation
  • Synchronization of Data and Applications
  • Master Data Management (MDM)
  • Legacy Modernization & Migration

If you are working in Oracle Technology space , then some of event-driven Processing like ESB (OSB), BPEL, CEP, BAM

dgreybarrow What industries need CDC?

CDC need is across the industry. That means this fits any industry. Typical example such as:

  • If you are in Financial Services the best example would be having efficient BI which may be event detection
  • In Manufacturing Typical example can be a real-time synchronization
  • In Retail similar to Financial CDC need must be to provide real-time BI for marketing
  • Govt and Public Sector mostly for efficient DW/BI

Therefore understand CDC requirement in ETL in next section.

dgreybarrowCDC for ELT

CDC typically provide up-to-date data for data warehouses, ODS, reporting databases, etc.

dgreybarrow How this works:

CDC detects new, updated and deleted records

  • When ODI processes are invoked they can be restricted to these records. Less data to process.
  • Allows to run the ODI processes much more often
  • Removes “batch-window” processing
  • Real/Right-time data warehousing

dgreybarrow Major benefits with use of CDC in ETL would be:

  • First is Efficiency
  • Next would be Low latency/Real-Time Integration
  • Lower cost
  • The most important it’s Event driven architecture

Therefore because of number of data acquisition methods, including Change Data Capture, its important now a day for become important for organizations to deal with greater diversity in their data architectures.

Posted in Emerging Technologies, Integration | No Comments »

Oracle eAM Integration and information flow

Posted on June 20th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle Enterprise Asset Management is part of the Oracle E-Business suite, and directly integrates with Oracle Manufacturing, Oracle Purchasing, Oracle Property Management,Oracle Quality, Oracle Inventory, Oracle Human Resources, Oracle Financials, Oracle Fixed Assets, and Oracle Projects.

A well-planned maintenance environment depends on the ability of key personnel to view available inventory items, equipment, and skilled personnel. Because eAM is an enterprise solution, you can view the resource availability for assets that are used by operations and
coordinate maintenance work to minimize operation disruption. You can refer to fig 1 for information flow .

For Best usage of EAM , these products must be required & installed:

  • Oracle Inventory
  • Oracle Bills of Material
  • Oracle Human Resources
  • Oracle Cost Management
  • Oracle Manufacturing Scheduling
  • Oracle Quality
  • Oracle Work In Process

Where as these are optional Products, which are not required;however, they are useful in the overall robust eAM solution:

  • Oracle Master Scheduling/MRP
  • Oracle Property Management
  • Oracle Financials
  • Oracle Fixed Assets
  • Oracle iProcurement
  • Oracle Projects
  • Oracle Project Manufacturing
  • Oracle Purchasing
  • Oracle Order Management
  • Oracle Time and Labor

dgreybarrow E-Business Suite Integration and Information Flow

Oracle eAM brings the functionality, look and feel of traditional best-of-breed CMMS systems to ERP.

Oracle eAM seamlessly integrates with other Oracle Supply Chain and Financial applications such as: Inventory, Bills of Materials, Work in Progress, Quality, Cost Management, Project Manufacturing, Fixed Assets, Property Management, Manufacturing Scheduling, MPS/MRP, and core Human Resources (as shared install) for employee definition and skill search. This unique integration to extensive enterprise applications improves overall organization efficiency and enables comprehensive work management capabilities. Fig 1 will gives EAM Integration options and Information flow. details are follow herewith:


  1. Fixed Assets For reference, Oracle eAM allows you to associate an asset to a fixed asset defined in Oracle Assets. Using Work Order Cost Capitalization, selected work order charges can be sent to Oracle Assets for additional capitalization.
  2. iSupplier Portal Integration with Oracle iSupplier Portal provides the capability for Web-based collaboration with suppliers / subcontractors. The accuracy and timing of suppliers’ reporting is greatly improved. Through iSupplier, a supplier can report work completion and any required collection data and meter readings.
  3. iProcurement Oracle eAM integrates with Oracle iProcurement to provide an intuitive, Web-shopping interface to order direct items for maintenance work orders. A powerful search engine and multi-supplier self-guiding catalog capabilities are the trademarks of Oracle iProcurement for item selection.
  4. Projects -Oracle eAM is integrated with Oracle Projects to provide a complete, seamlessly integrated business solution for maintenance project management. You can specify a project and task for your maintenance work order. Transaction costs are collected and passed to Oracle Projects for subsequent project cost analysis and management.
  5. Property Manager Oracle eAM integrates with Oracle Property Manager to provide a comprehensive real estate management solution that automates and enhances property definition, space utilization management, and lease administration. Users can link an eAM asset directly to a Property Management location name and code.
  6. Human Resources (HR) :It depends on how much of HR is being used. Just employees and jobs being used requires shared. EAM comes with a “shared” install of HR. This is a requirement so that the user can select an individual’s name (defined in HR) to assign to a work order. However, for training and certification tracking for selecting resources will require full installations
  7. Service Integration to Oracle Service allows you to log a maintenance service request. This provides the maintenance planner or supervisor with visibility into service requests logged against his / her department’s asset, and can assign work appropriately to them.
  8. Time and Labor With Oracle Time and Labor (OTL), employees can enter the hours they have worked by work order on a self-service timecard. Once the timecard is submitted, Oracle eAM will charge the time to the work order resource and assigned employee.
  9. Process Manufacturing Oracle eAM integrates with Oracle Process Manufacturing (OPM) Scheduling to improve the coordination between production scheduling and maintenance scheduling. Scheduled maintenance downtime updates resource availability in the OPM Resource Calendar
  10. Discrete Manufacturing and Advanced Supply Chain Planning -Oracle eAM streamlines the coordination between production scheduling and maintenance scheduling. The load production downtime process generates equipment resource downtime caused by scheduled maintenance. The downtime is included by production scheduling as a constraint on its scheduling. When a production plan is generated by Oracle Master Scheduling / MRP or Oracle Advanced Supply Chain Planning, equipment resource downtime can also be included as a capacity constraint. In this release, Oracle Shop Floor Management leverages Oracle eAM’s operation log data to identify production equipment down time for its production planning and scheduling.
  11. Installe Base : if you came from 11i background, you might aware there was no integration between EAM and IB in release 11, where in R12 there is a functionality introduced to allow EAM Assets to be trackable.The need for R12 add-on function was to maintain the transactional history of the EAM Asset linked with install base .Therefore integration only done to support
    • EAM Asset Tracking
    • Meters
    • Locations
  12. Grants:Unfortunately, there is no direct integration between EAM and Grants.Typical workaround is to create a Costing Extension .

Hope this helps.

Posted in Integration, Oracle eAM | No Comments »

Oracle General Ledger Integration

Posted on February 25th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle General Ledger is one of the core product of EBS suite, and this is Integrated with almost every segment within EBS.Here is a list of just some of the Financial ,manufacturing and Human Resource Management products that integrate with General Ledger. Typically the integration of General ledger in EBS can be best understood as:

GL Integration

The integration data information can be best understood as below:

double-arrowOracle Financial

  • Oracle Payables sends invoices, payments, realized gain and loss on foreign currency, and invoice price variance to GL.
  • Oracle Receivables sends invoices, payments, adjustments, debit memos, credit memos, cash, chargebacks, and realized gain and loss on foreign currency to GL.
  • Oracle Assets sends capital and construction in process asset additions, cost adjustments, transfers, retirements, depreciation, and reclassifications to GL.
  • Oracle Purchasing sends accruals or receipts not invoiced, purchase orders, final closes, and cancellations to GL.
  • Oracle Projects sends cost distribution of labor and non-labor costs, and project revenue to GL.
  • Oracle Treasury sends revaluation and accrual entries to GL.
  • Oracle Property Manager sends revenues and expenses related to real estate to GL.
  • Oracle Lease Management sends accounting distributions related to leases, such as bookings of contracts, accruals, asset dispositions, terminations, and adjustments for multi-GAAP contracts to GL.

double-arrowOracle HRMS and Payroll

  • Oracle HR shares employee information with GL.
  • Oracle Payroll sends salary, deductions, and tax information to GL.

double-arrowOracle Manufacturing:

In terms of manufacturing this is Integrated as:

  • Oracle Inventory sends cycle counts, physical inventory adjustments, receiving transactions, delivery transactions, intercompany transfers, sales order issues, internal requisitions, sub-inventory transfers, and Cost of Goods Sold (COGS) to GL.
  • Work In Process(WIP) sends material issues or backflush from WIP to GL, along with completions, returns, resource and overhead transactions, and cost updates.
  • Oracle Labor Distribution normally sends salary costs to GL.

double-arrowOther Products

Oracle GL not only integrated with Application product, it does have capability to integrate with other products which is used for adhoc cum management Reporting, these tools are mostly.

  1. Business Intelligence/Analytic Solutions
  2. Enterprise Planning and Budgeting (EPB)
  3. Oracle Financial Services Applications (OFSA)
  4. Daily Business Intelligence (DBI)
  5. Activity-Based Management (OABM)
  • General Ledger’s integration with Oracle Enterprise Planning and Budgeting (EPB) allows us to easily identify, analyze, model, budget, forecast, and report on information stored in our general ledger. Using Oracle GL to maintain and report on account balances throughout the accounting period, and use Financial Analyzer to analyze financial data, such as actual and budget balances, which is after closing the period. We can automatically transfer actual, budget, or encumbrance data, as well as functional, statistical, and foreign entered data from General Ledger to Financial Analyzer, which is on of requirement if company does have different management reporting approach. With financial Analyzer, we can perform sophisticated budgeting and modeling, make changes to budgets and write back budget data to a new budget in GL or to several budget versions for comparative reporting. We would also drill directly from EPB balances to balances and transactions in Oracle General Ledger. With this extended functionality your EPB users with immediate and direct access to GL data without having to run reports or account inquiries in GL, that makes process efficient without any extra step.
  • Oracle Financial Services Applications (OFSA) is a product suite that helps financial services institutions assess enterprise performance. This integration allows the transfer of General Ledger balances to OFSA to reconcile OFSA instrument tables, calculate transfer pricing of non-interest balance sheet items, or perform allocations. The results of OFSA allocation and transfer pricing results can then be transferred back to GL for posting and reporting.
  • The integration with Oracle Daily Business Intelligence (DBI) allows us to get a daily snapshot of company’s financial picture through its E-Business Suite Portals. This is achieved by over 200 pre-inbuilt Portals provide every user in the enterprise with the right information that they need, about every aspect of their business. This makes a centralized place to see the information spans across multiple applications in real time basis.
  • The integration with Oracle Activity Based Management (OABM) allows you to perform complex analysis on costs that are collected in General Ledger in a separate analysis environment—apart from your GL data. OABM is optimized to support multi-layer complex cost assignment rules, activity hierarchies, and complex product and service definitions in terms of activities with complete activity definitions.

Posted in Integration, Oracle General Ledger | 1 Comment »

Order Management(OM) Integration Options

Posted on February 25th, 2008 by Sanjit Anand ||Email This Post Email This Post

OM is one of the most complex modules in EBS, and in typical complex business model, the integration of other product or third party can’t be denied. Processing an Order requires integration with many other business areas. Most integration points with other Oracle products are implemented via PL/SQL-based APIs.Here is brief discussion for Order Management EBS Integration points.

OM Integration

double-arrowHow Order Management integrated with iStore?

OM records customer orders placed via iStore, Order Capture and other CRM applications. It validates setup for shipping and payment options along with providing order status and the shipping information to customers. Once the quote is converted into an order, you can only make changes to the order through Order Management, prior to booking.

double-arrowHow Order Management integrated with Telesales?

Telesales’ eBusiness Center has several integrations with Order Management. There is an Order tab to view order history and create new orders.

double-arrowHow Order Management integrated with Cost Management?

OM call the the Cost Management CST_COST_API to obtain cost from cst_item_costs or cst_quantity_layers when the Gross Margin feature of OM is enabled.

double-arrowHow Order Management integrated with Field Service?

Field Service Report requires specifically that you setup Price Lists, Units of Measure (UOM), and two Inventory Item Attributes in Order Management. Price Lists contain the list price for an item. Items could be material, but also labor and expenses like units of driving distance. Once material, expense and labor transactions for a task have been taken down on the Field Service Debrief, this information is updated to Charges. In Charges the list price for the item is received from Order Management and is used to generate an invoice for a customer.

double-arrowHow Order Management integrated with Depot Repair?

This is used by Depot Repair to create RMA and Sales Orders, validate customer accounts, and invoice customers for repairs.

double-arrowHow Order Management integrated with Install Base?

Information about Install Base trackable items is interfaced to Install Base in the following ways:

  • Shippable Items: For both orders and returns, information is interfaced to Install Base via Inventory Interface.
  • Non-Shippable Items: For both order and returns, information is interfaced to Install Base via the Order Management Fulfillment workflow activity Install Base also supports Internal Sales Order transactions by appropriately creating /updating item instances as a result of transactions between internal organizations such as pick transactions, shipments, and receipts.

double-arrowHow Order Management integrated with Service Contracts?

Service Contracts need to pulls information from the Install Base newly created customer records and creates an ownership record.

  • Warranty: A Warranty contract is created when a Serviceable product is shipped.
  • Extended Warranty: An Extended Warranty contract is created when an Extended Warranty is sold on a sales order. Oracle EAM & OM integration
  • Subscription: Fulfillment starts after the contract approval process.
  • RMA: Service Contracts sends Order Management RMA information

double-arrowHow Order Management integrated with Advanced Planning System/Global Order Promising/ ASCP?

Order Management uses Advanced Supply Chain Planning’s Global Order Promising functionality to check the availability of ordered items and to schedule order lines.Scheduled Order Lines are viewed as demand by the Advanced Planning System.

double-arrowHow Order Management integrated with Purchasing?

Order Management integrates with Oracle Purchasing in the following functional areas:

  • Return Receipts: Order Management uses the Oracle Purchasing Receipt functionality to handle Return receipts. When an item is received, Purchasing calls Order Management to indicate delivery and to get COGS information.
  • Internal Orders: Oracle Purchasing uses Order Import to create internal orders.
  • Drop-Ship Orders: Order Management integrates with Purchasing to fulfill drop-ship orders. It populates the PO requisitions interface table with information for order lines that need to be fulfilled via an external source.

double-arrowHow Order Management integrated with Bills of Material ?

This is integrated with BOM when models and kits are entered on sales orders.Normally OM uses the Bill of Material defined for the model or kit or explode the model into its components, for the purpose of the user selecting options and for shipping purposes.

double-arrowHow Order Management integrated with Workflow ?

Oracle Workflow is heavily used in EBS and specially to manage Order and Line processing. These PL/SQL based Workflow is a natural replacement for Order Cycles functionality. It provides a Graphical User Interfaces for defining activities, notifications, flows and viewing flow status.

double-arrowHow Order Management integrated with Advanced Pricing ?

OM is tightly integrated with Advance Pricing which includes price lists, modifiers, and agreements. Order Management, through its Sales Agreement functionality, creates price lists and pushes them into the Advanced Pricing tables. Order Management calls the Pricing Engine to make pricing requests during the processing of orders, and receives pricing information back from Advanced Pricing.

double-arrowHow Order Management integrated with Configurator ?

Order Management integrates with Oracle Configurator to support ordering and validation of configurations. The Configurator window is a Java Applet that can be launched from the Sales Order form.

double-arrowHow Order Management integrated with Oracle Payment ?

As we know Oracle payment is new product and OM accepts Credit Card information when entered on orders. It integrates with Oracle Payment to validate this information and get Credit Card authorizations. This information is then interfaced to Receivables.

double-arrowHow Order Management integrated with Receivables ?

Order Management integrates with Oracle Receivables in the following function areas:

  • Invoice Interface: Order Management sends invoices and credit memos to Receivables via the Invoice Interface workflow activity. The seeded Invoice Interface – Line workflow sub-process populates the Receivables interface table.
  • Receipts: Order Management calls Receivables’ Receipt API to create receipts for prepaid credit card orders. Order Management receives a payment-set id from AR when the receipt is created, and then passes that id back to AR in the autoinvoice tables at invoicing time so that the invoice can be matched to the receipt.
  • Tax: Order Management calls the Global Tax Engine APIs to default the Tax Code (ARP_TAX.GET_DEFAULT_TAX_CODE) and to calculate estimated tax (ARP_PROCESS_TAX.SUMMARY) for the order Line. The estimated tax value is now stored on the line and re-calculated only when any of the attributes affecting tax change. Information about the tax value is also stored as Line Price Adjustments.
  • Credit Management: If the Credit Management product is installed, notifications are sent to it by Order Management when an order or line goes on credit hold, to initiate a credit review. If the credit review results in a decision to approve the order, a business event is posted which OM subscribes to and then releases the credit hold.

double-arrowHow Order Management integrated with Payables ?

OM accesses the AP Bank Accounts table to populate the Credit Card LOV when an order is being entered with a payment type of Credit Card. Additionally, if a new credit card number is entered and the authorization of that card through iPayment is successful, Order Management calls an AR API to create a new bank account record for the customer in the Bank Accounts table.

double-arrowHow Order Management integrated with Inventory Management ?

  • Order Management integrates with Oracle Inventory Management through Managing Reservations.
  • You can create reservations to on-hand quantities from the Sales Orders form.

double-arrowHow Order Management integrated with Trade Management ?

Order Management can receive RMA orders and lines from Oracle Trade Management as part of its dispute handling functionality.

Posted in Integration, Oracle Order Management | 6 Comments »