Oracle EBS AP:PayablesOpenInterfaceImportNotCreatingTaxLineForInvoice

Oracle EBS AP:PayablesOpenInterfaceImportNotCreatingTaxLineForInvoice

Oracle EBS  AP: Payables Open Interface Import Not Creating Tax Line For Invoice

AP: Payables Open Interface Import Not Creating Tax Line For Invoice

当 calc_tax_during_import_flag calc_tax_during_import_flag  为N 情况下

1.Rejection Reason "TAX DATA FOUND ON NONTAX LINES" 

TAX DATA FOUND ON NONTAX LINES 

税行 必须

tax_regime_code

tax

tax_status_code

tax_rate_code

tax_rate_id

tax_jurisdiction_code 

注意 

tax_jurisdiction_code 此项是问题的一个关键点,常常被忽略，tax_jurisdiction_code 是税率设置中税务管辖区域代码，

检查脚本如下

  SELECT ratesbeo.tax_regime_code

       ,ratesbeo.tax

       ,ratesbeo.tax_status_code

       ,ratesbeo.tax_rate_code

       ,ratesbeo.tax_rate_id

       ,ratesbeo.tax_jurisdiction_code

    FROM apps.zx_mco_eo_rates_v   ratesbeo

    WHERE ratesbeo.tax_rate_code =&p_line_tax_code

                AND ratesbeo.active_flag = 'Y'

               AND ratesbeo.rate_type_code <> 'RECOVERY';

如果 tax_jurisdiction_code  设置具体的区域 那么税行必须要对 tax_jurisdiction_code进行赋值

2.Rejection Reason "ZX_TAX_RATE_ID_CODE_MISSING" 

确保ITEM行 

line_group_number 

org_id

tax_classification_code

税行 必须

line_group_number 

org_id

tax_regime_code

tax

tax_status_code

tax_rate_code

tax_rate_id

tax_jurisdiction_code 

--- 刘轶鹤