Setting Up BI Publisher Picking Plan and Goods Receipts Reports

Each template delivered by PeopleSoft Order Management has a data source associated to it. A data source defines how the XML data will be generated. Two data sources are delivered for producing the Picking Plan and Goods receipts respectively: OM_7000_PCK_PLN and OM_7000_GOODS_RECEIPT.

The data source type for Picking Plan is query and the one for Good Receipts is XML file. A XML file will be generated and will serve as the input to the PeopleTools APIs for BI Publisher.

This table shows all of the elements that are delivered in the BI Publisher Goods Receipts and Picking Plan solution

Report Definition

Data Source

Template

OM_GDSRCPT_M

OM_7000_GOODS_RECEIPT

OM_GDSRCPT_MAIN_ENG.rtf

OM_PCK_PLAN

OM_PCK_PLAN

OM_PICK_PLAN_ENG.rtf

The OM_GDSRCPT_M report definition contains two sub-templates. The table below shows the elements for these sub-templates.

Report Definition

Sub-Template Definition

Template

OM_GDSRCPT_M

OM_GDS_RCPT

OM_GDS_RCPT_ENF.rtf

OM_GDSRCPT_M

OM_BACK_ORD

OM_PICK_PLAN_ENG.rtf