Budgeting - Key Field Date Code Added To Ledger Budg In FIN Not In BP_LED_BUDG_F00
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.
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