- 博客(49)
- 资源 (9)
- 收藏
- 关注
原创 DQM Serial Sync Index Program (DQM Serial Sync Index Program)
The DQM Serial Sync Index Program is automatically submitted once a Party/Account is created or updated.When you update a supplier address, you will see an DQM Serial Sync Index Program is getting k
2014-07-18 08:54:28 1503
转载 How to Manage Oracle Application Workflow Background Process Concurrent Program
In this post I will talk about concurrent program (CP) "Workflow background process" , available in all the 11i and R12i releases.This is very critical and important program.Purpose of this pro
2014-05-28 21:54:34 956
转载 Introduction to OM
The Oracle Order Management Suite consists of:Oracle Order ManagementOracle Shipping ExecutionBasic PricingOrder Management implementation involves several phases, including setting up other i
2014-05-28 21:52:33 2182
原创 Cases for the incompatibility setup migration
cases for the incompatibility setup migration, 1. If the ldt does include incompatibility setup, the incompatibility may not work for the program unless rebound the concurrent manager.2. If the ld
2014-05-28 21:49:50 628
原创 What is the logic of base_amount + rounding_amt in Global Procurement's Intercompany AP Invoice
The function amount in AP header is round into 2 decimals (round(ap_invoices_all.invoice_amount*exchange_rate,2)), however line functional amount in AP lines are rounded every lines(round(ap_invoice_l
2014-04-03 09:49:05 1570
原创 Leading and Trailing zeroes truncated and Long Numbers display in scientific notation in excel
Microsoft Excel is too smart and it identifies whether the value in the cell is a Text or number and applies formatting accordingly. This sometimes becomes an issue for us when we are trying to gene
2014-04-03 09:39:29 819
转载 如何理解借贷的含义
一、借贷记账法讲解面临的难题 诗人歌德赞美借贷记账法是“人类聪明的绝妙创造”。但就是这个绝妙创造,迄今为止一直是困扰授课教师的难题。当代美国著名的会计学家A.C.利特尔顿教授甚至不无遗憾地感叹:借贷记账法给我们留下一个令人困惑的特征,某些账户的左方代表增方,而在其他账户,增加额却记入右方。这种安排太复杂了,以至于试图将它合理化成为徒劳无益的事。我们别无他法,只好接受它并记住它的增减法则。
2014-02-25 14:14:15 1031
原创 UNEXPECTED URL PARAMETERS HAVE BEEN DETECTED AND WILL BE IGNORED
When running test_fwktutorial.jsp , error message "UNEXPECTED URL PARAMETERS HAVE BEEN DETECTED AND WILL BE IGNORED" (文档 ID 978500.1)In this Document Symptoms Cause
2014-02-18 16:18:34 3178 1
转载 Check the active user in the Application
select fnd.user_name, icx.responsibility_application_id, icx.responsibility_id, frt.responsibility_name, icx.session_id, icx.first_connect, icx.last_con
2014-02-17 15:08:52 599
原创 How to bounce Web server
After finish OAF customization, we need to run two scripts:One Script which is responsible for bouncing Oracle HTTP Server (adapcctl.sh), while another responsible for bouncing OC4J container (adoac
2014-02-17 15:07:26 576
原创 The requested URL /OA_HTML/AppsLogin was not found on this serve
All the AP services are started successfully, but the login page can not open.Solution:This problem occurred because wsrp_service.wsdl was owned by root but the services were being sta
2014-02-16 22:42:58 4106
原创 How to get the Diagnostic data and debug file of Sales Order pick release
Refer to Note 133464.1--HTMOMSE Sales Order Diagnostic Script.1). Download the sql file containing the script.There are two versions of this script:HTMomse11i.sql for Release 11i.HTMomse12.sql
2013-12-27 16:41:54 1987
原创 SRN Receiving Failure
User reported that they fail to receive goods into inventory from a SRN order. Since the error message is "No cost of goods sold account is defined for the sales order", we check the Trans
2013-12-18 15:14:38 787
转载 Why is assigned responsibility not appearing in the navigator page during login?
Applies to:Oracle Application Object Library - Version: 11.5.10 to11.5.10.2Information in this document applies to any platform.GoalWhy is assigned responsibility not appearing in the
2013-09-28 11:16:30 599
原创 Debugging receipt transaction or the Sales Order issue transaction, Set the following profile option
RCV: Processing Mode to Immediate or Batch RCV: Debug Mode to Yes OM: Debug Level to 5 INV: Debug Trace to Yes INV: Debug level to 10 TP: INV Transaction processing mode to Background -Then go to Sys
2013-09-14 15:23:59 712
原创 R12 VIS 默认账号密码
APPL登录帐户/密码:sysadmin/sysadminmfg/welcomeoperations/welcomeservices/welcomemrc/welcomehrms/welocmeprojmfg/welcomeDB登录账户/密码:system/managerapplsys/appsap
2013-09-08 13:16:13 752
原创 Table: PO_LOCATION_ASSOCIATIONS_ALL
PO_LOCATION_ASSOCIATIONS associates a location defined within an organization with an Oracle Receivables customer. For each organization, you need one row for each association you want to make betwe
2013-08-20 17:09:54 2642
原创 Exceptions in Shipping Execution
1. The "Pick Selection List Generation" concurrent program complete with Error. Error message: Cause: solution: Specify the "Release Sequence Rule" & "Pick Slip Grouping Rule" in Pic
2013-07-25 11:36:16 3145
转载 Concurrent Processing - Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104 [ID 84
In this Document Symptoms Changes Cause Solution Information Center, Diagnostics, & Community References
2013-07-12 16:45:44 4102
原创 REP-1814: Report cannot be formatted. Object 'vertically' can never fit within
This one is hard to workaround particularly when you have complex report structure like several repeating parent child frames and anchoring objects.If you are lucky then simplest form of error mig
2013-07-12 16:43:36 3937
转载 Inter company transaction flow types.
There are two Inter company transaction flow types.Shipping and Procuring.A shipping flow is setup between two operating units of type shipping. You use the shipping flow when the shipping
2013-07-04 16:16:47 634
转载 Oracle FNDLOAD Scripts
1. Lookups -- ------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"
2013-06-10 10:04:48 544
原创 Differences between "in"/"out" and "nocopy"
By default, PL/SQL passes OUT and IN OUT subprogram parameters by value. Before running the subprogram, PL/SQL copies each OUT and IN OUT parameter to a temporary variable, which holds the value of
2013-04-02 10:10:17 441
转载 Oracle Pipelined Table Functions
Table FunctionsTable functions are used to return PL/SQL collections that mimic tables. They can be queried like a regular table by using the TABLE function in the FROM clause. Regular table functio
2013-04-02 09:53:25 640
转载 R12 sla tables
If you are looking for R12 sla tables information details as follow.1) All accounting performed before transfer to the GL. Accounting datagenerated and stored in "Accounting Events" tables prior t
2013-03-07 16:03:35 1033
转载 ORACLE EBS中查看某个Request的Output File
由于某些权限的限制,有时候哪怕System Administrator职责也只能看到某个Request信息,但是不能查看它的Output File(在“Requests Summary”窗口中“View Output”键显示灰色)。Select fnd_webfile.get_url(4,20378779,'APPLSYSPUB/PUB','FCWW',10) from dual第一个参数
2013-03-05 22:52:20 676
转载 APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package
in Order Management (Responsibility Order Management Super User, Vision Operations (USA) :Navigation : Shipping >> Transaction) trainees faced errorAPP-WSH-231210 An unexpected Error Occurred for Li
2013-01-23 10:41:33 1259
原创 R12 FORM compilation error with ORA-12154: TNS:could not resolve the connect identifier specified
$ cd $AU_TOP/forms/US$ frmcmp_batch.sh module=$AU_TOP/forms/US/$1.fmb userid=APPS/APPS output_file=$PER_TOP/forms/US/$1.fmx module_type=form batch=NO compile_all=specialForms 10.1 (Form Compiler)
2012-11-23 15:12:25 772
原创 How to get the query statement of LOV in Oracle Form
1. Make sure value of Profile "FND: Diagnostics" is Yes. if not, modify it. 2. Open your form and navigate to "HELP -> About Oracle Applications", get the Session SID of your current form.
2012-10-26 15:08:38 587
转载 INV - 多組織架構
多組織 (Multi-Org)Multi-org通常用在單一執行環境中,以設定方式啟用多個獨立企業單位。一個企業集團在單一執行環境中可利用Multi-org建構不同會計帳本 (Set of Book),不同公司法人 (Legal Entity) ,不同營運中心 (Operating Unit) 。有Multi-org,產品可由一個OU/LE接單,而由另外的OU/LE出貨,且
2012-08-07 16:37:37 623
转载 关于平衡段
会计科目中的自然段,平衡段记得看到过这样一句话其实最简单,最基本的会计科目结构就是公司代码+会计科目代码自然帐户段--我们一般可以理解为会计科目段,而平衡段呢,我们也叫公司段会计科目分类分为资产类,负债类,共同类,所有者权益类,成本类,损益类,共156个一级科目在ORACLE系统中,中国的会计科目一般分为五个段其中需要做弹性域限定词的为三个,分为:平衡段、自然帐户段、成
2012-07-06 16:23:32 2850
转载 安装Oracle Linux错误ide:failed opcode was 0xef
好不容易从https://edelivery.oracle.com下载了Oracle Linux 4.4安装时却出ide:failed opcode was 0xef错误,重试几次结果都是一样,无奈之下只好求助百度,问题得以解决-------------------------------------以下是网上搜索转载的文章 http://tomszrp.itpub.net/post/11
2012-06-07 19:14:38 1068
转载 Oracle行列转换
行列转换包括以下六种情况:*列转行*行转列*多列转换成字符串*多行转换成字符串*字符串转换成多列*字符串转换成多行下面分别进行举例介绍。首先声明一点,有些例子需要如下10g及以后才有的知识:a。掌握model子句,b。正则表达式c。加强的层次查询讨论的适用范围只包括8i,9i,10g及以后版本。begin:1、列转行CREAT
2012-03-04 22:26:45 289
转载 INV:物料现有量,可保留量,可处理提取方法
在INV模块,用户查看物料数量最多的三个栏位是现用量,可保留量,可处理量。下面的procedure是汉得技术顾问在公司上线时候提供的。CREATE OR REPLACE PROCEDURE get_inv_quantity(p_organization_id IN NUMB
2011-07-12 00:04:23 963
原创 ERP系统里的BOM展开函数
ERP系统里的BOM展开函数:l_grp_id NUMBER ;l_session_id NUMBER ;l_org_id NUMBER ;l_levels_to_explode
2011-06-27 23:56:00 1208
原创 bom 展开
SELECT distinct bb.BOM层次, bb.装配件, bb.装配件说明, bb.组件序号, bb.组件, bb.组件说明, bb.组件用量, bb.单位, bb.利用率, bb.冲减库房, bb.冲减货位, bb.属性, bb.B
2011-06-27 23:48:00 798
转载 用 VC++ 6.0 实现 JNI
<br />JNI是JDK的一部分,用于为Java提供一个本地代码的接口。通过使用JNI编写的程序能够确保你的代码能够完全的移植到所有的平台。JNI使得运行在JVM虚拟机上的Java代码能够操作使用其它语言编写的应用程序和库,比如C/C++以及汇编语言等。此外JNI提供的某些API还允许你把JVM嵌入到本地应用程序中。下图表达了JNI所扮演的角色。<br /><br /><br /><br /><br />本文将通过一个实例来阐述使用VC++6.0来实现JNI的完整过程。使用JNI来整合本地代码和Java代
2011-05-03 23:41:00 854 11
转载 用VC实现PC并行端口数字信息的输入/输出
目前,在实验室和工业应用的各种控制系统中,串口是常用的计算机与外部控制系统之间的数据传输通道。由于串行通信方便易行,所以应用广泛。但是使用串行通信,在实时性、速度、数据量等方面受到限制。而计算机的并行端口传输数据时是一次性传送8个位(一个字节)或更多,由于传输量较大,因此数据的传输速度要比串口快,在许多必须讲究传输速度的控制系统里,用PC并行端口与之连接就是一个很好的解决方案。 本文介绍PC并行端口在单片机等控制系统中作为数字I/O口的应用。在控制系统中,有许多的数字开关量、数字控制信号、数字信号等,都可
2011-05-03 22:13:00 988
转载 C++ API常用函数简单例子大全四
<br />第三十个CreateToolhelp32Snapshot给当前进程拍一个照<br />HANDLE hProcessSnap=::CreateToolhelp32Snapshot(TH32CS_SNAPPROCESS,0);<br />//记住这种格式就行了,返回的句柄,存储有进程信息,可以用Process32Firs函数找出来。<br />第三十一个Process32First根据CreateToolhelp32Snapshot函数返回的句柄获取进程信息<br />结合Process32Nex
2011-05-03 22:01:00 744
转载 C++ API常用函数简单例子大全五
<br />第四十一个CreateCompatibleDC创建一个兼容的内存设备上下文(DC)<br />简单的来说,就是复制一个模一样的DC。就把窗口看成一幅幅图画,窗口有大有小,里面的内容也不一样(颜色值),每个像素点的颜色值可能不一样,所以就用设备上下文来描述每个窗口的信息,对于DC具体是怎样描述设备上下文的,我们暂时还不需要知道,只要了解这个概念就行了。这个窗口信息,获得一个窗口设备上下文,就用GetDC函数就行了,如HDC hDC=GetDC(hWnd);而CreateCompatibleDC的作
2011-05-03 22:01:00 711
弹性域概念概览.doc
2010-08-03
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人