Process Manufacturing - EBS (MOSC)

MOSC Banner

how to show month if no sales

edited Nov 13, 2023 9:19AM in Process Manufacturing - EBS (MOSC) 2 commentsAnswered

Hi All,

Working in OPM

Version 12.2.10

how to show month if no sales in current year,

for example

in April there is sales but not in may and again june there is sales like wise

now what i am facing the problem is last year there is sales for May month but in current year there is no sales for May Month so it is skipping not showing data completely, so the report history sales not showing correct data,

I need some help, if no sales, show month

sample query

select distinct customer_name, to_char(trx_date,'Month') aa 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center