Scenario: How to get the request group ID for the request group “US SHRMS Reports & Processes”?
ORA-01403: NO DATA FOUND
Solution: Use CHR function
This BLOG might be helpful for oracle application beginners and technical developers. The BLOG post’s screen shots & source codes may distinguish from versions. If the code/steps fail please check with oracle guides or meta-links.