Oracle EBS API
文章平均质量分 84
田攀
tian.pan@qq.com
展开
-
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 Del转载 2012-07-17 11:22:25 · 18753 阅读 · 4 评论 -
Oracle Integration Repository
How to access 'Integration Repository' From E-Business SuiteResponsibility : 'Integration Repository' (12.0.x) 'Integrated SOA Gateway' (12.1.x)From the Public Web Sitehttp://irep.oracle.com/(This si原创 2013-01-15 11:41:43 · 4357 阅读 · 0 评论 -
Using API FND_PROFILE.save to update profile from backend
SyntaxFND_PROFILE.SAVE(, , , , );ExampleSET SERVEROUTPUT ON SIZE 1000000DECLARE l_user_id NUMBER; l_resp_id NUMBER; l原创 2012-12-12 12:15:55 · 8188 阅读 · 0 评论 -
Oracle Security API - FND_FUCTION.TEST
FND_FUCTION.TEST(Function_Name)Test if function is accessible under current responsibility.TRUE if function is accessible.This function Only checks static function security, and global object type gra原创 2013-02-20 18:58:59 · 3567 阅读 · 0 评论 -
Cache Pattern
Oracle EBS中,如果获取Item,Organization等基础数据的信息。你可以写SQL来查,这种做法的不好处就是,在不同Procedure或者Function中,你可能需要写多次类似的SQL来取值,造成代码的冗余。EBS标准的做法是,通过Cache模式来时缓存需要的信息。以获取Organization为例,系统中标准的做法是: l_return_value := INV_CACHE.原创 2013-03-04 13:12:46 · 2457 阅读 · 0 评论 -
BOM API - uses the BOM_BO_PUB.PROCESS_BOM API to create bill header and add components to the bill
CREATE OR REPLACE PROCEDURE SU_PROCESS_BOMAS -- API input variables l_bom_header_rec Bom_Bo_Pub.bom_head_rec_type := Bom_Bo_Pub.g_miss_bom_header_原创 2013-01-28 11:40:46 · 8674 阅读 · 0 评论 -
SAMPLE SCRIPT TO CREATE SALES ORDER USING OE_ORDER_PUB.PROCESS_ORDER
Use Of Oe_Order_Pub.Process_Order To Create Sale OrderProcess Order API is a PL/SQL packaged procedure which can be used to manipulate the sales order data by performing Insert, update or delete opera原创 2012-12-06 18:35:56 · 10130 阅读 · 0 评论 -
Using the this API wsh_deliveries_pub.Delivery_Action to ship confirm for the delvery
CREATE OR REPLACE procedure cc_shippingasl_return_status VARCHAR2(2000);l_msg_count NUMBER;--l_msg_data VARCHAR2(1000);pp_init_msg_list VARCHAR2(10) := FND_api.G_FALSE;pp_return_values VARCHAR2原创 2012-12-06 18:48:56 · 7008 阅读 · 0 评论 -
FND_REQUEST.SUBMIT_REQUEST in R12
FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrentprogram in ORACLE Applications.Parameters:Application : Short name ofthe application associated with the concurrent requ原创 2012-07-17 11:29:46 · 3894 阅读 · 0 评论 -
Purchase Document Open Interface(PDOI)
PO模块也有自己的接口表,多用于把其他业务系统在Oracle EBS系统生成采购订单记录。原创 2013-09-30 17:23:48 · 18102 阅读 · 0 评论