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.
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.
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