I hope to create a script that queries the URLs and makes a list, tests the connections, and sends an email when a connection cannot be made with the Java punchout test provided by Oracle.
What table would I need to query to get a list of punchout URLs to test? Thanks
below tables will help you for the punch-out
ICX_CAT_CONTENT_ZONEs_vl -- holding detail content zone information
ICX_CAT_SECURE_CONTENTS – holding responsibility assigned for the content zone
ICX_CAT_PUNCHOUT_ZONE_DETAILS – content definition details