Go to primary content
Oracle® Retail Financial Integration for Oracle Retail Merchandise Operations Management and Oracle Financials Installation Guide Installation Guide
Release 19.0
F23582-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

A Appendix: Troubleshooting PeopleSoft Services

This section provides few guidelines around few issues one might encounter while configuring PeopleSoft services to integrate with ORFI


Note:

These are broad guidelines. If problem persists then get a PeopleSoft administrator should validate the installation and service availability.

Error - Building the Project Objects

If you encounter either of the below mentioned errors while building the PeopleSoft project objects, try This section provides guidelines around few issues one might encounter while configuring PeopleSoft services to integrate with ORFI

Issue:

Open file operation failed. <FilePath>\PSBUILD.LOG

Figure A-1 Build

Surrounding text describes Figure A-1 .

Resolution:

Ensure to set the valid path for the log file shown in the above screen. Below screen shot shows how to change and validate the log file path.

Figure A-2 Log File Path

Surrounding text describes Figure A-2 .

Issue:

Open file operation failed. <FilePath>\PSBUILD.SQL

Figure A-3 Operation Failed

Surrounding text describes Figure A-3 .

Resolution:

Ensure to set a valid Set a valid path for the SQL file in Scripts tab. Check the below screen shot

Figure A-4 Scripts Tab

Surrounding text describes Figure A-4 .

Issue:

PeopleSoft service is not able to deliver messages to RFI. The system will throw an error message:

"Integration Gateway - HttpTargetConnector:ExternalApplicationException. Http status code HttpStatusCode returned : 500. (158,10623) RFI_INT_AP.RFI_WEBSERVICE_AP.RFI_WEBSERVICE_AC.OnExecute Name:RFI_Meth_InitRequest PCPC:8443 Statement:111…."

Resolution:

Follow the below mentioned steps and screen prints:

  1. Check the Target system is up and running (ORFI is the Target system)

  2. Validate the Primary URL value of the Target system in PeopleSoft :-

    Navigation: Main Menu -> PeopleTools -> Integration Broker -> Integration Setup -> Service Operation


    Note:

    Routing parameter value needs to be checked for respective Service Operation. Below are list of Service operations used with ORFI. Please note these are not exact names of the service operation.

    • Vendor

    • Payment Terms

    • Currency Rate

    • COMBO CF Edit Request

    • DrillForwardBackward Service

    The screenshots below show navigation for Vendor Service. Similar look up needs to be done for the service which has issue

    Navigation: Main Menu ->PeopleTools -> Integration Broker -> Integration Setup -> Services

    Search for service - SUPPLIERBUSINESSEVENTHANDLERSE and click on Service Link.

    Figure A-5 Services

    Surrounding text describes Figure A-5 .
  3. On the Service Definition page, click the Service Operation link to open Service Operation

    Figure A-6 Service Operation

    Surrounding text describes Figure A-6 .
  4. Click the Routings tab.

    Figure A-7 Routings

    Surrounding text describes Figure A-7 .
  5. Click the routing definition link. Look up the highlighted square in the above screen shot. This should open a pop-up window

    Figure A-8 Routing Definition

    Surrounding text describes Figure A-8 .
  6. Click on the "Connector properties" tab and validate the WSDL /Target URL reference given against "Primary URL". This should be pointing to service that is being invoked in RFI. If this is different, then Change the URL to point to the one configured in RFI. Save the changes by pressing "Save" button.

Issue:

Messages are not published to Retail from PSFT.

Resolution:

Check the status of the Domain to be active. The same can be verified by following below screen shots:-

Figure A-9 Domain Status

Surrounding text describes Figure A-9 .

Issue:

Invalid Business Unit error while creating Supplier in PeopleSoft. The system will throw a validation message "Operator Business Unit - XXX is not a AP Business Unit" if the Business Unit assigned to the user is not a Accounts Payable Business Unit.

Figure A-10 Error Message

Surrounding text describes Figure A-10 .

Resolution:

Check the default business unit assigned to the current user by following below mentioned steps.

Navigation: Main Menu -> SetUp Financials/Supply Chain -> Common Definitions -> User Preferences -> Define User Preferences

  1. Click on Overall Preferences to open the preferences assigned to the user as shown in the below screen shot:-

    Figure A-11 Define User Preferences

    Surrounding text describes Figure A-11 .
  2. Verify the Business Unit assigned to the user is defined as a Payable Business Unit. If not, make a business decision like whether to add the Business Unit or change the Business unit of the user.

    Navigation: Main Menu -> Set up Finance / Supply Chain -> Business Unit Related -> Payables -> Payables Definition

    Figure A-12 Payables Definition

    Surrounding text describes Figure A-12 .