Oracle EBS
文章平均质量分 81
Harry_ERP
这个作者很懒,什么都没留下…
展开
-
Diagnostic Script for Concurrent Requests .
source:REQCHECK.sql - Diagnostic Script for Concurrent Requests (Doc ID 164978.1)This Script is made available for Diagnosing Common Problems Related to Concurrent Requests.[sql] vie转载 2013-07-09 12:10:06 · 534 阅读 · 0 评论 -
Sales Order Related Scripts
--Line Ids Associated With This Order NumberSELECT LIN.LINE_ID LINE_ID, TO_CHAR(LIN.line_number) || DECODE(LIN.shipment_number, NULL, NULL, '.' || TO_CHAR(LIN.shipment_number)) || DECODE转载 2013-07-09 12:04:25 · 623 阅读 · 0 评论 -
Send Emails from PL/SQL .
1.要想从DB Server发邮件,首先得确保DB Server已经启用了SMTP(Simple Mail Transfer Protocol)服务。检查是否启动SMTP的方法telnet server.domain.com 25(25是SMTP的默认端口)2.PL/SQL to send email sample code:[sql] view plaincopy转载 2013-07-09 12:14:00 · 486 阅读 · 0 评论 -
Script – Tablespace Information .
SET linesize 150 column tablespace_name format a20 heading 'Tablespace' column sumb format 999,999,999 column extents format 9999 column bytes format 999,999,999,999 column largest format 999,999转载 2013-07-09 12:11:01 · 446 阅读 · 0 评论 -
Purchasing Useful Scripts .
Relation between Requisition and PO tables,Here is link:PO_DISTRIBUTIONS_ALL =>PO_HEADER_ID, REQ_DISTRIBUTION_IDPO_HEADERS_ALL=>PO_HEADER_ID, SEGMENT1PO_REQ_DISTRIBUTIONS_ALL =>DISTRIBUTION_ID,转载 2013-07-09 12:08:53 · 2597 阅读 · 0 评论 -
How to generate an GL debug log file .
Detail Log for GL programsUsed for concurrent request problems where we need to know what sql was used in key areas or we need to retain temporary tables.Note: Be aware that temp tables are n转载 2013-07-09 11:52:50 · 450 阅读 · 0 评论 -
How Inventory Passes Journals To General Ledger (GL)
Inventory Transactions transfer to GL normally done by Program called INCTGL.The accounting information related to transactions in INV module is transferred to GL by running the ‘Transfer Transact转载 2013-07-09 11:49:12 · 648 阅读 · 0 评论 -
Oracle ERP系统借贷关系表 .
一、 采购接收入库和退货: 1.接收: 借:材料采购 (订单价格) 贷:应计负债 (订单价格) 2.入库: 借:原材料 (标准成本) 贷:材料采购 (订单价格) 借或贷:材料成本差异_材料订单价格 3.退货至接收时产生与上面第2步相反的分录,退货至供货商时产生与上面第1步相反的分录。二、 子库存转移:只有转出子库产生分录转载 2013-07-09 11:41:21 · 450 阅读 · 0 评论 -
Oracle EBS Advanced Pricing Tables .
TablesQP_LIST_HEADERS_BQP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINESQP_LIST_LINES sto转载 2013-07-09 12:25:44 · 840 阅读 · 0 评论 -
Global Variable in PL/SQL .
Non-Across Sessions[sql] view plaincopyprint?create or replace package test_pkg as global_var number :=1; constant_var CONSTANT NUMBER := 2; end; create or replace package t转载 2013-07-09 12:22:39 · 376 阅读 · 0 评论 -
General Ledger Useful SQL Scripts – Oracle Applications 11i
General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview转载 2013-07-09 11:38:20 · 1217 阅读 · 0 评论 -
SQL Query to get Oracle Menus & Functions .
Script that queries the Menu structure[sql] view plaincopyprint?SELECT LPAD (' ', 6 * (LEVEL - 1)) || menu_entry.entry_sequence SEQUENCE, LPAD (' ', 6 * (LEVEL - 1))转载 2013-07-09 12:22:07 · 717 阅读 · 0 评论 -
PL/SQL Cursor常见用法模板 .
1.Loop[sql] view plaincopyprint?DECLARE emp_rec emp%rowtype; CURSOR emp_cur IS SELECT * FROM emp; BEGIN OPEN emp_cur; LOOP FETCH emp_cur INTO em转载 2013-07-09 12:16:54 · 481 阅读 · 0 评论 -
Script – Database structure and file location .
1.Control Files[sql] view plaincopyprint?set pagesize 500 set linesize 130 Prompt Prompt Control Files Location >>>> col name format a60 heading "Control Files" select name from转载 2013-07-09 12:12:13 · 505 阅读 · 0 评论 -
WIP Useful Scripts .
Query to find WIP Job details[sql] view plaincopyprint?SELECT E.WIP_ENTITY_ID, E.WIP_ENTITY_NAME Job, M.SEGMENT1 ITEM, --M.INVENTORY_ITEM_ID, M.DESCRIPTION Item_Desc, D.DESC转载 2013-07-09 12:28:26 · 792 阅读 · 0 评论