{"id":1678,"date":"2019-10-09T11:41:09","date_gmt":"2019-10-09T03:41:09","guid":{"rendered":"http:\/\/www.llku.com\/?p=1678"},"modified":"2019-10-09T14:07:06","modified_gmt":"2019-10-09T06:07:06","slug":"ebs-r12-2-6%e7%b3%bb%e7%bb%9f%e8%b5%84%e4%ba%a7%e6%a8%a1%e5%9d%97%e6%8a%98%e6%97%a7%e6%9c%aa%e4%bc%a0%e6%80%bb%e8%b4%a6%e9%97%ae%e9%a2%98%e5%a4%84%e7%90%86","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1678","title":{"rendered":"Oracle EBS R12.2.6\u7cfb\u7edf\u8d44\u4ea7\u6a21\u5757\u6298\u65e7\u8d26\u52a1\u672a\u4f20\u603b\u8d26\u95ee\u9898\u5904\u7406"},"content":{"rendered":"

\u80cc\u666f\uff1a<\/p>\n

\u67d0\u5ba2\u6237\u572810\u67088\u53f7\u8fd0\u884c9\u6708\u6298\u65e7\u540e\uff0c\u521b\u5efa\u4f1a\u8ba1\u53d1\u73b0\u8bf7\u6c42\u62a5\u9ec4\uff08\u4f46\u662f\u80fd\u628a9\u6708\u7684\u6298\u65e7\u6570\u636e\u6b63\u5e38\u4f20\u8fc7\u53bb\uff09\uff0c\u4e8e\u662f\u770b\u521b\u5efa\u4f1a\u8ba1\u79d1\u76ee\u8f93\u51fa\u62a5\u8868\uff08\u6216\u8005\u770b\u8d44\u4ea7\u6a21\u5757\u201c\u5b50\u5206\u7c7b\u5e10\u671f\u95f4\u5173\u95ed\u4f8b\u5916\u62a5\u8868\u201d\uff09\uff0c\u53ef\u4ee5\u53d1\u73b0\u91cc\u9762\u6709\u5927\u91cf7\u670831\u53f7\u7684\u6570\u636e\uff0c\u90fd\u662f\u5f88\u660e\u786e\u7684\u63d0\u793a\u5982\u4e0b\u6240\u793a\u5185\u5bb9\uff0c\u65e0\u6548\u671f\u95f4\uff1a
\n $\"\"$ <\/a><\/p>\n

\u6b64\u7c7b\u95ee\u9898\u539f\u56e0\u5f88\u591a\uff0c\u672c\u4eba\u9047\u5230\u8fc7\u4ee5\u4e0b\u51e0\u79cd\u60c5\u51b5\uff0c\u4ee5\u9891\u7387\u6392\u5e8f\uff1a
\n1\u3001\u8d44\u4ea7\u4f20\u603b\u8d26\u65f6\u672a\u6b63\u5e38\u4f20\u81f3GL\u6a21\u5757\uff08\u603b\u8d26\u671f\u95f4\u6b63\u5e38\u6253\u5f00,\u6b64\u79cd\u60c5\u51b5\u53ef\u6839\u636e\u4f8b\u5916\u62a5\u8868\u7684\u63d0\u793a\u5904\u7406\uff0c\u518d\u6b21\u4f20\u603b\u8d26\u5373\u53ef\uff09\uff1b<\/p>\n

2\u3001\u8d44\u4ea7\u4f20\u603b\u8d26\u65f6\u672a\u6b63\u5e38\u4f20\u81f3GL\u6a21\u5757\uff08\u603b\u8d26\u671f\u95f4\u5173\u95ed\uff09\uff1b<\/p>\n

3\u3001\u4ea4\u53c9\u9a8c\u8bc1\u89c4\u5219\u5bfc\u81f4\u751f\u6210\u8d26\u52a1\u95ee\u9898\uff08\u8fd9\u79cd\u60c5\u51b5\u5f88\u5c11\uff0c\u4e00\u822c\u5728\u65b0\u673a\u6784\u5efa\u7acb\u65f6\u53ef\u80fd\u6709\uff09\u3002<\/p>\n

\u5177\u4f53\u5230\u672c\u6b21\u95ee\u9898\uff0c\u7ecf\u8fc7\u8ffd\u6eaf\uff0c\u53d1\u73b0\u7528\u6237\u57287\u670831\u53f7\u665a\u4e0a5\u70b903\u5206\u63d0\u4ea4\u4e86\u8fd0\u884c\u6298\u65e7\u7684\u8bf7\u6c42\uff0c\u4f46\u662f\u5728\u8bf7\u6c42\u672a\u5b8c\u6210\u65f6\uff0c\u7acb\u5373\u63d0\u4ea4\u4e86\u521b\u5efa\u4f1a\u8ba1\u79d1\u76ee\u5230\u603b\u8d26\u6a21\u5757\uff08\u9ed8\u8ba4\u4f1a\u5c06\u8d44\u4ea7\u76f8\u5173\u8d26\u52a1\u5904\u7406\u4f20\u603b\u8d26\uff09\u3002\u5bfc\u81f47\u6708\u65b0\u589e\u8d44\u4ea7\u6570\u636e\u79d1\u76ee\u548c\u4e2d\u8f6c\u79d1\u76ee\u90fd\u6b63\u5e38\u5230\u4e86\u603b\u8d26\u6a21\u5757\uff08\u7528\u6237\u68c0\u67e5\u65f6\u68c0\u67e5\u4e86\u4e2d\u8f6c\u79d1\u76ee\u4e3a0\uff0c\u672a\u518d\u505a\u6df1\u5165\u6838\u5b9e\uff0c8\u6708\u6298\u65e7\u4e5f\u51fa\u95ee\u9898\uff0c\u7528\u6237\u672a\u5bdf\u89c9\uff09\u3002<\/p>\n

\u65b9\u68481\uff1a\u6253\u5f007\u6708\u671f\u95f4\u6b63\u5e38\u4f20\u81f37\u6708\u603b\u8d26\u6a21\u5757\uff0c\u7531\u4e8e\u7528\u6237\u53cd\u99887\u30018\u6708\u4efd\u62a5\u8868\u5df2\u7ecf\u51fa\u5177\uff08\u91d1\u878d\u884c\u4e1a\uff09\uff0c\u4e0d\u540c\u610f\u518d\u5f007\u6708\u671f\u95f4\u3002<\/p>\n

\u65b9\u68482\uff1a\u540e\u53f0\u4fee\u590d\u6570\u636e\u81f3\u5f53\u671f\uff089\u6708\uff09\uff0c\u5177\u4f53\u6267\u884c\u547d\u4ee4\u4e0d\u518d\u8d58\u8ff0\uff0c\u89c1\u4ee5\u4e0b\u811a\u672c\uff08\u6839\u636e\u81ea\u8eab\u60c5\u51b5\u9650\u5236\u6761\u4ef6\uff09<\/p>\n

–1\u3001\u5907\u4efd\u4e09\u4e2a\u8868\u7684\u95ee\u9898\u6570\u636e(\u5177\u4f53\u6761\u4ef6\u6839\u636e\u81ea\u8eab\u95ee\u9898\u9650\u5236)
\nselect t.*
\nfrom xla_ae_headers t
\nwhere 1 = 1
\nand to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.gl_transfer_status_code = ‘N’;<\/p>\n

select *
\nfrom xla_ae_lines t
\nwhere 1 = 1
\nand to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.ae_header_id in
\n(select t.ae_header_id
\nfrom xla_ae_headers t
\nwhere 1 = 1
\nand to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.gl_transfer_status_code = ‘N’);<\/p>\n

select *
\nfrom xla.xla_events# t
\nwhere t.event_type_code = ‘DEPRECIATION’
\nand to_char(t.event_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\norder by t.transaction_date desc;<\/p>\n

–2\u3001\u66f4\u65b0\u4e09\u5f20\u8868,\u6309\u987a\u5e8f\u4ee5\u514d\u540e\u7eed\u65e0\u6cd5\u5173\u8054,\u66f4\u65b0\u7684\u65f6\u5019\u6700\u597d\u770b\u4e00\u4e0b\u6761\u6570\u662f\u5426\u6b63\u786e
\nupdate xla_ae_lines t
\nset t.accounting_date = to_date(‘2019-09-30’, ‘yyyy-mm-dd’)
\nwhere 1 = 1
\nand to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.ae_header_id in
\n(select t.ae_header_id
\nfrom xla_ae_headers t
\nwhere 1 = 1
\nAND to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.gl_transfer_status_code = ‘N’);<\/p>\n

update xla_ae_headers t
\nset t.accounting_date = to_date(‘2019-09-30’, ‘yyyy-mm-dd’),
\nt.period_name = ‘2019-09’
\nwhere 1 = 1
\nand to_char(t.accounting_date, ‘yyyy-mm-dd’) = ‘2019-07-31’
\nand t.gl_transfer_status_code = ‘N’;<\/p>\n

update xla_events t
\nset t.transaction_date = to_date(‘2019-09-30’, ‘yyyy-mm-dd’),
\nt.event_date = to_date(‘2019-09-30’, ‘yyyy-mm-dd’),
\nt.event_status_code = ‘P’,
\nt.process_status_code = ‘P’
\nwhere t.event_type_code = ‘DEPRECIATION’
\nand to_char(t.event_date, ‘yyyy-mm-dd’) = ‘2019-07-31′;<\/p>\n

\u6269\u5c55\uff1a<\/p>\n

LOOKUP_TYPE LANGUAGE LOOKUP_CODE MEANING DESCRIPTION
\nXLA_EVENT_PROCESS_STATUS US D Draft Draft
\nXLA_EVENT_PROCESS_STATUS US E Error Error
\nXLA_EVENT_PROCESS_STATUS US I Invalid Invalid
\nXLA_EVENT_PROCESS_STATUS US P Processed Processed
\nXLA_EVENT_PROCESS_STATUS US R Related Event In Error Related Event In Error
\nXLA_EVENT_PROCESS_STATUS US U Unprocessed Unprocessed<\/p>\n

LOOKUP_TYPE LANGUAGE LOOKUP_CODE MEANING DESCRIPTION
\nXLA_EVENT_STATUS US I Incomplete Incomplete
\nXLA_EVENT_STATUS US N No Action No Action
\nXLA_EVENT_STATUS US P Processed Processed
\nXLA_EVENT_STATUS US U Unprocessed Unprocessed<\/p>\n

SELECT * FROM APPS.FND_LOOKUP_VALUES WHERE LOOKUP_TYPE =’XLA_EVENT_PROCESS_STATUS’ ;<\/p>\n

SELECT * FROM APPS.FND_LOOKUP_VALUES WHERE LOOKUP_TYPE =’XLA_EVENT_STATUS’ ;<\/p>\n

\u65e5\u671f\u65e0\u8bba\u6539\u5230\u54ea\u5929\u90fd\u4f1a\u5728\u671f\u95f4\u7684\u6700\u540e\u4e00\u5929\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"