Request for Standard API/SOAP Service to Extract Subscription Billing Data with Complex Filtering — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Request for Standard API/SOAP Service to Extract Subscription Billing Data with Complex Filtering

edited May 29, 2025 1:20PM in Subscription Management 3 comments

We are currently using a custom BIP report to extract Subscription, Product, and Bill Line data required for downstream invoicing and reconciliation processes. This report is essential for our business because it includes:

  • Complex joins across multiple Oracle modules
  • Context-sensitive filtering
  • Business rule validations

These requirements are not feasible using the standard Oracle REST or SOAP APIs as of today.

Our API Requirements

We specifically require a supported API (REST or SOAP) that can fetch Subscription Billing data based on the following conditions:

  • Payment Term Name (e.g., RA_TERMS mapping for inclusion/exclusion)
  • Fulfillment Line EFF field values (e.g., context_code = 'SourceOrdercreation', conditional logic on attribute_char3)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!