My Oracle Support Banner

R12: AP: Error ORA-942 While Running Data-Fix Script ap_prep_cash_bzns_code_fix.sql (Doc ID 2811982.1)

Last updated on NOVEMBER 15, 2021

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Error ORA-942  While Executing data-Fix script ap_prep_cash_bzns_code_fix.sql via SQL*Plus command line.

SQL> UPDATE xla_ae_lines                                                                 
  2      SET business_class_code='AP_PREPAY'                                             
  3    WHERE application_id = 200                                                        
  4      AND (ae_header_id, ae_line_num) IN                                              
  5       (SELECT drv.ae_header_id,                                                      
  6               drv.ae_line_num                                                        
  7          FROM ap_prep_cash_bzns_code_drv /*ap_prep_msng_bzns_code_drv*/ drv          
  8        WHERE drv.process_flag = 'Y' )  ;   

    FROM ap_prep_msng_bzns_code_drv drv               
             *                                                                           
ERROR at line 7:                                                                         
ORA-00942: table or view does not exist

Data-Fix was executed because output of the "MGDF Analyzer" identified Error Signature ID 295

MGDF-295 - For cash basis accounting, tax journal lines created for the payment accounting of the prepayment invoice are missing the business class code, causing issues while accounting the prepayment application events

 

Changes

 Successfully executed data-fix SEL script ap_prep_cash_bzns_code_sel.sql

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.