How to Resolve Common Errors Encountered on SAFT Feature for Portugal
(Doc ID 2068837.1)
Last updated on FEBRUARY 22, 2023
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 |
| 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: 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: 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: 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 |