Post upgrade concurrent programs Flex Loader: FDFVGN () (Flexfield View Generator) failede post
Quite a few of the post upgrade concurrent requests running EXAMPLE: "Flex Loader: FDFVGN(3,200,ap_gov_detail_apsp) (Flexfield View Generator)" failed with the following error:
CREATE OR REPLACE VIEW AP_SYSTEM_PARAMETERS_ALL_DFV
(ROW_ID, "CONTEXT_VALUE", Transaction_Code,
CONCATENATED_SEGMENTS)
AS SELECT ROWID, USSGL_TRX_CODE_CONTEXT, USSGL_TRANSACTION_CODE,
USSGL_TRANSACTION_CODE
FROM AP_SYSTEM_PARAMETERS_ALL
Oracle error 1403: ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
We found a MOS note stating it was probably the the install group for APPS again. When checked, it has gone back to 0 so we updated it to 1, but the jobs had already failed. It had been 1 previously so maybe running changing the ALLORACLE password did something, just not sure.