How to fetch all Receipt Transactions without filtering by Receipt Number — 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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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