My Oracle Support Banner

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

Last updated on MARCH 09, 2020

Applies to:

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


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.




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

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