Dear Professionals, Please have the below requirement and send me your consultant resumes That fits the below job description.
Please reply at *chris.br...@panzersolutions.com*<chris.br...@panzersolutions.com> *Note :* This is not our direct client requirement.We have a single layer between us and the end client. Oracle SCM / Manufacturing Reports Developer Boston, MA 2+ Months Contract This resource would be expected to drive the technical design and be the EBS expert. The code to populate the table will likely be written in a combination of ODI and PL/SQL. We have a BI reports developer, and an ODI developer, available to assist. Technical Design Document in our project template Code (Client can contribute to non-EBS-specific aspects of report/ODI code) Create custom table One-time extract/load of 11i information Nightly extract/load 12 information Report Informal Unit Test Scripts in our project template *Exact description of what they will be doing :* ---------------------------------------------------------- We need to produce a report that combines 11i *OPM* and R12 Inventory Lot Genealogy information. The amount of information is significantly less than what’s in the standard reports – it’s basically the indented Bill of Materials with some supplemental information (transaction qty, uom, etc.). This person needs to understand the OPM & Inventory tables, and be able to extract code from the *OPM* Lot Genealogy (Oracle*Reports) and Inventory Genealogy (PL/SQL) reports for use in developing this solution. We have drafted a plan where we create a custom table (basically mtl_object_genealogy with additional fields) that contains the data both from 11i and R12. The 11i population will be a one-time load during cutover. The R12 data will be refreshed nightly/on-demand. A new custom BI report will then be sourced off that table. Unlike the standard reports, which run for exactly 1 Item/Lot combination, our report needs to run for several Items/Lots at a time. Thank you for your time and look forward to work with you. ____________________________________________________________ Thanks Chris Brown | Technical Recruiter Panzer Solutions LLC chris.br...@panzersolutions.com Direct: 203-652-1444*123 -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/groups/opt_out.