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

How can I build an ASL report in BI Publisher with supplier, item, and organization names?

in BI Publisher Learning Center

Hello,

I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enrich the data with full names instead of just IDs.

However, when I attempt to join it with other tables such as POZ_SUPPLIERS, MTL_SYSTEM_ITEMS_B, or HR_ORGANIZATION_UNITS, I encounter the following error:
ORA-00907: missing right parenthesis.

Could you please confirm the following:

  • Are these tables accessible in our Fusion Cloud environment via BI Publisher?
  • If not, are there any Secured List Views (SLVs) or interfaces available that I can use to retrieve supplier names, item descriptions, and organization names?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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