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