-
编辑 删除
BI Publisher Password Protect Documents
EBS
-
编辑 删除
Validate Email Adress in PL/SQL
EBS
-
编辑 删除
Debug Business Event Subscription- How to create WF Event subscription
EBS WORKFLOW
-
编辑 删除
Script to raise the Business Event in Oracle Applicaitons
EBS EVENT
-
编辑 删除
How To Create and Use Custom Business Events in Oracle E-Business Suite
EBS WORKFLOW EVENT
-
编辑 删除
Single Insertion scripts for Approved Supplier List (ASL).
EBS ASL
-
编辑 删除
Suppliers in TCA - A dive into Vendor Tables in R12
Suppliers in TCA - A dive into Vendor Tables in R12
-
编辑 删除
Supplier Conversion in R12
Supplier Conversion in R12
-
编辑 删除
OAF开发概念和案例总结
OAF
-
编辑 删除
EBS 循环处理块记录的代码
decalre i number;begin i := 0;go_block('asg_employee'); --导航到数据块first_record; --焦点放到第一条记录上loop i := i + 1; if i <> 1 then --判断是否第一条记录，不是就处理小一条记录 next_record; end if; update eju_assess_ledger_...
-
编辑 删除
How to Return Receiving Transaction with Receiving Open Interface
________________________________________ 修改时间 08-JUL-2011 类型 HOWTO 状态 PUBLISHED In this Documenthttps://support.oracle.com/CSP/m ... WTO&id=360340.1 Goal &...
-
编辑 删除
关于FND_PROFILE,FND_GLOBLE
fnd_global package可以取得一些關於當前login in用戶的信息fnd_concurrent_requests functions select FND_PROFILE.VALUE('RESP_APPL_ID') from dual 取得当前APPLICATION_ID select * from FND_USER_RESP_GROUPS 存放用户所拥有的一些责任 ...
-
编辑 删除
Pick Release the Sales Order using WSH_DELIVERIES_PUB.Delivery_Action
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...
-
编辑 删除
在Procedure中增加自己的Debug Log
如何在Oracle EBS的PL/SQL Procedure中增加自己的Debug Log，并且不希望这些Log不要跟系统的日志混在一起，可以考虑用下边这个方法[sql] view plaincopyprint?create sequence pt_debug_sequence INCREMENT BY 1 -- 每次加几个 &nbs...
-
编辑 删除
Using script to submit INV Manager to process MTI/MMTT
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  ...
-
编辑 删除
Script]Call Inventory Transaction Manager
set serveroutput on; declare --retmsg varchar2(1000); retmsg varchar2(240); retval number; trxhdrid number := '&1'; prnmsg varchar2(256);&nbs...
-
编辑 删除
FND_REQUEST.SUBMIT_REQUEST in R12
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...
-
编辑 删除
Sales Order Related Scripts
分享到一键分享QQ空间新浪微博百度云收藏人人网腾讯微博百度相册开心网腾讯朋友百度贴吧豆瓣网搜...
-
编辑 删除
Order Management Useful Scripts
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_...
-
编辑 删除
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.DELET...
