ITPub博客

Listed some useful queries scripts for Oracle Order Management Flow.(For Order Management Detailed Flow, You may check my previous post: Oracle EBS订单的流程(Order->AR): http://blog.csdn.net/pan_tian/article/details/7693447 )Sales Order InfoOrder HeaderSELECT * FROM OE_ORDER_...

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.DELET...

       Solutions ? ? Support ? ? Enterprise Cloud ? ? ...

Profile：一个Profile其实就是一个参数，在开发员职责里面定义，注意这个时候选择的Application仅仅是方便管理，对以后的使用没有限制；一个Profile的具体值需要在系统管理员职责里面定义，可以分别在四个层次上定义，即Site/Application/Responsibility/User，具体来说可以给任意一个Site或任意一个Application或任意一...

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...

1.检查存在性，如没有则新增fnd_flex_keyval.validate_segs('CREATE_COMBINATION'                                    &...

在Oracle Forms客户化开发中，如果遇到有在Form上提供关键性弹性域（以下简称“键弹性域”）功能支持的时候，我们可以利用FND_KEY_FLEX.DEFINE函数来轻松完成所有的初始化工作。其中也包括键弹性域的组合描述字段的显示的初始化：只要在FND_KEY_FLEX.DEFINE调用时指定了DESCRIPTION参数即可。然而有时我们仅是想要显示...

（一）应收款常用标准表简介 1.1   常用标准表 如下表中列出了与应收款处理相关的表和说明： 表名说明其他信息AR_BATCHES_ALL...

AR_RECEIPT_API_PUB.CREATE_CASH(P_API_VERSION                => 1.0,                                 P_INIT_MSG_LIST              => FND_API...

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...

最近在处理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 - 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官方文档库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...

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb04cre.htm#sthref465 

     一般地，在开发xmlp的时候，我们要先用report builder制作rdf模板，然后上传rdf到客户化应用下的reports文件夹下，通过并发请求，输出xml数据，然后保存成xml文件，或者直接将请求输出的out文件改后缀为xml，同样得到输出数据的xml文件，接着通过加载xml数据制作rtf模拟，定义数据和模板，再次处...

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...

PO模块也有自己的接口表，多用于把其他业务系统在Oracle EBS系统生成采购订单记录。 Table NameDescriptionTypePO_HEADERS_INTERFACEThis is the table where to insert PO headers data in interface table....

These APIs are handful when you want to do Insert, Update or Delete programmatically for some business requirements (rare cases!)   API Name Procedure Name Description ...

API - pos_vendor_pub_pkg.create_vendor_site  Example --  -- API to Create Supplier Site DECLARE  l_vendor_site_rec      ap_vendor_pub_pkg.r_vendor_site_rec_type;  lc_return_status         VARCHA...