刚木的博客

关闭工单提示 这些任务存在待定事务处理。

package com.dtxytech.account.generate;import java.io.*;import java.nio.charset.StandardCharsets;import java.time.LocalDateTime;import java.time.ZoneOffset;public class SqlFileGenerate { static String globalPath = "D:/plsql";//sql脚本所在路径 stati

1.在数据库执行下面脚本创建java类create or replace and compile java source named cux_http_utl asimport java.io.BufferedReader;import java.io.InputStream;import java.io.InputStreamReader;import java.io.OutputStream;import oracle.jdbc.OracleConnection;import oracl

-- Purpose : JSON特殊字符替换 FUNCTION replace_json_char(p_char VARCHAR2) RETURN VARCHAR2 IS l_char VARCHAR2(20000); l_temp_char VARCHAR2(100); BEGIN FOR i IN 1 .. length(p_char) LOOP l_temp_char := substr(p_char, i, 1); IF.

create or replace and compile java source named CUX_md5 as import java.security.MessageDigest;import java.security.NoSuchAlgorithmException;import java.sql.Clob;import java.sql.Blob;public class CUX_md5 { private static final byte [] hexDigit = {

Click to add to Favorites How to POST and RECEIVE a response as a CLOB using UTL_HTTP? (Doc ID 1375312.1) To BottomTo BottomIn this DocumentGoalSolutionAPPLIES TO:PL/SQL - Version 11.2.0.3 and laterInformation in this document applies to any platfor

select TRUNC(ADD_MONTHS(SYSDATE,-2-DECODE(MOD(TO_CHAR(sysdate,'MM'),3),0,3,MOD(TO_CHAR(sysdate,'MM'),3))),'MM') from dual; select TRUNC(ADD_MONTHS(SYSDATE,1-DECODE(MOD(TO_CHAR(sysdate,'MM'),3),0,3,MOD(TO_CHAR(sysdate,'MM'),3))),'M..

--JSON特殊字符替换 FUNCTION replace_json_char(p_char VARCHAR2) RETURN VARCHAR2 IS l_char varchar2(20000); l_temp_char VARCHAR2(100); BEGIN for i in 1.. length(p_char) loop l_temp_char := substr(p_char,i,1) ; -- DBMS_OUTPUT.put_line(L_

select GCC.concatenated_segments,GCC2.concatenated_segments,GST.TEMPLATE_NAME from gl_code_combinations_kfv gcc, gl_code_combinations_kfv gcc2, GL_ACCOUNT_HIERARCHIES G, GL_SUMMARY_TEMPLATES gst WHERE G.TEMPLATE_ID = GST.TEMPL

把unit_selling_price自动转成unitSellingPrice代码如下 --把字段转成驼峰格式 FUNCTION get_hump_value(p_value VARCHAR2) RETURN VARCHAR2 IS l_return VARCHAR2(2000); l_index NUMBER; BEGIN l_index := instr(p_value, '_'); IF l_index <= 0 THEN RETURN

离线审批概念离线审批–是指不进入系统，通过邮件来完成工作流审批的工作。适用于不希望登录系统，又能及时做审批的情形。当审批人点击了邮件中的批准或拒绝后，会向指定的收件人发一封邮件，Oracle会定时读取并处理收到的邮件，根据邮件中的标识来更新相应的单据状态，以使审批者不进系统而可以完成审批的工作。通知和邮件处理过程 邮件处理程序定时读取收件箱文件夹中的邮件。如果邮件是工作流节点的通知响应，这意味着它包含当前节点的节点标识（NID）和响应结果。 如果通知不存在，意味着通知ID或NID是不

一、简介DBMS_SQL包提供一个接口，用于执行动态SQL（包括DDL 和DML）。DBMS_SQL定义了一个实体叫游标ID，游标ID是一个PL/SQL整型数，通过游标ID，可以对游标进行操作。DBMS_SQL包和本地动态SQL在功能上有许多重叠的地方，但是有的功能只能通过本地动态SQL实现，而有些功能只能通过DBMS_SQL实现。二、主要函数DBMS_SQL封装过程中的主要函数：1、OPEN_CURSOR：返回新游标的ID值2、PARSE：解析要执行的语句3、BIND_VARIABLE：将

表不走索引的情况下可以执行表分析begin fnd_stats.gather_table_stats(‘表所在用户’,‘表名字’); end;

1.修改如下2个配置文件把 FND:启用调试日志 在当前用户或职责层改成 是把 FND:调试日志级别 在当前用户或职责层改成 对账单2.重新运行创建会计科目请求3.执行下面的sql查询日志信息select * from FND_LOG_MESSAGES T where T.MODULE LIKE ‘xla.plsql.XLA_CREATE_ACCT_RPT_PVT%’ ORDER BY T.LOG_SEQUENCE DESC;...

SELECT * FROM ap_prepay_history_all t WHERE t.posted_flag <> 'Y';SELECT * FROM ap_payment_history_all t WHERE t.posted_flag <> 'Y';SELECT * FROM xla_ae_headers WHERE gl_transfer_status_code <> 'Y';SELECT * FROM xla_events t WHERE t.

DECLARE req utl_http.req; resp utl_http.resp; VALUE VARCHAR2(4000);BEGIN req := utl_http.begin_request('www.baidu.com'); utl_http.set_header(req, 'Content-Type', 'text/html; charset=gb2312'); resp := utl_http.get_response(req); dbms_outpu

给前端调用的pkg里面的过程和函数，全部调用动态sql执行另外包里的过程和函数，这样具体的逻辑都在另外的包，修改和编译包不会影响到前端的使用。

UPDATE AP_INVOICE_DISTRIBUTIONS_ALL T SET T.POSTED_FLAG = 'Y', T.ACCRUAL_POSTED_FLAG = 'Y' where T.INVOICE_ID = 98972 AND T.POSTED_FLAG = 'N'; UPDATE AP_PREPAY_HISTORY_ALL T SET T.POSTED_FLAG = 'Y' where T.INVOICE_ID = 98972; UPDATE XLA_EV..

or的机制是顺序找所有条件，一旦有一个条件满足，后面的条件都不会执行。CREATE FUNCTION F_CUX_TEST_FUNC RETURN NUMBER IS BEGIN dbms_output.put_line (1111); RETURN 1; END; select sysdate from dual where 1=1 OR F_CUX_TEST_FUNC=1; 执行上面sql后会发现，并不会输出1111.由于or条件前面的1=1已经是true，所

大数据传输会比较长时间导致超时，可以通过Utl_http.set_transfer_timeout (600);来设置时间，单位是秒DECLAREA NUMBER; BEGINUtl_http.set_transfer_timeout (600); utl_http.get_transfer_timeout (A); dbms_output.put_line (A);END;主要是 utl_http.set_header(v_http_req, ‘Content-Length’, l

SELECT FCPP.CONCURRENT_REQUEST_ID REQ_ID, FCP.NODE_NAME, FCP.LOGFILE_NAME FROM FND_CONC_PP_ACTIONS FCPP, FND_CONCURRENT_PROCESSES FCP WHERE FCPP.PROCESSOR_ID = FCP.CONCURRENT_PROCESS_ID AND FCPP.ACTION_TYPE = 6

function get_hours(p_date1 date, p_date2 date) return number is l_return NUMBER; l_date1 date; l_date2 date; l_days NUMBER; --天数 l_week_days NUMBER :=0; --周末天数 begin --开始时间小于8点 if p_date1 < trunc(p_date1) + 1 / 3 then .

DECLARE L_ID NUMBER := 1; L_STATUS VARCHAR2(200); L_MESSAGE VARCHAR2(2000);BEGIN EXECUTE IMMEDIATE 'begin cux_xxx_pkg.xx(p_invoice_id => :1, x_status => :2,

Function replaceClob_new(srcClob IN CLOB, replaceStr IN VARCHAR2, replaceWith IN VARCHAR2) Return CLOB IS vBuffer VARCHAR2(32767); l_amount BINARY_INTEGER := 4000; l_pos PLS_.

--库存SELECT GJH.JE_CATEGORY, GJH.JE_SOURCE, XTE.ENTITY_CODE, XDL.SOURCE_DISTRIBUTION_TYPE,A.*, MTA.* FROM GL_JE_HEADERS GJH, GL_JE_LINES GJL, GL_IMPORT_REFERENCES T, XLA_AE_LINES

UPDATE PO_LINES_ALL T SET T.CANCEL_FLAG = 'N', T.CANCELLED_BY = NULL, T.CANCEL_DATE = NULL, T.CANCEL_REASON = NULL, T.CLOSED_CODE = 'OPEN', T.CLOSED_DATE = NULL, T.CLOSED_REASON = NULL, T.CLOSED_

SELECT ph.segment1 , ph.po_header_id, ph.type_lookup_code, ph.displayed_field type, ph.vendor_name, ph.vendor_id, ph.full_name, 'Vendor' , ph.org_id, MO_GLOBAL.get_ou_name (ph.org_id) operating_unit FROM po_pos_val_trx_v ph WHERE (SEGMENT1 LIKE :1) AND ( e

l_icx_val := fnd_profile.value( 'ICX_DATE_FORMAT_MASK');IF l_icx_val IS NOT NULLTHENexecute immediate 'alter session set nls_date_format = ''' || l_icx_val || '''';END IF; FND_GLOBAL.APPS_INITIALIZE(---------); 直接调用FND_GLOBAL.APPS_INITIALIZ会报错链接服务.

select /*count(organization_id)*/ costed_flag, acct_period_id, ---*****该字段一定要注意确定是否正确，否则出错 transaction_set_id, request_id, transaction_group_id, error_code, error_explanation, transaction_date from

Re-Open a Closed Inventory Accounting Period (文档 ID 472631.1)SELECT acct_period_id period, open_flag, period_name name, period_start_date, schedule_close_date, period_close_date FROM org_acct_periods WHERE organization_id = &org_id order by 1,2;

update mtl_transactions_interfaceset process_flag = 1,lock_flag = NULL ,Transaction_mode = 3 ,Error_code = NULL ,Error_explanation = NULLwhere transaction_header_id = &transaction_header_idand error_code is not NULL;update mtl_material_transa

xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id, gcc.code_combination_id) --这个api会截断 gl_flexfields_pkg.get_concat_description( chart_of_accounts_id,

FUNCTION FA_GET_DEPRN(P_ASSET_ID IN NUMBER, P_BOOK IN VARCHAR2, P_TYPE IN VARCHAR2) RETURN NUMBER IS V_LTD_DEPRN NUMBER; DUMMY_NUM NUMBER; IMPAIRMENT_RESERVE NUMBER; Y.

SELECT ibybanks.bank_name, --银行 ibybanks.bank_branch_name, --分行 ibybanks.bank_account_num_electronic--银行帐号 FROM iby_external_payers_all iepa, iby_pmt_instr_uses_all ipiua, iby_ext_bank_accou