详解EBS接口开发之物料导入API
INV API
Oracle EBS供应商接口导入
EBS 供应商
Examples To howto Insert into Transaction Open Interface
EBS MTL TRANSACTION INTERFACE
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
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空间新浪微博百度云收藏人人网腾讯微博百度相册开心网腾讯朋友百度贴吧豆瓣网搜...