![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle ERP-财务模组
yy5512
这个作者很懒,什么都没留下…
展开
-
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-07-17 16:25:00 · 1404 阅读 · 0 评论 -
查询FA折旧Accounting资料
以下查询透过SLA的几张table(xla_events/xla_transaction_entities/xla_ae_headers/xla_ae_lines),来查询资产具体折旧传票状况,包括折旧金额,是否抛转等信息。Select fab.asset_number ,xah.period_name ,xe.event_type_code原创 2009-08-13 13:20:00 · 1774 阅读 · 0 评论 -
How to Enable and Run a Payables Concurrent Program in Debug Mode
How to Enable and Run a Payables Concurrent Program in Debug Mode [Help]PURPOSE How to Enable and Run a Payables Concurrent Program in Debug Mode Producing a Debug Log File. SCOPE & APPLICATION Us转载 2009-08-19 13:16:00 · 1199 阅读 · 0 评论 -
总帐接口表gl_interface的详细说明
要使"日记帐导入"成功地将导入数据转换为日记帐分录,您必须在要求输入值的所有GL_INTERFACE 表列(包括所有非空列)中输入值。请在 GL_INTERFACE表的以下要求列中输入值: 1. 状态:输入 NEW 值,以指明您要将新数据导入总帐应用产品。 2. SET_OF_BOOKS_ID:输入事务处理的相应帐套标识。您可以在总帐应用产品的"帐套"表单-->"帐套"表的 SET_转载 2009-07-09 10:51:00 · 2080 阅读 · 0 评论 -
根付款相关的表
Payments and its tables:You can create either single payments or payments batches containing multiple payments. Payment Types-- Manual Payment: When you create a single payment, rather than an entir转载 2009-07-09 10:54:00 · 1907 阅读 · 0 评论 -
跟发票相关的表
Invoice Types:-- Standard: A trade invoice you receive from a supplier.-- Credit Memo(贷项通知单): A negative amount invoice(负数发票) you receive from a supplier representing creditfor goods or services purc原创 2009-07-09 10:55:00 · 2413 阅读 · 0 评论 -
AP月结关会计期间检查逻辑
1. 未确认的付款批 SELECT Y FROM ap_inv_selection_criteria_all AISC, iby_pay_service_requests IPSR , ap_selected_invoices_all ASI WHERE IPSR.call_app_pay_service_req_code (+) = A转载 2009-07-09 10:58:00 · 3269 阅读 · 0 评论 -
Unable to See the Legal Entity List of Value in the Bank Account Owner Field [ID 415529.1]
Applies to: Oracle Cash Management - Version: 12.0 to 12.0This problem can occur on any platform.AccountOwnerUsePG 120.8 SymptomsUnable to create a new bank account in release 12 in Cash Mana转载 2009-11-25 14:49:00 · 6769 阅读 · 0 评论 -
How to Enable Creation of Employee Type Suppliers
1. Sign on to Application 2. Select Responsibility: System Administration3. Navigation: Application / Menu4. Query Menu: POS_HT_SP_FULL_ACCESS_MENU5. Verify the Function: POS_HT_SP_EMP_SUPPLIER, Displ转载 2010-03-31 14:17:00 · 5519 阅读 · 0 评论 -
Oracle ERP Application Diagnostics使用
invoice异常的时候,可以先使用Application Diagnostics查询一下相关的资料,资料非常全,看起来也非常直观。使用步骤1)进入Responsibility Application Diagnostics2)点击Diagnose3)点击Select Application按钮,输入Payables4)点击Invoice前面的+号,勾上Invoice Data原创 2012-04-27 14:52:14 · 16507 阅读 · 0 评论 -
Oracle EBS 如何月结之应付(AP)对账详解
概述应付模块的多数业务基于采购和库存的操作,因此应付模块的月结应该在采购模块和库存模块月结后才能关闭会计期。月结步骤在每个会计期末,应付模块的月结应遵循以下流程:1.检查业务是否全部录入;2.检查是否有未验证、暂挂发票;3.更新到期的远期付款状态;4.检查应付业务是否生成分录;5.应付业务传送到总帐;6.确认应付分录全部传送总帐;7.创建成批增加;8.复核凭证,确认无误后过帐;9.确认及核对供应商转载 2009-08-04 17:42:00 · 9594 阅读 · 0 评论 -
采购到入库所经历的表
--采购到入库所经历的表--0.请购单--创建请购单方式有--a.从外挂系统导入请购的接口表PO_REQUISITIONS_INTERFACE_ALL,并允许请求(名称:导入申请)SELECT *FROM PO_REQUISITIONS_INTERFACE_ALLWHERE INTERFACE_SOURCE_CODE = TEST KHJ--b.在系统中创建请购单(路径:PO/申请/申请)-转载 2009-08-04 13:57:00 · 1936 阅读 · 0 评论 -
Oracle EBS 常用表关系
http://bbs.itjaj.com/thread-802-1-1.html Tables_Relationship.pdf转载 2009-08-04 16:38:00 · 2572 阅读 · 2 评论 -
R12 APP-OFA-48392 Unable to Get The Concurrent Request Status Using Procedure FND_CONCURRENT.GET_REQUEST_STATUS
Subject: R12 APP-OFA-48392 Unable to Get The Concurrent Request Status Using Procedure FND_CONCURRENT.GET_REQUEST_STATUS Doc ID: 742830.1Type: PROBLEM Modified Date : 2转载 2009-07-17 16:48:00 · 3781 阅读 · 0 评论 -
EBS R12 SLA: Analyzing Subledger Accounting
As in last post about subledger accounting we understood with this new feature:All accounting performed before transfer to the GL. and this is achieved by user setup who can do by definable acco转载 2009-08-04 13:02:00 · 2289 阅读 · 0 评论 -
oracle ebs R12 SLA 后台技术
前面的都是业务方面的,现在进行技术简析,更多的内容还在整理中。 在SLA中技术方面最常用的就是日记帐来源追溯,在追溯的过程中从GL到SLA和11i差别不大,使通过gl_import_references表来进行,该表的je_batch_id,je_header_id,je_line_num是和GL关联,该表字段gl_sl_link_id是和SLA中的行表(XLA_AE_LINES)关联,转载 2009-08-04 13:05:00 · 7449 阅读 · 1 评论 -
不能创建会计分录
不能创建会计分录 --------------------------------------------------------------------------------打补丁:6826219和6901404处理原理:如果创建会计分录失败,只要把xla_events.event_status_code和xla_events.process_status_code都改成U,然后提交>转载 2009-08-03 17:15:00 · 8814 阅读 · 0 评论 -
R12 SLA 经典查询
--根据日记帐查询其事件信息 select _^_ "KEY" --======xla_transaction_entities=========-------- ,xte.application_id "应用" ,xte.entity_id ,xte.ledger_id "分类帐SOB" ,xte.entity_code转载 2009-08-04 10:54:00 · 1912 阅读 · 0 评论 -
R12 SLA: Accounting Methods Builder
In Subledger Accounting, have you heard something called Accounting Methods Builder, which is sort of toolset to define journal entry rules for the transactions and events of a subledger applicatio转载 2009-08-04 12:49:00 · 1509 阅读 · 0 评论 -
How To Collect Diagnostic Data to Troubleshoot Create Accounting in Oracle Assets?
Applies to: Oracle Assets - Version: 12.0.0Information in this document applies to any platform.FAACCPB - Create Accounting - AssetsXLAACCUP - Accounting Program GoalHow to collect diagnostic da转载 2009-08-04 09:12:00 · 1945 阅读 · 0 评论 -
Oracle EBS R12经验谈(二)
作者: jianping.ni 时间: 2009-2-13 12:52 标题: Oracle EBS R12经验谈(二)OAF页面:银行帐户开户人LOV值列表无值 在输入 应付超级用户职责/Setup : Payment/银行帐户/创建银行帐户:帐户开户人和用途 中的银行帐户开户人字段时,不要选择边上的LOV值列表(选了也白选,因为没有值可选,是bug),直接在该字段转载 2009-08-04 10:59:00 · 16112 阅读 · 0 评论 -
GL, SLA, SOB, COA, BSV, CCID, LE 概念的简单介绍
写这篇文章基本上就是陈述和翻译了一篇oracle finance blog 上面的文章(看参考).再加上我一点点自己的理解. 这几个缩写, 在Oracle ERP 上的确很常见, 也经常把我们搞迷糊.GL= General Ledger指的是Oracle 的总帐系统. application_id = 101. 在uk似乎居然还有不同的解释(In the UK, it was referred转载 2009-08-04 11:08:00 · 2407 阅读 · 0 评论 -
asset transfer api测试范例
经过测试ok的sample --测试代码开始declare l_trans_rec fa_api_types.trans_rec_type; l_asset_hdr_rec fa_api_types.asset_hdr_rec_type; l_asset_dist_tbl fa_api_原创 2012-06-05 15:28:58 · 6566 阅读 · 0 评论