ProCard Load Statement runs to No Success After Image 31. Getting error Process ABENDED at Step PC_EDIT.EXTERNAL.Step02B (Action Do When) -- RC = 904 ROLLBACK
(Doc ID 2541640.1)
Last updated on NOVEMBER 13, 2019
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
After applying Image 31 the PO_CCLOADLD process is running to No Success. The process abends with the following error:
ERROR
-----------------------
Process 568692 ABENDED at Step PC_EDIT.EXTERNAL.Step02B (Action Do When) -- RC = 904 ROLLBACK
07:58:40.392 SQL Error: ORA-00904: "L"."BUSINESS_UNIT": invalid identifier
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 122 Return: 9 04 - ORA-00904: "L"."BUSINESS_UNIT": invalid identifier Failed SQL stmt: SELECT DISTINCT H.SETID FROM PS_CC_DIST_TAO L ,PS_SET_CNTRL_REC H WHERE L.PROCESS_I NSTANCE = 568692 AND H.SETCNTRLVALUE = L.BUSINESS_UNIT AND H.RECNAME LIKE 'GL_ACCOUNT_TBL' AND L.BUS INESS_UNIT_GL = 'WA170' AND L.PROJECT_ID <> ' ' AND L.ACTIVITY_ID <> ' ' AND L.BUSINESS_UNIT_PC <> ' ' AND 'U' = 'G' AND ' ' = 'Y'
Required Setup:
Go to Set Up Financials/Supply Chain-->Common Definitions-->Design Chartfields-->Combination Editing-->Combination Definition
Add a new value
SetID=SHARE
Combination Definition=T1
Go to Set Up Financials/Supply Chain-->Common Definitions-->Design Chartfields-->Combination Editing-->Combination Rule
Add a New Value
SetID=SHARE
Combination Rule=T2
Go to Set Up Financials/Supply Chain-->Common Definitions-->Design Chartfields-->Combination Editing-->Combination Group
Add a new value
SetID=SHARE
Process Group=T3
Go to Set Up Financials/Supply Chain-->Business Unit Related-->General Ledger-->Ledgers For A Unit
Enter Business Unit=US001
Enter T3 as Process Group for RECORDING under Journal Edit Options tab.
Go to Set Up Financials/Supply Chain-->Business Unit Related-->Purchasing-->Purchasing Definition
Enter PO BU USOO1
GL BU is US001
Go to Set Up Financials/Supply Chain-->Business Unit Related-->Purchasing-->Purchasing Options
Enter Process Option ID US001 and click Search
Edit Cominations is turned on. Chartfield Edit Option is set to Reject w/edit error
Save the Page
Go to Setup Financials/Supply chain-->Product Related-->Procurement Options-->Purchasing-->ProCard Card Issuers
Enter your Caurd Issuer and click Search
Verify Status is Active
Replication Steps:
Run Build Combination Data
Review Combination Data
Run Load ProCard Stage process
Navigate to Card Profiler-- Correct errors
Assign Proxy- Have User Id as VP1.
Run Load Statement process
Proces abends with an error
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Can't load pcard transactions in production since Image 31 was applied
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 |