How to Update Table Value to null Through API in Oracle PL/SQL EBS

Discover how to set a database field to `null` using Oracle PL/SQL EBS APIs, overcoming common errors encountered in the process.
---

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Update table value to null thru API in Oracle PL/SQL EBS

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Updating Table Values to Null in Oracle PL/SQL EBS APIs

The Problem

You may have encountered the following situations when trying to set a value to null:

The API fails to update the value and retains the original value.

You use fnd_api.G_NULL_NUM to set values to null but receive various errors like:

ORA-06502: PL/SQL: numeric or value error: number precision too large

ORA-01438: value larger than specified precision allowed for this column

These errors can be perplexing and may leave you unsure of the next steps to take. The good news is that there's a straightforward solution to this issue!

Step-by-Step Guide

Identify Your API Call:

Ensure that you are using the fnd_user_pkg.UpdateUser API in your code as intended.

Replace fnd_api.G_NULL_NUM:

Example Implementation:

Here's a sample implementation of how to use the function:

[[See Video to Reveal this Text or Code Snippet]]

Why This Works

Conclusion

If you have any further questions about Oracle PL/SQL or the E-Business Suite, feel free to leave a comment below.