Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Monday, January 3, 2011

[PO] Missing Purchase Order (PO) Distribution After RTV - FIXED

With reference back to my problem logged to Metalink TAR, it was fixed after applied patch 4463796.
This patch upgrade the version of PAPOUTLB.pls to 115.3.90.4. Eventhough Project Accounting is not used, but this patch works.

How to check PAPOUTLB.pls version?

SELECT fi.file_id
,filename
,version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'PAPOUTLB.%'
AND ve.file_id = fi.file_id
AND REPLACE(version, '.','') =
(SELECT MAX(TO_NUMBER(REPLACE(version, '.', '')))
FROM apps.ad_file_versions ven
WHERE ven.file_id = fi.file_id);

No comments:

Post a Comment