My Oracle Support Banner

How To Get Business Unit Of Customer in Fusion Receivables ? (Doc ID 2355605.1)

Last updated on APRIL 22, 2024

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Customer & Business Unit link Table Name required


What is the link between customer and org_id/operating_unit assigned to customer.
The two tables 'HZ_CUST_ACCT_SITES_ALL' and 'HZ_CUST_SITE_USES_ALL'  have no columns/references containing org_id/operating_unit_id.
Please provide the table name and the column_name in that table which contains organization_id/operating_unit_id assigned to customer.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.