Oracle AOL API(Lookup,Profile,Value set value) , testing in R11 11.5.10
FND_PROFILE.SAVE(, , , &nbs...
弹性域报表实例(二)
报表 3:表格式报表[@more@]This is a sample report that selects Accounting Flexfield information for a single structure for a single company. This report uses a more complex WHERE clause with an ORDER BY clause. It also contains extra columns for the report header information.Sample OutputThis report contains a list of Accounting Flexfield combinations and a description for each based on their segment values. It has a more complex header that includes the set of books, date, currency, period, and
弹性域报表实例(一)
本节示范如何将弹性域数据纳入报表,以及如何使用 Oracle Application Object Library (AOL) 用户出口来建立不同类型的弹性域报表。以下样本报表示范了五种构造报表的方法。[@more@]本节示范如何将弹性域数据纳入报表,以及如何使用 Oracle Application Object Library (AOL) 用户出口来建立不同类型的弹性域报表。以下样本报表示范了五种构造报表的方法。报表 1:简单表格式报表报表 2:具有多弹性域结构的简单表格式报表报表 3:表格式报表报表 4:主 - 明细报表报表 5:多结构的主 - 明细报表前两个实例显示了建立具有弹性域支持的报表
Which responsibility ran the sales order Workflow ?
OEOL Workflow , 客制化一个function node ,在function node 里面 call apply hold API, 问题来了apply hold API 会check对于hold name 的职责权限, 那些职责有权限做apply hold和release hold, 很想知道workflow取的环境的值是什么,取的是那个职责。 fnd_global.apps_initialize我们知道Workflow是后台运行的,通过...
How to find the common problems from the trace file
1. didn't use the bind variableA number of very similar statements that execute only once (Executions = 1)2. Ratio between logical IOs and processed rows is big (greater than 1000)Normally this is evidence of an inferior execution plan and could also indicate a big number of throwaways due to po...
第一篇
从业五年,一直在用网络找资料,所以在这个2015年圣诞节的时候开个BLOG, 希望可以记录工作的点滴的同时也可以方便有共同问题的人查阅。