Oracle EBS 开发小贴士

1.      组织屏蔽视图

  and   NVL(qsi.ORG_ID
          ,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
                                       ,1
                                       ,1)
                               ,' '
                               ,NULL
                               ,SUBSTRB(USERENV('CLIENT_INFO')
                                       ,1
                                       ,10)))
              ,-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
                                                   ,1
                                                   ,1)
                                           ,' '
                                           ,NULL
                                           ,SUBSTRB(USERENV('CLIENT_INFO')
                                                   ,1
                                                   ,10)))
                          ,-99)

 

 

2.      值集之间的关联

  关联子集定义的语法为where field_name = :$FLEX$.value_set_name；value_set_name的大小写要与定义的完全一致。

      :$flex$.value_set_name.id : 以id为比较字段

      :$flex$.value_set_name.value : 以value为比较字段

      :$flex$.value_set_name.meaing : 以meaning为比较字段

 

3.   初始化报表的应用用户

   Oracle默认没有进行Application用户初始化，所以没有环境变量，需要建一个用户参数 

P_CONC_REQUEST_ID/Number/20，在Before Report触发器里加SRW.USER_EXIT('FND 

SRWINIT');，在After Report触发器里加SRW.USER_EXIT('FND SRWEXIT')

 

4.   FORM中调用请求

v_Request_Id := Fnd_Request.Submit_Request('应用简称',

                                              '请求名称',

                                              '',

                                              '',

                                              FALSE,

                                              Chr(0));

5.   设定PL/SQL的默认组织号

  DBMS_APPLICATION_INFO.set_client_info('XXX');

6.   在FORM中调用功能

  FND_FUNCTION.EXECUTE( '功能简称', 'Y', 'N')