Oracle eBS經驗分享

功能說明：透過Security設定，可以讓該Responsibility下的人只選擇的到特定的Segment Value.

避免立帳立錯…

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;

If we need write Oracle PL/SQL Program for concurrent program using.

We need create procedure (ex. xx_procedure)

This xx_procedure need has base two parameter.(errbuf out varchar2,retcode out number).

• Errbuf : Errbuf is one the paramter which will define in pl/sql to store procedure to get error messges into log file.
• Retcode: this parameter will be used to get the status of the concurrent program. It will give the values
  - 0 for sucess
  - 1 for warning
  - 2 for errors

Issue :

Solution :

[Unassign from trip]

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.