OAF错误
OAF错误
Webadi 问题集锦
1. webadi trace解决方案:How to enable tracing for WEBADI [ID 294739.1] 2. How to Avoid OM error: ORA-06508: PL/SQL解决方案: Could Not Find Program Unit Error. [ID 436947.1] 3.ADI Pro...
接口表GL_INTERFACE中的字段STATUS表示的含义
在从AP导入GL的过程中,导入到接口表GL_INTERFACE中的数据,在字段STATUS中出现了'EF05' 'P'等错误状态。其中的'P状态不是错误的状态,是由于同一个组标示的其他的数据出现了问题。出现的错误状态可能有:期间错误代...
The Internal Requisition
How To Create Internal Requisition From Sales Order [ID 1363518.1] FAQ: Purchasing Create Internal Requisition / Sales Order [ID 223858.1]Internal Sales Order Cycle In Order Management [ID 744...
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是字段...
资产拷贝折旧到税簿
Initial Mass Copy (FAIMCP) Produces Incorrect YTD as Reserve Depreciation In Tax Book [ID 784801.1] -- Initial Mass Copy (FAIMCP) Produces Incorrect YTD as Reserve Depreciation In Tax Boo...
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...
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 ...