'ORA-00904: "XXXX": invalid identifier' Error While Running JEPTAPER: Portuguese Payables Taxpayer ID Exception Report and JEPTARER: Portuguese Receivables Taxpayer ID Exception Report (Doc ID 3035631.1)

Last updated on JULY 23, 2024

Applies to:

Symptoms

JEPTAPER: Portuguese Payables Taxpayer ID Exception Report and JEPTARER: Portuguese Receivables Taxpayer ID Exception Report is completing with below error when the report is submitted with Balancing Segment Parameter:

The error can be seen in Log file of the request.

Report is working fine when it is submitted without this parameter.

Following are the steps to replicate the issue:
1. Go to Portuguese Payables Responsibility 
2. Navigate to view -> Requests -> Submit a single request -> Ok
3. Submit Portuguese Payables Taxpayer ID Exception Report. Make sure to provide the Balancing Segment Parameter.
4. Verify the Log file of the request once the request is completing in error.
5. For Portuguese Receivables Taxpayer ID Exception Report, follow the same steps from 2 to 4 from Portuguese Receivables Responsibility.

Cause

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