EBS Customizations (MOSC)

MOSC Banner

fnd_set API not working as expected getting ORA-06501: PL/SQL: program error and other errors

edited Oct 19, 2016 5:00AM in EBS Customizations (MOSC) 2 commentsAnswered

Hello All,

Thanks in advance for taking a look at my issue. We are trying to automate the process of cleanup of all existing unwanted programs from our application including references of programs/request sets. Below is the code used for deleting request set from application but it is not working. Please review:

DECLARE

v_old_request_set_short_name VARCHAR2(200);

v_old_request_set_application VARCHAR2(200);

v_old_request_group VARCHAR2(200);

v_old_group_application VARCHAR2(200);

BEGIN

--Initializing the constants needed by all the oracle standard API's

v_old_request_set_short_name := 'CUSTSETUPS'; --P_OLD_REQUEST_SET_SHORT_NAME;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center