Chilean Payables Withholding Certificate Shows No Data
Last updated on APRIL 09, 2018
Applies to:
Oracle Financials for the Americas - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1 version, Chile Payables
There is no data in the Chilean Payables Withholding Certificate (JLCLPWTC)
Expect to see data in the report
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Payables - Chile localization
2. Path: Other -> Requests -> Run
3. Run the Chilean Payables Withholding Certificate (JLCLPWTC)
Parameters:
Reporting Level: Operating Unit
Reporting Context: Level 3 CL OU - 654
Legal Entity Name:
Ledger Currency:
Certificate Year: 2014
Report Mode: Preview
Taxpayer ID:
Price Index: CHILEAN PI 2013
Print Company Information: Yes
There is no data in the output file.
There is no data for 2013, customer is testing invoices from 2014.
Ran in preview mode because need to continue working in the currently fiscal period.
There is not data in the table:
SELECT * FROM JL_CL_AP_AWT_CERT;
no rows selected
4. Analyses
select object_name, status
from all_objects
where object_name like 'FND_SEQNUM';
OBJECT_NAME STATUS
------------------------------ -------
FND_SEQNUM VALID
FND_SEQNUM VALID
FND_SEQNUM VALID
FND_SEQNUM VALID
FND_SEQNUM VALID
FND_SEQNUM VALID
FND_SEQNUM VALID
Original issue:
Responsibility: System Administrator
Path: Sequence -> Assign
Go to the Assignment
Enter Application = Latin America Localization
Open the lov for the Category field
The following error appears:
FRM-41830: List of values contains no entries.
As per Oracle® Financials for the Americas User Guide Release 12.1 Part No. E13422-02:
Page Chile 5-43
Defining Sequences for Withholding Tax Certificate Numbering
In Chile, you must send your suppliers withholding tax certificates to certify that you
withheld taxes from the professional service fees and participation amounts you paid
the suppliers. You can use the Chilean Payables Withholding Certificate in Oracle
Payables for Chile to print withholding tax certificates.
Before you run the Chilean Payables Withholding Certificate, however, you must define
document sequences with sequential numbering for Oracle Payables to use in
numbering the certificates. You can assign document sequences to the seeded Chilean
Payables Withholding Certificate document category to determine which sequences are
used for certificate numbering.
Enabling Sequential Numbering
Enable sequential numbering for your document sequences by entering Always Used or
Partially Used for the Sequential Numbering profile option. Use the System Profile
Values window to assign a value to the Sequential Numbering profile option.
Workaround:
Created the sequence manually.
SQL> select * from fnd_doc_sequence_assignments where category_code = 'JL_CL_AWT_CERT_CAT';
DOC_SEQUENCE_ASSIGNMENT_ID LAST_UPDA LAST_UPDATED_BY CREATION_ CREATED_BY LAST_UPDATE_LOGIN APPLICATION_ID DOC_SEQUENCE_ID CATEGORY_CODE
-------------------------- --------- --------------- --------- ---------- ----------------- -------------- --------------- ------------------------------
7594 05-FEB-14 70095 05-FEB-14 70095 45977597 7004 2504 JL_CL_AWT_CERT_CAT
START_DAT END_DATE SET_OF_BOOKS_ID METHOD_CODE
--------- --------- --------------- ------------------------------
01-JAN-12 774
SQL> select * from fnd_document_sequences where doc_sequence_id = 2504;
DOC_SEQUENCE_ID NAME LAST_UPDA LAST_UPDATED_BY CREATION_ CREATED_BY LAST_UPDATE_LOGIN APPLICATION_ID
--------------- ------------------------------ --------- --------------- --------- ---------- ----------------- --------------
2504 CHILE_WTH_SEQ 03-FEB-14 70095 03-FEB-14 70095 45975466 7004
AUDIT_TABLE_NAME M START_DAT T DB_SEQUENCE_NAME END_DATE INITIAL_VALUE TABLE_NAME
------------------------------ - --------- - ------------------------------ --------- ------------- ------------------------------
JL_DOC_SEQUENCE_AUDIT N 03-FEB-10 A FND_DOC_SEQ_2504_S 1 JL_CL_AP_AWT_CERT
Application: Latin America Localizations
Code: JL_CL_AWT_CERT_CAT
Name: Withholding Tax Certificate
Table Name: JL_CL_AP_AWT_CERT
The issue has the following business impact:
It's not possible to show this requirement in the CRP1
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms