Oracle EBS OM App, Ship Confirm 後, line 無法 Close

解法參考: Ship Confirm 後, line 無法 Close

JSF 轉換器及驗證器介紹

介紹如何使用 JSF 的轉換器及驗證器, 顯示並驗證表單的資料. 此外, 也介紹如何停用(disable)及繞過(pass by)驗證器轉跳其他頁面

全文: https://hychen39.github.io/jsf_teaching/2018/11/15/JSF_Unit08.html

頁面樣板(JSF Templates)

介紹如何使用 JSF 樣板製作頁面, 使得每個頁面可以有相同的頁首, 頁尾或共同的顯示外觀。

全文參考: https://hychen39.github.io/jsf_teaching/2018/10/31/JSF_Unit07.html

Show the message generated from the PL/SQL process

We need to show the messages from the PL/SQL process (back-end) to the user (front-end) very often.

One way is to use the global variable APEX_APPLICATION.G_PRINT_SUCCESS_MESSAGE. The Apex will shows the message in the upper right corner with the green box. The method is suitable for showing information that doesn’t need the user to interact with.

The second way is to use APEX_ERROR.ADD_ERROR procedure to add the message to the error stack. When loading the page, the Apex will show these messages. We can specify the locations of showing the messages either on the upper right corner or associate with pages items or event an error page. However, the APEX_ERROR.ADD_ERROR procedure will interrupt the request processing process such that the codes after the APEX_ERROR.ADD_ERROR will not be executed. The method is appropriate for the form validation.

This article presents another way to show the message from the PL/SQL process. We use the Application Item to store the message from the PL/SQL process. There is a Application Process executing on the page loading to show the message in the Application Item using the JS functions in the apex.message namespace.

See the full article: https://hychen39.github.io/oracle_apex/2018/10/17/apex_messages_app_item.html

Enhance orclapex maven plugin to use NaturalDocs 2.x to generate pl/sql API documents.

Use the orclapex maven plugin with the NaturalDocs 2.x to generate pl/sql API document.

See https://github.com/hychen39/orclapex-maven-plugin/blob/master/README-1.0.4.md.

使用 Maven 匯出 Apex Application file 到本地端電腦

Export Oracle Apex Application from remote to local computers using Maven

Abstract
Oracle Apex application needs to be exported as a sql file from the Workspace in order to deploy to another workspace. Other than exporting manually, this article introduces an automatic way to export the Apex file and copy it to the local computer by using Maven. The automation enables automated build and release process.

Full article:
https://hychen39.github.io/oracl_apex/2018/08/29/export_apex_app_maven.html

PDF Utilities

Here two utilities that let us merge pdf files and add page numbers to the merged file. And, the best part is that we don't need the Acrobat to do that.

PDFSAM: Merge multiple pdf files
A PDF Number: Add page numbers to your pdf file.