My Oracle Support Banner

What Is The Replacement Table in R12 for HZ_LOC_ASSIGNMENTS? (Doc ID 463987.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.0.2 and later
Information in this document applies to any platform.
Information in this document applies to any platform.


Purpose

HZ_LOC_ASSIGNMENTS and loc_id have been obsoleted in R12.
This object is a table in R11i and the same is a view in Release 12. 
Also, the number of records returned is different after upgrading to R12.

In Release 12, the object HZ_LOC_ASSIGNMENTS is now a synonym pointing to the view ZX_LOC_ASSIGNMENTS_V. This view picks up data from the following HZ objects:

Scope

 

Details

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
Purpose
Scope
Details
 Still Have Questions?


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