My Oracle Support Banner

How to Resolve Common Errors Encountered on SAFT Feature for Portugal (Doc ID 2068837.1)

Last updated on JANUARY 06, 2021

Applies to:

EMEA Add-on Localizations - Version 12.0.6 to 12.2.3 [Release 12 to 12.2]
Information in this document applies to any platform.

Purpose

 This note explains how to resolve several errors that can occur during SAFT xml validation on Portuguese Tax Authority Link, errors generated during SAFT program execution as well as other errors that can occur while validating the xml data.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 A-   Errors during the execution of program CLE:Generate SAFT-PT Audit File XML Data
 In this section we will explain how to solve some common ORA error occurring while running program CLE:Generate SAFT-PT Audit File XML Data
 Issue: "WDI"."SYSTEM_ENTRY_DATE": invalid identifier
 Issue: CANNOT INSERT NULL INTO ("GL"."GL_ACCTS_MAP_INT_GT"."FROM_CCID")
 Issue: The GLD is an alias for the table cle_f361_saft_gl_data
 Issue: ORA-06512: at "APPS.GL_ACCOUNTS_MAP_GRP"
 Issue: ORA-01427: single-row subquery returns more than one row
 Issue: ORA-01427: single-row subquery returns more than one row
 
 B -  Common errors on SAFT validator link
 In this section we will explain how to solve some common errors occurring during SAFT xml validation. Please note that SAFT feature is compliant only with the latest version required by Portuguese Tax Authorities (version 1.04_01) and the validation should be done against this version. SAFT xml file 1.04 can be validated through the following links:
 Issue: 'SourceBilling' is not valid
 Issue: 'InvoiceType' is not valid
 Issue: InvoiceProductCodeConstraint not found for identity constraint
 Issue: 'EACCode' is not valid
 Issue: 'DocumentNumber' is not valid
 Issue: 'GroupingCategory' is not valid
 Issue: 'GeneralLedgerEntries' is not complete
 Issue: element 'TaxCode' is not valid.
 Issue: 'PostalCode' is not valid
 Issue: element 'Line' is not complete
 Issue: Customer element 'City',    'PostalCode'   ,'Country' is not valid
 Issue: Supplier element 'City',    'PostalCode'   ,'Country' is not valid
 Issue: GeneralLedgerEntriesSupplierIDConstraint
 Issue: 'PaymentPaymentRefNoCustomerIDConstraint'
 Issue: 'PaymentRefNo' is not valid
 Issue: SAFT XML validation error for 12+4 periods calendar setup.
 Issue: Some transactions are exported on Annual SAFT report but not on Monthly SAFT report.
 Issue: LDFF CLE: Additional Information On AR Transaction Type
 C -  Others
  Different kind of issues that can occur on SAFT feature
 Issue: GDFF on  shipping transactions
 Issue: Function not available to this responsibility
 Issue: Key 'InvoiceProductCodeConstraint'
 Issue: 'CreditAmount' is not valid
 Issue: 'GeneralLedgerEntriesSupplierIDConstraint
 Issue: 'ProductDescription' is not valid
 Issue: Invalid content was found starting with element 'DebitAmount'
 Issue: Invalid content was found starting with element 'CreditAmount'
 Issue: Constrain “WorkDocumentDocumentCustomerIDConstraint” violated
 Issue: Invalid content was found starting with element 'DocumentTotals'
 Issue: 'InvoiceProductCodeConstraint'
 Issue: Line details not printed on migrated transactions
 Issue: Invalid content was found starting with element 'TaxExemptionReason'
 Issue: Payment lines not exported for bills receivables cash receipts in case of Short_Term_Debt Source Type.
 Issue: Reversed Payments are not exported to the SAFT
 Issue: SAFT not showing line information for some receipts
 D -  Questions and Answers
 Question: Number of GL entries (GeneralLedgerEntries) contains the correct data, but General Ledger block didn't export GL Journals on SAFT xml file. What can be the difference between the entries on these blocks?
 Question: GDFF JG_RA_CUSTOMER_TRX for the context JE.PT.ARXTWMAI.CLE_SAFT - What is the Source System Id? it is required, but it has no LOV assigned.
 Question: GDFF JG_RA_CUSTOMER_TRX for the context JE.PT.ARXTWMAI.CLE_SAFT -  What happens if we enter the same value or different values in the Source System?, in other words, what is the repercussion of this value when running the Extraction?
 Question: How to populate the Global Descriptive FlexFields (GDFF) on shipping transaction window ?
 Question: How is SAFT program using the information from "Applicable to SAFT Reporting" flag in JG_RA_BATCH_SOURCES FlexField?
 Question: How is SAFT program populating the Hash Tags?
 Question: The setup of SAFT program in release 11i is the same as R12 setup?
 Question: Users are using the following link to upload the SAFT files (11i) to Portugal Government Site (https://faturas.portaldasfinancas.gov.pt/enviarSaftAppletForm.action). Is there any separate site available to upload the R12 Version files?
 Question: Is it compulsory to use the 1.04 version to upload the SAFT files? Is it okay to use 1.03  version ?
 Question: We have a file version of 1.02, do we have to make any changes in the way we upload the file to government application for 1.04 version?
 Question: Why can I upload the SAFT xml file on efacturas link
 Question: Why can't I use the accounts defined in my Chart Of Accounts?
 Question: Parent Accounts balances need to be exported on GeneralLedger Block
 Question: What is the "Self Billing" LDFF at customer level?
 Question: What is the profile CLE: PT Tax Code not subject to VAT and how should be the LDFF for this profile and for Zero Taxes used on transactions?
References

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