I'm currently working on OBIEE 11g (default RPD) implementation with Oracle EBS R12 (Supply Chain, HR, Financial) as source system.I do not have prior knowledge on Oracle EBS R12 and any modules.
I have a task to identify how "Due Date" is getting calculated whether with Original "Promised date" field or not by looking into Informatica mappings.
As I do not have any prior knowledge in this, can anybody point me some documentation or link to know this calculation?
Any help on this will be highly appreciated.
Thanks in advance.
For purchased items, due date is calculated by looking at the Finished good demand date (such as sales order ship date).
Then Oracle backs out the manufacturing time (based on routing) and arrives at a date/time when the component is needed on the assembly line.
This is the due date.
Oracle then subtracts the Post processing lead time and arrives at the date/time the purchased material should arrive on the receiving dock. This is the need-by-date on the purchase order.
Thanks a lot for your reply.
I was just searching here and there for the proper information.
Can you just tell me one more thing? Is anywhere Oracle BI or ETL takes "Original Promised date" into consideration along with Need By Date?
Is it possible to copy paste the calculation here? If not then no issues.
I will just wait for your reply before closing this thread.