Oracle eBS經驗分享

• Module : Web Applications Desktop Integrator (BNE)
• Responsibility : Desktop Integration

資料來源：夏普視野

直接改iexplore捷徑，加入-nomerge ("C:\Program Files\Internet Explorer\iexplore.exe" –nomerge )，完成。

資料來源：http://erpschools.com/Apps/oracle-applications/scripts/Supply-Chain-Management/Inventory/Get-On-Hand-Quantities-through-API/index.aspx#

Get On Hand Quantities through API

This script can be used to get the below quantities. 1. On-hand Quantity 2. Available to Reserve 3. Quantity Reserved 4. Quantity Suggested 5. Available to Transact 6. Available to Reserve You can also get the On-hand quantities from the table mtl_onhand_quantities

Create a block level KEY_DUPREC trigger and write NULL inside it.
It'll then prevent rows from duplicating.

How to set window title name on Oracle EBS Form?

==Code==

--1. 置換掉原來Winodw Property上的Title String

ex.

SET_WINDOW_PROPERTY('XXDII_INV_MISC_TXN_V',TITLE,:misc_trx_qf.Q_TYPE_NAME||'['||:misc_trx_qf.Q_MISC_TRX_NUM||']');

--2. 使用EBS Standard Library, 在Window title後加入Organization Name

app_window.set_title('XXDII_INV_MISC_TXN_V',:parameter.org_name); 

[Preview Result]