主题: Cannot Add New Periods to Existing Calendar Definition

纵横四海

主题:  Cannot Add New Periods to Existing Calendar Definition
  文档 ID:  注释:216727.1 类型:  TROUBLESHOOTING
  上次修订日期:  15-MAR-2004 状态:  PUBLISHED

fact: Oracle General Ledger 11.0.3
fact: GLXSTCAL - Calendar
symptom: Cannot add new periods to existing calendar definition
symptom: Query of an existing calendar generates errors
symptom: FRM-40505 unable to perform query
symptom: ORA-00904 invalid column name
change: NOTE: The following are the steps to replicate the issue:
1. Logon as GL Super User
2. Navigate: Setup->Financials->Calendar->Accounting.
3. Perform a query, find all.
cause: GL_PERIODS_V is not properly created

fix:
Perform the following steps to identify and fix the issue:
1. Perform a form trace which will show the name of the query being executed at
the time of the error.
   
2. Review the trace file which will display all the columns being referenced by
the view.
3. Run "desc gl_periods_v" from SQL*Plus to view the columns
currently existing.

4. If GL_PERIODS_V does not contain all the columns, recreate the view as
follows from the APPS schema:
(i) First drop the current view.
(ii) Execute the following to re-create the view:
CREATE VIEW GL_PERIODS_V
  AS  SELECT  PER.ROWID ROW_ID ,
    PER.PERIOD_NAME PERIOD_NAME ,
    PER.PERIOD_SET_NAME PERIOD_SET_NAME ,
    PER.START_DATE START_DATE ,
    PER.END_DATE END_DATE ,
    PER.PERIOD_TYPE PERIOD_TYPE ,
    PT.USER_PERIOD_TYPE USER_PERIOD_TYPE ,
    PER.PERIOD_YEAR PERIOD_YEAR ,
    PER.PERIOD_NUM PERIOD_NUM ,
    PER.QUARTER_NUM QUARTER_NUM ,
    PER.ENTERED_PERIOD_NAME ENTERED_PERIOD_NAME ,
    PER.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG ,  
    PT.NUMBER_PER_FISCAL_YEAR NUMBER_PER_FISCAL_YEAR ,
    PER.DESCRIPTION DESCRIPTION ,
    PER.CREATION_DATE CREATION_DATE ,
    PER.CREATED_BY CREATED_BY ,
    PER.LAST_UPDATE_DATE LAST_UPDATE_DATE ,
    PER.LAST_UPDATED_BY LAST_UPDATED_BY ,
    PER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,
    PER.CONTEXT CONTEXT ,
    PER.ATTRIBUTE1 ATTRIBUTE1 ,
    PER.ATTRIBUTE2 ATTRIBUTE2 ,
PER.ATTRIBUTE3 ATTRIBUTE3 ,
    PER.ATTRIBUTE4 ATTRIBUTE4 ,
    PER.ATTRIBUTE5 ATTRIBUTE5 ,
    PER.ATTRIBUTE6 ATTRIBUTE6 ,
    PER.ATTRIBUTE7 ATTRIBUTE7 ,
    PER.ATTRIBUTE8 ATTRIBUTE8
  FROM  GL_PERIODS PER,   GL_PERIOD_TYPES PT
WHERE   PER.PERIOD_TYPE = PT.PERIOD_TYPE;