My Oracle Support Banner

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

Last updated on JULY 16, 2020

Applies to:

Oracle Project Foundation - Version 12.2.5 and later
Information in this document applies to any platform.

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

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


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