ITPub博客

1.查看临时表空间使用情况  Select f.tablespace_name ,sum(f.bytes_free + f.bytes_used) /1024/1024/1024 "total GB" ,sum((f.bytes_free + f.bytes_used) - nvl(p.bytes_used, 0)) /1024/1024/1024 "Free GB" ,sum(nvl(p.bytes_used, 0)) /1024/1024/1024 "Used GB" from sys.v_$temp_space_header f, ...

AR SLA GL SqlLink  2012-08-10 17:51:47|  分类： 技术、专业相关 |  标签： |字号大中小 订阅 AR-SLA:select xte.entity_id,       xte...

R12月末关帐的异常检查和处理在R12版本中月末关帐时经常会出现关不了的情况，而系统的异常报表的信息太过简单且不完全。结合项目本身发生的情况，做了以下的总结，希望能对公司其他R12项目有所启示。R12月度关帐的要...

1,发运行的接收应计(PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG)控制接收时是否产生分录.2,分配行的接收应计(PO_DISTRIBUTION_ALL.ACCRUE_ON_RECEIPT_FLAG)控制发票匹配PO时,分配行的科目取PO charge account,...

Use Receivables Responsibility.1. Define user write-off limit The Navigation Path is: Setup > Transactions > Approval Limit Enter user limit for each currency the user is allowed to write off 2. Defin...

1.对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引。3 n8 U' |* Y! ]0 S4 H; \$ _" W8 l; I) g. {5 l2.应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎...

CREATE OR REPLACE PACKAGE INVGRCVK_BG_1 IS  PROCEDURE MAIN(ERRBUF      OUT VARCHAR2,              &...

this profile  "Utilities:Diagnostics"  using control Diagnostics funaction -----修改AP的密码.DECLAREX BOOLEAN;BEGINX := FND_USER_PKG.ChangePassword('SYSADMIN','21111111');END;--公司PR...

CREATE OR REPLACE PACKAGE GLGENSEQ_BG_1 AS/**********************************************************//** This package is used for Copy GL document sequence to New Fin year  P_COPY_FR_YEAR and P_...

总账系统系统报表名中文译名用途描述Journals-Voucher日记账传票通过提交该报表来打印日记账传票Journals-Document Nummber传票文档号按传票的文档序列号来打印日记账传票列表,可作为装订每月传票...

在Oracle EBS OM模块中,  一个典型订单流程包括: 下单, 挑库, 发货确认; 创建客户安装Install Base, 以及失效Install Base等业务. 本文列出主要业务的API示例, 供客户化或系统集成时参考. (所有代码在11...

<%@ page errorPage="errorpage.jsp"%> <%@ page language="java" %><%@ page contentType="text/html; charset=GB2312"%><%@ page import="java.sql.*"%> <%@ page import="java.io.*, java.util.*, java.text...

<html><HEAD><meta. http-equiv="expires" content="0"><title>AP Invoice Upload</title></HEAD> <link rel="stylesheet" charset="UTF-8" type="text/css"href="../css/belton-oracle.css"><body><table sum...

Order Import Interface Item Import (Item conversion)  Order Import Interface (Sales Order Conversion)           Interface tables·&nb...

ü On-hand Quantityü Customer Conversionü Customer APIü Auto Invoice Interfaceü Receipt APIü Auto Lockbox Interfaceü AP Invoice Interface  On-hand quantity   ...

ü Receipt APIü Auto Lockbox Interfaceü AP Invoice Interfaceü Vendor Interface/Conversionü Requisition Importü PO receipts interfaceü GL Interfaceü GL Budget Interfaceü GL Daily conve...

1. 在11.5.10下的Responsibility "Inventory Vision Operation(USA)", 若要切换组织到 V1. 需要设置如下:方案：切换Responsibility 到 "Order Management Super User, Vision Operations(USA)", 打开路径Inventory...

-找到锁住表的sid和serial#select sid,serial# from v$session where sid in (select sid               from v$lock    &...

begin  fnd_global.apps_initialize(user_id      => 3532,                   &...

Here you can find some SQL samples and some selected commands.--Select select vendor_namefrom po_vendors --Whereselect vendor_namefrom po_vendors where vendor_name = 'Google'--Group byselect vendor_...