My Oracle Support Banner

Award By Spreadsheet And Analyze By Spreadsheet Is Not Showing Any Data After Export (Doc ID 2580171.1)

Last updated on AUGUST 22, 2019

Applies to:

Oracle Sourcing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Auction/RFx creation

ACTUAL BEHAVIOR
---------------
Award By Spreadsheet And Analyze By Spreadsheet is not showing any data after export

EXPECTED BEHAVIOR
-----------------------
When opening the folder the appropriate content should exist.

FND log shows following exception
-----------------------------------------------
pon.loader.xml.server.AwardXmlWorkbook.writeStartRowTag 1 BEGIN
pon.loader.xml.server.XmlWorksheet 1 set Worksheet rowNum:18
pon.loader.xml.server.AwardXmlWorkbook.writeEmptyCellXml 1 BEGIN
pon.loader.xml.server.AwardXmlWorkbook.writeCellXml 1 BEGIN: core method null null null -1 1 -1 null null null false
pon.loader.xml.server.AwardXmlWorkbook.allElementsFinished 1 BEGIN
pon.loader.xml.server.XmlWorksheet 1 set Worksheet columnNum:1
pon.loader.xml.server.AwardXmlWorkbook.writeTblReadOnlyCellXml 1 BEGIN: 3 params
UNEXPECTED_OA_EXCEPTION: user name = P157260: responsibility name = XYZ Sourcing Buyer 6 "oracle.apps.fnd.framework.OAException: java.sql.SQLSyntaxErrorException: ORA-00904: ""PAI"".""AWARD_STATUSL"": invalid identifier

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.pon.loader.xml.server.AwardXmlWorkbook.downloadXml(AwardXmlWorkbook.java:1643)
at oracle.apps.pon.loader.award.server.ExportAwardsAppModuleImpl.writeZipFileXml(ExportAwardsAppModuleImpl.java:2033)
at oracle.apps.pon.loader.award.server.ExportAwardsAppModuleImpl.writeZipFileXml(ExportAwardsAppModuleImpl.java:2078)
at oracle.apps.pon.loader.award.webui.ExportAwardsPageCO.download(ExportAwardsPageCO.java:720)
at oracle.apps.pon.loader.award.webui.ExportAwardsPageCO.processFormRequest(ExportAwardsPageCO.java:374)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:924)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)

STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Select the Sourcing responsibility
2. Under the Negotiations tab select a published negotiation
3. Under the Action drop down LOV select Analyze by Spreadsheet
4. Click Export
5. Click OK
6. Open the folder you save the zip file to
7. Open the Zip file and notice it is blank
 

Cause

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
Symptoms
Cause
Solution
References


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