My Oracle Support Banner

R12: AP: Error: ORA-20001 APP-SQLAP 10000 ORA -12096 : While Creating Supplier Site Address (Doc ID 2863472.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.


When attempting to add an address to supplier site
the following error occurs.


Address and Site Creation - Unable to create address and sites because of the following error when trying to create this site in Operating unit : ORA-20001 APP-SQLAP 10000 ORA -12096: error in materialized view log on AP.AP_SUPPLIER_SITES_ALL ORA:01653 unable to extend table AP.MLOG$AP_SUPPLIER_SITES_ALL by XX in table space XXXXXXX occurred in with parameter (VENDOR_S in Package AP_VENDOR_PUB_PKG Procedure Create_VENDOR_SITE.

The issue can be reproduced at will with the following steps:

  1. Log into Oracle Applications and select Payables Responsibility
  2. Navigate to Suppliers -> Inquiry
  3. Query for Supplier 
  4. Click on Address Book -> Create Address




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

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