Get Started with Redwood: Oracle Cloud SCM and Purchasing
Query to fetch the Receipt Date from Manage Orders UI page
in Purchasing
Hello everyone,
I’m trying to retrieve the Receipt Date for Purchase Order (PO) Receipts in Oracle Fusion Cloud Procurement / Receiving.
In the UI (as shown in the attached screenshot), the Receipt Date appears under the Lines section of the Receipt page, alongside the PO Number, Item, Quantity, and UOM.
I’m currently using the field RCV_TRANSACTIONS.TRANSACTION_DATE in my SQL query to fetch the Receipt Date. However, I’ve noticed that for some records, the date displayed on the UI does not match the value stored in this column in the backend table.
Could anyone please help clarify:
0