Please have the below requirement and send me your consultant resumes That
fits the below job description.
Please reply at
*Note :* This is not our direct client requirement.We have a single layer
between us and the end client.
Oracle SCM / Manufacturing Reports Developer
2+ Months Contract
This resource would be expected to drive the technical design and be the
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
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
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
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.
Chris Brown | Technical Recruiter
Panzer Solutions LLC
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to firstname.lastname@example.org.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/groups/opt_out.