|
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 |
Wednesday, 15 July 2026
Real Time Requirement to build GRN(Goods Receipt Note) Automation Report with Bursting feature in Oracle Fusion
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment