Patch:22850140:R12.PSA.C

[big]

Hi,
On R12.2.9, DB 19c I want to know if patch   Patch:22850140:R12.PSA.C for 12.2 is presente. Then I run  
SQL>  select bug_number,bug_id from ad_bugs where bug_number='22850140';

BUG_NUMBER                         BUG_ID
------------------------------ ----------
22850140                           544791
And :
SQL> select APPLIED_PATCH_ID ,PATCH_NAME from ad_applied_patches where PATCH_NAME='22850140';

no rows selected
Can I conclude that Patch:22850140:R12.PSA.C for 12.2  is present?

Can I say that BUG 544791 is fixed and we do not need to apply the patch 22850140:R12.PSA.C?

Thanks.

[ErmanArslansOracleBlog]

Yes that bug is fixed.. But 22850140 should be there in the ad_applied_patches as well.. But your bug is fixed!
Check the ad_applied_patches by ordering it with dates and see the records displayed there..
Maybe the patch name is different.. You can also use patch_name like '%22850140%'... But if nothing returns, query the ad_applied_patches table by ordering the date with the dates (maybe the column CREATION_DATE) and see..

[big]

Hi,
Thank you Erman.

I ran:

select APPLIED_PATCH_ID ,PATCH_NAME from ad_applied_patches where PATCH_NAME like '%22850140%';
no rows selected.

Should we apply this patch: 22850140:R12.PSA.C for 12.2?

Regards.

[ErmanArslansOracleBlog]

patch name in the ad_applied_patches table may be different.
as I said earlier ; if nothing returns, query the ad_applied_patches table by ordering the date with the dates (maybe the column CREATION_DATE) and see..
You have that record in ad_bugs .. So if there are no errors in the patch log, I think you are okay..