Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transact

Nov 13, 2024 8:49AM

Hi Team,

We need to retrieve available to reserve and available to transact , but we've observed discrepancies when querying through SQL. Our goal is to achieve this via a REST API/Web service instead. We already have a POST method in place to fetch the necessary details through the REST API.

Below are the details:
URL:
https://XXXXXXXXXX.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/availableQuantityDetails
Payload:
{

"OrganizationCode": "M1"
,"ItemNumber": "100000"
,"Subinventory": "FINISHED G"
,"Lot": "9999"

}
Method: POST

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24d/fasrp/op-availablequantitydetails-post.html

However, we've encountered difficulties in invoking the REST/SOAP service within BIP (Business Intelligence Publisher). Despite several attempts, we haven't been able to find a working solution.

Invoking REST API/SOAP in BIP for Fetching available to reserve and available to transact

Howdy, Stranger!