ITPub博客

此制作方法是结合HTML语言及PL/SQL语言,以所见即所得方式发布的报表,发布的结果可直接拷贝到EXCEL中进行编辑,方便实用.1.制作报表模板建议利用DreamWaver 制作. 主要工作是画报表布局及表头.然后拷出生成的HTML语句.如下:设计窗口:代码窗口:生成的HTML 语句如下:<html><head><meta. http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>无标题文档</title></head><body><table width="740" border="1">----------表头区域

DECLAREv_entity_name VARCHAR2(30) := 'ENG_ENGINEERING_CHANGES';v_media_id NUMBER;v_category_id NUMBER;v_seq_num NUMBER;v_datatype_id NUMBER;p_entity_id NUMBER := 9008;p_document_desc VARCHAR2(120) := 'TEST';p_file_name VARCHAR2(100) := '11-a.pdf';b_file BFILE;b_lob BLOB;BEGINfnd_global.apps_initialize(user_id => 1,resp_id => 2,resp_appl_id => 3);dbms_application_info.set_client_info(4);SELECT category_idINTO v_category_idFROM fnd_document_categories_tlWHERE user_name = 'ECO Attachments'

/*create or replace directory JACK as 'D:jack';*/DECLARE b_file BFILE; b_lob BLOB;BEGIN INSERT INTO a (a) VALUES (empty_blob()) RETURN a INTO b_lob; --为了使PL/SQL编译成功，必须先为该列插入一个empty_blob() 值，return a into b_lob将该列与一个blog类型的变量绑定在一起，以后只要为b_lob赋值，即等于将该值插入了表中。 b_file := bfilename('JACK', 'a.bmp'); --tmp是建立的文件所在的目录，filename.jpg是文件名;将文件转换为bfile类型 dbms_lob.OPEN(b_file, dbm

The instructions on this page are here for completeness, however there is an easier method to control forms recording and playback in Oracle E-Business Suite. Please ensure you have read all the steps on the Forms Playback Setup page before following the steps on this page. Only follow the setup instructions outlined below if you know what you are doing and have decided the Profile Option approach described on the Setup page is not appropriate for you.http://www.dataload.com/help/recplay/url.htm

BEGIN web_server_prefix := fnd_web_config.gfm_agent; mime_type := nvl(fnd_profile.VALUE('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values'); db_file := fnd_gfm.file_create(content_type => mime_type, program_name => 'export'); v_record_num := :system.cursor_record; go_block('PO_RULE'); first_record; LOOP EXIT WHEN system.last_query = TRUE; outstring := 输入你要的数据; fnd_gfm.file_wr

HI Follow these steps."PO:Secondary Email Address"1)Open Workflow Builder.2)Open the required workflow for which this attribute needs to be added3)Navigate to the message for which additional recipients have to be set.4)Right Click on this message and select new attribute5)Enter Internal Name as #WFM_CC (or #WFM_BCC). Enter any desired name as Display name6)Also keep Type as Text and Source as Send.7)Save the workflow.8)While Launching the workflow you enter list of the e-mail addresse

PROCEDURE Set_print_layout IS -- L_printer_name VARCHAR2(50); L_printer_bool BOOLEAN; L_output_format VARCHAR2(20); L_add_layout BOOLEAN; -- BEGIN L_printer_name := 'XXXX'; L_printer_bool := Fnd_request.Set_print_options(Printer => L_printer_name, Style => 'XXXX' Copies => 1, Save_

BEGINweb_server_prefix := fnd_web_config.gfm_agent;mime_type := nvl(fnd_profile.VALUE('FND_EXPORT_MIME_TYPE'),'text/tab-separated-values');db_file := fnd_gfm.file_create(content_type => mime_type,program_name => 'export');v_record_num := :system.cursor_record;go_block('PO_RULE');first_record;LOOPEXIT WHEN system.last_query = TRUE;outstring := 输入你要的数据;fnd_gfm.file_write_line(db_file,output_string);next_record;END LOOP;go_record(v_record_num);db_file := fnd_gfm.file_close(db_file);url

CREATE OR REPLACE PACKAGE oracle_cdh ISPROCEDURE create_party(p_party_id VARCHAR2,p_party_type VARCHAR2,p_party_name VARCHAR2,p_party_number VARCHAR2,p_person_pre_name_adjunct VARCHAR2,p_person_first_name VARCHAR2,p_person_middle_name VARCHAR2,p_person_last_name VARCHAR2,p_person_title VARCHAR2,p_created_by_module VARCHAR2,p_person_name_suffix VARCHAR2,p_person_academic_title VARCHAR2,p_person_previous_last_name VARCHAR2,p_known_as VARCHAR2,p_known_as2 VARCHAR2,p_tax_reference VARCHAR2,p_person_

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 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 >

比如有一个外围支持系统，用户需要在外围系统登录之后点个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_

WEB_SERVER_PREFIX := FND_WEB_CONFIG.GFM_AGENT; MIME_TYPE := NVL (FND_PROFILE.VALUE ('FND_EXPORT_MIME_TYPE'), 'text/tab-separated-values' ); DB_FILE := FND_GFM.FILE_CREATE (CONTENT_TYPE => MIME_TYPE, PROGRAM_NAME => 'export'); V_RECORD_NUM := :SYSTEM.CURSOR_RECORD; GO_BLOCK ('PO_RULE'); FIRST_RECORD LOOP EXIT WHEN SYSTEM.LAST_QUERY = TRUE ; OUTSTRING := 输入你要的数据 FND_GFM.FILE_WRITE_LINE (DB_FILE, OUTPUT_STRING); NEXT_RECORD; END LOOP; GO_RECORD (V_RECORD_NUM); DB_FILE := FND_GFM.FILE_C

DECLARE--By: Anil Passi--When Jun-2001v_session_id INTEGER := userenv('sessionid');v_user_name VARCHAR2(30) := upper('&Enter_User_Name');BEGIN--Note, can be executed only when you have apps password.-- Call the procedure to Creaet FND Userfnd_user_pkg.createuser(x_user_name => v_user_name,x_owner => '',x_unencrypted_password => 'oracle',x_session_number => v_session_id,x_start_date => SYSDATE - 10,x_end_date => SYSDATE + 100,x_last_logon_date => SYSDATE - 10,x_descriptio

1.startup --启动数据库2.create temporary tablespace TEMP2 TEMPFILE @#/home2/oracle/oradata/sysmon/temp02.dbf@# SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; --创建中转临时表空间3.alter database default temporary tablespace temp2; --改变缺省临时表空间 为刚刚创建的新临时表空间temp24.drop tablespace temp including contents and datafiles;--删除原来临时表空间5.create temporary tablespace TEMP TEMPFILE @#/home2/oracle/oradata/sysmon/temp01.dbf@# SIZE 512M REUSE AUTOEXTEND ON NEXT

SELECT B.FILE_ID 文件ID号,B.TABLESPACE_NAME 表空间名,B.FILE_NAME 文件名,B.BYTES / 1024 / 1024 "空间(M)",(B.BYTES - SUM(NVL(A.BYTES, 0))) / 1024 / 1024 "已使用(M)",SUM(NVL(A.BYTES, 0)) / 1024 / 1024 "剩余空间(M)",SUM(NVL(A.BYTES, 0)) / (B.BYTES) * 100 剩余百分比FROM DBA_FREE_SPACE A,DBA_DATA_FILES BWHERE A.FILE_ID = B.FILE_IDAND B.TABLESPACE_NAME = 'POD' --GTDGROUP BY B.TABLESPACE_NAME,B.FILE_ID,B.FILE_NAME,B.BYTESORDER BY B.FILE_ID;SELECT d.status "Status"

一、模板制作：YSFOLDER.FMB打开TEMPLATE.FMB，如果打开的是APPSTAND.FMB，以下步骤省略：1、FORM级触发器：1、 在WHEN-NEW-FORM-INSTANCE后面添加以下代码：--定义文件夹数据块app_folder.define_folder_block( object_name => ' DETAILBLOCK _FOLDER' ,folder_block_name => 'DETAILBLOCK',prompt_block_name => 'DETAILBLOCK_PROMPT',folder_canvas_name => 'DETAILBLOCK_STACKED',folder_window_name => 'BLOCKNAME',disabled_functions => '');--以上参数均为VARCHAR2,长度不得超过20个字符2、 增加FORM级触发器：

DECLARE c utl_smtp.connection; PROCEDURE send_header(name IN VARCHAR2, header IN VARCHAR2) AS BEGIN utl_smtp.write_data(c, name || ': ' || header || utl_tcp.CRLF); END; BEGIN-- << 用你的SMTP服务器地址替换 'smtp.xxx.com'c := utl_smtp.open_connection('smtp.xxx.com');-- << 用你的用户名替换user1, 密码替换pass-- << 用你的SMTP服务器地址替换 'smtp.xxx.com' utl_smtp.helo(c, 'smtp.xxx.com');utl_smtp.command(c, 'AUTH LOGIN');utl_smtp.command(c, utl_raw.cast_to_varchar2(utl_encode.base64_

http://jpkc.ecnu.edu.cn/kjx/web/index2.htm 1.定义会计是计量经济活动、处理并加工经济信息，并将处理结果与决策者进行交流的经济信息系统。2.对象会计的一般对象可以表述为或“社会再生产过程中以货币表现的经济活动”或“社会再生产过程中的资金运动”。资金：以货币表示的财产物资 资金运动：用货币表示的商品价值运动。3.主体指会计为之服务的特定单位。 4.资产资产是指过去的交易或事项形成并由企业拥有或者控制资源，该资源预期会给企业带来经济利益。5.负债负债是过去的交易、事项形成的义务，履行义务预期会导致经济利益流出企业

GL_interface要使“日记帐导入”成功地将导入数据转换为日记帐分录，您必须在要求输入值的所有 GL_INTERFACE 表列（包括所有非空列）中输入值。 请在 GL_INTERFACE 表的以下要求列中输入值：状态：输入 NEW 值，以指明您要将新数据导入总帐应用产品。 SET_OF_BOOKS_ID：输入事务处理的相应帐套标识。您可以在总帐应用产品的“帐套”表单中定义帐套。“帐套”表的 SET_OF_BOOKS_ID 列 (GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID) 中提供了有效值列表。 ERP博客群落 Blog.Erp100.CoM /MM'T5i#s7^ L4R7~建议：您可以使用以下 SQL*Statement 来访问相