gl_code_combinations_kfv or FDFVGN

[mimi_miao]

Hi people!

I encountered an error in GL11i while trying to turn on DYNAMIC INSERT for code combinations, the error has something to do with FDFVGN module and GL_CODE_COMBINATIONS_KFV (its a view that will be generated by FDFVGN module, in case you dont know...)
Well, can someone be kind enough to send me the script of creating GL_CODE_COMBINATIONS_KFV, its located in APPS schema, or the FDFVGN module ( or how it works) so that I can trace the cause of error.
Thanks and regards people!
[:D] [;)]

[oteixeira]

Hello.

Here's the script:

Code: Select all

CREATE OR REPLACE VIEW GL_CODE_COMBINATIONS_KFV
(ROW_ID, CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID, CONCATENATED_SEGMENTS, PADDED_CONCATENATED_SEGMENTS, 
 GL_ACCOUNT_TYPE, DETAIL_BUDGETING_ALLOWED, DETAIL_POSTING_ALLOWED, REFERENCE2, SEGMENT_ATTRIBUTE37, 
 SEGMENT_ATTRIBUTE14, SEGMENT5, SEGMENT19, SEGMENT8, LAST_UPDATE_DATE, 
 SEGMENT_ATTRIBUTE6, SEGMENT_ATTRIBUTE20, ATTRIBUTE4, SEGMENT_ATTRIBUTE16, SEGMENT2, 
 SEGMENT_ATTRIBUTE32, SEGMENT17, SEGMENT26, REFRESH_FLAG, ATTRIBUTE1, 
 SEGMENT16, SEGMENT_ATTRIBUTE3, ATTRIBUTE8, SEGMENT_ATTRIBUTE23, SEGMENT_ATTRIBUTE9, 
 SEGMENT6, ALLOCATION_CREATE_FLAG, SEGMENT9, IGI_BALANCED_BUDGET_FLAG, SEGMENT29, 
 SEGMENT23, JGZZ_RECON_CONTEXT, SEGMENT18, SEGMENT25, SEGMENT_ATTRIBUTE27, 
 SEGMENT28, SEGMENT_ATTRIBUTE4, ATTRIBUTE7, SEGMENT11, SEGMENT_ATTRIBUTE36, 
 TEMPLATE_ID, SEGMENT_ATTRIBUTE7, SEGMENT_ATTRIBUTE10, ATTRIBUTE9, SEGMENT_ATTRIBUTE8, 
 SEGMENT3, JGZZ_RECON_FLAG, START_DATE_ACTIVE, SEGMENT_ATTRIBUTE26, SEGMENT22, 
 SEGMENT_ATTRIBUTE40, SEGMENT_ATTRIBUTE13, SEGMENT15, SEGMENT24, SUMMARY_FLAG, 
 REFERENCE1, REFERENCE3, SEGMENT20, SEGMENT_ATTRIBUTE31, SEGMENT27, 
 SEGMENT_ATTRIBUTE29, SEGMENT_ATTRIBUTE21, REFERENCE5, SEGMENT_ATTRIBUTE1, PRESERVE_FLAG, 
 SEGMENT_ATTRIBUTE18, SEGMENT_ATTRIBUTE35, ENABLED_FLAG, SEGMENT_ATTRIBUTE19, END_DATE_ACTIVE, 
 SEGMENT12, SEGMENT_ATTRIBUTE5, ATTRIBUTE2, SEGMENT21, SEGMENT_ATTRIBUTE28, 
 SEGMENT_ATTRIBUTE41, SEGMENT7, SEGMENT14, ATTRIBUTE5, LAST_UPDATED_BY, 
 SEGMENT_ATTRIBUTE34, SEGMENT_ATTRIBUTE33, SEGMENT30, SEGMENT_ATTRIBUTE15, SEGMENT_ATTRIBUTE24, 
 COMPANY_COST_CENTER_ORG_ID, SEGMENT_ATTRIBUTE25, REFERENCE4, SEGMENT_ATTRIBUTE39, SEGMENT_ATTRIBUTE11, 
 SEGMENT10, SEGMENT_ATTRIBUTE42, SEGMENT_ATTRIBUTE22, SEGMENT_ATTRIBUTE17, SEGMENT_ATTRIBUTE30, 
 SEGMENT_ATTRIBUTE2, SEGMENT_ATTRIBUTE38, SEGMENT4, DESCRIPTION, SEGMENT1, 
 ATTRIBUTE3, SEGMENT_ATTRIBUTE12, REVALUATION_ID, ATTRIBUTE10, CONTEXT, 
 ATTRIBUTE6, SEGMENT13)
AS 
SELECT ROWID, CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID,  
 (DECODE(CHART_OF_ACCOUNTS_ID,  
      101, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' || SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6 || '.' || SEGMENT7 || '.' || SEGMENT8, NULL)),  
 (DECODE(CHART_OF_ACCOUNTS_ID,  
      101, RPAD(NVL(SEGMENT1, ' '), 2) || '.' || RPAD(NVL(SEGMENT2, ' '), 10) || '.' || RPAD(NVL(SEGMENT3, ' '), 10) || '.' || RPAD(NVL(SEGMENT4, ' '), 7) || '.' || RPAD(NVL(SEGMENT5, ' '), 7) || '.' || RPAD(NVL(SEGMENT6, ' '), 4) || '.' || RPAD(NVL(SEGMENT7, ' '), 6) || '.' || RPAD(NVL(SEGMENT8, ' '), 6), NULL)),  
 ACCOUNT_TYPE, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, REFERENCE2, SEGMENT_ATTRIBUTE37, SEGMENT_ATTRIBUTE14, SEGMENT5, SEGMENT19, SEGMENT8, LAST_UPDATE_DATE, SEGMENT_ATTRIBUTE6, SEGMENT_ATTRIBUTE20, ATTRIBUTE4, SEGMENT_ATTRIBUTE16, SEGMENT2, SEGMENT_ATTRIBUTE32, SEGMENT17, SEGMENT26, REFRESH_FLAG, ATTRIBUTE1, SEGMENT16, SEGMENT_ATTRIBUTE3, ATTRIBUTE8, SEGMENT_ATTRIBUTE23, SEGMENT_ATTRIBUTE9, SEGMENT6, ALLOCATION_CREATE_FLAG, SEGMENT9, IGI_BALANCED_BUDGET_FLAG, SEGMENT29, SEGMENT23, JGZZ_RECON_CONTEXT, SEGMENT18, SEGMENT25, SEGMENT_ATTRIBUTE27, SEGMENT28, SEGMENT_ATTRIBUTE4, ATTRIBUTE7, SEGMENT11, SEGMENT_ATTRIBUTE36, TEMPLATE_ID, SEGMENT_ATTRIBUTE7, SEGMENT_ATTRIBUTE10, ATTRIBUTE9, SEGMENT_ATTRIBUTE8, SEGMENT3, JGZZ_RECON_FLAG, START_DATE_ACTIVE, SEGMENT_ATTRIBUTE26, SEGMENT22, SEGMENT_ATTRIBUTE40, SEGMENT_ATTRIBUTE13, SEGMENT15, SEGMENT24, SUMMARY_FLAG, REFERENCE1, REFERENCE3, SEGMENT20, SEGMENT_ATTRIBUTE31, SEGMENT27, SEGMENT_ATTRIBUTE29, SEGMENT_ATTRIBUTE21, REFERENCE5, SEGMENT_ATTRIBUTE1, PRESERVE_FLAG, SEGMENT_ATTRIBUTE18, SEGMENT_ATTRIBUTE35, ENABLED_FLAG, SEGMENT_ATTRIBUTE19, END_DATE_ACTIVE, SEGMENT12, SEGMENT_ATTRIBUTE5, ATTRIBUTE2, SEGMENT21, SEGMENT_ATTRIBUTE28, SEGMENT_ATTRIBUTE41, SEGMENT7, SEGMENT14, ATTRIBUTE5, LAST_UPDATED_BY, SEGMENT_ATTRIBUTE34, SEGMENT_ATTRIBUTE33, SEGMENT30, SEGMENT_ATTRIBUTE15, SEGMENT_ATTRIBUTE24, COMPANY_COST_CENTER_ORG_ID, SEGMENT_ATTRIBUTE25, REFERENCE4, SEGMENT_ATTRIBUTE39, SEGMENT_ATTRIBUTE11, SEGMENT10, SEGMENT_ATTRIBUTE42, SEGMENT_ATTRIBUTE22, SEGMENT_ATTRIBUTE17, SEGMENT_ATTRIBUTE30, SEGMENT_ATTRIBUTE2, SEGMENT_ATTRIBUTE38, SEGMENT4, DESCRIPTION, SEGMENT1, ATTRIBUTE3, SEGMENT_ATTRIBUTE12, REVALUATION_ID, ATTRIBUTE10, CONTEXT, ATTRIBUTE6, SEGMENT13 
 FROM GL_CODE_COMBINATIONS
/

Octavio

[mimi_miao]

Thanks for the help!
I really appreciate it...
By the way can I ask, is it ok to create the <b>GL_CODE_COMBINATIONS_KFV</b> manually?
coz FDFVGN is not working properly, thou according to metalink compiling of accounts thru segment should be done by GL SUPER USER, and I did but still I encountered the error

here's the error:

Routine FDFGOC found no rows in the ALL_TAB_COLUMNS.

[pushpaveniu]

Hi
i didn't get your problem exactly.Will u pls write what error is coming while you are entering code combinations???
Let me know what are the steps u have performed for entering this code combinations??

Regards,
pushpa

[mimi_miao]

FDFVGN is a module that will create the GL_CODE_COMBINATIONS_KFV automatically and it calls FDFGOC procedure, I cant find the source code of this 2 module/procedure, thats why I cant figure out whats the cause of problem, as of now, I manually created my GL_CODE_COMBINATIONS_KFV.