U.S. Sales Tax Report Completes In Error - MSG-01001: Before Parameter MSG-01002: Starting after Parameter REP-1401 ORA-06502 (Doc ID 1664170.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Atttempting to run the US Sales Tax Report using the Ledger parameter and receive the following error:

MO_GLOB_ORG_ACCESS_TMP was flushed
Returning from PL/SQL procedure MO_GLOBAL.DELETE_ORGS
Calling PL/SQL procedure MO_GLOBAL.POPULATE_ORGS
p_org_id=116, p_sp_id=

"P_REPORTING_LEVEL='1000'
P_REPORTING_ENTITY_ID='1'
P_CHART_OF_ACCOUNTS_ID='50425'
P_GL_DATE_LOW='2013/10/01 00:00:00'
P_GL_DATE_HIGH='2013/10/31 00:00:00'
P_SHOW_DEPOSIT_CHILDREN='Y'
P_DETAIL_LEVEL='Summary'
P_ORDER_BY='CUSTOMER NAME'
P_POSTED_STATUS='ALL'
P_SHOW_CMS_ADJS_OUTSIDE_DATE='N'
P_SQL_TRACE='N'
P_USING_US_TAX_VENDOR='N'
P_SHOW_GL_WARNINGS='Y'
P_SHOW_TRX_WO_TAX='Y'"

"MSG-01001: Before Parameter from "
"MSG-01002: Starting after Parameter form trigger "
"MSG-01002: after Parameter form trigger : Predicate "
"REP-1401: 'afterpform': Fatal PL/SQL error occurred. "
"ORA-06502: PL/SQL: numeric or value

WORKAROUNDS
===========
Run the report for the Operating Unit

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms