如何查找OAF页面所对应的表？

最新推荐文章于 2021-04-04 22:22:53 发布

田攀

最新推荐文章于 2021-04-04 22:22:53 发布

阅读量3.5k

点赞数

本文链接：https://blog.csdn.net/pan_tian/article/details/38511743

版权

Oracle EBS Debug 专栏收录该内容

40 篇文章 3 订阅

订阅专栏

在Oracle EBS Form界面，你可以通过Diagnostics或Record History来找到（或猜到）界面所对应的表，那在OAF Web页面我们如何知道此页面在后台对应的表呢？

方法：

A1: Please follow the following steps to get the Supplier related table information:

> Navigate to the Supplier Page
> Click on the About this page link
> Click Expand All
> You will be seeing SuppSrchVO, SupplierVO and SitesVO
> If you click on that view it will show you the query used.

A2: To get the About this Page Link:

Please ensure the below Profile option is set to Yes at site level:

FND: Diagnostics
System Administrator > Profile > System

The FND: Diagnostics profile option controls whether the Diagnostics button is rendered.
It also controls the display of the About this Page link.

Add the below responsibilities to the user:

System Administrator > Security > User > Define

1. FND Html Forms
2. Functional Administrator
3. Functional Developer
4. Once done bounce the apache
5. Retest the issue
6. Migrate the solution to other environments as appropriate.