Budgeting - Key Field Date Code Added To Ledger Budg In FIN Not In BP_LED_BUDG_F00 (Doc ID 2264592.1)

Last updated on MAY 10, 2017

Applies to:

PeopleSoft Enterprise EPM Planning & Budgeting - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Budgeting - Key Field Date Code was added to Ledger Budg in Financials this field is  not in BP_LED_BUDG_F00

This is causing  major issues. Because when running allocations on the Financials side they do not populate anything in the DATE CODE field. Other process do populate with a 0. So we can end up with two rows in the LEDGER_BUDG.

For instance.

60500 - 0123 - 00 with a Blank Date Code

60500 - 1023 - 00 with a 0 in the Date Code Field

When these rows are pushed to Budgeting since Date code is not on the BP_LED_BUDG_F00 table we end with two rows that have the same keys fields and we get a Unique Constraint error.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms