-
编辑 删除
OAF错误
OAF错误
-
编辑 删除
ebs 报表导出 excle 有问号
Applies to:Oracle Marketing - Version: 11.5.10.2 to 11.5.10.3 - Release: Unknown Release to Information in this document applies to any platform.Checked for relevance 12-Sep-2011 and updatedSympt...
-
编辑 删除
ORACLE EBS 系统常用标准报表
ORACLE EBS 系统常用标准报表 总账系统 系统报表名 中文译名 用途描述 Journals-Voucher 日记账传票&n...
-
编辑 删除
Oracle EBS R12多组织访问架构
关于R12的新特性Multi-Org Access Control(MOAC).Oracle宣传的好处主要有:1.enable users to access to secured data in one or more Operating Units from a single responsibility2.End-Users can access/transact...
-
编辑 删除
在XML Publisher输出到excel后如果数字变成科学计数了
在XML Publisher输出到excel后如果数字变成科学计数了，可以在template里头添加 =T("域") <?format-number:JRNL_LINE_ENT_DR;'999G990D99'?>在template上设置字段输出的格式JRNL_LINE_ENT_DR是字段...
-
编辑 删除
12.1.3 诊断功能无法输入密码
How To Enforce Password Protection On Accessing Menu Help > Diagnostic > Examine? [ID 1487534.1] Applies to:Oracle Application Object Library - Version 12.1.3 and laterInformation in this docu...
-
编辑 删除
EBS-api
http://blog.csdn.net/pan_tian/article/details/7754598API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)API for Cancelling the Purchase Order (PO) Docume...
-
编辑 删除
Description and Usage of Fields in RA_INTERFACE_LINES Table
Description and Usage of Fields in RA_INTERFACE_LINES Table [ID 1195997.1]To BottomModified:Aug 31, 2012Type:REFERENCEStatus:PUBLISHEDPriority:3Comments (0)Applies to: ...
-
编辑 删除
《让Oracle跑得更快1》第二章 锁和阻塞
1.分别模拟insert，update和delete造成阻塞的示例，并对v$lock中的相应的信息进行说明，给 出SQL演示。 建立t1表，进行作业。 a.模拟insert阻塞 当有唯一索引时，会发生insert阻塞。 为t1表建...
-
编辑 删除
ebs assets common apis
Oracle Assets Common APIs (Oracle Assets Documentation Supplement)<!--Oracle Assets Common APIsThis document is relevant for 11i only. There are small code changes in API code for R12. ...
-
编辑 删除
Get ORA-00933 in People Management Template Form [ID 1085991.1]
=== ODM Solution /Action Plan ===To implement the solution, please execute the following steps:1. Go into the responsibility: System Administrator2. Navigate to Application -> Validation -> Se...
-
编辑 删除
WEB ADI 注册功能的SQL 语句
1.删除集成器：bne_integrator_utils.delete_integrator 2.注册功能DECLARE x_APPL_ID FND_APPLICATION.APPLICATION_ID%TYPE; x_FORM_ID FND_FORM.FORM_ID%TYPE; x_ROWID VARCHAR2(100); x_FUNC_I...
-
编辑 删除
On reading trace files with PL/SQL
Reading a trace file is usually a three step process. First, the trace file is created with an SQL statement such as alter session set sql_trace=true. Then, the name of the trace fil...
-
编辑 删除
printf in PL/SQL
There are a few things in PL/SQL that I am really missing. One of these things is printf. I am not aware of any built-in functionality that remotely resembles the elegance of printf. Ok, l...
-
编辑 删除
On finding changed values in a table with flashback
The as of clause in a select statement allows to see the data as of a past SCN or past point in time. So, it's possible, for example, to compare the current data in a table with a previous ...
-
编辑 删除
On creating bitmaps with pure PL/SQL only
Out of idle curiosity, I wanted to know if it is possible to create bitmaps (BMPs) with pure PL/SQL alone. And it is! The following package is the result of this endeavor. The pr...
-
编辑 删除
Debugging PL/SQL with DBMS_DEBUG
It is possible to debug PL/SQL Code in Oracle with DBMS_DEBUG. This article tries to show how to do that. Firstly, a PL/SQL Package (called ADP_DEBUG) is created that acts as a wrapper a...
-
编辑 删除
Synchronizing sessions in Oracle with DBMS_LOCK
Let's say, we want two sessions to do a task concurrently, that is, both tasks should start at the same time. This is ideally solved with dbms_lock. The following table will be ...
-
编辑 删除
oracle自制事物
各位大侠，以下有几个关于存储过程事物的问题请教下...，本人对oracle事物机制真正学习中，希望高手指点并详细说明下，非常感谢..例：oracle PACKAGE 里调用3个存储过程，分别为A,B,C; A里面调用B；A和B对同...
-
编辑 删除
Oracle EBS默认的账户
DB的默认账户及密码system/managersys/manager(或者change_on_install)apps/appsinv/invwms/wmswip/wippo/po......Vision Demo库默认的用户名及密码sysadmin/sysadminmfg/welcomeoperations/welcomeservic...
