My Oracle Support Banner

SLM How To Save UDA Calculated Data? (Doc ID 2651846.1)

Last updated on MARCH 25, 2020

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Oracle Supplier Hub - Version 12.1.3 and later
Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Goal


When using Supplier Lifecycle Management (SLM) for prospective supplier registrations there are defined user defined (pl/sql) functions to perform certain activities using the user defined attributes (UDA) similar to <Note 1553625.1>.

While the user defined function is working fine, how to save the data on the page in the UDAs?

For example there are 3 UDAs (say UDA1, UDA2 and UDA3) and a user defined plsql function/action to calculate the sum of UDA1 and UDA2 and populate it in UDA3.

When clicking on the user defined action/button, it calculates UDA3 (as UDA1 + UDA2) and shows the result in the UDA3 textfield. However the result is only temporary and not saved in the underlying tables.

Currently the workaround is to click on the page, go back to the main page and then click on save button but that involves extra navigation steps.

How can the results be saved in the UDA3 in the underlying table?
 

Solution

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
Goal
Solution
References


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