My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.