Interface Tables for the Integration

Three tables interface data from Subscription Management to Revenue Management:

1. OSS_RMCS_DOC_T
2. OSS_RMCS_DOC_LINES_T
3. OSS_RMCS_DOC_SUB_LINES_T

More details of these tables can be found in the guide Oracle CX Tables and Views for CX Sales and B2B Service.

After the scheduled process, Send Subscription Revenue Information to Oracle Revenue Management Cloud, is executed, the data is interfaced to these VRM interface tables:

1. VRM_SOURCE_DOCUMENTS
2. VRM_SOURCE_DOC_LINES
3. VRM_SOURCE_DOC_SUB_LINES

Here's a brief description of these VRM interface tables:

Interface Table	Description
VRM_SOURCE_DOCUMENTS	Stores the basic subscription header information, such as document date, document number, bill-to customer ID, bill-to site ID, subscription start date, subscription number, and so on
VRM_SOURCE_DOC_LINES	Stores information about the subscription lines, such as the quantity, unit selling price, and line amount
VRM_SOURCE_DOC_SUB_LINES	Stores the information about satisfaction events