Somtimes, we will need to debug some SQLs and try to run them within environment parameters.
It will be complex to debug in PL/SQL by setting fnd_client_infor or else.
Following is the way to run debug SQL quickly within the right environgment you want:
(1) Login any application or form to the situation you want to chek SQL data (e.g. Enter 'Inventory' resp, change organization to M1 and open Receiving Transaction form and go on with following steps)
(2) Click menu 'Help' - 'Diagnostics' - 'Examine'
(3) Imput apps password and OK
(4) Enter the following information in 'Examine Field and Variable Values' window:
-- Block = *SELECT*
-- Field = Input you SQL here and TAB , you will get the SQL result
Kep points: this function has lots of limitation and please find the tips below
(A)For only 1 field of just 1 row: Suggest you to try the following 'Field' to get the sense of it:
--Right Test case1:sysdate
--Right Test case2:(Select count(*) from po_headers_all)
--Right Test case3:(Select segment1 from po_headers_all where segment1 like 'TAG%' and rownum=1)
--Wrong test case 4: (Select segment1,creation_date from po_headers_all)
--Wrong test case 5: (Select segment1,creation_date from po_headers_all and rownum=1)
--Right test case 6: (Select segment1 from po_headers_all and rownum=1)
Solution: If you want to select multi rows or columns, you should change condition and select to run more times.
(B)SQL length is limited to 80
--Right Test case3:(Select segment1 from po_headers_all where segment1 like 'TAG%' and rownum=1) --Length is 79 < 80 and OK
--Wrong Test case3:(Select NVL(segment1,'88') from po_headers_all where segment1 like 'TAG%' and rownum=1) --Length overflow
Solution: If we need to run a big SQL which is more than 80 (e.g. 1000 chars), we can create a view in PL/SQL(e.g. CPO_TAG_TEST1_V) and use the view for a single query (e.g. Select segment1 from CPO_TAG_TEST1_V where rownum=1)
Hope it will be helpful in your work, especially in View debug and test data inquiry.
分享到:
相关推荐
此资料适合EBS sql初学者开发,前期的关于SQL基本上都有
How To Run Rapid Clone (adcfgclone.pl) Non-Interactively (Doc ID 375650.1)
EBS11-HOW TO INSTALL UNZIP5.52
EBS11-HOW TO INSTALL ZIP3
ORACLE EBS查看库存现有量SQL
ORACLE EBS 物料和类别对应SQL
记录了常用的sql,有说明,常用表及查询,新手入门下载
个性化EBS标准OAF页面:替换VO添加客户化属性(VO基于EO的版本)、替换VO添加客户化属性(VO基于SQL的版本)。
EBS固定资产FA开发常用表结构及描述,EBS固定资产FA模块学习总结,EBS固定资产方面的查询SQL
数据库优化包括:实例的性能优化和SQL语句的性能优化,实例优化和sql优化均可以通过AWR报告来分析并作出优化方案。 这篇文档描述了如何调查EBS系统性能下降原因、如何使用和理解AWR报告、分别阐述了数据库层/应用层/...
日常工作和日常运维总结沉淀下来的SQL,希望能够给正在学习的同学提供快速了解的机会
这个是整理的 ebs表结构,非常的全面 ,直接有查询语句,类似于select * from ra_customers 客户。用起来比较方便
Oracle EBS 操作手册
EBS R12 with Database 11gR2 官方文档
Order to Cash Lifecycle 1 Entering a Sales Order with Standard Items 1 Entering a Sales Order with ATO Item 5 Entering a Sales Order with PTO Kit 22 Entering a Sales Order with Service Items 27 ...
Integrating_EBS_with_Oracle_Internet_Directory_and_Oracle_Single_Sign-On Oracle EBS 单点登录 方案
Oracle EBS Student guide -inventory module, teach you how to use it step by step.
本文是面试华为oracle ebs的一些知识点,希望对你有所帮助
EBS工作流邮件配置流程,对于EBS很有好处
Deploy Customize Jar file in Oracle EBS R12.pdf