EAP: VENDOR_SYNC Gives Warning: SQL Object In Bulkmode Was Not Closed Properly
(Doc ID 3037258.1)
Last updated on JULY 24, 2024
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Integration Broker log files shows warning as below after upgrading to PeopleTools version 8.60.08 and application to FSCM 9.2 Image 48 when using VENDOR_SYNC messages coming from Student Financials
PSSUBHND_dflt.XXXX SubConProcess] - - - (3) Detected time zone is Atlantic Standard Time
PSSUBHND_dflt.XXXX WARNING: SQL object in BulkMode was not closed properly in the PeopleCode. Add a call to the Close method when finished with the SQL object.
PSSUBHND_dflt.XXXX SubConProcess] - - - (2) SQL object statement: %Insert(:1)
STEPS:
1. Make sure that the Node is setup on both the HRMS and Financials side
PeopleTools > Integration Broker > Integration Setup > Node Definition
2. Make sure that the Service Operation = VENDOR_SYNC is Active (PeopleTools > Integration Broker > Integration Setup > Service Operations)
3. Log into the HRMS application
4. Navigate to Student Financials > Refunds > Student Refund
5. Create a Student Refund for a Vendor existing on the Financials side
6. On the Student Refund page, post the refund by clicking on the Post Refund button
7. Run Create Vendors and Vouchers (Student Financials > Refunds > AP Refunding > Create Vendors and Vouchers)
8. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Details
9. Message is published and Status is Done on the HRMS side
10. Check the integration broker logs on the Financial side - warning messages will show as above
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |