My Oracle Support Banner

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

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.