Oracle table name to fetch all Supplier Profile Change Request Details
Summary:
We have requirement to build report with below columns.
1. Supplier name
2. Supplier account number.
3. Date of account update- Initiated
4. Account update- Date approved
5. Type of update(Ex: Bank detail change, address change, site addition, contact change, account status)
6. Original Information (Ex: original address, bank, contact etc.)
7. Updated Information (Ex: new address, bank, contact etc.)
8. Account change initiated by
9. Account change Approved by
So we have suggested Seeded "Listing of Supplier Profile Change Requests" dashboard which is present in the /shared/Procurement/Supplier Profile Change Request/Transactional Analysis Samples path but the dashboard and OTBI Report inside the dashboard does not contain the necessary details which we are looking for. So, we tried to build custom report with custom query.