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

Feasibility check: OTBI report for supplier registration resubmissions

in Reporting and Analytics for ERP 1 comment

Summary:

Hi Team,

We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their volume.

We thought of developing OTBI graph that shows record counts by Supplier Type (VENDOR / SUPPLIER / TRANSPORTADOR) and Resubmission bucket (2–3, 4–6, >6)—matching POZ_SUPPLIER_REGISTRATIONS.RESUBMISSION_NUM (e.g., VENDOR: 66/19/2; SUPPLIER: 109/30/4; TRANSPORTADOR: 1/0/1). This data is available in supplier registration table.

Gap we found

In Supplier Registration – Supplier Real Time, we cannot find a column equivalent to RESUBMISSION_NUM (or enough detail to derive these buckets).

Question Is there an OTBI subject area that exposes RESUBMISSION_NUM (or an equivalent field), or is this only achievable via a custom model/extract?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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