Setting up a Receivable Activity Raises Error: ORA-01403: No data found and FRM-40735: PRE-FORM trigger raised unhandled
Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
ARXSUMRT
Symptoms
When attempting to create or update a Receivables Activity, the following error occurs.
ERROR:
ORA-01403: No data found
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-1403.
Steps to Reproduce:
Respopnsibility: Receivables Manager
Navigation: Setup > Receipts > Receivables Activities
1. Enter an operating unit
2. Enter a Name
3. Change Type
Cause
No Party Tax Profile (eBusiness Tax) has been setup for this Operating Unit.
Creating a Party Tax Profile for the operating unit is required to Setup in Receivable Activities in Oracle Receivables.
A better error message mechanism is provided via Bug 7677429 ARXSUMRT SETUP RECEIVABLE ACTIVITY ERROR FRM-40735 WHEN-VALIDATE-ITEM ORA-1
Solution
1. A Party Tax Profile is a pre-requisite to creating Receivable Activities, Please create Party Tax Profile for this OU
Responsibility: Tax Managers
Navigation: Party Tax Profile
Choose Party Type= Operating Unit owing Tax Content
Select Party Name= Operating Unit
Create Party Tax Profile for the new operating unit.
2. For a better error message raised by the form, please apply the following:
1. Bug Summary
Description
Unhandled exception in creating a Receivable Activity Raises ORA and FRM errors
Workaround
None
Resolution
Provided better error handling by providing a user-friendly error message.
2. Fixed Files
R12.AR.A:
ARXSUMRT.fmb 120.25.12000000.7
R12.AR.B:
ARXSUMRT.fmb 120.25.12010000.5
3. Recommended Patches
R12.AR.A and R12.AR B: Patch 7677429
R12.AR.B: No standalone patch released. However, the fix is included in R12.1.1
4. Solution Steps
Ensure that you have taken a backup of your system before applying the recommended patch.
Apply the patch in a test environment.
Confirm the file versions listed above.
You can use the commands like the following:
strings -a $AR_TOP/filename |grep '$Header'
Retest the issue.
Migrate the solution as appropriate to other environments.
If the patch for your release is unavailable for download or needs a password, please contact Oracle Support for Assistance.
References
Well-ordered guidelines to Solve Oracle Error Message ORA-01924 through Remote DBA Services
ReplyDeleteThe Error ORA-01924 means part string not yielded or does not exist. This misstep happens exactly when trying to set part using either DBMS_SESSION.SET_ROLE or SET ROLE on the 601th+ section. Well! This issue gives off an impression of being extraordinarily nefarious and customers are not prepared to handle by have. For this circumstance you need to get advise with any best help provider association who settles these issues without taking as much time as is required. By and by, for best game plan you have to contact either Database Administration for Oracle or Online Oracle DB Support.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801