Oracle E-Business R12 - Configuring the Custom Top
Solutions ? ? Support ? ? Enterprise Cloud ? ? ...
Application(EBS)开发整理
Profile:一个Profile其实就是一个参数,在开发员职责里面定义,注意这个时候选择的Application仅仅是方便管理,对以后的使用没有限制;一个Profile的具体值需要在系统管理员职责里面定义,可以分别在四个层次上定义,即Site/Application/Responsibility/User,具体来说可以给任意一个Site或任意一个Application或任意一...
How to Create Code Combination ID by API
I was on an integration assignment between Home Grown Project System and Oracle Payable. A big gap which I faced there was how to maintain single source of Account Code Combinations. We had following options to manage this issue.Built a View of GL_CODE_COMBINATIONS table and pass Combination a...
利用API自动建立GL科目段组合
1.检查存在性,如没有则新增fnd_flex_keyval.validate_segs('CREATE_COMBINATION' &...
利用fnd_flex_keyval包轻松获取关键性弹性域组合描述字段
在Oracle Forms客户化开发中,如果遇到有在Form上提供关键性弹性域(以下简称“键弹性域”)功能支持的时候,我们可以利用FND_KEY_FLEX.DEFINE函数来轻松完成所有的初始化工作。其中也包括键弹性域的组合描述字段的显示的初始化:只要在FND_KEY_FLEX.DEFINE调用时指定了DESCRIPTION参数即可。然而有时我们仅是想要显示...
详解EBS接口开发之应收款处理
(一)应收款常用标准表简介 1.1 常用标准表 如下表中列出了与应收款处理相关的表和说明: 表名说明其他信息AR_BATCHES_ALL...
AR Receipt API For R12:
AR_RECEIPT_API_PUB.CREATE_CASH(P_API_VERSION => 1.0, P_INIT_MSG_LIST => FND_API...
How to create AR Lockbox interface
Lockbox interface AutoLockbox lets us automatically process receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables AutoLockbox is a three step process: 1. Import: During this step, Lockbox reads and formats the data fr...
ra_interface_lines_all各字段说明
最近在处理oracle ebs问题时,碰到好几次是关于ar模块的接口表上的错误处理,上面有些核心的字段还是值得我们去认真研究的,上metalink上看了下,刚好有一篇是关于ra_interface_lines_all各个字段的介绍,copy过来,供有需要的XDJMM看看。note:Description and Usage of Fields in RA_INTERFACE_LINES Table [ID 1...
AR Invoice Interface
AR Invoice Interface - ra_interface_lines_all, ra_interface_distributions_all, ra_interface_errors_allAR Invoice InterfaceAR INVOICE INTERFACE************************Interface Tables are :------------------------ra_interface_lines_allra_interface_distributions_all...
项目总结之接口开发 [摘]
松下决裁项目属于一个开发项目。其开发的功能所实现的就是从金蝶EAS中把数据导入到松下腾龙EBS中。涉及到GL/AR/AP模块。项目的住要任务是接口的开发。下面是我在项目上这段时间对接口开发实践与学习的总结.AP模块一:设置:1、设置税码2、弹性域的设置:二:字段A: 接口头表1、gr...
Oracle EBS学习网站列表
Oracle官方文档库http://tahiti.oracle.com/http://www.oracle.com/technetwork/documentation/index.html#apps其中EBS较新的为12.1.3和12.2.2版本,主要包含各模块的User Guide、Implementation Guide等。Oracle E-Business Suite Online Documentation Library Release 12.1.3+http://docs.oracle.com/cd/E1872...
Jdevelop配置
解压至某目录(我是d:\java\jdev_oaf)(注意目录中不要带有空格!) 解压后的目录结构是 jdevbin jdev的执行程序所在目录 jdevdoc 开发文档 jdevhome oaf工作目录 配置步骤: 1) 填加环境变量 JDEV_USER_HOME 指向d:\java\jdev_oaf\jdevhome\jde...
XMLType Operations
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb04cre.htm#sthref465
在oracle中通过字段信息生成xml文件
一般地,在开发xmlp的时候,我们要先用report builder制作rdf模板,然后上传rdf到客户化应用下的reports文件夹下,通过并发请求,输出xml数据,然后保存成xml文件,或者直接将请求输出的out文件改后缀为xml,同样得到输出数据的xml文件,接着通过加载xml数据制作rtf模拟,定义数据和模板,再次处...
How to Check Debug Log on OAF Pages
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.3.In list box, Choose 'Show Log on Screen',and Select Statement4.Once thi...
Oracle EBS APIs
API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS) API for Cancelling the Purchase Order (PO) Document (PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT) API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGO...
Purchase Document Open Interface(PDOI)
PO模块也有自己的接口表,多用于把其他业务系统在Oracle EBS系统生成采购订单记录。 Table NameDescriptionTypePO_HEADERS_INTERFACEThis is the table where to insert PO headers data in interface table....
OAF MVC Architecture
MVCM:The Model is the place containing the business logic.V:The View is the presentation layer.C:The Controller manages the flow between pages.OAF MVC Architectureor1] ModelBC4J(Business Components For Java) have three basic component clas...
MetaData Service (MDS) in OA Framework
OAF的XML文件有:UIX Pages and Regions.OAF PersonalizationsBC4J Substitutions (EO, VO Substitutions)BC4J Components (EO.xml, VO.xml, AM.xml, AO.xml, VL.xml)OAF的很多组件都是以XML的形式存在,但到最终的系统里,OAF的XML文件会存储到数据库表中(JDR_...