My Oracle Support Banner

Questions About Extraction Conditions For Subscription Related Object Using Export Management (Doc ID 2830984.1)

Last updated on JANUARY 11, 2022

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version 11.13.21.07.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.21.07.0 version, REST/Web Services

Questions about extraction conditions by SMCS export(REST API)

Questions about extraction conditions by SMCS export

Subscription
SubscriptionProduct
SubscriptionProductBillLine

Set the following as conditions when exporting the above

Subscription: Status = Active, Closed, Expired
SubscriptionProduct: None in particular
SubscriptionProductBillLine: LastUpdateDate> = 2021-10-20

[Expected Reasult]
Extract only data that has been updated on SubscriptionProductBillLine since 2021-10-20
Extract Subscription and Subscription Product associated with it

[Actual Result]
For SubscriptionProductBillLine, only data updated after 2021-10-20 are exported.
For Subscription, all active, closed, and expired records are exported.
For SubscriptionProduct, all records associated with Subscription are exported.

[Expected Result Example]
SubscriptionProductBillLine
Record: A
Record: B

Associated to the above
SubscriptionProduct
Record: A
Record: B

Associated to the above
Subscription
Record: A
Record: B

[Actual Result Example]
SubscriptionProductBillLine
Record: A
Record: B

SubscriptionProduct
Record: A
Record: B
Record: C*
Record: D*

Subscription
Record: A
Record: B
Record: C*
Record: D*

(*)Unexpected result

We attached the sample we are actually using.

* Is there a way to make it work as expected?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.