Invoice Print Selected Invoices Ends with Error REP-1419 (Doc ID 175372.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

 RAXINV_SEL - Invoice Print Selected Invoices fails with:

MSG-00100: DEBUG: BeforeReport_Trigger
ORA-00904. INVALID COLUMN NAME

RAXINV_SEL module: Invoice Print Selected Invoices
+---------------------------------------------------------------------------+

Current system time is 02-APR-2001 13:44:53

+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
p_order_by='TRX_NUMBER'
p_open_invoice='Y'
p_check_for_taxyn='N'
p_tax_registration_number='XXX123456789'
p_choice='SEL'
p_header_pages='1'
p_debug_flag='N'
p_message_level='10'
------------
MSG-00100: DEBUG: AfterPForm_Trigger +
MSG-00100: DEBUG: Multi Org established.
MSG-00100: DEBUG: AfterParam_Procs.Get_Country_Details
MSG-00100: DEBUG: AfterParam_Procs.Switch_On_Debug
MSG-00100: DEBUG: AfterParam_Procs.Get_Trx_Number_Low
MSG-00100: DEBUG: AfterParam_Procs.Get_Trx_Number_High
MSG-00100: DEBUG: AfterParam_Procs.Get_Tax_Option
MSG-00100: DEBUG: AfterPForm_Trigger -
MSG-00100: DEBUG: BeforeReport_Trigger +
MSG-00100: DEBUG: AfterParam_Procs.Populate_Printing_Option
MSG-00100: DEBUG:AfterParam_Procs.Populate_Tax_Printing_Option
MSG-00100: DEBUG: BeforeReport_Trigger.Get_Message_Details
MSG-00100: DEBUG: BeforeReport_Trigger.Get_Org_Profile.
MSG-00100: DEBUG: Organization Id: 2
MSG-00100: DEBUG: Organization Profile set ok.
MSG-00100: DEBUG: BeforeReport_Trigger.Build_Where_Clause
MSG-00100: DEBUG: P_Choice: SEL
MSG-00100: DEBUG: Choice is other than ADJ, setting ORDER BY.
MSG-00100: DEBUG: BeforeReport_Trigger -
MSG-05000: DEBUG: Trx No... 1
MSG-00010: 13:45 1 Transaction: 1
MSG-05000: DEBUG: Trx No... 10000
MSG-43749: There is no remit to address defined for country MX and state
DISTRITO FEDERAL.
REP-1419: 'remit_to_control_idformula': PL/SQL program aborted.

Changes

Cause