{"id":147,"date":"2015-01-13T19:39:56","date_gmt":"2015-01-13T11:39:56","guid":{"rendered":"http:\/\/www.llku.com\/?p=147"},"modified":"2016-04-20T21:56:23","modified_gmt":"2016-04-20T13:56:23","slug":"ebs%e5%81%9a%e4%bb%98%e6%ac%be%e7%9a%84%e6%97%b6%e5%80%99%e6%9c%89%e6%97%b6%e5%80%99%e4%bc%9a%e5%87%ba%e7%8e%b0frm-40654%e8%ae%b0%e5%bd%95%e5%b7%b2%e6%9b%b4%e6%96%b0","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=147","title":{"rendered":"EBS\u505a\u4ed8\u6b3e\u7684\u65f6\u5019\u6709\u65f6\u5019\u4f1a\u51fa\u73b0FRM-40654\u8bb0\u5f55\u5df2\u66f4\u65b0"},"content":{"rendered":"

\n\t\u95ee\u9898\u63cf\u8ff0\uff1a\n<\/p>\n

\n\t EBS\u505a\u4ed8\u6b3e\u7684\u65f6\u5019\u6709\u65f6\u5019\u4f1a\u51fa\u73b0FRM-40654\u8bb0\u5f55\u5df2\u66f4\u65b0\uff0c\u5bfc\u81f4\u65e0\u6cd5\u8fdb\u884c\u4e0b\u4e00\u6b65\u64cd\u4f5c\u7684\u95ee\u9898\u3002\n<\/p>\n

\n\t\u89e3\u51b3\u65b9\u6cd5\uff08\u53ea\u662f\u5176\u4e2d\u53ef\u80fd\u6027\u4e4b\u4e00\uff0c\u5176\u4ed6\u4e5f\u53ef\u80fd\u662f\u9501\u8868\uff0c\u6700\u540e\u9644\u4e0a\u9501\u8868\u7684\u67e5\u8be2SQL\uff09\uff1a\n<\/p>\n

\n\tSELECT S.TITLE,S.DESCRIPTION
\n\t FROM FND_DESCRIPTIVE_FLEXS_VL S
\n\t WHERE S.TITLE LIKE '%\u652f\u7968\u5730\u5740%';
\n\t\u68c0\u67e5\u7ed3\u679c\u662f\u5426\u6709\u7a7a\u683c\uff0c\u5982\u679c\u6709\u7a7a\u683c\uff0c\u5c06\u7a7a\u683c\u53bb\u6389\uff0c\u7136\u540e\u5728\u754c\u9762\u4e0a\u8fdb\u884c\u5982\u4e0b\u64cd\u4f5c\uff1a
\n\t1.\u8fdb\u5165\u5230\u8bf4\u660e\u6027\u5f39\u6027\u57df\u6bb5\uff0c\u67e5\u51fa\u6807\u9898\u4e3a“\u652f\u7968\u5730\u5740”\u7684\u5185\u5bb9
\n\t2.\u53bb\u6389\u51bb\u7ed3\u5f39\u6027\u57df\u5b9a\u4e49\u7684\u52fe\uff0c\u7136\u540e\u5c06\u4ee3\u7801\u4e3aDEFAULT\u7684\u52fe\u53bb\u6389\uff0c\u4fdd\u5b58\uff0c\u52fe\u4e0a\u51bb\u7ed3\u5f39\u6027\u57df\u5b9a\u4e49\uff0c\u4fdd\u5b58\u5e76\u7f16\u8bd1\u5373\u53ef\u3002\u5982\u4e0b\u56fe\u6240\u793a\uff1a\n<\/p>\n

\n\t $\"payment\"$ <\/a>\n<\/p>\n

\n\t\u67e5\u8be2\u89e3\u9501\u5e76\u89e3\u9501\u547d\u4ee4\uff1a\n<\/p>\n

\n\tSELECT DOB.OBJECT_NAME TABLE_NAME,
\n\t LO.LOCKED_MODE,
\n\t LO.SESSION_ID,
\n\t VSS.SERIAL#,
\n\t VPS.SPID,
\n\t VSS.ACTION ACTION,
\n\t VSS.OSUSER OSUSER,
\n\t VSS.PROCESS AP_PID,
\n\t VPS.SPID DB_PID,
\n\t 'ALTER SYSTEM KILL SESSION ' || '''' || LO.SESSION_ID || ',' ||
\n\t VSS.SERIAL# || ''';' KILL_COMMAND
\n\t FROM V$LOCKED_OBJECT LO, DBA_OBJECTS DOB, V$SESSION VSS, V$PROCESS VPS
\n\t WHERE LO.OBJECT_ID = DOB.OBJECT_ID
\n\t AND LO.SESSION_ID = VSS.SID
\n\t AND VSS.PADDR = VPS.ADDR
\n\t ORDER BY 2, 3, DOB.OBJECT_NAME;<\/p>\n","protected":false},"excerpt":{"rendered":"