Pa_Budget_Pub.Add_budget_line API Returns Status 'S' When No Rows Inserted (Doc ID 2691322.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Goal

The Pa_Budget_Pub.add_budget_line API is returning Success but budget lines are not getting created in the base table pa_budget_lines.

When below parameters are NULL, the API is not inserting row but return status is still 'S' (success).
QUANTITY IS NULL
AND RAW_COST IS NULL
AND BURDENED_COST IS NULL
AND REVENUE IS NULL

If these 4 parameters cannot be NULL, then API should return some message.
 

Solution

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