Unnecessary Debug Message Is Logged to FND_LOG_MESSAGES and A Request Log Even when Standard Purchase Order Import Or Requisition Import Ends With No Issue.
(Doc ID 2939934.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
Oracle Purchasing - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Actual Behavior
FND debug log option is set as below on a production instance to catch the unexpected error.
FND: Debug Log Enabled : Yes
FND: Debug Log Level : Unexpected
On Import Standard Purchase Order Import (PDOI), purchase orders are imported successfully but the following message is shown on a request log file
and some messages are inserted into FND_LOG_MESSAGES.
A Request Log file;
against FND_LOG_MESSAGES table:
AUDSID = 18892210
Message in FND_LOG_MESSAGES;
select * from FND_LOG_MESSAGES where AUDSID = 18892210;
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Start Time :27-02-2023 16:08:48
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 End Time :27-02-2023 16:08:48
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Total Time :0:0:0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of partner calls :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Time taken by partner(secs) :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of records in ZX_TRX_HEADRS_GT :1
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of records in ZX_TRANSACTION_LINES_GT :3
<snip>
po.plsql.PO_PDOI_PVT.wrap_up. 10 Timing Stat: PDOI_ALL-1: Start=16:08:49.080,
End=16:08:49.488, Duration=+00 00:00:00.407303
po.plsql.PO_PDOI_PVT.wrap_up. 10 Timing Stat: PREPROCESSING-1:
Start=16:08:49.095, End=16:08:49.103, Duration=+00 00:00:00.008152
po.plsql.PO_PDOI_PVT.wrap_up. 10 Timing Stat: HEADER_GROUPING-1:
Start=16:08:49.103, End=16:08:49.105, Duration=+00 00:00:00.001689
po.plsql.PO_PDOI_PVT.wrap_up. 10 Timing Stat: MAIN_PROCESSING-1:
Start=16:08:49.105, End=16:08:49.325, Duration=+00 00:00:00.220225
po.plsql.PO_PDOI_PVT.wrap_up. 10 Timing Stat: HEADER_PROCESS-1:
Start=16:08:49.105, End=16:08:49.109, Duration=+00 00:00:00.004010
<snip>
This issue also occurs on Requisition Import where Purchase order is created automatically by CREATE PO Workflow.
Expected Behavior
- If PDOI succeeded without any issue, any log message should not be inserted into FND_LOG_MESSAGES, in order not to consume database resource.
- If PDOI succeeded without any issue, the message "To get the log messages for PDOI...." should not be shown on a request log, in order not to confuse users.
Steps to Reproduce
- Navigate to System Administrator > Profile > System > Set profile option "FND: Debug Log Enabled" = Yes, FND: Debug Log Level = Unexpected
- Execute Standard Purchase Orders Import.
- Review a request log file.
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 |