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

Requisition Report errors when filtering to one BU

edited Jan 21, 2025 2:15PM in Reporting and Analytics for SCM 1 comment

We have a Requisition Approved Status report that runs a report for approved Reqs for our 3 Business Units, Report runs fine when ALL BUs are selected or even 2 BUs. But when we select just 1, the report give a Invalid Number error. SQL code for the report is below. Anyone have idea and what we can change to prevent the error.

SELECT
HOU.NAME REQUISITION_BU_NAME,
HOU.ORGANIZATION_ID,
PRH.REQ_BU_ID,
PRH.REQUISITION_NUMBER,
PRH.DESCRIPTION,
PREPARER.FULL_NAME ENTERED_BY,
--trunc(PRH.CREATION_DATE) CREATION_DATE,
to_char(PRH.CREATION_DATE, 'DD-Mon-YYYY','NLS_DATE_LANGUAGE=AMERICAN') CREATION_DATE,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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