Wednesday Jan 06, 2016

Integration of Oracle Property Manager with Other Applications

Oracle Property Manager provides an integrated solution with other Oracle Applications. It integrates with other applications such as General Ledger, Oracle Payables, Oracle Receivables etc. Here is a glimpse of other sub ledgers which are integrated with Oracle Property Manager.

1. Oracle General Ledger:- Property Manager  retrieves few setup related information like  chart of account, accounting period types, accounting calendar, ledger, subledger accounting options etc  from General Ledger. Also the normalized accounting entries are transferred from Property Manager to general ledger via Oracle Subledger Accounting module.

2. Oracle Subledger Accounting:- Oracle Property Manager predefines certain setups in Oracle Subledger Accounting like accounting events and event types, sources, account derivation rules etc and these setups will be used when the create accounting program is run in Property Manager.

In addition to that you can transfer normalization-related accounting information from Oracle Property Manager to Oracle Subledger Accounting. Oracle Subledger Accounting creates the appropriate journal entries and transfers them to Oracle General Ledger.

3. Oracle Human Resources (HRMS):- The employee information which we use in Oracle Property Manager while managing office space and allocating locations to employees, are retrieved from HRMS.

Also in HRMS module we can define a hierarchy of organizations to represent the structure of the company. Once you have created the required organizations, you can classify one or more as operating units. In Oracle Property Manager, operating units are used to partition data. Users create all leases, agreements, contacts, locations, and space assignments for a specific operating unit.

4. Oracle Payables :- The owner of the property your organization intends to lease (the landlord) must be set up as a supplier in Oracle Payables and this supplier information will be used while creating a expense lease in Property Manager. Also Property manager uses the other information’s like payment term, distribution set etc which are setup in payables.

Once the leases are created and payments are approved, their invoice information is send to Accounts Payables for invoice creation and for payment processing.

5. Oracle Receivables :- In Property Manager, while creating a revenue lease few information which we use like customers, transaction source, transaction types, grouping rules, payment terms etc are retrieved from Oracle Receivables module.

Also once the Revenue leases are created and finalized, billing lines are approved and transferred to Receivables for invoice creation and further the accounting of invoices is sent to General ledger.

In addition to above, Oracle Property Manager module also integrates with Oracle E-Business Tax, Oracle Projects and Oracle Enterprise Asset Management.

The tax rates which we define in Oracle E-Business Tax appear in the tax input classification or tax output classification LOVs on the term details window. Users can thus associate the appropriate tax rates with lease terms.

You can assign projects which are defined in Oracle Projects module to a location in Oracle Property Manager. By linking locations to projects, your organization can track where project team members are located and the exact costs of space assignment.

The integration between Oracle Property Manager and Oracle Enterprise Asset Management (eAM) enables eAM assets to correspond with locations defined in Oracle Property Manager. Using the Export Locations to Enterprise Asset Management concurrent program we can export location data to Oracle Enterprise Asset Management.

Oracle Property Manager also uses an open interface to integrate with CAD and CAFM applications. This integration enables you to manipulate and view information about your space definition and usage in either a forms-based or CAFM environment, synchronizing data across applications as required.

For more details on integration of Property manager with Other subledgers, refer the Property Manager implementation guide.

Monday Nov 18, 2013

Troubleshooting CRM Integration Points

A topic that consistently comes up in CRM product family Service Requests and in MOS Communities is that of integration points between products, either between products within the CRM product family or between a CRM and an ERP product.  Often there is confusion about how that integration point should work and what to do when it doesn't!

To try and address the types of problems and queries that arise, we have been producing Integration Troubleshooting articles which address a number of different integration hotspots:
  • Integration Troubleshooting: Install Base to Service Contracts (Doc ID 1451488.2)
  • Integration Troubleshooting: Order Management to Service Contracts (Doc ID 1455545.2).
  • Integration Troubleshooting : Charges (Core Service to Order Management) (Doc ID 1589712.2)
  • Integration Troubleshooting : Charges to Installed Base (Doc ID 1443462.2)
  • Integration Troubleshooting : Charges (Core Service) to Order Management (Doc ID 1446616.2)
  • Integration Troubleshooting : Territories to Core Service (Doc ID 1519495.2
  • Integration Troubleshooting : Email Center to Core Service (Automatic SR Creation) (Doc ID 1495860.2).

The notes present information on:

  • details of the integration point, with the applications navigation
  • setup considerations
  • integration flow explanation and troubleshooting.

Integration troubleshooting note example

Let us know if you like these notes and find them useful by rating the documents using the 'Rate this Document' link Rate this document iconon the top right of every KM document, or you can mail us directly on and let us know what you want to see.

Thursday Aug 22, 2013

Why Doesn't My Sales Order Generate A Contract?

When a Sales Order is created in Order Management which includes a Service line, when the order is booked and shipped a Service Contract is created (or amended depending on the order).

In some cases, the service contract is not created.  In this blog post I try to give some pointers to help you debug this integration point.  Note that in R12 there was a change in how this integration point works, here I refer only to R12 functionality.  If you are on an earlier EBS release please see Doc ID 463912.1 for troubleshooting steps.

Is your order interfaced?

Make sure that your order has been successfully shipped and the line has been interfaced.  Sometimes the order can be deferred until a future date.  Check the OM workflow to see if that's happened.  You'll see the deferred date in the OM Order Line (OEOL) 'Fulfill' node.  If it's not deferred to a future date but is not closed, then running the Workflow Background Process is required to progress the workflow.

Is the instance created in IB?

Make sure that the install base instance has been created.  Search in IB using the sales order number and make sure that the item with the linked service line is created as an instance.
Remember that the inventory item must be set up with 'Track in Installed Base' and 'Service Allowed' set to yes (ticked) in the item master.

What's the status of the interfaced record?

When the sales order is processed, a record is created in the OKS_REPROCESSING table.  Check the status of the this record in Service Contracts > Reprocess Order.
Query using the sales order number. This should return the sales order with a status of NEW (if the record is available for processing) or ERROR (if the record has been processed but failed to create the service contract).
If the status is NEW then all you have to do is select it for processing and then submit the Service Contracts Order Processing concurrent program.
If the status is ERROR then the error message displayed should give you an indication of why the contract creation has failed.

If all fails and you can't find the order in the Reprocess Order form, the query below will return order numbers with service lines which have not created a contract and are not in OKS_REPROCESSING table.   
select ord.order_number "Order_Number",
ord.header_id "Order_Id",
line.service_reference_line_id "Reference ID",
line_id "Service_Line_ID"
from csi_item_instances ib,
oe_order_lines_all line,
oe_order_headers_all ord
where not ib.last_oe_order_line_id is null
and ib.last_oe_order_line_id = line.service_reference_line_id
and ord.header_id = line.header_id
and line.flow_status_code = 'CLOSED'
and line.service_reference_type_code = 'ORDER'
and line.line_id not in
(select order_line_id from oks_reprocessing);
You can then use this information to implement a workaround such as creating the service contract manually OR you can log a service request with Oracle Support to get a datafix which will insert the missing order lines into OKS_REPROCESSING.

The following notes also have useful information about this integration point:
Integration Troubleshooting: Order Management to Service Contracts (Doc ID 1455545.1)
R12 How to Process Order Lines from Order Management to Create Service Contracts (Doc ID 785760.1)

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« June 2016