Scribd Logo
Upload

Welcome to Scribd!

  • 121 views

    Ebiz Tax and AP Issues

    Uploaded by

    Beverly Baker-Harris
    This document provides troubleshooting steps for resolving eBusiness Tax issues in Oracle Payables and E-Business Tax versions 12.0 and later. It includes steps to check the patch level, form and package versions, review diagnostic scripts for the RDA, application data, and tax setup, and obtain debug logs. The document also lists notes that describe known issues and recommended patches.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Ebiz Tax and AP Issues

    Uploaded by

    Beverly Baker-Harris
    121 views5 pages
    This document provides troubleshooting steps for resolving eBusiness Tax issues in Oracle Payables and E-Business Tax versions 12.0 and later. It includes steps to check the patch level, form and package versions, review diagnostic scripts for the RDA, application data, and tax setup, and obtain debug logs. The document also lists notes that describe known issues and recommended patches.

    Original Description:

    EBIZ TAX

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides troubleshooting steps for resolving eBusiness Tax issues in Oracle Payables and E-Business Tax versions 12.0 and later. It includes steps to check the patch level, form and package versions, review diagnostic scripts for the RDA, application data, and tax setup, and obtain debug logs. The document also lists notes that describe known issues and recommended patches.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    121 views5 pages

    Ebiz Tax and AP Issues

    Uploaded by

    Beverly Baker-Harris
    This document provides troubleshooting steps for resolving eBusiness Tax issues in Oracle Payables and E-Business Tax versions 12.0 and later. It includes steps to check the patch level, form and package versions, review diagnostic scripts for the RDA, application data, and tax setup, and obtain debug logs. The document also lists notes that describe known issues and recommended patches.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5
    At a glance
    Powered by AI
    The document describes various troubleshooting steps, diagnostics scripts and notes to help troubleshoot eBusiness Tax issues. It provides guidance on collecting system information, reviewing logs, checking setup and more.

    The document lists 12 troubleshooting steps including checking patch levels, form/report versions, package versions, running diagnostics scripts, reviewing logs and more.

    The RDA/ACT script provides details on all the AP versions of code installed at the site which can help identify inconsistencies or issues.

    To Bottom

    Modified:Jan 16, 2013 Type:TROUBLESHOOTING

    In this Document

    Purpose
    Troubleshooting Steps
    References

    APPLIES TO:

    Oracle Payables - Version 12.0.0 and later


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

    PURPOSE

    The purpose of this troubleshooting guide is to help on collecting the


    required information to troubleshooting eBTax issues and provide a summary
    of the known patches & issues.

    TROUBLESHOOTING STEPS

    1. Patchset level

    Run the following SELECT script:


    select patch_level
    from fnd_product_installations
    where patch_level like '%<product>%';
    For example:
    select patch_level
    from fnd_product_installations
    where patch_level like '%AP%';

    2. Form Version or Report version


    Run the following UNIX command:
    cd $<product>_TOP/forms/US
    strings -a <form executable name>* |grep -i '$Header'
    or
    cd $<product>_TOP/reports/US
    strings -a <report executable name>* |grep -i '$Header'
    For example:
    cd $AP_TOP/forms/US
    strings -a APXINWKB* |grep -i '$Header'

    3. Packages versions

    Run the following SELECT script:


    SELECT owner
    , name
    , text
    , SUBSTR( LTRIM(text)
    , INSTR(lTRIM(text),' ',1,2 )+1
    , INSTR(lTRIM(text),' ',1,4)-INSTR(LTRIM(text),' ',1,2 )-1
    ) filever
    FROM all_source
    WHERE line = 2
    AND name IN
    ( 'AP_INVOICE_DISTRIBUTIONS_PKG'
    , 'AP_INVOICE_LINES_PKG'
    , 'AP_APPROVAL_PKG'
    , 'AP_UTILITIES_PKG'
    , 'AP_ETAX_SERVICES_PKG'
    , 'AP_ETAX_UTILITY_PKG'
    , 'AP_MATCHING_PKG'
    , 'AP_MATCHING_UTILS_PKG'
    , 'ZX_TDS_CALC_SERVICES_PUB_PKG'
    , 'ZX_SRVC_TYP_PKG'
    , 'ZX_API_PUB'
    , 'ZX_TCM_PTP_PKG'
    , 'ZX_TRL_PUB_PKG'
    , 'ZX_TRL_MANAGE_TAX_PKG'
    , 'ZX_VALID_INIT_PARAMS_PKG'
    , 'ZX_GLOBAL_STRUCTURES_PKG'
    , 'ZX_CHECK_REQUIRED_PARAMS_PKG'
    , 'ZX_SECURITY'
    , 'ZX_TRL_DETAIL_OVERRIDE_PKG'
    , 'ZX_TRL_SUMMARY_OVERRIDE_PKG'
    , 'ZX_TDS_TAX_ROUNDING_PKG'
    , 'ZX_DEFAULT_AUTOMATION_PKG'
    , 'ZX_TCM_EXT_SERVICES_PUB'
    , 'ZX_TDS_TAX_LINES_POPU_PKG'
    , 'ZX_TDS_TAX_LINES_DETM_PKG'
    , 'ZX_TDS_APPLICABILITY_DETM_PKG'
    , 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG'
    , 'ZX_TRL_ALLOCATIONS_PKG'
    , 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG'
    , 'ZX_TDS_TAX_LINES_POPU_PKG'
    , 'ZX_AP_EXTRACT_PKG'
    , 'ZX_AP_POPULATE_PKG'
    , 'ZX_AR_EXTRACT_PKG'
    , 'ZX_AR_POPULATE_PKG'
    , 'ZX_NEW_SERVICES_PKG')
    ORDER BY owner, name, text;

    4. RDA/ACT script

    Upload the results for the RDA/ACT diag script showing all the AP versions
    of code at your site.
    See Note.420427.1 Gen Ext/Pub All RDA Data Collection Test

    5. IF the problem occurs in a form ==> Last query

    Review and provide last query executed, as follows:


    Login to the Oracle Applications.
    Open the form where the problem occurs.
    Reproduce the problem
    Choose Help -> Diagnostics -> Examine
    Select block=system and field=last query.
    Upload the script that appears in the Value field.

    6. Debug tax log file

    Issue can arise either in a concurrent request (program) or in a form (on-


    line process).
    In both cases use MOS Note:1320736.1 and follow the suggested steps to
    get this information.

    7. IF the problem is in the invoice validation ==> WORKAROUND

    a) Is the online invoice validation working? Can it be used as a


    workaround?
    b) Are you able to create the tax line manually? Can it be used as a
    workaround?

    8. IF it's a data problem ==> APLIST

    Review the results for the APLIst diag script for the involved invoice(s)
    See Note:419773.1 or Note:732163.1. Note:167000.1 can also help with
    diagnostics.

    9. IF it's a setup problem ==> Tax Setup Test

    Review the results for the E-Business Tax Setup Test diag script
    See Note:462877.1 or Note:732162.1. Note:167000.1 cna also help with
    diagnostics. < a>10. Setup & Diagnostics

    Note:462877.1 - eBTax Setup Test diag script (OA release 12.0.4-)


    Note:732450.1 - eBTax Setup Test diag script (OA release 12.0.6+)
    Note:732091.1 - Applications DBA RDA Data Collection Test
    Note:1117544.1 - E-Business Tax (EBTax) Information Center
    Note:1320736.1 - R12: How To Get The FND Debug Log For On-Line Processes
    And For Concurrent Requests

    11. Known Issues

    Note:744185.1 - eBusiness Tax Release 12 Error Messages: Causes and


    Actions
    Note:1288314.1 - Tax Unhandled Errors Presentations and Solutions
    Note:1305895.1 - Known Issue in EBTax Reporting
    Note:1316316.1 - EBTax Data Corruption Issues & Recommended Solutions
    Note:1082172.1 - Overview and Basic Troubleshooting of Tax That Does Not
    Calculate in R12 E-Business Tax (EBTAX)
    Note:1152123.1 - R12 E-Business Tax/Payables Data-Fixes: Cause and action
    to handle ZX_LINES_SUMMARY_U1 issue
    Note:1323750.1 - EBTax Known Data Corruption Issues and Recommended
    Solutions

    12. Recommended Patches

    Note:954704.1 - EBS: R12.1 Oracle Financials Recommended Patch Collection


    (RP

    You might also like