目前分類:未分類文章 (31)

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

==PL/SQL==

FND_MESSAGE.SET_STRING ('You have no freight data access authority .You need to get it first.Please contact local IT');
FND_MESSAGE.SHOW;

image


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

Error Messge :

image

[Solution]

image


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

APP-FND-00756: Cannot find combination CCID=-2 CODE=GL# SET=101

image

image

mtl_transaction_accounts

image

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

Please verify your setting as below picture.

Uncheck []Close Other Forms, then it should be ok now.

image


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

OM Order Header Processes

我們在新增OM Order Type時,會需要設定一組”Fulfillment Flow”,選單如下:

而每個Flow代表的流程是什麼呢?

image

這邊整理〔Order Flow - Generic〕的Flow Chart,供大家查閱..

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

目的:讓User 在Date 欄位可以使用下拉式選單

Subclass Information : TEXT_ITEM_DATE

image 

Trigger : Key_Listval

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

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

<說明> 敝公司教育Order key-in人員訂單都維護Schedule Arrival Date(SAD).,但常常有User會反應有時候會出現以下的錯誤訊息。

Error :

The order type is “Ship”. Schedule Arrival Date can’t be manually change.

Schedule arrival date can be recalculated if you change request date or schedule ship date.

image

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

這個User的Menu 上少了兩個 Cost Management的權限

但我們確定有assign也沒有失效

image

 

Execute Request by sequence..

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

APP-SQLAP-97198' When Matching an Invoice to a Purchase Order of Finally Closed Shipment (Doc ID 781983.1)

未避免AP Match無法選擇到Finally Closed PO

AP: Show Finally Closed POs Value 要設yes就看的到了..

image


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

How to create Select all “checkbox”

 

<Sample>

go_block('RECEIPT_MATCH');
first_recor;
LOOP
:RECEIPT_MATCH.SELECTION_CHECKBOX:='Y';--OR THE VALUE YOU WANT TO PASS

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

This job is doing backorder all open move order .(ps. it’s not work for WMS move order)

Below is what I do.

For you all reference.

/* Formatted on 2010/01/12 17:44 (Formatter Plus v4.8.8) */
DECLARE

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

以下是我安裝Oracle Form Developer 6i 工具紀錄

(Oracle 目前Developer 版本已經出到11g了,但因為我公司的application server,還是舊版的,所以依然還是使用R6做為開發的工具,故僅供有需要的人參考使用)

Software Prerequisition

  • Oracle Form 6i
  • Oracle Form Patch 16

基本上Oracle Form 6i Tool 應該可以在OTN下載的到,但是我實在是找不到link..所以無法提供給大家download位置,下次如果我不小心找到連結位置,會再Post上來跟大家分享。

下圖僅是我自己以前的保存的安裝檔

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

我們一般在建立一個簡單的Tabular Form的做法如下:

首先我先建立一個View for Query(F11)使用

In general, complex blocks are based on views while simple setup
blocks are based on tables.

透過View來呈現資料是比較簡單的方式:(節錄於Oracle Applications Developer’s Guide)

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

Updating Item Attributes to NULL

The method to update these columns to NULL is to use the following values:
· for Numeric fields: insert
-999999
· for Character fields: insert '!'

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

Profile

Variable

PO: MFG Organization ID :$PROFILES$.MFG_ORGANIZATION_ID
 

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

Prerequisites for this example

  1. 1.Oracle9i database
  2. 2.Oracle9i Report

 

Start ==>

1.Download and install the example files

   1.1 Go to the Oracle Technology NetworkWeb site(http://otn.oracle.com/product/reports/).Download the files BarcodePaper.zip and BarCodeWeb.zip into a temporary directory on your machine (e.g., d:\temp).

  Download Information:

  BarCodeWeb.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanWeb/index.html

  1.2 Unzip the contents of the file, maintaining the directory structure, into an examples directory on your machine

2. Update the REPORTS_CLASSPATH environment variable

oraclebarcode.jar folder path to your client regedit “REPORTS_CLASSPATH”

  ex. ORACLE_HOME/Examples/BarCodeBeanPaper/Scripts/oraclebarcode.jar;

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

Updating Item Attributes to NULL

The method to update these columns to NULL is to use the following values:
· for Numeric fields: insert -999999
· for Character fields: insert '!'

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

About Global Parameter or Form Personalize you shall know.

  • GLOBAL variables are dynamically created at runtime
  • They can hold up to 255 bytes
  • They are visible across all forms that are currently running

2 Properties affect them:

  • VALUE:

–Creates it if it does not exist

–Always sets the value

  • INITIAL VALUE:

–Creates it if it does not exist, setting it to null

–Only sets the value if it is currently null

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

問題:使用Personal Framework 開Workflow List 出現此錯誤

image

Solution: Reference Doc ID: 296470.1

Starting with Oracle Applications 11.5.10, all PL/SQL web cartridge UI has been obsoleted. As a result, please use the Framework version of Portal.  Make sure that the profile option Self Service Personal Home Page is set to FRAMEWORK ONLY at the SITE level and that the Workflow Administrator Web(NEW)  responsibility


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

Responsibility : Inventory Super User

1. Choose Organization to Destination Organization

2. Create Cost Type

Path : Setup > Costs > Cost Types

image

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

1 2
找更多相關文章與討論