-
编辑 删除
《让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...
-
编辑 删除
Oracle EBS R12 客户表结构
Oracle EBS R12 客户表结构 分类： EBS2012-05-27 09:29397人阅读评论(0)收藏举报R12 客户表结构客户表/联系人/PARTY关联 HZ_PARTIES客户账户表 HZ_CUST_ACCOUNTS例子： SE...
-
编辑 删除
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对同...
-
编辑 删除
Credit Check Testing Examples
http://www.itpub.net/thread-1129147-1-1.html
-
编辑 删除
Oracle EBS默认的账户
DB的默认账户及密码system/managersys/manager(或者change_on_install)apps/appsinv/invwms/wmswip/wippo/po......Vision Demo库默认的用户名及密码sysadmin/sysadminmfg/welcomeoperations/welcomeservic...
-
编辑 删除
采购部管理方案
第1章 采购管理本章重点讲述了工厂采购的具体实施步骤和方法，包括准备采购订单计划，整理物料清单和文件、发出采购订单、签定协议发及对合同进行跟踪等内容，还讲述了怎样对供应商进行评估和管理，并给...
-
编辑 删除
PO AP FA 采购到固定资产的疑问
PO AP FA 采购到固定资产的的操作方式.按照指导.我去做,怎么都做不对 非常着急情况是:我按照上面大侠们说的去做了.但是收料单匹配后,抛到AP的invoice.总是无法自动勾上 track as asset .手动也没办法勾上.非常奇怪....
-
编辑 删除
Oracle EBS 寄销/VMI(1)-->基础设置；寄销/VMI(2)-->采购篇
名词解释: BPA:一揽子采购协议 BPR:一揽子发放 SR:来源补充规则 ASL:合格供应商列表 VMI: 供应商管理库存 寄售(Consignment)是把货...
-
编辑 删除
Oracle采购 接收入库 接口开发
接收入库是项目中会经常碰到的开发，这类开发一般来说比较简单，但是接收入库在Oracle中其实涉及到很多模块，其中层次较多，也可以做得比较复杂。本文将尽可能深入细致地讨论接收入库的流程，种类，数据来源，数据...
-
编辑 删除
Oracle ERP 库存管理（业务流程 核心流程）
库存核心业务库存管理的核心是对货物本身的管理，是对货物的数量与相关属性的管理，目的是为销售与采购服务，确保合理的库存保有量，处理库存分类帐目与进出流水帐，以单据的形式基本涵盖仓库的各种进出库业务。 ...
-
编辑 删除
PO, AP, GL Open/Closed Period Action
说明,该文档不包含OM,WIP,AR,COST相关开关期间操作.关帐次序:完成PO操作->完成INV操作->完成AP操作->关闭AP期间->关闭PO期间->关闭INV期间->检查GL期间->关闭GL期间-----------------------------------------------...
