资源描述：
《oracle ebs 报表开发步骤》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、PLSQL报表开发步骤1．PLSQL创建package1.1在PL/SQLDeveloper中创建一个package。Ø此时会生成一个包头和包体。Ø包头部分定义一个过程：Ø包体部分定义具体的格式控制及输出数据。Ø在print函数中进行输出（输出到控制台和报表）。Øcursor的定义放在包体的最前面。Ømain函数为该函数的入口地址。入口函数的特点为：前两个的定义必须为errbufoutvarchar2,retcodeoutnumber,否则报错。使用errbuf返回任何错误消息和retcode返回完成状态。参数retcode返回0表示成功、警告，成功为1和2的错误。在
2、并行程序运行后，并发管理器会将errbuf和retcode的内容写入与您的并发请求相关联的日志文件。NorthGateStationandallthelongdistanceIntercity,TRANS-provincelines;NorthGateStationcurrentlyrunstheoriginalcounties,ruralroutes;Simon,stationmain,Yibincity,acrossthecity,acrosstheprovinceandtotheWestofrangeline.Yibincityhighwaymainstatio
3、ndistributiontable3.1-6stationnamegradeaccountedfortoarea(m2)GaoØ屏蔽不在包体外调用的函数声明。Ø创建的package可不必上传到应用。在数据库中编译后即可。参考文件：plsql形式报表开发及html输出格式.pdf参考代码：Rz_Gl_Period_Charge_Pkg最后.pck（在PLSQL中打开）1．定义并发可执行Ø在EBS中注册挂载：登录oracleEBSR12系统。选择应用开发员--》并发--》可执行。Ø填入如下信息。2．定义并发程序l应用开发员--》并发--》程序 NorthGateStat
4、ionandallthelongdistanceIntercity,TRANS-provincelines;NorthGateStationcurrentlyrunstheoriginalcounties,ruralroutes;Simon,stationmain,Yibincity,acrossthecity,acrosstheprovinceandtotheWestofrangeline.Yibincityhighwaymainstationdistributiontable3.1-6stationnamegradeaccountedfortoarea(m2)Ga
5、o参数设置： NorthGateStationandallthelongdistanceIntercity,TRANS-provincelines;NorthGateStationcurrentlyrunstheoriginalcounties,ruralroutes;Simon,stationmain,Yibincity,acrossthecity,acrosstheprovinceandtotheWestofrangeline.Yibincityhighwaymainstationdistributiontable3.1-6stationnamegradeacco
6、untedfortoarea(m2)GaoNorthGateStationandallthelongdistanceIntercity,TRANS-provincelines;NorthGateStationcurrentlyrunstheoriginalcounties,ruralroutes;Simon,stationmain,Yibincity,acrossthecity,acrosstheprovinceandtotheWestofrangeline.Yibincityhighwaymainstationdistributiontable3.1-6statio
7、nnamegradeaccountedfortoarea(m2)GaoNorthGateStationandallthelongdistanceIntercity,TRANS-provincelines;NorthGateStationcurrentlyrunstheoriginalcounties,ruralroutes;Simon,stationmain,Yibincity,acrossthecity,acrosstheprovinceandtotheWestofrangeline.Yibincityhighwaymainstationdistr
