Golden Tax : Unable To Search Consolidated Invoice With Draft Status On GTA Workbench Form (Doc ID 3068226.1)

Last updated on JANUARY 30, 2025

Applies to:

Symptoms

In Golden Tax Invoice Workbench, Getting below error while searching for the Consolidate invoices with draft status.

STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in Receivables Manager Responsibility
2. Transactions > Transactions
3. Create 2 AR Invoices
4. Run Receivables Transfer to Golden Tax Adaptor program
5. Log in Golden Tax Adaptor Responsibility
6. Golden Tax Invoices > Golden Tax Invoice Workbench
    Query Receivables Transactions created in step 3
    Select Invoices and Click "Consolidate" button
7. Check Golden Tax Invoice Consolidation program completed in concurrent requests
8. Re-query the Invoice by entering value in Status field as "Draft"
    Click Find button,below error encountered
    FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

Cause

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