-
编辑 删除
Oracle Applications Interface Programs
Oracle Applications Interface ProgramsOrder Import Interface (Sales Order Conversion)Interface tables:· OE_HEADERS_IFACE_ALL · OE_LINES_IFACE_ALL · OE_ACTIONS_IFACE_ALL · OE_ORDER_SOURCES · OE_CUSTOMER_INFO_IFACE_ALL · OE_PRICE_ADJS_IFACE_ALL · OE_PRICE_ATTS_IFACE_ALLBase tables: · OE_ORDER_HEADERS_ALL · OE_ORDER_LINES_ALLPricing tables · QP_PRICING_ATTRIBUTESDuring import of orders, shipping tables are not populated.If importing customers together with the order, OE_ORDER_CUST_IFACE_A
-
编辑 删除
Trace a Concurrent Request And Generate TKPROF File
Trace a Concurrent Request And Generate TKPROF FileOctober 5, 2008 · 1 CommentHello Friends, As in Oracle Application, there always need to tune programs , procedure and it is always difficult to make a perfect program, here i am trying to put a “How to” on tkprof and surely like to know if you find it useful.How to Trace a Concurrent Request And Generate TKPROF File Enable Tracing For The Concurrent Manager Program Responsibility: System Administrator Navigate: Concurrent > Program >
-
编辑 删除
使用 fnd_user_pkg API 创建用户，添加职责，修改用户密码等
比如有一个外围支持系统，用户需要在外围系统登录之后点个link就可以登录到Oracle ERP系统中，那么我们需要先把外围系统的用户创建在Oracle ERP中，并且分配职责给他。DECLAREa BOOLEAN;BEGIN---------------------------------------------------------------Change password-------------------------------------------------------------/*a := apps.fnd_user_pkg.changepassword('SIMON','oracle');IF NOT a THEN--RAISE_APPLICATION_ERROR(-20002, 'Password not updated');dbms_output.put_line('Password not updated');ELSEdbms_
