PL/SQL (MOSC)

MOSC Banner

Sequential document number missing for a particular company code

edited Dec 30, 2018 4:04AM in PL/SQL (MOSC) 2 commentsAnswered

Hello, Document number 18000001 has been missing for a particular company code in fiscal year 2018. I mean to say document number 18000002 has not been utilised Whereas document number 18000003 and 18000004 exists for the company code in fiscal year 2018. Looking assistance to write sql/function to find where a document number is missed to post in sequential order. Regards, Sohail

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