Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need to get Opening and Closing stock data from Orcle EBS.
Please let me know if anybody have worked on this. Any suggestions are greatly appreciated.
Thank you.
Regards,
Viresh
Does EBS stores the Ledger information?
Hi Anil,
I am attaching the sample data along with input and output data. we migrated the data from legacy system to Oracle EBS on 31/21/2017. So that data which is migrated from legacy to Oracle is my opening stock as on 31/12/2017.
Please find the attached sample and let me know for any questions.
Thank you.
Regards,
Viresh
I don't have s/w installed in my machine. Will look in the evening
Thank you...
I got access now. Can you tell me exactly you want to generate missing dates too?
yes.
Hi tried something but not getting the transaction quantity. and it is showing same quantity for all the days.
please find the attached script and screenshot as well.
I feel the issue is while calculating the opening and closing stock.
Thanks,
Viresh
Great, Some what we are in hurry.. So, Try to remove all synthetic keys first or do same implementation in Live to continue further..
Hi Anil,
I removed all synthetic keys but in the final output not getting the transaction qty. Please refer the image in the previous reply.
Thank you.