Supply Chain Management - PSFT (MOSC)

MOSC Banner

Several different business units not populating when running the PCard close query report

edited Apr 5, 2022 3:36PM in Supply Chain Management - PSFT (MOSC) 2 commentsAnswered

My organization just upgraded from Image 33 to Image 41 on 03.07.22. Since then, we have received a case for several different business units not populating when running the PCard close query report. We are thinking it’s a bug due to running select count (*) from PS_CC_TRANS_LINE where business_unit = ' '; and pulling back the below data for missing business units.

query in uDEV – there were ZERO users with no Business Units.

query in uTST – there were 142 users with no Business Units.

query in UAT – there were 691 users with no Business Units. A month refreshed before Prod upgrade.

query in PROD – There are 6998 users with no Business Units.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT SCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center