ITPub博客

File Types.fmbForm binary source code.fmtForm text.fmxForm executable.mmbMenu source code.mmtMenu text.mmxMenu executable.pldText version Package file.plldesign time of library,can open by Form.plxexecutable , complied version.plsDB Level Package File.pkgDB Level Package File转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7444929

System Variables Toutorial System Variables About System Variables A system variable is an Oracle Forms variable that keeps track of an internal Oracle Forms state. You can reference the value of a system variable to control the way an application behaves. Oracle Forms maintains the values of system variables on a per form basis. That is, the values of all system variables correspond only to the current form. The following list presents the names of the available system variab

Physical Inventory Basic Steps 1.Define Physical Inventory > Snapshot(The snapshot saves all current item on-hand quantities and costs) > It will raise "Freeze physical inventory" Concurrent Request > Then re-query Physical Inventory,Snapshot Date will be populated a Date. 2. Tag Generation -> Request "Generate physical inventory tags" 3.Tag Counts 4.Approve Adjustments 5.Launch adjustments "Perform physical inventory Adjustments"

Windows下用Form打开fmb文件，报错 FRM-10043: Cannot open file. Cause:最有可能的原因是fmb所在的路径中包含中文 Solution:把Form文件放到一个全英文的目录,需要注意中文的Windows，“桌面”的全路径是有中文的

几年里总结了不少东西，都静静的躺在硬盘中，这些资料很多是遇到问题后总结的，也有一些是从好的文章中摘选的，不管如何都是花费了一些功夫才得来的，与其让这些资料在硬盘中沉睡，不如拿出来分享让更多人受益。很多东西如果不记录，很快就会被遗忘，之前清楚的东西，过了若干时间后就变得模糊了，不得不重头开始研究，时间上确实是一种浪费。另外记录了一段

Somtimes, we will need to debug some SQLs and try to run them within environment parameters. It will be complex to debug in PL/SQL by setting fnd_client_infor or else.   Following is the way to run debug SQL quickly within the right environgment you want:   (1) Login any application or form to the situation you want to chek SQL data (e.g. Enter \'Inventory\' resp, change organization to M1 and open Receiving Transaction form and go on with following steps) (2) Click menu \'H

如何在Oracle EBS的PL/SQL Procedure中增加自己的Debug Log，并且不希望这些Log不要跟系统的日志混在一起，可以考虑用下边这个方法create sequence pt_debug_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加，不循环 CACHE 10; --1. Create temp table. create table pt_debug_tab (seq INTEGER,text Varchar2(300),datetag Varchar2(30)); --2. Create procedure. create or replace proc

Flexfields FNDSQF Debugger The global variable GLOBAL.FND_FLEX_FNDSQF_DEBUG takes one of the following values: ’OFF’, ’EXCEPTION’, ’FAILURE’, ’DEBUG’. You set GLOBAL.FND_FLEX_FNDSQF_DEBUG through the Examine window before you open your form. 1. From the Help menu, navigate to Diagnostics > Examine.14 – 70 Oracle Applications Developer’s Guide 2. Enter GLOBAL for Block, and FND_FLEX_FNDSQF_DEBUG for Field. Tab to Value field. (If you get a ”variable doesn’t ex

做的一个Dropship流程的实录(包括流程期间遇到问题的解决) What are the advantages of Drop Shipment Orders? These are the benefits: No inventory is requiredReduced order fulfillment processing costsReduced flow timesElimination of losses on non-sellable goodsElimination of packing and shipping costsReduced inventory space requirementsReduced shipping time to your customerAllows you to offer a variety of products to your customers How to understand the data

各种文件类型所在的目录转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7432635

DB的默认账户及密码system/managersys/manager(或者change_on_install)apps/appsinv/invwms/wmswip/wippo/po......Vision Demo库默认的用户名及密码sysadmin/sysadminmfg/welcomeoperations/welcomeservices/welcomemrc/welcomehrms/welocmeprojmfg/welcome (For Project)process_ops/welcome(FOR OPM)INVPLANNER/welcomeMRC/welcomeA Script: EBS Apps passwords - $FND_TOP/patch/115/sql/fnddefpw.sql – will list seeded accounts with default password select USER_NAME USER_WITH_DEFAULT_PASSWORD f

Oracle EBS深入浅出系列，应该算比较全了 深入浅出Oracle EBS之全模块设置详例.pdf 深入浅出oracle ebs之核心功能（mfg）.pdf 深入浅出Oracle EBS之核心功能(FIN).pdf 深入浅出Oracle EBS之核心功能(DIS).pdf 深入浅出Oracle EBS之FINDISMFG应用模块.pdf 深入浅出Oracle EBS之Discoverer实例详解.pdf 深入浅出Oracle EBS之 workflow.pdf 下载可以到我ITPUB的帖子：http://www.itpub

任何产品（不特指Oracle产品）都有自己的支持策略，一个产品不可能无期限的给予最高优先级的支持.Oracle对自己产品也一样，对于自己的产品在不同的时期，支持的强度是不一样的。大体分来，支持的强度分为三个级别：Premier Support（最高优先级的支持）,Extended Support（中等优先级的支持）,Sustaining Support（最低优先级的支持）Premier Support provides a standard five-year support policy for

做库存事务，发现Transaction Date是2016年的一个时间 然后查了Sysdate，发现数据的时间确实不对 但查了下Unix Server的时间没有问题，是当前时间 -bash-3.2$ date Sun Mar 4 23:25:45 PST 2012 解决方法： 先设定一个固定的时间到系统 SQL> alter system set fixed_date =\'2012-03-03\' 2 / System altered.--- 再恢复系统时间 SQL> alter system set fixed_date = none 2 / System altered. 然后sysdate就返回了

declare x_po_head_id number ; begin select po_header_id into x_po_head_id from po_headers_all where segment1 = \'&ponumber\' and org_id = &org_id; update po_headers_all set authorization_status = \'APPROVED\', approved_flag = \'Y\', approved_date = sysdate, last_update_date= sysdate where po_header_id = x_po_head_id; update po_line_locations_all set approved_flag = \'Y\' where po_header_id = x_po_head_id ; commit; end;

一些误操作可能会造成数据被锁，可以尝试用下边的脚本来解锁脚本可行，已经试用多次Column SID FORMAT 9999999 heading "Sess|ID " COLUMN SERIAL# FORMAT 9999999 heading "Serial# " COLUMN OBJECT_NAME FORMAT A17 heading "OBJ NAME or|TRANS_ID" Trunc COLUMN OSUSER FORMAT A10 heading "Op Sys|User ID" COLUMN USERNAME FORMAT A8 select B.SID, C.SERIAL#, C.USERNAME, C.OSUSER, DECODE(B.ID2, 0, A.OBJECT_NAME,\'Tran

You can reference items indirectly with the NAME_IN and COPY built-in subprograms.The NAME_IN function returns the contents of an indicated variable or item.  Use the NAME_IN function to get the value of an item without referring to the item directly.The following statements are equivalent:IF :emp.ename = \'smith\' -- direct referenceIF NAME_IN(\'emp.ename\') = \'smith\' -- indirect referenceThe return value is always a character string.  To use NAME_IN for a DATE or NUMBER

FOR UPDATE NOWAIT BEGIN   SELECT x FROM table FOR UPDATE NOWAIT; EXCEPTION   WHEN OTHERS THEN     <handle exception> END; FOR UPDATE(Wait model) BEGIN   SELECT x FROM table FOR UPDATE; EXCEPTION   WHEN OTHERS THEN     <handle exception> END;

EBS PO Approve Scriptdeclare x_po_head_id number ; begin select po_header_id into x_po_head_id from po_headers_all where segment1 = \'&ponumber\' and org_id = &org_id; update po_headers_all set authorization_status = \'APPROVED\', approved_flag = \'Y\', approved_date = sysdate, last_update_date= sysdate where po_header_id = x_po_head_id; update po_line_locations_all set approved_flag = \'Y\' where po_header_id = x_po_head_id ; commit; end; NOTE:You can only use this script at

准备通过这个博客记录一些Oracle E-Business Suite相关的文章，把我了解并且有价值的内容记录下来，希望更多地人能从这里有所收获。“九层之台，起于累土；千里之行，始于足下。” ~ 老子