1.drop MATERIALIZED view GL_ACCESS_SET_LEDGERS; 2:执行文件glvaslmv.sql重新生成物化视图 3.SELECT * FROM all_objects WHERE object_name = 'GL_ACCESS_SET_LEDGERS'; 4:新建凭证或管理GL期间FORM处,查看编译情况
1.drop MATERIALIZED view GL_ACCESS_SET_LEDGERS; 2:执行文件glvaslmv.sql重新生成物化视图 3.SELECT * FROM all_objects WHERE object_name = 'GL_ACCESS_SET_LEDGERS'; 4:新建凭证或管理GL期间FORM处,查看编译情况
GL_ACCESS_SET_LEDGERS_PK ACCESS_SET_ID, LEDGER_ID Columns NameDatatypeLengthPrecisionNot-nullComments ACCESS_SET_ID NUMBER 18 Yes Data access set unique identifier. LEDGER_ID NUMBER 18 Yes Ledger or ledger set ID assigned to the data access set. ACCESS_PRIVILEGE_CODE VARCHAR2 1 Yes Access ...
This table contains the access privilege information for each data access set. Each row includes the data access set, ledger or ledger set, and the corresponding access privilege information.