<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[alongsun的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/alongsun</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; alongsun]]></copyright><item><title><![CDATA[Oracle Cloud ERP use the rest API process Miscellaneous InventoryTransactions]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/128152049</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/128152049</guid><author>alongsun</author><pubDate>Fri, 02 Dec 2022 17:51:54 +0800</pubDate><description><![CDATA[Oracle Cloud ERP use the rest API process Miscellaneous InventoryTransactions]]></description><category></category></item><item><title><![CDATA[Oracle cloud ERP, [incomplete] button of AR disabled]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/128151818</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/128151818</guid><author>alongsun</author><pubDate>Fri, 02 Dec 2022 17:41:41 +0800</pubDate><description><![CDATA[Depends on the [Manage Receivables System Options] setting.]]></description><category></category></item><item><title><![CDATA[When deploy the war of SpringBoot project with jpa to weblogic, can not print sql log to file.]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/128151628</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/128151628</guid><author>alongsun</author><pubDate>Fri, 02 Dec 2022 17:27:37 +0800</pubDate><description><![CDATA[because the hibernate use the jboss logging, have to add the jboss lgging to weblogic.xml
org.jboss.*]]></description><category></category></item><item><title><![CDATA[What is the difference of PO Charge Account,PO Accrual Account and PO Variance Account]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/121824741</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/121824741</guid><author>alongsun</author><pubDate>Thu, 09 Dec 2021 17:05:29 +0800</pubDate><description><![CDATA[What is the difference of PO Charge Account,PO Accrual Account and PO Variance Account]]></description><category></category></item><item><title><![CDATA[Oracle ERP Cloud的erpIntegrationService自动FBDI后Download Job Log。]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/109644186</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/109644186</guid><author>alongsun</author><pubDate>Thu, 12 Nov 2020 15:21:23 +0800</pubDate><description><![CDATA[Oracle ERP Cloud（Oracle SaaS）要和别的系统连携导入数据的话，

是可以用FBDI手动导入到ERP系统中的。

手动有些麻烦，如果需要经常需要导入数据的话，可以写批处理程序自动导入FBDI的。

Oracle SaaS提供有Web API(REST,SOAP)可以支持自动导入。

SOAP的话，需要用到erpIntegrationService这个接口，里面有个方法是SubmitESSJobRequest

可以提交想要执行的Job。

执行完Job后，在SaaS上会生成Log文件]]></description><category></category></item><item><title><![CDATA[SpringBoot部署到Weblogic后的DB问题]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/105713352</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/105713352</guid><author>alongsun</author><pubDate>Thu, 23 Apr 2020 18:27:33 +0800</pubDate><description><![CDATA[总结一下遇到的问题，为遇到同样问题的同学提供些帮助。

SpringBoot部署到Weblogic后，发现DB的事务处理有问题。Debug程序发现程序的事务已经提交了，但要执行的SQL文没有被执行到。

原来的SpringBoot的DB连接配置是Spring datasource到Oracle DB，事务也是Spring的。

部署到Weblogic后发现DB的数据怎么都更新不了。

一通乱查，发...]]></description><category></category></item><item><title><![CDATA[SpringBoot Deploy to WebLogic]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/105362250</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/105362250</guid><author>alongsun</author><pubDate>Tue, 07 Apr 2020 13:17:20 +0800</pubDate><description><![CDATA[版本信息：

SpringBoot：2.0.2.RELEASE

web logic：Oracle WebLogic Server 12.2.1.4.0

1.编辑Pom.xm

・添加或修改编译后格式为War

&lt;packaging&gt;war&lt;/packaging&gt;

・添加依赖

 &lt;dependency&gt;
   &lt;gro...]]></description><category></category></item><item><title><![CDATA[财务模块 - 采购、接收、应付会计分录和功能认识]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104862031</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104862031</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 16:04:09 +0800</pubDate><description><![CDATA[一、企业采购业务
采购业务是一般企业都会有的业务，主要包括请购、采购、接收、入库、发票、付款几个步骤。分别对应采购、库存、成本、应付以及总账模块。
Oracle是财务业务一体化的系统，只要录入了相应的业务，则会自动生成相应的财务信息。1、采购接收
采购模块主要功能是帮助业务部门管理采购订单，控制采购流程，审批层次，在请购单、和采购订单录入审批阶段是不产生财务信息的。
现假设企业采购两批原材料，价格...]]></description><category></category></item><item><title><![CDATA[Oracle EBS R12 总帐和子分类账关系详解]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104861724</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104861724</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 15:51:06 +0800</pubDate><description><![CDATA[子模块和GL之间关联的变化
12i在功能模块上的变化很多，比如，基本每个模块都启用了MOAC特性，新增加了子帐模块，税模块等等很多新的模
块，OPM库存和离散库存集成了。不过这些变化中，大部分不是我们需要重点关注的，不过有一个东西需要重点关注那就是子帐模块。子帐模块功能非常强大，现
在所有的子模块会计分录都可以使用特定的公式配置出来。但是对技术而言，我们不太关心如何配置生成会计分录，我们只关心子模...]]></description><category></category></item><item><title><![CDATA[EBS中预付款的核销：“发票上的预付款”和“核销”两个按钮的含义(Prepayment on invoices VS apply)]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104861678</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104861678</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 15:49:56 +0800</pubDate><description><![CDATA[Example

Prepayment Invoice -&gt; amount=100

Standard Invoice -&gt; amount=1000



Case 1

Apply check box

This is checked when the Prepayment amount has been paid and Supplier sends a Stan...]]></description><category></category></item><item><title><![CDATA[R12 表详解系列—-总账]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104860802</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104860802</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 15:09:09 +0800</pubDate><description><![CDATA[分类帐表
用于存储币种、日历和科目表信息的主表包括：
•FND_CURRENCIES
•GL_PERIOD_SETS
•GL_PERIODS
•GL_PERIOD_STATUSES
•GL_PERIOD_TYPE
•FND_ID_FLEX_STRUCTURES
•GL_LEDGERS
•GL_CODE_COMBINATIONS
FND_CURRENCIES 和 FND_ID_FLE...]]></description><category></category></item><item><title><![CDATA[EBS R12版 GL追溯到各个模块]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104860670</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104860670</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 15:04:49 +0800</pubDate><description><![CDATA[应收、应付、收款、付款等单据都可以生成ERP的日记帐，那么这些模块的关系是如何关联的呢，我们将会解决这个问题。
各个模块与总帐模块的关系，主要是通过子分类帐来进行关联的。
下面的SQL就是总帐与子分类帐的关联关系：
SELECT *
 FROM gl_je_headers jh
   ,gl_je_lines jl
   ,gl_import_references gir
  ...]]></description><category></category></item><item><title><![CDATA[Oracle EBS常用数据表]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104860646</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104860646</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 15:01:19 +0800</pubDate><description><![CDATA[INV库存
organization 两个含义:
1. 经营单位，A/B/C分公司，A下面有A1，A2等工厂，主题目标是为了独立核算此组织
ORG，ORG_ID;
2. 库存组织，例如制造商的仓库，例如A1，A2等工厂
Organization_id;

HR_ORGANIZATION_UNITS －
Org_organization_definitions
Mtl_subinventory_ 库...]]></description><category></category></item><item><title><![CDATA[怎么样从Oracle ERP Cloud只抽出增量数据。]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104860198</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104860198</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 14:50:26 +0800</pubDate><description><![CDATA[Oracle ERP Cloud抽出数据比较方便的工具就是BIP。

BIP里面可以创建Data Model，这里可以直接写抽出SQL，然后关联到Report可以手动下载数据也可以FTP传送或Mail传送等。

有个问题就是，你只能抽出Oracle SaaS的数据，不能更新SaaS里面的数据被抽出了标记。

定义一个定时执行Job，只抽增量的话，就只能想别的办法。

有个表REQUEST_HIST...]]></description><category></category></item><item><title><![CDATA[oracle EBS采购订单（PO）各表作用分析]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104860146</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104860146</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 14:36:43 +0800</pubDate><description><![CDATA[一、采购订单（路径：PO/采购订单/采购订单）

1、po_headers_all 采购订单头表

2、po_lines_all 采购订单行表

--po_header_id=po_headers_all.po_header_id

--此表是保存采购订单的行信息

3、po_line_locations_all 采购订单行的发送表

--po_line_id=po_lines_all.po_li...]]></description><category></category></item><item><title><![CDATA[ORACLE EBS AP发票到付款的数据流]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/104859827</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/104859827</guid><author>alongsun</author><pubDate>Sat, 14 Mar 2020 14:19:32 +0800</pubDate><description><![CDATA[--1.发票创建时生成数据如下表
--发票主表
SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001';
--发票分配表
SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444;
--发票付款计划表
SELECT * FROM A...]]></description><category></category></item><item><title><![CDATA[vb.net2005 用API打开文件夹对话框和设定默认路径。]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/1857546</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/1857546</guid><author>alongsun</author><pubDate>Tue, 30 Oct 2007 17:48:00 +0800</pubDate><description><![CDATA[新建一个窗体，添加一个textbox 和一个button，拷贝下面的代码。 Imports System.TextImports System.Runtime.InteropServicesPublic Class OpenFolder_OK    Private Delegate Function fbCallBack(ByVal hWnd As Integer, ByVal uMs]]></description><category></category></item><item><title><![CDATA[常用正则表达式]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/1210997</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/1210997</guid><author>alongsun</author><pubDate>Tue, 12 Sep 2006 09:42:00 +0800</pubDate><description><![CDATA[ 摘要：收集一些常用的正则表达式。正则表达式用于字符串处理，表单验证等场合，实用高效，但用到时总是不太把握，以致往往要上网查一番。我将一些常用的表达式收藏在这里，作备忘之用。本贴随时会更新。匹配中文字符的正则表达式： [/u4e00-/u9fa5]匹配双字节字符(包括汉字在内)：[^/x00-/xff]应用：计算字符串的长度（一个双字节字符长度计2，ASCII字符计1）St]]></description><category></category></item><item><title><![CDATA[常用网站介绍]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/769250</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/769250</guid><author>alongsun</author><pubDate>Fri, 02 Jun 2006 10:14:00 +0800</pubDate><description><![CDATA[ASP.NET 中的正则表达式http://www.microsoft.com/china/msdn/library/webservices/asp.net/regexnet.mspx?mfr=true正则表达式综合网站,上面有很多的模式,可以直接的拿来用的.http://regexlib.com/.NET网站http://www.gotdotnet.com/http://www.do]]></description><category></category></item><item><title><![CDATA[正则表达式之全部符号解释]]></title><link>https://blog.youkuaiyun.com/alongsun/article/details/768413</link><guid>https://blog.youkuaiyun.com/alongsun/article/details/768413</guid><author>alongsun</author><pubDate>Thu, 01 Jun 2006 18:53:00 +0800</pubDate><description><![CDATA[                        字符             描述                            /             将下一个字符标记为一个特殊字符、或一个原义字符、或一个 向后引用、或一个八进制转义符。例如，n 匹配字符 "n"。/n 匹配一个换行符。序列 // 匹配 "/" 而 "/(" 则匹配 "("]]></description><category></category></item></channel></rss>