Chilean Payables Withholding Certificate Shows No Data

Last updated on APRIL 09, 2018

Applies to:

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