Financial Management - PSFT (MOSC)

MOSC Banner

This sql is hanging

edited Aug 31, 2012 9:41AM in Financial Management - PSFT (MOSC) 3 commentsAnswered ✓
Hi experts.

I need help. The Developer is telling me that this sql is hanguing again.

Oralce Database Entrprise Edition version 10.2.0.4   - PeopleTools version 8.47.14

Yesterday I implement a profile, then kill the os spid and the Developer finished with Sucess the instance.

Now they are asking e to do this again. 

Do you know what is happening in here?

Process

AP_PSTPYMNT


Process Instance: 2553695

SID: 232

SQL_HASH_VALUE: 2713383249

SQL_ID: 75p85t6hvpwaj

SELECT 'X' FROM PS_PST_PYMT_TAO31 PST , PS_VOUCHER_LINE VLN , PS

_PYMNT_VCHR_WTHD WTHD WHERE PST.PROCESS_INSTANCE = 2553695 AND P

ST.BUSINESS_UNIT = VLN.BUSINESS_UNIT AND PST.VOUCHER_ID = VLN.VO

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 Financial 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