环境： EBS R12.2.xx
PLSQL API 使用 fnd_flex_keyval.validate_segs()， plsql写的程序包中实现杂项入库功能，偶尔会出现失败，
提示信息： 值集CUX_COA_Company中不存在弹性域段 Company 的值 470， 值集CUX_COA_Company中不存在弹性域段 Company 的值 470。
实际上是存在的。
解决方式：在fnd_flex_keyval.validate_segs() 前，添加一个 “
gl_global.set_aff_validation('XX',null);
”
APPS.POR_UTIL_PKG dependencies on GL_GLOBAL
Line 2007: gl_global.set_aff_validation('XX',null);
2003:
2004: result := -1;
2005: X_concatSegs := '';
2006:
2007: gl_global.set_aff_validation('XX',null);
2008: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');
2009:
2010:
2011: if res = TRUE THEN
Line 2035: gl_global.set_aff_validation('XX',null);
2031: END IF;
2032:
2033: -- validate individual segments based on passed validation date
2034: IF result = 1 THEN
2035: gl_global.set_aff_validation('XX',null);
2036: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));
2037: IF res = FALSE THEN
2038: result := -1;
2039: END IF;
Line 2087: gl_global.set_aff_validation('XX',null);
2083:
2084: result := -1;
2085:
2086: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',X_chartOfAccountsId, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),X_concatSegs);
2087: gl_global.set_aff_validation('XX',null);
2088: res := fnd_flex_keyval.validate_segs('FIND_COMBINATION','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',SYSDATE,
2089: 'ALL',
2090: NULL,
2091: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
参考： https://etrm.live/etrm-12.2.2/etrm.oracle.com/pls/trm1222/etrm_pnavae5e-13.html?n_object_id=1022587&c_name=GL_GLOBAL