自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(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 1502

转载 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 955

转载 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 2180

原创 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 818

转载 如何理解借贷的含义

一、借贷记账法讲解面临的难题  诗人歌德赞美借贷记账法是“人类聪明的绝妙创造”。但就是这个绝妙创造,迄今为止一直是困扰授课教师的难题。当代美国著名的会计学家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 3177 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 598

原创 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 575

原创 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 4105

原创 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 2641

原创 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 4100

原创 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 3934

转载 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 440

转载 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 771

原创 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 2849

转载 安装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 1067

转载 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 1207

原创 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 853 11

转载 用VC实现PC并行端口数字信息的输入/输出

目前,在实验室和工业应用的各种控制系统中,串口是常用的计算机与外部控制系统之间的数据传输通道。由于串行通信方便易行,所以应用广泛。但是使用串行通信,在实时性、速度、数据量等方面受到限制。而计算机的并行端口传输数据时是一次性传送8个位(一个字节)或更多,由于传输量较大,因此数据的传输速度要比串口快,在许多必须讲究传输速度的控制系统里,用PC并行端口与之连接就是一个很好的解决方案。  本文介绍PC并行端口在单片机等控制系统中作为数字I/O口的应用。在控制系统中,有许多的数字开关量、数字控制信号、数字信号等,都可

2011-05-03 22:13:00 987

转载 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

ATO操作步骤(VIS demo)

Oralce EBS R12 ATO操作步骤(VIS demo)

2012-07-02

ATO操作步骤

Oracle EBS R12 ATO操作步骤(多图)

2012-07-02

OM中文操作手册

Oracle EBS R12 Order Management中文操作手册

2012-07-02

R12中文HELP_V1.0.part1

Oralce EBS r12中文帮助文档

2012-07-02

ps/2鼠标键盘协议

ps/2鼠标键盘协议 ps/2鼠标键盘协议 ps/2鼠标键盘协议

2011-05-17

弹性域概念概览.doc

多数组织使用由具有意义的段(智能关键字是由一些段组成的代码,这些段中的一个或多个部分可能具有某种含义。智能关键字“代码”仅标识如帐户或部分作业之类的对象。由于智能关键字比唯一编号更利于用户记忆和使用,所以它们在应用产品中非常有用。例如,部件编号 PAD-YEL-11 × 14 比唯一的部……

2010-08-03

华为AR账龄模块培训资料.ppt

华为AR账龄模块培训资料 华为AR账龄模块培训资料

2010-08-03

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除