目前日期文章:201010 (14)

瀏覽方式: 標題列表 簡短摘要

之前我們做XML report Excel輸出時,雖然RTF format上有崁入圖片,但只有PDF可以完整呈現。
如何讓使用 Word and Excel 輸出都可以秀出Logo呢?
請參下面說明:

1. Word 中圖片按右鍵『設定圖片格式』
2. 選擇"Web"
3. Entry ==> url:{'www.maximaltech.com/images/sImage/oracle_use.jpg'}

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

Reference Metalink Document ID 397364.1.

Oracle Order Management - Version: 11.5.7 to 12.0.5 - Release: 11.5 to 12.0
Information in this document applies to any platform.

---------------------------------------------------------------------------------------------------------------------

Goal

How does one close the order headers as soon as order lines are closed?
How does one modify the OEOH workflow by closing it immediately?

 

---------------------------------------------------------------------------------------------------------------------

Solution

The Standard Functionality will close the order header by last day of the month when all the lines are closed. To Close the order header as soon as the line is closed or to close the lines as per business scenario the following steps will be help to achieve the functionality. This will affect only new orders that uses this newly modified Flow. For the existing orders, one needs to wait till the end of the month - the month in which the Sales Order was created. Please note that this happens only for the month the Sales order is created.

Please perform the following steps in test instance:

1. Connect to the database using the Work flow Builder.
2. Go to OM order header work flow.

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

For Web ADI funtion

1. 本機Excel 設定要先設定安全性

image

image

2. Setup user profile first.

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

並不是所有Oracle Table都有支援儲存Multi-language data.

當你在Oracle Form Toolbar上看到小地球的icon,就代表我們可以儲存多國語言資訊。

image

image 

提供給大家參考囉

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Turn on前

image

Responsibility : Application Developer

1. Define your document entities

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

About Profile 【OM: Administer Public Queries】

image

Orders,Returns> Order Organizer

設定後的作用:

image

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Order Entry/Shipping provides the following application-level profile options to support your scheduling needs.

OE: Reservations
This profile option defines whether you manage your business by reserving on-hand available inventory at some point in the order process. A reservation allocates a reservable item's on-hand available inventory to a sales order line. Oracle Inventory does not include reserved inventory in Current On-hand Available balances, and Oracle Applications do not allow you to transact inventory reserved to another sales order or use it in an inventory material transaction.

With this profile option set to Yes, you can reserve on-hand quantities of an item on-line using the Sales Orders or Schedule Orders windows, or via OrderImport. If you have not reserved the item before releasing the item for shipment, Pick Release automatically reserves the item.

If this profile option is set to No, Order Entry/Shipping does not allow on-line reservations during scheduling, and Pick Release releases all eligible order lines regardless of stock availability.

OE: Autobackorder
If this profile option is set to Yes and there is insufficient quantity on hand to release a shipment, Pick Release automatically backorders the unavailable quantity (the order line status becomes Backorder Release - Eligible). If this profile option is set to No, the items are not released (the order line status remains Pick Release - Eligible).

The profile option OE: Reservations must be set to Yes for Order Entry/Shipping to recognize this profile option setting.

OE: Schedule Date Window
This profile option defines the number of days past the schedule date (including the schedule date) that the Demand Interface attempts to demand inventory. Inventory must be available for all items and options if you place demand for a ship set, ATO configuration, or Ship Model Complete PTO model. There is no limit on the value you can specify, but it must be greater than or equal to one day.

Pick Release ignores the value of this profile option, and its value is irrelevant when you attempt to demand part of a ship set or Ship Model Complete PTO model on-line.

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Click which value you want to delete , press “Ctrl+Shift+<”

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

資料來源:夏普視野

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

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

資料來源: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

DECLARE
x_return_status      VARCHAR2 (50);
x_msg_count          VARCHAR2 (50);
x_msg_data            VARCHAR2 (50);
v_item_id               NUMBER;
v_org_id                NUMBER; 
v_qoh                   NUMBER;
v_rqoh                  NUMBER;
v_atr                   NUMBER;
v_att                   NUMBER;
v_qr                    NUMBER;
v_qs                    NUMBER;
v_lot_control_code      BOOLEAN;
v_serial_control_code   BOOLEAN;
BEGIN 
  -- Set the variable values 
  v_item_id := 12758; 
  v_org_id := 91; 
  v_qoh := NULL; 
  v_rqoh := NULL; 
  v_atr := NULL; 
  v_lot_control_code := FALSE; 
  v_serial_control_code := FALSE; 
  -- Set the org context 
  fnd_client_info.set_org_context (1); 
  -- Call API 
  inv_quantity_tree_pub.query_quantities (p_api_version_number = 1.0
   , p_init_msg_lst             ='F' 
   , x_return_status            =x_return_status 
   , x_msg_count                =x_msg_count 
   , x_msg_data                 =x_msg_data 
   , p_organization_id          =v_org_id 
   , p_inventory_item_id        =v_item_id 
   , p_tree_mode                =apps.inv_quantity_tree_pub.g_transaction_mode -- or 3 
   , p_is_revision_control      =FALSE 
   , p_is_lot_control           =v_lot_control_code-- is_lot_control, 
   , p_is_serial_control        =v_serial_control_code 
   , p_revision                 =NULL   -- p_revision, 
   , p_lot_number               =NULL   -- p_lot_number, 
   , p_lot_expiration_date      =SYSDATE 
   , p_subinventory_code        =NULL   -- p_subinventory_code, 
   , p_locator_id               =NULL   -- p_locator_id, 
   -- p_cost_group_id           =NULL,  -- cg_id, 
   , p_onhand_source            =3 
   , x_qoh                      =v_qoh  -- Quantity on-hand 
   , x_rqoh                     =v_rqoh --reservable quantity on-hand 
   , x_qr                       =v_qr 
   , x_qs                       =v_qs 
   , x_att                      =v_att  -- available to transact 
   , x_atr                      =v_atr   -- available to reserve 
     ); 
  DBMS_OUTPUT.put_line ('On-Hand Quantity: ' || v_qoh); 
  DBMS_OUTPUT.put_line ('Available to reserve: ' || v_atr); 
  DBMS_OUTPUT.put_line ('Quantity Reserved: ' || v_qr); 
  DBMS_OUTPUT.put_line ('Quantity Suggested: ' || v_qs); 
  DBMS_OUTPUT.put_line ('Available to Transact: ' || v_att); 
  DBMS_OUTPUT.put_line ('Available to Reserve: ' || v_atr); 
EXCEPTION 
  WHEN OTHERS 
  THEN
    DBMS_OUTPUT.put_line ('ERROR: ' || SQLERRM);
END;

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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

image

image

[Preview Result]

image


SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

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); 

 

SomebabyTina 發表在 痞客邦 PIXNET 留言(0) 人氣()

Date and datetime fields should enable the List lamp. When the user invokes List on these fields, the form opens the Calendar window.

 

SOP

1. 選擇要設定的Item Property

2. 設定Item Data Type = Date or Datetime

SomebabyTina 發表在 痞客邦 PIXNET 留言(1) 人氣()

找更多相關文章與討論