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

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)