How to Enable Purchasing in Redwood Pages?

1. Opt-In / Offerings

Procurement > Redwood: Set up Purchasing

Redwood: Set Up Purchasing

You can now view and configure these setup pages using the Redwood experience:

• Procurement Agents
• Document Styles
• Change Order Template
• Procurement Document Numbering 
• Purchasing Line Types
• Special Handling Types
• Hazard Classes
• UN Numbers

Purchasing > Enable All Applicable Redwood Features

Suppliers > Enable All Applicable Redwood Features

Items > Enable All Applicable Redwood Features

Supplier Portal > Enable All Applicable Redwood Features

Sourcing > Enable All Applicable Redwood Features

Supplier Qualification > Enable All Applicable Redwood Features

2. Profile Options

Navigation: Setup and Maintenance > Task List > Manage Administrator Profile Values

2.1. Search with Profile Option Code %REDWOOD% and Application Purchasing

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_PO_ASL_REDWOOD_ENABLED	Redwood Page for Approved Supplier List Entries Enabled
ORA_PO_CONTRACT_FULFILLMENTS_REDWOOD_ENABLED	Redwood Page for Contract Fulfillments Enabled
ORA_PO_MANAGE_AGREEMENTS_REDWOOD_ENABLED	Redwood Manage Agreements Enabled
ORA_PO_PROCESS_REQS_REDWOOD_ENABLED	Redwood Page for Process Requisitions Enabled
ORA_PO_PURCHASE_ORDERS_REDWOOD_ENABLED	Redwood Page for Purchase Orders Enabled for Purchasing
ORA_PO_PURCHASING_OVERVIEW_REDWOOD_ENABLED	Redwood Page for Purchasing Overview Enabled
ORA_PO_SUPPLIER_PORTAL_PURCHASE_AGREEMENTS_REDWOOD_ENABLED	Redwood Page for Purchase Agreements Enabled for Supplier Portal
ORA_PO_SUPPLIER_PORTAL_PURCHASE_ORDERS_REDWOOD_ENABLED	Redwood Page for Purchase Orders Enabled for Supplier Portal

2.2. Search with Profile Option Code %REDWOOD% and Application Supplier Model

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_POZ_MANAGE_SUPPLIERS_REDWOOD_ENABLED	Redwood Pages for Manage Suppliers Enabled
ORA_POZ_MANAGE_SUPPLIER_REGISTRATIONS_REDWOOD_ENABLED	Redwood Manage Supplier Registration Pages Enabled
ORA_POZ_SUPPLIER_MANAGEMENT_REDWOOD_ENABLED	Redwood Page for Supplier Management Enabled
ORA_POZ_SUPPLIER_PROFILE_REDWOOD_ENABLED	Redwood Pages for Supplier Profile Enabled

2.3. Search with Profile Option Code %REDWOOD% and Application Self Service Procurement

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_POR_RCO_REDWOOD_ENABLED	Requester Change Orders Managed on Redwood Page
ORA_POR_REDWOOD_CATALOG_SETUP_ENABLED	Redwood Catalog Setup Pages Enabled
ORA_POR_VIEW_PO_REDWOOD_ENABLED	Redwood Page for Purchase Orders Enabled for Self Service Procurement

2.4. Search with Profile Option Code %REDWOOD% and Application Supplier Portal

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_POS_COMPANY_PROFILE_SUPPLIER_PORTAL_REDWOOD_ENABLED	Redwood Company Profile in Supplier Portal Pages Enabled

2.5. Search with Profile Option Code %REDWOOD% and Application Sourcing

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_PON_AWARD_NEGOTIATION_REDWOOD_ENABLED	Redwood Page to Award Negotiation Enabled
ORA_PON_CREATE_NEGOTIATION_REDWOOD_ENABLED	Redwood Page to Create Negotiation Enabled
ORA_PON_REDWOOD_SOURCING_PROGRAM_ENABLED	Redwood Sourcing Program Enabled
ORA_PON_SELLER_AUCTIONS_REDWOOD_ENABLED	Redwood Page to Seller Negotiations Enabled
ORA_PON_SOURCING_REDWOOD_ENABLED	Redwood Pages for Sourcing Enabled

2.6. Search with Profile Option Code %REDWOOD% and Application Supplier Qualification

Enable (Make it Yes / Y) all the applicable profile options.

Profile Option Code	Profile Display Name
ORA_POQ_ASSESSMENT_INITIATIVES_REDWOOD_ENABLED	Redwood Assessment Initiatives Pages Enabled
ORA_POQ_AUTOMATION_ERRORS_REDWOOD_ENABLED	Redwood Automation Errors page enabled
ORA_POQ_INTERNAL_QUESTIONNAIRES_REDWOOD_ENABLED	Redwood Internal Questionnaires Pages Enabled
ORA_POQ_QUALIFICATIONS_REDWOOD_ENABLED	Redwood Qualifications Pages Enabled
ORA_POQ_QUALIFICATION_INITIATIVES_REDWOOD_ENABLED	Redwood Qualification Initiatives Pages Enabled
ORA_POQ_REDWOOD_RESPOND_TO_QUESTIONNAIRE_SUPPLIER	Redwood Respond to Questionnaire for Suppliers
ORA_POQ_SUPPLIER_ELIGIBILITY_REDWOOD_ENABLED	Supplier eligibility redwood enabled
ORA_POQ_SUPPLIER_QUALIFICATION_REDWOOD_ENABLED	Redwood Supplier Qualification Page Enabled

3. Run the Indexing Programs

3.1. Items

Navigation: Product Management > Product Management

Actions > Configure application > Indexes

Items

Items > Three Dots (...) > Enable attribute sets

Select all the applicable applications.

Click on Apply > Save

Three Dots (...) > Rebuild

Schedule index rebuild process?

Select Now > Rebuild

3.2. Suppliers

ESS job to create index definition and perform initial ingest to OSCS

Index Name to Reingest

• fa-prc-suppliers
• fa-prc-poz-registrations

3.3. Saved Search

ESS job to create index definition and perform initial ingest to OSCS

Index Name to Reingest

• fa-hcm-savedsearch

3.4. Purchasing Documents

ESS job to create index definition and perform initial ingest to OSCS

Index Name to Reingest

• fa-prc-po
• fa-prc-po-schedules
• prc_por_downstream
• fa-prc-pa
• fa-prc-pa-line

3.5. Procurement Agents

ESS job to create index definition and perform Initial Ingest to OSCS

Index Name to Reingest

• fa-hcm-person

3.6. Sourcing

ESS job to create index definition and perform Initial Ingest to OSCS

Index Name to Reingest

• fa-prc-pon-managenegotiations
• fa-prc-pon-negotiationresponses
• fa-prc-pon-suppliermessages
• fa-prc-pon-buyermessages

3.7. Supplier Qualification

ESS job to create index definition and perform Initial Ingest to OSCS

Index Name to Reingest

• fa-prc-poq-qualifications
• fa-prc-poq-initiatives
• fa-prc-poq-questionnaires

Redwood Pages:

How to Enable Supplier Site, Contact DFF in Redwood?

 User → Administration → Edit Page in Visual Builder Studio

If you've not created the Repository yet, Create it!

Create Repository, Workspace 

Oracle Visual Builder Studio will open:

Open the respective page (Sites, Contact), rules..

DFF disabled (by default)

Create a New Business Rule for Sites page:

See All Children → Hidden → See All children Visible

Change DFF → Hidden → Visible

Repeat the steps for all the required the pages (Sites, contact) for both the mode (Edit & View).

Preview & Validate the DFF

Publish the changes

SQL Query to Get the Supplier Contact Details

Suppliers & Supplier Sites - Details

SELECT hp.party_name                    supplier_name,
       ps.segment1                      supplier_number,
       ps.vendor_type_lookup_code       supplier_type,
       ps.organization_type_lookup_code supplier_tax_org_type,
       ps.business_relationship,
       hop.duns_number_c                supplier_duns_number,
       ps.customer_num,
       ps.standard_industry_class       supplier_sic,
       hop.party_number                 supplier_registry_id,
       hop.year_established,
       hop.mission_statement,
       psp.income_tax_id                supplier_taxpayer_id,
       hps.party_site_name              address_name,
       hp.address1,
       hp.address2,
       hp.city,
       hp.state,
       hp.county,
       hp_contact.person_last_name
       ||', '
       ||hp_contact.person_pre_name_adjunct
       ||' '
       ||hp_contact.person_first_name   contact_person
FROM   poz_suppliers ps
       join hz_parties hp
         ON hp.party_id = ps.party_id
       join hz_organization_profiles hop
         ON hop.party_id = ps.party_id
       left join poz_suppliers_pii psp
              ON psp.vendor_id = ps.vendor_id
       left join hz_party_sites hps
              ON hps.party_site_id = hp.iden_addr_party_site_id
       left join hz_parties hp_contact
              ON hp_contact.party_id = hp.preferred_contact_person_id

Suppliers & Supplier Sites - Contact Details

SELECT hpo.party_name              supplier_name,

       hpp.person_pre_name_adjunct title,

       hpp.person_first_name,

       hpp.person_last_name,

       hpp.status                  contact_status,

       pu.username,

       hc.job_title,

       hps.party_site_name,

       email.email_address,

       email.last_updated_by,

       email.last_update_date,

       phone.phone_area_code,

       phone.phone_number

FROM   hz_parties hpo

       join hz_relationships hzr

         ON hzr.object_id = hpo.party_id

       join hz_parties hpp

         ON hpp.party_id = hzr.subject_id

       join hz_org_contacts hc

         ON hc.party_relationship_id = hzr.relationship_id

       left join hz_org_contact_roles hor

              ON hor.org_contact_id = hc.org_contact_id

       left join poz_supplier_contacts poc

              ON poc.relationship_id = hzr.relationship_id

       left join hz_party_sites hps

              ON hps.party_site_id = poc.party_site_id

       left join poz_suppliers ps

              ON ps.party_id = hpo.party_id

       left join per_users pu

              ON pu.user_guid = hpp.user_guid

       left join (SELECT

                                              email_address,

                         owner_table_id,

                         last_updated_by,

                         To_char(last_update_date, 'YYYY-MM-DD HH24:MI:SS')

                                              last_update_date

                  FROM   hz_contact_points hcp

                  WHERE  hcp.contact_point_type = 'EMAIL'

                         AND hcp.owner_table_name = 'HZ_PARTIES') email

              ON email.owner_table_id = hpp.party_id

       left join (SELECT phone_country_code,

                         phone_area_code,

                         phone_number,

                         phone_extension,

                         owner_table_id

                  FROM   hz_contact_points hcp

                  WHERE  hcp.contact_point_type = 'PHONE'

                         AND hcp.owner_table_name = 'HZ_PARTIES'

                         AND hcp.phone_line_type = 'GEN') phone

              ON phone.owner_table_id = hpp.party_id

WHERE  1 = 1

       AND hpo.party_type = 'ORGANIZATION'

       AND hpp.party_type = 'PERSON'

       AND hzr.relationship_code = 'CONTACT_OF'

ORDER  BY email.last_update_date DESC 

How to Set Up the Responsive Self-Service Receiving Application - My Receipts (New)?

You can add the My Receipts (New) work area icon by following these steps:

1. In the Setup and Maintenance work area, search for and select the Manage Receiving Profile Options task.
2. On the Manage Receiving Profile Options page, search for and select the DORA_RCV_SELF_SERVICE_RECEIVING_REDWOOD_ENABLE profile option code.
3. In the Profile Values section, set the Site level to Yes. The default value is No.
• Yes = enables the feature
• No = disables the feature
4. Click Save and Close. 

Changes in the profile value will affect users the next time they sign in.

If you are a Procurement or Inventory Management customer and you do not see the My Receipts (New) icon even after you enable the profile option, that means you previously made changes to the Navigator menu in your implementation. In this case, you can add the responsive self-service receiving capabilities and the My Receipts (New) work area icon by following these steps:

1. Activate a Sandbox with the Structure tool.
2. Enter the Sandbox and click the Structure link under Tools.
3. Expand the Procurement node and click My Receipts (New).
4. From the Show on Navigator list, select Yes.
5. Click Save and Close.
6. Publish the Sandbox.

After you enable the profile option and take the additional steps to expose the My Receipts (New) work area icon (if necessary), you'll need to perform the steps outlined below:

Create Index Definition and Perform Initial Ingest to OSCS

For the Responsive Self-Service Receiving application, you must perform the initial ingest. This requires submitting the scheduled process job to create the index definition and performing the initial ingest to Oracle Search Cloud Service (OSCS).

This process ingests purchase order expected receipts, transfer order expected receipts, advanced shipment notice expected receipts, and receiving transactions. This is a prerequisite step to search and receive orders in Self-Service Receiving.

Ensure that your administrator provides you with the Manage Scheduled Job Definition privilege before performing these steps to complete the initial ingestion of existing orders and receipts into the index and enable search. New orders and receipts created after these steps are automatically inserted into the search index.

1. Log in as the Supply Chain Application Administrator or Procurement Application Administrator user.
2. Navigate to Tools → Scheduled Processes, then click Schedule New Process.
3. Search and select the process name: ESS job to create index definition and perform initial ingest to OSCS

Parameter values for index name to reingest:

• fa-scm-rcv-expected-po-receipts
• fa-scm-rcv-expected-asn-receipts
• fa-scm-rcv-expected-to-receipts
• fa-scm-rcv-transactions
• fa-scm-rcv-expected-rma-receipts

1. Expected PO Receipts

 

2. Expected ASN Receipts

3. Expected TO Receipts

4. Expected RCV Transactions

5.  Expected RMA Receipts

Receive Using the Responsive Self-Service Receiving Application

Use the Receive Now or Receive with Details actions on the Orders to Receive page to receive items with or without additional details using the Responsive Self-Service Receiving application.

Receive Now

You can immediately receive your orders by tapping the Receive Now button. You can quickly receive your orders without having to enter specific details about your receipt. In the event you need to enter additional receipt details, you can tap the Receive with Details icon to the right of the Receive Now button. Once you've performed the Receive Now action, you're presented with a toast confirmation message indicating that the receipt has been successfully created.

Receive with Details

Based on your organizations receiving process, you may need to view details associated with the order or modify or enter additional information when performing a receipt. For example, you can adjust the receipt quantity or enter attachments such as an invoice or packing slip. In such cases, you should use the Receive with Details action. Tapping this button opens the New Receipt page allowing you to enter additional details when performing a receipt.

Note

Configure the Blind Receiving for Self-Service Procurement Enforced (RCV_SSP_REQUIRE_BLIND_RECEIVING) profile option to specify whether the Receive Now button or the Receive with Details button displays as the primary action on the Orders to Receive page. A profile value of No indicates that the Receive Now button displays as the primary action on the Orders to Receive page. An icon displays allowing you to Receive with Details. A profile value of Yes indicates that the Receive with Details button displays as the primary action on the Orders to Receive page. The Receive Now button won't be displayed.

Profile Option	Value	Action / Button
Blind Receiving for Self-Service Procurement Enforced (RCV_SSP_REQUIRE_BLIND_RECEIVING)	No	Receive Now
	Yes	Receive with Details