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:
- Log into Oracle Applications and select Payables Responsibility
- Navigate to Suppliers -> Inquiry
- Query for Supplier
- 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