R12 AP Invoice Distribution 產生的時間點

R12 在 ap invoice validate 後 Distribution 才會產生資料哦，跟 R11不同，所以一些報表需要改寫

R11 R12 table 差異

Oracle ERP 讀取 MASTER_ORGANIZATION_ID sql

select distinct t.parameter_value
  from ont.oe_sys_parameters_all t
   where t.parameter_code like 'MASTER_ORGANIZATION_ID';

Oracle ERP R12 Java Concurrent Program

公司正在導入 ERP R12，還是不太習慣 Form, Report 的開發
所以想要看看  java concurrent program 的方法是否有比較好用

這邊有一篇文章可以看看，我自己也在學習中

Oracle Support Knowledge

Error creating AIR file: 305: ERROR, 10

最近要換新電腦，把程式搬到新電腦後，只裝 flex 3 plug-in for eclipse ，再開啟以前的專案要想重新 compile air 的程式再作匯出，看看是否正常，在 compile時沒什麼問題，但匯出時出現如標題的錯誤，經網路上查詢後發現一個網站，經如其設定後就可以解決此問題。

我在想如果有安裝 flex 3 standalone的版本的話就不會發生此問題，應該是我只裝plug-in的版本所造成的吧。

CSS 應用分享 -- 排版

最近公司的網頁要改版，對於之前都在使用 Flex 開發程式的我來說，CSS是不怎麼熟悉的，

把美編給的圖片排成其想要的畫面真是讓我花了很多時間

有一個部份可以分享的是 div 的應用

div style="position:relative"
      div  style="position:absolute"
      /div
/div

第一個 div position設為 relative 

內部的 div 再設為 absolute，這樣的話，畫面放大、縮小，圖就不會亂跑了

這是最近學到的。

iis更換網站本機目錄的問題

這幾天有發生換了目錄之後，之前所設的虛擬路徑的程式都不能執行，只好全部 kill後再重建，

是我的操作步驟錯誤了嗎 ?

還有一個問題 ，如果網站的asp.net 版本設為 2.0.50724 ，虛擬目錄設為1..1.4322 這樣可以嗎?

希望好心人事可以回答

Oracle EBS Payable 模組 table for R11 R12 的差別

相關文章，目前還在實作如何作到 SQL for GL Drill Down to AP
在 oracle support 有一篇文章有說到

 mapping Between Subledger Tables, SLA and GL Tables

LA: A TECHNICAL PERSPECTIVE OF THE AP TO GL RECONCILIATION

SLA: Subledger Accounting Reference Articles


general ledger ap -> gl  transaction drill down


How to link GL data to the subledger data or vice versa


SQL for Drill Down from AP

How to join GL tables with XLA (SubLedger Accounting) tables

百度文件

SQL for Drill Down from AR

R12 AR  R12 AR Tables
R12 Table Relation

OAuth authorization with Flash and Flex apps

目前有看到相關設定的 video ，可以參考看看

連結網址

Oracle 全文檢索

參考文章
http://space.itpub.net/13379967/viewspace-474767
oracle全文檢索（oracle text）
http://winie.javaeye.com/blog/663835
http://hi.baidu.com/lzycsd/blog/item/f083473835da4f2897ddd878.html
1.

create table WT_LIGHTING_S_INDEX
(
  SOURCE_ID   NUMBER,
  ID          NUMBER,
  DESC1       VARCHAR2(4000),
  CREATE_DATE DATE
)


2.ctx_ddl.create_preference ('lighting_lexer', 'chinese_lexer');

3.CREATE INDEX wt_lighting_index ON WT_LIGHTING_S_INDEX(DESC1)

indextype is ctxsys.context parameters('lexer lighting_lexer');

alter user lighting quota unlimited on users;

 GRANT EXECUTE ON CTXSYS.CTX_DDL 

OpenSSO (OpenAM) web service security 資源

http://www.stormacq.com/?p=385

這個文章的部份內容，因為還沒實作，怕這個網站消失不見，所以就先截取下來了。

An Open Source implementation is also available from ForeRock’s OpenAM.

To summarize, a Secure Token Service is a third-party broker where Web Services clients can authenticate and receive a security token to be sent to a Web Service Provider.  The Web Service Provider will, in turn, validate the token and to evaluate authentication and authorization decisions.

The best STS description / tutorial I found on the web is on a deprecated page of Microsoft’s MSDN.  If you don’t know about STS, I highly recommend to read this serie of articles.

After installing / setting up OpenSSO / OpenAM, you will be ready to configure the STS part.

There are three approaches to interact with STS Server

Approach #1 – STS’s WSDL definition

This is the platform agnostic approach.  Just rely on STS’s WSDL definition to generate whatever client code you will need.

Unfortunately, on Java SE 6, this approach fails because of incompatibilities in OpenSSO’s STS WSDL definition and JAX-WS.

ForgeRock’s community is tracking this issue under Bug ID 287 and Bug ID 306

Stay tuned on ForgeRock’s JIRA for more details on this approach.

Approach #2 : Using JAX-RPC and JSR 196 provider

JSR 196 is a SPI specification allowing to hook a filter inside a container.  This filter will be invoked for all incoming and outgoing JAX RPC call, allowing it to be used for logging or security purposes for example.

OpenSSO and OpenAM do provide a JSR 196 provider for web service authentication (JSR 196) and authorization (JSR 115).  This provider is able to work with an STS provider.  The provider is available as part of openssowssprovider.jar JAR file.

While a little cumbersome to configure, this approach is working out of the box.  As long as you strictly follow the documentation.  Thesetroubleshooting steps will probably be useful as well.

However, this approach has a major drawback : it is JAX RPC based, i.e. quite old, now that the (Java) world has embraced JAX WS.  In other words, Oracle only supports this when the web service provider and the web service consumer are deployed into a GlassFish v2 instance.

So, if you want to use JAX WS, you will require a little more work.

Approach #3 – JAX WS

JAX-WS also provides hooks to intercept outgoing and incoming SOAP requests.  These hooks are named “Handler“.

The good news about Handlers is that they are web-app specific, unlike JAX-RPC JSR 196 provider which are installed at container level; hence for all your web applications.

You can think of an Handler as a Servlet Filter, dedicated to web service calls.  They can be part of a web app, to protect web services providers, or stand alone client, to protect web service consumers.  IBM has a very good documentation about using Handlers with JAX WS web services.

To test OpenSSO / OpenAM STS service with JAX WS handlers, I suggest you to read this tutorial.

All in all, this is an excellent step by step article, covering deployment in Tomcat, GlassFish and Websphere.

Unfortunately, you will soon realize that these step by step instructions are not working.

Problem #1 : Oracle removed the download link to openssowssagents.jar file.  Yes you read it right.  As of today, there is no binary distribution for the JAX WS Handlers and WSS Agents.  The JAR file is only available from ForgeRock.

Problem #2 : JAX-WS ClientHandler and ServerHandler are not included in openssowssagents.jar file.  So even, if you are downloading ForgeRock’s JAR file, you won’t get these two JAX WS handlers.

So the only solution is to download the source code and built it yourselves.  Building OpenSSO / OpenAM is not an easy task.  This product has many dependencies and historical (legacy) branches.  Anyway, your build will not be supported by Oracle nor ForgeRock.  For your convenience, here is a openssowssagents.jar file with the JAX WS classes included.

Should you have a valid support contract with Oracle and/or ForgeRock, do not hesitate to open a support case and see what / if /how they will handle this situation.

AIR SDK 2.5 URLRequest IOError 問題

AIR SDK 2.5 URLRequest 問題討論

我使用的是 burrito 開發，也會出現這樣的問題，找了半天才看到這篇文章～～

感謝天呀

Flex 存檔 charset問題

目前想在flex 上直接作存檔動作，flash 10 以後的版本可以直接存檔而不用透過server，在實作上有遇到中文亂碼的問題，本來以為使用 bytearray.writeUTFBytes() 的方式就可以解決問題，但後來發現不行，只能用筆記本打開才不會亂碼，用wordpad, excle 打開都是亂碼，看來是我太淺了.............

charset information

後來有找到解決方式如下：

var f:FileReference = new FileReference();

var _txtByte :ByteArray = new ByteArray();
......
......

 _txtByte.writeMultiByte(str,"cn-big5");  //繁体中文
f.save(_txtByte, "test.csv");



如果檔案要存成 excel的可以參考如下的文章
參考網址：  as3xls 中文解決方式
其方式改寫 excelFile.saveToByteArray 多一個 charset 參數 ，繁体中文可以設定 cn-big5

Clear Data Builder 3 自動產生的 Class 放那呢?

在 WEB-INF\lib

services-generated.jar
services-original.jar

FormsAuthentication RedirectFromLoginPage 使用

參考文章

就是要加上ReturnUrl=回存網址 才有用，要不然會被 導到 default 的網頁