How to fetch all Receipt Transactions without filtering by Receipt Number
Hello Experts,
We are working with Oracle Fusion Procurement REST APIs to extract Receiving transactions.
Currently, we are using the below endpoint:
/fscmRestApi/resources/11.13.18.05/receivingTransactionsHistory
As per the documentation, at least one of the following attributes is mandatory:
ItemId, ItemNumber, ShipmentHeaderId, ReceiptNumber, ShipmentNumber, POHeaderId, PONumber, TransferOrderHeaderId, TransferOrderNumber, ReceiptAdviceHeaderId, ReceiptAdviceDocumentNumber, ExternalSystemTransactionReference.
Because of this, we are forced to query only one Receipt or PO at a time. Our requirement is to fetch all Receiving Transactions in bulk (similar to how /purchaseOrders returns all POs with pagination).
We also noticed another endpoint:
/fscmRestApi/resources/11.13.18.05/receivingReceiptTransactionRequests
This API returns records (including those with status ERROR or IN PROGRESS), but our requirement is specifically to get all posted Receipt Transactions without passing ReceiptNumber or POHeaderId explicitly.