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)
Tagged:
0