EBS API
API与接口相关
知了学飞
就职世界300强,QQ/WX:316187205
展开
-
自动创建web adi的代码
/*Stepstocreatethecustomintegrator.Step1.Usingbne_integrator_utils.CREATE_INTEGRATORpackagecreatethecustomintegratorStep2.Usingbne_integrator_utils.CREATE_INTERFACE_FOR_AP...原创 2012-05-08 14:33:00 · 129 阅读 · 0 评论 -
获取 Transaction Source
报表上要获取物料事务处理表上的的Source(来源)字段,非数据库项。 /*==================================================ProcedureName:get_txn_sourceDescription:Thisprocedureisusedt...原创 2012-05-26 15:37:00 · 227 阅读 · 0 评论 -
OE_ORDER_PUB.PROCESS_ORDER to Apply hold on a sales order(应用暂挂API)
PURPOSE: This post is to provide a sample script to Apply hold on a sales order using an API OE_ORDER_PUB.PROCESS_ORDER. TEST INSTANCE: R12.1.1 SCRIPT: 
...原创 2012-06-08 10:43:00 · 119 阅读 · 0 评论 -
OE_HOLDS_PUB.RELEASE_HOLDS -- Release Holds Script(释放暂挂API)
Below script will help you to Release Order level or Line Level hold in Oracle Order Management through API OE_HOLDS_PUB.RELEASE_HOLDS This script was tested in R12.1.1 SET...原创 2012-06-08 11:50:00 · 292 阅读 · 0 评论 -
获得AP发票状态
路径:应付->发票录入 一般页签 的状态区域 AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID, AI.INVOICE_AMOUNT,...原创 2012-05-09 13:16:00 · 491 阅读 · 0 评论 -
使用API:FND_PROFILE.save更新EBS系统配置文件
SyntaxFND_PROFILE.SAVE(<Profile_Option_Name>, <Profile_Option_Value>, <Level SITE/APPL/RESP/USER>, <Level_Value>, ...原创 2013-03-12 16:16:00 · 496 阅读 · 0 评论 -
How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS? [ID 558514.1]
Applies to: Oracle Inventory Management - Version: 12.0.6<max_ver>and later[Release: 12 and later ]Information in this document applies to any platform.***Checked for relevance on ...原创 2013-07-05 17:14:00 · 116 阅读 · 0 评论