ORACLE ERP
文章平均质量分 70
feixiangVB
Oracle EBS 进行时......
展开
-
Budget and Encumbrance
Budgetary control refers to the process of recording budget data and tracking encumbrance and actual data against a budget. “Funds checking” is the feature of budgetary control that helps prevent原创 2008-12-18 09:35:00 · 988 阅读 · 0 评论 -
Oracle Accounts Receivables (AR) - key Tables
AR_RECEIVABLES_TRX_ALLThis table links accounting information with your ReceivablesActivities. Possible types of activities include Adjustment,Miscellaneous Cash, and Finance Charges. If your type is转载 2009-04-28 09:02:00 · 2151 阅读 · 0 评论 -
UNPOSTED ITEMS REPORT SHOWS UNPOSTED QUICK CASH
Problem Description: =================== You have rows on the Unposted Items Report. The legend says that This receipt is part of an unposted quick cash batch. There are no quickcash batches tha转载 2009-04-29 13:27:00 · 1928 阅读 · 0 评论 -
Diagnostic Scripts: Close Period Notes - Diagnostic SQL Scripts
Checked for relevance on 06-Dec-2007DISCLAIMER: This script is provided for educational purposes only. It is not supported by Oracle World Wide Technical Support. The script has been转载 2009-05-05 08:41:00 · 1508 阅读 · 0 评论 -
APP-SQLAP-10637: The system cannot create this payment
Scenario:Due to typo error made last April 3, 2009, instead of paying 876.48, we paid only 376.48 in actual to tally payment in bank recon. We did partial payment in oracle and it was successf原创 2009-07-17 16:36:00 · 2370 阅读 · 0 评论 -
查询EBS接口表
select *from dba_objects dbwhere db.object_type = TABLEand db.object_name like %INTERFACE%转载 2009-05-08 13:23:00 · 882 阅读 · 0 评论 -
Two-way, Three-way and Four-way matching
Two-way, Three-way and Four-way matching Two-way approval verifies that purchase order and invoice information match within your tolerances as follows: • Quantity billed on the purchase ord转载 2009-07-22 16:38:00 · 1342 阅读 · 0 评论 -
已知接受号,如何查这笔接受传到GL的分录?
已知接受号,如何查这笔接受传到GL的分录?1)可否在用户界面查找?2)能否在后台通过关联GL_SL_LINK_ID来查找?RCV_RECEIVING_SUB_LEDGER中的gl_sl_link_id GL_JE_LINES中的gl_sl_link_id把上面两表进行关联查询其实RCV_RECEIVING_SUB_LEDGER表就是接收生成的会计分录信息,在生成这个的同时,也会传一份到原创 2009-05-08 08:51:00 · 1896 阅读 · 0 评论 -
Oracle EBS 统计我们客制的报表
SELECT t.user_concurrent_program_name, b.concurrent_program_nameFROM fnd_concurrent_programs_tl t, fnd_concurrent_programs bWHERE b.application_id = t.application_idAND b.concurrent_program_id =原创 2009-05-08 11:36:00 · 871 阅读 · 0 评论 -
销售到出仓所经历的表
销售到出仓所经历的表销售订单要经历登记、发放、挑库、交货四个主要环节,有些表在各个环节都有不同的特性,作者罗列了几个主要的常用的表,其它好象还有些货物路线、停靠之类的信息表则没有涉及下面是销售订单的四个主要环节和每个环节用到的常用表:一、登记1、oe_order_headers_all--订单头信息表2、oe_order_lines_all--header_id=oe_order_headers转载 2009-05-08 11:57:00 · 1651 阅读 · 0 评论 -
Quantity Invoiced Defaults To Many Decimals In The Match To Receipts Window
Applies to: Oracle Payables - Version: 11.5.9This problem can occur on any platform.FORM:APXRMTCH.FMB - Match to Receipts SymptomsWhen an invoice is matched to a Receipt and the Purchase Order u转载 2009-05-14 14:38:00 · 1554 阅读 · 0 评论 -
AP Encountered Error while creating accounting for AP Invoice
Doc ID: AG0516Subject: PQ AP Encountered Error while creating accounting for AP InvoiceType: ProblemCreation Date: 26-Jul-07Last Revision Date: 22-Oct-07Status: DoneOwner: Divine/Lucy原创 2009-04-24 11:34:00 · 1521 阅读 · 0 评论 -
How to manually release Insufficient Funds Hold on An Invoice?
The information in this document applies to: Oracle Payables - Version: 11.5.7Information in this document applies to any platform.GoalSometimes, you need to manually release "Insufficient Funds转载 2009-04-23 13:36:00 · 1025 阅读 · 0 评论 -
AP Encountered Error while creating accounting for AP Invoice [intangible assets-1]
Doc ID: AG1043Subject: PQ AP Encountered Error while creating accounting for AP Invoice [intangible assets-1]Type: ProblemCreation Date: 08-DEC-08Last Revision Date: 12-JAN-09Status: Closed原创 2009-03-12 09:34:00 · 4411 阅读 · 0 评论 -
PQ Accounting requested to cancel unaccounted invoice
Doc ID: AG1023Subject: PQ Accounting requested to cancel unaccounted invoiceType: ProblemCreation Date: 06-Nov-08Last Revision Date: 04-DEC-08Status: OpenOwner: Kevin SymptomThe erro原创 2009-03-12 09:47:00 · 3579 阅读 · 0 评论 -
GL ACCOUNT ON TAX DISTRIBUTION LINE SHOULD COME FROM ACCOUNT SETUP ON TAX CODE
Problem Description-------------------In Oracle Payables, you have created a new tax name and assigned it to your invoice. When your tax distribution line is created, you expect the GL account to be转载 2009-03-12 13:13:00 · 1127 阅读 · 0 评论 -
How To Correct Misclassified Accounts in General Ledger
Last Updated 10-July-2008This affects all versions up to 11i. The sam issue exists in R12 but the scripts in the appendix will not work.PROBLEM DESCRIPTION-------------------The Goal of the Note is ex转载 2009-03-16 15:27:00 · 3868 阅读 · 0 评论 -
Unable to Cancel Invoice As Exchange Rate Missing Invoice Now On No Rate Hold.
Applies to: Oracle Payables - Version: 11.5.10This problem can occur on any platform.APXINWKB Symptoms### Detailed Problem Statement ###A foreign currency invoice was entered with no daily rate转载 2009-03-24 17:00:00 · 4591 阅读 · 0 评论 -
How do the Match Approval Level Option and Invoice Match Option work?
Applies to: Oracle Payables - Version: 11.5.10.2 to 11.5.10.2Information in this document applies to any platform.FORM:APXINWKB.FMB - Invoice WorkbenchFORM:APXPMTCH.FMB - Match to Purchase OrderFORM转载 2009-03-25 15:46:00 · 2891 阅读 · 0 评论 -
Loading asset data with source data from an external source
Loading asset data with source data from an external source Doc ID: 200077.1Type: BULLETIN Modified Date : 20-APR-2005Status: PUBLISHEDPURPOSE-------Thi转载 2009-04-13 13:55:00 · 3196 阅读 · 0 评论 -
Autoinvoice Master Program Does Not Trigger Autoinvoice Import Program--已解决
(1)Applies to: Oracle Receivables - Version: 11.5.10.2This problem can occur on any platform.RAXTRX - Autoinvoice Import Program RAXMTR - Autoinvoice Master Program SymptomsAutoinvoice Master转载 2009-04-03 11:40:00 · 7368 阅读 · 0 评论 -
CUSTOMER INTERFACE STATUS ERROR CODES
Checked for relevance on 08-Dec-2008Problem Description-------------------You are running Customer Interface RACUST and there is an error message in theINTERFACE_STATUS column, but you dont know what转载 2009-04-03 10:07:00 · 7151 阅读 · 0 评论 -
Report starting...
傻瓜式步骤记录:1.手工创建一个report2.Design In Character Units --Yes3.Layout Model--Main Section--Report Width4.Use Report Wizard... NOTE:1.error: REP-1219: Margin has no size -- length or width is原创 2009-04-10 10:23:00 · 1057 阅读 · 0 评论 -
零碎的问题记录--持续更新中......
1.Transaction historical summary On the date 31-DEC-2008, quantity was 0.00341. Since the report is showing upto 2 digits after the decimal, it is showing as 0.00If the customer want to show t原创 2009-07-27 15:06:00 · 1015 阅读 · 0 评论 -
AR Period Cannot Be Closed Even The Unposted Items Report Is Empty
Oracle Receivables 11.5.10.2ARXSUMPS - Open/Close Accounting Periodsfact: System Option: Accounting Method "Cash Basis"symptom: APP-AR-11332 You must post all transactions in this period before you原创 2009-07-30 13:19:00 · 8393 阅读 · 0 评论 -
当invoice匹配一个没有receive的PO时,没有触发QTY REC Hold,why?
触发 var currentContainer = null; var currentLink = null; var multipleArticles = false; var bugsContent = new Object(); //in case of duplicate bug ids, save all bug bodies as field原创 2010-01-26 16:35:00 · 1883 阅读 · 0 评论 -
Cost of goods sold (COGS)
In financial accounting, cost of goods sold (COGS)includes the direct costs attributable to the production of the goodssold by a company. This amount includes the materials cost used increatin转载 2010-02-01 13:33:00 · 6233 阅读 · 0 评论 -
APXTADTC How to Setup Tax Codes [ID 198616.1]
goal: How to Setup Tax Codesfact: Oracle Payables 11.5fact: APXTADTC - Tax Codesfix:In the Tax Codes window, you define the tax names, or tax codes, you use on invoices转载 2009-12-17 16:11:00 · 1146 阅读 · 0 评论 -
APXTADTC - Tax Authority Field is Required Although Option "Create Withholding Invoice" is Never
APXTADTC - Tax Authority Field is Required Although Option "Create Withholding Invoice" is Never [ID 243419.1] --------------------------------------------------------------------------------转载 2009-12-28 10:03:00 · 1386 阅读 · 0 评论 -
Background:用户cancel invoice并错误地创建会计分录到2010-12(实际应该是2009-12),未传递到GL,SQL修正,请谨慎使用
----UPDATE------------1CREATE TABLE AP_INVOICE_DISTRIBUTIONS_BACAS SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALLWHERE INVOICE_ID IN (215563,215564)AND ACCOUNTING_DATE=TO_DATE(2010-12-01,YYYY-M原创 2009-12-28 10:17:00 · 1302 阅读 · 0 评论 -
Assets FAQ: Standard Reports - TOP Report Issues [ID 109758.1]
Assets FAQ: Standard Reports - TOP Report Issues [ID 109758.1] -------------------------------------------------------------------------------- 修改时间 17-APR-2005 类型 BULLETIN 状态 PUBL转载 2010-01-04 16:01:00 · 2757 阅读 · 0 评论 -
A problem about Autoinvoice
Please run the following fixUpdate ra_interface_lines_all set Request_id = Nullwhere NVL(INTERFACE_STATUS, ~) != PAND (REQUEST_ID IS NOT NULL)AND BATCH_SOURCE_NAME = Order原创 2010-04-12 14:25:00 · 792 阅读 · 0 评论 -
Oracle EBS 数据导入方法比较(English)
Oracle EBS 数据导入方法比较(English)转载 2010-07-07 10:26:00 · 2469 阅读 · 0 评论 -
R12 点滴记录
AP1、Differences Between Entering Invoices in the Quick Invoices Window and the Invoice WorkbenchUse the Quick Invoices window for your e原创 2011-09-06 00:23:40 · 1603 阅读 · 0 评论 -
关于启用EBS应收票据的设置
是按nightwind前辈写的步骤设置的.----在11.5.7中的简单设置步骤:(1)启用系统选项:杂项-应收票据(2)显示菜单:在AR标准菜单中隐藏的子菜单增加说明(AR_NAVIGATE_GUI、AR_SETUP_TRANSACTIONS_GUI中的Bills Receivable Stamp Values)(11.5.7应收票据工作台还不是标准菜单)(3)定义自动会计中转载 2011-11-03 00:53:32 · 3193 阅读 · 0 评论 -
Invoice Tolerance Not Applied At Validation [ID 363613.1]
var currentContainer = null; var currentLink = null; var multipleArticles = false; var bugsContent = new Object(); //in case of duplicate bug ids, save all bug bodies as fields转载 2010-01-26 16:50:00 · 1413 阅读 · 0 评论 -
How To Reconcile Accrual Reconciliation Report And GL [ID 414169.1]
How To Reconcile Accrual Reconciliation Report And GL [ID 414169.1] Modified 20-JUL-2009 Type HOWTO Status PUBLISHED In this Document转载 2010-01-18 11:24:00 · 2597 阅读 · 0 评论 -
What Effects Does 'Replicate Seed Data' Concurrent Request Have On Appls?
The information in this article applies to: Oracle Incentive Compensation - Version: 11.5.8This problem can occur on any platform.GoalSystem wide consequences of running "Replicate Seed Data"转载 2009-05-22 15:01:00 · 2136 阅读 · 0 评论 -
Oracle ERP数据转换论
Oracle ERP 方法体系中属实施管理范畴的是AIM(Application Implementation Method),从下图AIM流程中我们可以看到系统时间轴上共分为六个阶段: 需求定义阶段(Definition) 业务分析阶段(Operations Analysis) 方案设计阶段(Solution Design) 建立系统阶段(Build) 系统切换阶段(Transitio转载 2009-05-22 15:46:00 · 832 阅读 · 0 评论 -
How the revaluation works or gets calculated--来自Metalink的解释
ACTION PLAN===========As this issue is related to two modulesie, general ledger and Payables, it taking sometime. From the General ledger side , I would explain how the revaluation works or gets ca原创 2009-05-21 11:04:00 · 1474 阅读 · 0 评论