eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DIAG_DISCRETE_LOT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 135: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

131: where_clause2 ||
132: ' and mmt.transaction_date < wrs.date_released ' ||
133: ' order by 1, 3 ' ;
134:
135: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
136: ' Transactions where transaction_date is before the job release date ',true,null,'Y',row_limit) ;
137:
138: IF (dummy_num = row_limit) THEN
139: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 139: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

135: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
136: ' Transactions where transaction_date is before the job release date ',true,null,'Y',row_limit) ;
137:
138: IF (dummy_num = row_limit) THEN
139: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
140: END IF;
141:
142: if dummy_num > 0 then
143: reportStr := 'The rows returned above indicates transaction date before Job/Schedule Release Date.' ;

Line 144: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

140: END IF;
141:
142: if dummy_num > 0 then
143: reportStr := 'The rows returned above indicates transaction date before Job/Schedule Release Date.' ;
144: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
145: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
146:
147: /*
148: if apps_ver = '11.5.10' then

Line 145: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;

141:
142: if dummy_num > 0 then
143: reportStr := 'The rows returned above indicates transaction date before Job/Schedule Release Date.' ;
144: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
145: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
146:
147: /*
148: if apps_ver = '11.5.10' then
149:

Line 156: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;

152:
153: reportStr := '
For Release 11.5.10 :' ;
154: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
155:
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
157:
158: --JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
159: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
160:

Line 158: --JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;

154: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
155:
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
157:
158: --JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
159: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
160:
161: elsif apps_ver = '11.5.9' then
162:

Line 167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

163: -- reportStr := '
For Release 11.5.9 :' ;
164: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
165: reportStr := '
Root cause patch not available. If issue can be reproduced at will, please log a service request againt WIP with steps to reproduce' ;
166: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
168:
169: reportStr := '
Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.update_mmt_for_jobs(organization_id, wip_entity_id) ' ;
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
171: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

Line 170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

166: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
168:
169: reportStr := '
Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.update_mmt_for_jobs(organization_id, wip_entity_id) ' ;
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
171: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
172: end if ;
173: **/
174:

Line 218: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

214: ' AND WPB.ORGANIZATION_ID = WDJ.ORGANIZATION_ID ' ||
215: ' AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID)' ||
216: ' order by we.wip_entity_name, we.organization_id' ;
217:
218: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
219: ' Transactions erred due to missing record in WIP_PERIOD_BALANCES (error: CST_NO_BALANCE_ROW)',true,null,'Y',row_limit) ;
220:
221: IF (dummy_num = row_limit) THEN
222: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 222: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

218: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
219: ' Transactions erred due to missing record in WIP_PERIOD_BALANCES (error: CST_NO_BALANCE_ROW)',true,null,'Y',row_limit) ;
220:
221: IF (dummy_num = row_limit) THEN
222: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
223: END IF;
224:
225: if dummy_num > 0 then
226: reportStr := 'The rows returned above indicate record is missing in WIP_PERIOD_BALANCES.' ;

Line 227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

223: END IF;
224:
225: if dummy_num > 0 then
226: reportStr := 'The rows returned above indicate record is missing in WIP_PERIOD_BALANCES.' ;
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
229:
230: /*
231: reportStr := '
Action:' ;

Line 228: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;

224:
225: if dummy_num > 0 then
226: reportStr := 'The rows returned above indicate record is missing in WIP_PERIOD_BALANCES.' ;
227: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
228: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
229:
230: /*
231: reportStr := '
Action:' ;
232: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

Line 242: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

238: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
239:
240: reportStr := reportStr || '
2. Please log a service request with steps to reproduce if Client can reproduce issue at will.' ;
241: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
242: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
243: */
244:
245:
246: sqltxt :=

Line 284: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

280: ' AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+) ' ||
281: ' order by we.WIP_ENTITY_ID, mmtt.transaction_header_id, mmtt.transaction_temp_id ' ;
282:
283: IF (dummy_num = row_limit) THEN
284: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
285: END IF;
286:
287: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql( sqltxt, 'Stuck Pending Material Transaction',true,null,'Y',row_limit) ;
288: if dummy_num > 0 then

Line 287: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql( sqltxt, 'Stuck Pending Material Transaction',true,null,'Y',row_limit) ;

283: IF (dummy_num = row_limit) THEN
284: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
285: END IF;
286:
287: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql( sqltxt, 'Stuck Pending Material Transaction',true,null,'Y',row_limit) ;
288: if dummy_num > 0 then
289: reportStr := 'The rows returned above indicates Lots can''t be derived successfully.' ;
290: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
291: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;

Line 290: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

286:
287: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql( sqltxt, 'Stuck Pending Material Transaction',true,null,'Y',row_limit) ;
288: if dummy_num > 0 then
289: reportStr := 'The rows returned above indicates Lots can''t be derived successfully.' ;
290: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
291: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
292: end if ;
293:
294:

Line 291: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;

287: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql( sqltxt, 'Stuck Pending Material Transaction',true,null,'Y',row_limit) ;
288: if dummy_num > 0 then
289: reportStr := 'The rows returned above indicates Lots can''t be derived successfully.' ;
290: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
291: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
292: end if ;
293:
294:
295: end if ;

Line 358: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

354: ' AND WDJ.STATUS_TYPE IN (3,4))' ||
355: ' AND NOT EXISTS (SELECT 1 FROM WIP_COST_TXN_INTERFACE WCTI' ||
356: ' WHERE WCTI.SOURCE_LINE_ID = RT.INTERFACE_TRANSACTION_ID ) ' ;
357:
358: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
359: ' OSP receipts whose corresponding jobs were not charged',true,null,'Y',row_limit) ;
360:
361: IF (dummy_num = row_limit) THEN
362: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 362: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

358: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
359: ' OSP receipts whose corresponding jobs were not charged',true,null,'Y',row_limit) ;
360:
361: IF (dummy_num = row_limit) THEN
362: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
363: END IF;
364:
365: if dummy_num > 0 then
366: reportStr := 'The rows returned above indicate OSP Resource is not charged after items are delivered to ShopFloor.' ;

Line 367: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

363: END IF;
364:
365: if dummy_num > 0 then
366: reportStr := 'The rows returned above indicate OSP Resource is not charged after items are delivered to ShopFloor.' ;
367: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
368: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
369: end if ;
370:
371: END corrupt_osp_txn_wdj ;

Line 368: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');

364:
365: if dummy_num > 0 then
366: reportStr := 'The rows returned above indicate OSP Resource is not charged after items are delivered to ShopFloor.' ;
367: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
368: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
369: end if ;
370:
371: END corrupt_osp_txn_wdj ;
372:

Line 414: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

410: ' locator_id,' ||
411: ' completion_transaction_id,'||
412: ' source_line_id';
413:
414: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
415: ' Duplicate material transactions in case of WIP completion ',true,null,'Y',row_limit) ;
416:
417: IF (dummy_num = row_limit) THEN
418: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 418: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

414: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
415: ' Duplicate material transactions in case of WIP completion ',true,null,'Y',row_limit) ;
416:
417: IF (dummy_num = row_limit) THEN
418: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
419: END IF;
420:
421: if dummy_num > 0 then
422: reportStr := 'The rows returned above indicates duplicate transactions.' ;

Line 423: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

419: END IF;
420:
421: if dummy_num > 0 then
422: reportStr := 'The rows returned above indicates duplicate transactions.' ;
423: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
424: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
425: end if ;
426:
427: sqltxt :=

Line 424: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');

420:
421: if dummy_num > 0 then
422: reportStr := 'The rows returned above indicates duplicate transactions.' ;
423: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
424: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
425: end if ;
426:
427: sqltxt :=
428: 'SELECT organization_id, ' ||

Line 453: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

449: ' subinventory_code,' ||
450: ' locator_id,' ||
451: ' move_transaction_id,' ||
452: ' source_line_id';
453: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
454: ' Duplicate backflush records for wip move transactions ',true,null,'Y',row_limit) ;
455:
456: IF (dummy_num = row_limit) THEN
457: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 457: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

453: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
454: ' Duplicate backflush records for wip move transactions ',true,null,'Y',row_limit) ;
455:
456: IF (dummy_num = row_limit) THEN
457: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
458: END IF;
459:
460: if dummy_num > 0 then
461: reportStr := 'The rows returned above indicates duplicate backflush records originating from Move Transaction.' ;

Line 462: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

458: END IF;
459:
460: if dummy_num > 0 then
461: reportStr := 'The rows returned above indicates duplicate backflush records originating from Move Transaction.' ;
462: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
463: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
464: end if ;
465: END dup_mat_txn_wdj ;
466:

Line 463: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');

459:
460: if dummy_num > 0 then
461: reportStr := 'The rows returned above indicates duplicate backflush records originating from Move Transaction.' ;
462: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
463: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
464: end if ;
465: END dup_mat_txn_wdj ;
466:
467: BEGIN

Line 469: apps_ver := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version ;

465: END dup_mat_txn_wdj ;
466:
467: BEGIN
468:
469: apps_ver := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version ;
470:
471: END WIP_DIAG_DISCRETE_LOT ;