ERP Resources for Wine and Spirits Suppliers

The PLCB has implemented NEW SYSTEMS transforming its business from a traditional retail model to a wholesale/distribution, e-commerce and retail-focused business. Release 1 of Project New Horizon - our new enterprise resource planning platform - went live in January 2022, providing new finance and non-merchandise procurement systems. Release 2 went live July 2023, providing new systems that separate our wholesale and retail lines of business, changing the ways we procure wines and spirits, plan wholesale distribution, replenish stores and manage inventory and accounting. We also have a new Licensee Online Order Portal (LOOP) and a new and improved FWGS.com.

For information on how to access and use our self-service Oracle Supplier Portal and new Retail Special Order Portal, please refer to the training resources below.

For questions pertaining to use of the PLCB's new systems, please scroll to the contact list at the bottom of this page.

EXPLORE OUR TRAINING RESOURCES! We've developed a series of quick reference guides (QRGs), eLearning videos and step by steps for suppliers on how to use our new systems. In all, there are 39 new eLearning videos that will take 3-4 hours to review.

Course Title	Course Description
Project New Horizon Release 2 Supplier Overview Video	This video highlights the major changes impacting suppliers in Release 2 of the PLCB's Project New Horizon. (5:31)
Supplier - Wine, Spirits & Accessories Supplier (Merchandise Supplier) Registration QRG	This course reviews how Wine, Spirits & Accessories Suppliers (Merchandise Suppliers) can register with the PLCB. Note: Skip this step if already registered. See related eLearning: Wine, Spirits & Accessories Supplier (Merchandise Supplier) Registration eLearning (6:29)
Supplier - Oracle Supplier Portal Basic Navigation QRG	This course reviews how to navigate the new Oracle Supplier Portal including information on logging in and navigating the Welcome Springboard; session timeout and sign out; navigating the Supplier Portal screen; search functionality; and a profile management overview. See related eLearnings: Supplier - Log In, Navigate the Welcome Springboard and Sign Out eLearning (5:43) Supplier - Setting Preferences in Oracle Supplier Portal eLearning (2:05) Supplier - Searching in Oracle Supplier Portal - Quick Search Examples eLearning (3:17) Supplier - Searching in Oracle Supplier Portal – Basic Search Example eLearning (2:30) Supplier - Searching in Oracle Supplier Portal – Advanced Search Example eLearning (3:44) Supplier - Saving a Search in Oracle Supplier Portal eLearning (2:55) Supplier - Search by "Query by Example" Function eLearning (2:52) Supplier - Searching on the Manage Products Screen and Saving the Search eLearning (4:24) Supplier - Perform a Wildcard Search Query in Oracle Supplier Portal eLearning (1:42) Supplier - Overview of Profile Management eLearning (1:39)
Supplier - Manage Supplier Data in Oracle Supplier Portal QRG	This course reviews how to manage supplier data in the Oracle Supplier Portal including bank account data, tax information, contacts, addresses and change request tracking. See related eLearning: Supplier - Update Supplier Profile Using Oracle Supplier Portal eLearning (4:24)
Supplier - Create an Invoice in Oracle Supplier Portal QRG	This course reviews how to suppliers enter an invoice in the Oracle Supplier Portal. See related eLearning: Supplier – Create Invoice in Supplier Portal eLearning (5:19)
Supplier – View Consumption Advice, Invoice and Payments in Supplier Portal QRG	This course reviews how suppliers view consumption advices, invoices and payments in the Oracle Supplier Portal.
Supplier - View Invoices and Payments in Oracle Supplier Portal QRG	This course reviews how suppliers view invoices and payments in the Oracle Supplier Portal. See related eLearning: Supplier - View Invoices and Payments in Oracle Supplier Portal eLearning (4:14)
Supplier - Create and Submit Items in Oracle Supplier Portal QRG	This course reviews how suppliers use the Oracle Supplier Portal to submit requests for stock items stored in a PLCB distribution center (DC) and for direct store delivery (DSD) items sent directly to Fine Wine & Good Spirits (FW&GS) stores. See related eLearnings: Supplier - Create and Submit a Stock Parent Item in Oracle Supplier Portal eLearning (16:29) Supplier - Create and Submit Supplier SCC/GTIN Item in Oracle Supplier Portal eLearning (8:04) Supplier - Search Attributes in Oracle Supplier Portal eLearning (2:49)
Supplier - Create and Submit Special Order Items in Oracle Supplier Portal QRG	This course reviews how suppliers will use the new Oracle Supplier Portal to submit requests for Special Order (SO) items for sale to licensees through the Licensee Online Order Portal (LOOP) and retail customers through FWGS.com, and for direct delivery or delivery to Fine Wine & Good Spirits (FW&GS) stores or Licensee Service Centers (LSC) for customer pickup. See related eLearnings: Supplier – Create Special Order Items in the Oracle Supplier Portal elearning (11:23) Supplier - Search Attributes in Oracle Supplier Portal eLearning (2:49)
Supplier - Supplier Special Order - Adding (Supplier) Members in LOOP QRG *NEW*	This course reviews how authorized suppliers with an Administrator role, as designated by a licensee within the Licensee Online Order Portal (LOOP), can add additional team members from their supplier organization to create Special Orders (SOs) on behalf of the licensee to a licensee account. See related eLearning: Supplier - Supplier Special Order - Adding (Supplier) Members in LOOP eLearning
Supplier Create and Submit Item Updates in Oracle Supplier Portal QRG	This course reviews how suppliers use the new Supplier Portal to submit requests for updates to any item. See related eLearning: Supplier - Create and Submit Item Updates in Oracle Supplier Portal eLearning (3:01)
Supplier - Licensee Special Order Fulfillment QRG	This course reviews how suppliers fulfill licensee Special Orders (SOs) using the Oracle Supplier Portal and includes information on how to search for a licensee SO to view or fulfill; update a promised delivery date; print a shipping label; create an advance shipment notice (ASN); create an invoice; and cancel a licensee SO. See related eLearnings: Supplier - Search for FW&GS Store or LSC Pickup Special Order eLearning (6:00) Supplier - Update the Promised Delivery Date on a Licensee Special Order eLearning (4:37) Supplier - Print Licensee Special Order Shipping Label eLearning (4:11) Supplier - Create ASN for Licensee Special Order eLearning (5:46) Supplier - Create an Invoice in Oracle Supplier Portal eLearning (8:29)
Supplier - Retail Special Order Portal QRG	This course reviews how suppliers use the Retail Special Order Portal (RSOP) to fulfill and cancel Special Orders (SOs) placed by retail customers on FWGS.com. See related eLearning: Supplier - Retail Special Order Portal eLearning (12:55)
Supplier - Special Order Entry in LOOP QRG	This course reviews how suppliers enter a licensee Special Order (SO) in the new Licensee Online Order Portal (LOOP). Suppliers must be authorized by licensees before they can create SOs in LOOP. See related eLearning: Supplier - Special Order Entry in LOOP eLearning (8:19)
Supplier - Submit Responses and Monitor Negotiations QRG	This course reviews how suppliers use the Oracle Supplier Portal to respond to and monitor negotiations. The negotiation process will support the bi-annual item listing cycles as well as One-Time Buy (OTB) item negotiations. All stock items must have a corresponding negotiation created. See related eLearning: Supplier - Submit Responses and Monitor Negotiations eLearning (12:37)
Supplier - Oracle Supplier Portal Supply Chain Management (SCM) QRG	This course reviews how suppliers will use the Oracle Supplier Portal to review order forecasts; review purchase orders; manage min-max thresholds; create replenishment requests; create ASNs; review consumption advices; and manage supplier data. See related eLearnings: Supplier – Access and Review Order Forecast eLearning (7:51) Supplier – Review Order Forecasts by an Item eLearning (2:55) Supplier – Search for and Review Purchase Orders eLearning (2:46) Supplier – Update the Promised Date on a Purchase Order eLearning (3:51) Supplier – Manage Min-Max Thresholds eLearning (6:46) Supplier – Create a Replenishment Request Manually eLearning (4:03) Supplier - Create a Replenishment Request Using Mass Upload eLearning (5:48) Supplier – Manage Advance Shipment Notices (ASN) eLearning (5:03) Supplier - Cancel Advance Shipment Notices (ASNs) eLearning (1:50) Supplier - Review Consumption Advices in Oracle Supplier Portal eLearning (3:00) Supplier - Locate Oracle SCC Number for Supplier SCC/GTIN eLearning (2:14)

Please direct questions pertaining to use of the PLCB's new systems as follows:

For help updating your supplier profile (addresses, contacts, bank account data), contact ra-lbsupregreq@pa.gov.  
For questions on item listing, creation, set up and maintenance in the Supplier Portal, contact
ra-LBProductSelect@pa.gov.
For assistance with forecasting, bailment and non-bailment PO fulfillment and inventory management functions, contact your PLCB Planner or email ra-LBMerchPOSupport@pa.gov.
For status of invoice payment, contact ra-PLCBExceptionProcess@pa.gov.   
For questions on Consumption Advices and creating invoices, contact RA-LBSUPPLINV@pa.gov.
If you have questions about Special Order functionality, contact ra-lbslo@pa.gov.

ERP Resources for Wine & Spirits Suppliers