My Oracle Support Banner

Vision Demo - API to Create, Update and Delete Approved Supplier List (ASL) (Doc ID 2287379.1)

Last updated on JULY 20, 2020

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


The goal of this note is to demonstrate the functionality of Approved Supplier List (ASL) API in Vision Demo test instance.


This article is intended for reader who has good knowledge of SQL and PL/SQL.


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
 How does the ASL API work?
 Test Case 1 : Create New ASL
 Test Case 2 : Update attributes of existing ASL
 Test Case 3 : Add additional Source Document to existing ASL
 Test Case 4 : Add new ASL record to existing ASL with different Supplier and Supplier site
 Test Case 5 : Delete Source Document record from existing ASL
 Test Case 6 : Delete ASL record
 Additional Information needed for Debugging

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