Real Time Requirement to build GRN(Goods Receipt Note) Automation Report with Bursting feature in Oracle Fusion

BIP.Req.	15th July 2026	Goods Receipt Automation Report
	Purpose:
		Write SQL query is designed for BIP report "to identify Purchase Order (PO) lines of type "Goods" that have been ordered but have not yet been received" (that means they are missing a Goods Receipt).
	Why	In AP automation(through Email Bursting: GoodsAutoEmail Bursting Report), BIP report is typically used to drive a workflow or notification system. It identifies the exact requesters (and their email addresses) who need to go into the system and perform a "Receive" action so that Accounts Payable can complete the 3-way match and pay the supplier.
	Domain	Oracle Fusion Finanicals
	MODULE	Account Payable
		Columns/Attributes Required
		REQUESTER_ID
		REQUISITION_NUMBER
		PURCHASE_ORDER
		ITEM_NUMBER
		ITEM_DESCRIPTION
		QUANTITY_ORDERED
		NEED_BY_DATE
		DELIVER_TO_LOCATION
		SUPPLIER_NAME
		SUPPLIER_SITE
		REQUESTER
		EMAIL_ADDRESS
		PO Line Type
		TRANSACTION_TYPE