Oracle eBS經驗分享

Responsibility : Receivables Super User

Navigator : Setup > System > System Options

[Tab] Trans and Customers

Q: How to set the start sequence number for customer numbering ?

A:

Responsibility : Application Developer
Navigator: Application> Database > Sequence

Query on sequence RA_CUSTOMERS_NUM_S and set Start Value to 9999 (You want) .

Issue : Cannot choose item when create IR line.

Issue Description :

There are three inventory organizations A/B/C under SGB-OU. One item XX has been assign to org B but not assign to org A. User want to source item to B org, but they cannot select the item when the create IR line.

Root cause :

But system just can reference one inventory org when we create IR line.System will fetch the item exists in the inventory org (A).

Solution

Change the "Finance option” setting or assign the item to org A.

You can setup the picking order by each locator.

For example

There are some pick tasks of two locators in my control board.

If I set FGI-AR-01-03 picking order is larger than FGI-AR-01-04

My picker will get FGI-AR-01-04 first.

On opposite sides

If I set FGI-AR-01-04 picking order is larger than FGI-AR-01-03.

System will assign FGI-AR-01-03 first

資料來源：Oracle Pending Transactions Guide page 21 of 32.

In resolving Pending Receiving Transactions the status and quantity received of the actual purchase order of the receiving transaction should be reviewed. If after reviewing the Purchase Order if the status is closed or complete and the purchase order quantity is equal to the quantity received then most likely the Pending Receiving transaction is a duplicate. Duplicate transactions can be deleted through the ‘Transaction Status Summary’ screen by clicking on the transaction line and then clicking on the delete icon.

如果資料已經存在RCV_Transactions , 代表資料重複了，所以可以從Pending receiving 畫面上的Delete鍵直接刪除。

Receiving transactions are processed through RCV_TRANSACTiON_INTERFACE table by submitting the ‘Receiving Transaction Processor’ (short name RVCTP).

{Error} Mobile System : Internal Error - Task_Merge_Aplit API - LOAD_SINGLE. Press any key to continue.

<Root cause>

You are not able to pick tasks in the mobile environment when the task quantity is a large number (8 digits or more). You have created a task for quantity 10000000 (8 digits). Release the order and attempt to pick using the mobile. The following error is seen:

Internal error- Task_Merge_Split API - LOAD_SINGLE. Press any key to continue.

During Picking Tasks, when the quantity to be loaded is huge, java sends this quantity in exponential format to PLSQL. While applying the format mask to this quantity, exception was raised as it is not a number.

< Solution >  因為撿貨數量過大，quantity 超過 10000000，將數量拆掉後，再做pick