报错:
OOAP0010: Please define Calendar Periods before opening them
处理过程:
open and close period 界面发现latest opened period 错误(之前定义accouting时错误,且错误期间已经开启)
打开open and close period 界面时,系统会执行SELECT
ROW_ID, APPLICATION_ID, SET_OF_BOOKS_ID, CLOSING_STATUS,SHOW_STATUS,PERIOD_NAME, PERIOD_NUM,
PERIOD_YEAR, START_DATE, END_DATE, LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,
PERIOD_TYPE,QUARTER_NUM,ADJUSTMENT_PERIOD_FLAG,CREATED_BY, LAST_UPDATE_LOGIN,
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, CONTEXT
FROM GL_PERIOD_STATUSES_V
WHERE application_id = 101 AND set_of_books_id = 6 ---当前sob
AND( start_date <= to_date('01-04-2012','DD-MM-YYYY') or closing_status = 'F' ) order by period_year desc, period_num desc
其中'01-04-2012' 即为latest opened 期间名称对应的开始日期,系统会在界面显示该日期前的期间及该日期后状态为Future - Entry的期间,并根据该日期决定下一开启期间,并将开启的期间在GL_SETS_OF_BOOKS中LATEST_OPENED_PERIOD_NAME记录。
之前定义期间错误并开启,并在GL_SETS_OF_BOOKS中LATEST_OPENED_PERIOD_NAME记录错误值,导致系统无法转换到正确的最近开启期间。
解决方案:
更新GL_SETS_OF_BOOKS 中 LATEST_OPENED_PERIOD_NAME 为正确值