Oracle eBS經驗分享

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

Error Messge :

[Solution]

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

mtl_transaction_accounts

Please verify your setting as below picture.

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

OM Order Header Processes

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

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

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

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

Subclass Information : TEXT_ITEM_DATE

<說明> 敝公司教育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.

<問題原因>

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

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

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就看的到了..

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
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;

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.

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

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

Software Prerequisition

• Oracle Form 6i
• Oracle Form Patch 16

我們一般在建立一個簡單的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)

1. 1.Network traffic is minimized because all foreign keys are denormalized on the server
2. 2.You do not need to code any POST–QUERY logic to populate non–database fields
   3.You do not need to code PRE–QUERY logic to implement query–by–example for non–database fields

[Query Data Souce Name] : View Name

[DML Data Target ]

Column 上的設定

DML Table Column - 要設定一個Primiary Key Column

Non DML Table Column Setting

ps. 此Column 要能夠讓User 從 LOV選擇，並儲存 ID 值到DML table中

注意:如果Column是要Query by view, 但寫入時不寫入DML Table的，其property中”Query Only”要設定成”Yes”(如下圖)

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:

•   BarcodePaper.zip download from http://www.oracle.com/technology/products/reports/htdocs/getstart/examples/BarcodeBeanPaper/index.html

  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;

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 '!'

· for Date fields: the above list does not include any updateable date fields.

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

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

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

Responsibility : Inventory Super User

1. Choose Organization to Destination Organization

2. Create Cost Type

Path : Setup > Costs > Cost Types

Multi-Org : Share this cost type with other org.

3. Run "Copy Item Information" Concurrent

Path : Costs > Cost Mass Edits > Copy Cost Information

Choose Program Name = "Copy Item Costs Across Organizations"

Parameters

• Copy Option : Remove and replace all cost information

The AR_DISTRIBUTIONS_ALL table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions. The records are joined to the AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_ADJUSTMENTS, AR_RECEIVABLE_APPLICATIONS_ALL, and AR_TRANSACTION_HISTORY_ALL tables.