How to enable the MOAC parameter “Operating Unit” for a Concurrent Program
EBS Concurrent Program MOAC
EBS Signon Password Policies
EBS Password Policy
Password Policies in Oracle E-Business Suite
EBS Password Policy
R12 Mapping Between Subledger Tables, SLA and GL Tables
ORACLE SLA
General Ledger to Fixed Assests Drilldown
General Ledger,FA
Drilldown from GL to Receiving Transactions Query
SLA GL RCV
如何永久关闭选项"Close Other Forms"
Oracle EBS里Tools>Close Other Forms如果被勾选上的话,那么用户在打开一个Form的时候,就会关闭其他的Form,保证只有一个Form存在。我们去掉了这个选项的勾选,再次登录,有的时候会发现这个选项不知道什么原因又被勾选上了。这里提供一个通过脚本永久修改这个选项的解决方法:SELECT preference_valu...
Query_Find Form开发入门
1. 打开Template.fmb,并另存为一个名字(QUERYFIND.fmb)2.从Window,Canvas,Data Block中删除BLOCKNAME,从Data Block中删除DETAILBLOCK3.创建一个Window(DEPT_WINDOW),subclass选择WINDOW4.Pre-Form trigger中,把DEPT_WINDOW设置为第一个显示的窗口Program Unit:AP...
bad bind variable 'parameter.G_query_find'
Form
使用DBMS_UTILITY.GET_TIME来捕获某段代码的执行时间
DBMS_UTILITY.GET_TIME
Oracle EBS中打印二维码
Oracle EBS暂时还只支持一维码,所以如需要二维码的打印和扫描,需要自行开发。PL/SQL还没有成熟的二维码生成类库,但Java已有很多二维码生成和解码的第三方类库(比如,QRCode,ZXing...),这里以比较简单的QRCode为例演示怎么输出和解码二维码。一个QRCode的简单例子:涉及到的主要类库:编码 lib:Qrc...
Speeding Up Queries with Semi-Joins and Anti-Joins
EBS
Oracle EBS诊断方面几种情况的解决方法
EBS
如何处理Jdeveloper 启动时出现的错误-Unable to create an instance
Jdeveloper Java Virtual Machine
Get error while update the PA_TRANSACTION_INTERFACE_ALL table
As some data error, i am going to update the Project Number filed on PA_TRANSACTION_INTERFACE_ALL Table. But once i applied the SQL, there will appear the error message:MSG-20003: ORA-20003: import1_prog:ORA-28115: policy with check option violationORA-06512: at ...
DBMS SCHEDULER
ORACLE JOB
Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4
Hi,It's been a long time since I wrote a blog post, I was busy working with Oracle EBS upgrades,content server setup, and Oracle SOA 11g upgrade projects. We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4.There are lot of difference.Below are the key ones, I will try to ext...
The concurrent manager has timed out waiting for the Output Post-processor
In this DocumentPurposeTroubleshooting StepsReferencesAPPLIES TO:BI Publisher (formerly XML Publisher) - Version 12.0 to 12.0 [Release 12.0]BI Publisher (formerly XML Publisher) - Version...
XML Publisher 并发程序由于"输出提交处理程序提交失败
XML Publisher
Tables involved with security rules in oracle apps R12 & R11i
Security Rules