Oracle Fusion

POZ_SUPPLIERS: Supplier Table In Oracle Fusion

Mohit Saxena

POZ_SUPPLIERS is the table used by Oracle Fusion to store the data related to supplier. Supplier is someone you use to source the material or the services from, so it makes supplier one of the key entities in your business. So if you have implemented Purchasing/ Payables or P2P Cycle, it is inevitable that you will have to query the POZ_SUPPLIERS table. In this post we will talk about the table structure as well as the indexes present on this table in Oracle Fusion so that you can query the table more efficiently. But in case you are looking for the query to fetch the supplier details, this post may help you. Before we have a look at the structure, here are a few points to remember:

Navigation: Procurement –> Suppliers

POZ_SUPPPLiERS
Suppliers Navigation ( POZ_SUPPLiERS)

1. Segment1 of the table holds the supplier number or the vendor number.
2. Party_Id is the column which links the table POZ_SUPPLIERS with HZ_PARTIES table. This link is critical as using it you will be able to find the supplier name ( Thanks to TCA architecture).
3. POZ_SUPPLIER_SITES_ALL_M is the child table which is used to store the supplier site details.

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

POZ_SUPPLIERS Columns

COLUMN_NAMEDATA_TYPENULLABLE
 VENDOR_IDNUMBERN 
 REVIEW_TYPEVARCHAR2(120)Y 
 OBJECT_VERSION_NUMBERNUMBERN 
 SEGMENT1VARCHAR2(120)N 
 PARTY_IDNUMBERN 
 CREATION_SOURCEVARCHAR2(100)Y 
 ENABLED_FLAGVARCHAR2(4)Y 
 SUMMARY_FLAGVARCHAR2(4)Y 
 VENDOR_TYPE_LOOKUP_CODEVARCHAR2(120)Y 
 CUSTOMER_NUMVARCHAR2(100)Y 
 ONE_TIME_FLAGVARCHAR2(4)Y 
 EMPLOYEE_IDNUMBERY 
 PARENT_PARTY_IDNUMBERY 
 PARENT_VENDOR_IDNUMBERY 
 MIN_ORDER_AMOUNTNUMBERY 
 SET_OF_BOOKS_IDNUMBERY 
 TYPE_1099VARCHAR2(40)Y 
 WITHHOLDING_STATUS_LOOKUP_CODEVARCHAR2(100)Y 
 WITHHOLDING_START_DATEDATEY 
 INCOME_TAX_ID_FLAGVARCHAR2(4)Y 
 NI_NUMBER_FLAGVARCHAR2(4)Y 
 ORGANIZATION_TYPE_LOOKUP_CODEVARCHAR2(120)Y 
 TAXPAYER_COUNTRYVARCHAR2(8)Y 
 START_DATE_ACTIVEDATEY 
 END_DATE_ACTIVEDATEY 
 MINORITY_GROUP_LOOKUP_CODEVARCHAR2(100)Y 
 WOMEN_OWNED_FLAGVARCHAR2(4)Y 
 SMALL_BUSINESS_FLAGVARCHAR2(4)Y 
 STANDARD_INDUSTRY_CLASSVARCHAR2(100)Y 
 TAX_VERIFICATION_DATEDATEY 
 NAME_CONTROLVARCHAR2(16)Y 
 STATE_REPORTABLE_FLAGVARCHAR2(4)Y 
 FEDERAL_REPORTABLE_FLAGVARCHAR2(4)Y 
 TAX_REPORTING_NAMEVARCHAR2(320)Y 
 ALLOW_AWT_FLAGVARCHAR2(4)Y 
 AWT_GROUP_IDNUMBERY 
 BANK_CHARGE_BEARERVARCHAR2(4)Y 
 NI_NUMBERVARCHAR2(120)Y 
 BC_NOT_APPLICABLE_FLAGVARCHAR2(4)Y 
 EXTERNAL_SYSTEM_IDNUMBERY 
 EXTERNAL_SYSTEMVARCHAR2(360)Y 
 LAST_UPDATE_DATETIMESTAMP(6)N 
 LAST_UPDATED_BYVARCHAR2(256)N 
 LAST_UPDATE_LOGINVARCHAR2(128)Y 
 CREATION_DATETIMESTAMP(6)N 
 CREATED_BYVARCHAR2(256)N 
 REQUEST_IDNUMBERY 
 JOB_DEFINITION_NAMEVARCHAR2(400)Y 
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)Y 
 PROGRAM_APPLICATION_IDNUMBERY 
 PROGRAM_IDNUMBERY 
 PROGRAM_UPDATE_DATEDATEY 
 ATTRIBUTE_CATEGORYVARCHAR2(120)Y 
 ATTRIBUTE1 –  ATTRIBUTE20VARCHAR2(600)Y 
 ATTRIBUTE_DATE1- ATTRIBUTE_DATE10DATEY 
 ATTRIBUTE_TIMESTAMP1 –  ATTRIBUTE_TIMESTAMP10TIMESTAMP(6)Y 
 ATTRIBUTE_NUMBER1 –  ATTRIBUTE_NUMBER10NUMBERY 
 GLOBAL_ATTRIBUTE1 –  GLOBAL_ATTRIBUTE20VARCHAR2(600)Y 
 GLOBAL_ATTRIBUTE_DATE1 –  GLOBAL_ATTRIBUTE_DATE10DATEY 
 GLOBAL_ATTRIBUTE_TIMESTAMP1 –  GLOBAL_ATTRIBUTE_TIMESTAMP10TIMESTAMP(6)Y 
 GLOBAL_ATTRIBUTE_NUMBER1 –  GLOBAL_ATTRIBUTE_NUMBER10NUMBERY 
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(120)Y 
 AP_TAX_ROUNDING_RULEVARCHAR2(4)Y 
 AUTO_TAX_CALC_FLAGVARCHAR2(4)Y 
 AUTO_TAX_CALC_OVERRIDEVARCHAR2(4)Y 
 AMOUNT_INCLUDES_TAX_FLAGVARCHAR2(4)Y 
 OFFSET_TAX_FLAGVARCHAR2(4)Y 
 OFFSET_VAT_CODEVARCHAR2(80)Y 
 VAT_CODEVARCHAR2(120)Y 
 VAT_REGISTRATION_NUMVARCHAR2(80)Y 
 CORPORATE_WEBSITEVARCHAR2(600)Y 
 BUSINESS_RELATIONSHIPVARCHAR2(120)Y 
 SPEND_AUTH_JUSTIFICATIONVARCHAR2(4000)Y 
 SPEND_AUTH_REVIEW_STATUSVARCHAR2(120)Y 
 SUPPLIER_LOCKED_FLAGVARCHAR2(4)Y 
 CHANGE_REQ_NUMBERNUMBERY 
 REBUILD_INDEXVARCHAR2(4)Y 
 CREATED_BY_REST_FLAGVARCHAR2(4)Y 
 DATAFOX_COMPANY_IDVARCHAR2(120)Y 
POZ_SUPPLIERS Table Structure

Indexes

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN_NAME
 POZ_SEARCH_INDEXDOMAINNONUNIQUEREBUILD_INDEX
 POZ_SUPPLIERS_N2NORMALNONUNIQUEPARENT_VENDOR_ID
 POZ_SUPPLIERS_N3NORMALNONUNIQUEPARENT_PARTY_ID
 POZ_SUPPLIERS_N4NORMALNONUNIQUEPARTY_ID
 POZ_SUPPLIERS_N5FUNCTION-BASED NORMALNONUNIQUESYS_NC00170$
 POZ_SUPPLIERS_N6NORMALNONUNIQUELAST_UPDATE_DATE
 POZ_SUPPLIERS_N7NORMALNONUNIQUETAXPAYER_COUNTRY
 POZ_SUPPLIERS_N8NORMALNONUNIQUECREATION_DATE
 POZ_SUPPLIERS_N9NORMALNONUNIQUEDATAFOX_COMPANY_ID
 POZ_SUPPLIERS_U1NORMALUNIQUEVENDOR_ID
 POZ_SUPPLIERS_U2NORMALUNIQUESEGMENT1
Indexes

Related Posts

Supplier Detail Query
Supplier Site Query ( SQL) – General in Fusion
Vendor Site – Invoicing & Payments Query
Vendor Fiscal Classification Query in Oracle Fusion

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 3

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

1 thought on “POZ_SUPPLIERS: Supplier Table In Oracle Fusion”

  1. Pingback: Supplier Site Query ( SQL) - General in Fusion - Oracle Bytes

Comments are closed.