Revenue Management Cloud

Co-Existence with E-Business Suite

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Safe Harbor Statement
The following is intended to outline our general product direction. It is intended for
information purposes only, and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or functionality, and should not be relied upon
in making purchasing decisions. The development, release, and timing of any features or
functionality described for Oracle’s products remains at the sole discretion of Oracle.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 2

Agenda

1 Inbound
2 Outbound

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 3
Agenda

1 Inbound
2 Outbound

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 4
RMCS Integration with EBS
Inbound | Source Applications

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | Source Applications
Order Management
All sales orders and returns in a status of Booked are integrated into RMCS based on the start date and transaction
sources specified on the System Options page. The Extract Revenue Basis Data process sends satisfaction events to
RMCS based on contingencies or fulfillment of orders.

Service Contracts
All approved service contracts are integrated into Revenue Management based on the start date and transaction sources
specified on the System Options page. EBS Service Contracts manages billing schedules and RMCS manages revenue
schedules. RMCS creates document versions to track terminations and changes to price and service duration.
RMCS supports contract terminations and changes to price and service duration.

Receivables
All transactions in a status of Completed are integrated into RMCS based on the start date and transaction sources
specified on the System Options page. Fulfillment of contingencies in EBS Receivables are sent to RMCS as satisfaction
events for revenue recognition.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | EBS Process Steps
Run Extract Revenue Basis Data process in EBS
This Program will extract the transaction data of the source application, which were not extracted in the prior runs and
funnel the data to Revenue Management Cloud Service canonical tables on EBS.

Run Create Revenue Management Data Export File process in EBS

The data file will be created in the UTL_FILE_DIRECTORY and subsequently trigger Fusion File Transfer & File Import and
Export process in Fusion and the data is imported into RMCS canonical tables.

Run Create Billing Data File process in EBS to create the billing data file from EBS AR
The data file will be created in the UTL_FILE_DIRECTORY and subsequently trigger Fusion File Transfer & File Import and
Export process in Fusion and the data is imported into RMCS canonical tables.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | Fusion Process Steps
After extracting the data from EBS, complete the following steps in RMCS:

Run the Validate Customer Contract Data process.

Correct validation errors using the Correct Contract Document Errors in Spreadsheet task.

Run the Identify Customer Contracts process to identify and create contracts and to
recognize revenue.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | EBS Process Steps | Screenshots

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | EBS Process Steps | Screenshots

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | EBS Process Steps | Screenshots

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | Process
Source Applications UCM Revenue Management Cloud (RMCS)
Transform

Code
Seeded hooks
Extract
Views Extract Revenue Load
Basis Data program
EBS Create Revenue Data Files Interface Rev Mgmt
Management Data (Source Tables base tables
Export File program headers, lines
Extract & sublines) Load Interface File for Import Revenue Management Daily
Job (automatically triggered) Job Set

control file

3rd Party Custom extract program

Application

Register the new source

Document Type

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 12

RMCS Integration with EBS
Inbound | Transformation
To extract additional data elements not captured by the standard process, use the transformation hook
provided by the Create Revenue Management Data Export File process

With this transformation hook you can extract:

Additional data elements from within EBS
Additional data elements from external locations such as legacy applications and data warehouses

The transformation hook then populates the values in the interface tables. You can write custom code to
select values from the specified table or view and populate the values in the generic columns. These
additional data elements can be used in RMCS as configurable attributes in defining rules.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | Setup
• EBS – Apply RMCS Integration Patches (EBS 12.1.3+; 12.2.x)
• EBS – System Options | Revenue Management tab
• EBS – Profile Option | AR: Source System Value for Revenue Management to ‘EBIZ’
• EBS – Setup to utilize Fusion Web Services via Business Events

Reference
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2244173.1

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Inbound | Setup | System Options

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Agenda

1 Inbound
2 Outbound

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 16
RMCS Integration with EBS
Outbound
General Ledger
The accounting entries created in Revenue Management for the transactions extracted
from EBS products can be integrated back into EBS GL

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Outbound

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Outbound | Process
UCM Revenue Management Cloud

EBS GL

RMCS
Import Journal Entries from Fusion Create Revenue
Subledger Accounting (in EBS) Accounting
Data Files

External
Application

Custom BI
Publisher
Extract

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 19

RMCS Integration with EBS
Outbound | Process Steps
Set Enable Transfer to Oracle EBS GL profile option to Yes in RMCS

Go to Manage Subledger Accounting task and set the transfer option to Oracle EBS GL for the subledger
Revenue Management

Run Create Accounting process. The process posts the accounting entries to a flat file. The file is available for
further processing in EBS GL

Run EBIZ GL:Import Journal Entries From Fusion Subledger Accounting process in EBS GL to trigger the
accounting entries to be posted into EBS General Ledger

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration with EBS
Outbound | Process Steps
For Reconciliation,

Run 'Create Revenue Management Reconciliation Data File' in EBS

Run 'Extract Revenue Management Reconciliation Data' in RMCS

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Agenda

3 With ERP Cloud

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 22
RMCS Integration ERP Cloud
Process Steps
Enterprise Contracts & Project Billing

Run Extract Revenue Basis Data from Oracle Fusion Applications

Imports sales cycle data from Enterprise Contracts and Project Billing into Revenue Management
Imports events from Enterprise Contracts and Project Billing to record satisfaction events and book revenue in
Revenue Management

Run Validate Customer Contract Source Data process to validate the imported data.

Run Identify Customer contracts process to identify and create contracts and performance obligations.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

RMCS Integration ERP Cloud
Process Steps
Receivables
You can import revenue basis data and billing data from Receivables into Revenue Management.

Import invoice and credit memo transactions from Receivables into Revenue Management by running the
Extract Revenue Basis Data from Oracle Fusion Applications process in Revenue Management. Run the
process using the document type Oracle Fusion Receivables. The process imports Receivables transactions as
source documents and fulfillment of contingencies as satisfaction events.

You can import billing data into Revenue Management by running the Import Billing Data from Oracle Fusion
Receivables process. This process imports the billing information of the imported source documents. You can
schedule the process to run periodically.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |