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')

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-677393/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-677393/