隨手筆記

今天遇到一個問題,

外包工單在release 後未產生PR,

經查詢PR interface是有資料的,

但發生了錯誤,所以並未建立PR成功,

錯誤訊息為 Please enter a valid Deliver to Location

在PR interface的該筆資料中此欄位為null(DELIVER_TO_LOCATION_ID)

查詢原因為  Department linked with the OSP resource is not having a Location specified.

參考文件 Doc ID 968639.1 (Oracle Support文件)

參考Table : PO_INTERFACE_ERRORS  ,  po_requisitions_interface_all  ,  hr_organization_units

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

CAUSE

Department linked with the OSP resource is not having a Location specified.

SOLUTION

To implement the solution, please execute the following steps:

1. Go into the responsibility [R] Bills of Material (method A)

Alternate way is by using
- for Enterprise Asset Management (EAM) use [R] Enterprise Asset Management (method B)
- for Work In Process (WIP) use [R] Manufacturing and Distribution Manager (method C)

2. Navigate to [N] Routings -> Departments, form name BOMFDODP

Alternate way is
- method B, [N] Setup -> Routing - Departments, form name BOMFDODP
- method C, [N] Bills of Materials -> Routings -> Departments, form name BOMFDODP

2A. If prompted, select the organization

3. Query the department and add a location. Save the change

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.