ITPub博客

Once the Delivery Details are assigned to a Delivery the Next Step is to Pick Release the Delivery.Sample code to Pick Release the Delivery: DECLARE -- Standard Parameters. p_api_version NUMBER; p_init_msg_list VARCHAR2(30); p_c...

如何在Oracle EBS的PL/SQL Procedure中增加自己的Debug Log，并且不希望这些Log不要跟系统的日志混在一起，可以考虑用下边这个方法[sql] view plaincopyprint?create  sequence pt_debug_sequence  INCREMENT BY 1 -- 每次加几个 &nbs...

1.Using script to submit INV Manager to process MMTT[sql] view plaincopyprint?/*  * When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for &nbsp...

set serveroutput on;  declare  --retmsg varchar2(1000);   retmsg varchar2(240);  retval number;  trxhdrid number := '&1';  prnmsg varchar2(256);&nbs...

FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrent program in ORACLE Applications.Parameters:Application : Short name of the application associated with the concurrent request to be submitted. Program - Short name of the concurrent program (not the execu...

分享到一键分享QQ空间新浪微博百度云收藏人人网腾讯微博百度相册开心网腾讯朋友百度贴吧豆瓣网搜...

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