Category Archives: Oracle BI related posts – Оракл Тайлан Шинжилгээний асуудлууд болон ойлголт

In this category, we can find Oracle Business Intelligence related problems, solutions and developments etc.

Requisition Processing Age by Purchasing Organization

Bi-n zarim negen report deer age-n medeelel haruulhad doorh age-uudiin noloolol:

Average UnProcessed Age Days = sysdate – requisition header approved date
Average Processed Cycle Time Days = purchase order line location approved date – requisition header approved date
Average Unfullfilled Age Days = sysdate – requisition header approved date
Average Fullfilled Cycle Time Days = purchase order line location shipment closed date (esvel purchase order line location closed for invoice date esvel closed for receiving date/ herev Receipt Required Flag ‘Y’ bol shuud Closed for Receiving Date baih )- requisition header approved date

Advertisements

BI-n date-g 0-r orluulah

BI deer date oruulsanii daraa tuhain date-g INT-ruu huvirgaj bolno. ingesniihee daraa tuhain date herev baihgui bol null-n orond 0 gej ogch bolno. uuniig SIL deer hiih ba doorh co-g ashiglaj bolno:
IFF(date!=null,p_date,0)