Posted by
Mohammed Hamed on
Apr 01, 2021; 11:07pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/POXML-error-in-oracle-r12-tp9556p9564.html
The port and server is working fine.
Document ID 430023:11:0:104
Internal Transaction Type PO
Internal Transaction Subtype PRO
Party ID 17237
Party Type Supplier
Trading Partner Name GOLD STAR FOODS
Site Name PO BOX 4328 ONTARIO91761
URL Sent To
https://l8f5lgen5f.execute-api.us-west-1.amazonaws.com/dev
Generation Date 01-Apr-2021 06:52:43
Generation Status Success
Generation Message Message created and enqueued for delivery.
Module Name
Delivery Date 01-Apr-2021 11:39:58
Delivery Status Error
Delivery Message Invalid CACert File.
Retry Date
Retry Status
Retry Message
some log says this.
[Apr 1, 2021 10:05:59 AM PDT]:1617296759897:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Defer the Read of CLOB reference of Event Data
[Apr 1, 2021 10:05:59 AM PDT]:1617296759898:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Dequeued the following BusinessEvent -> BusinessEvent{name=oracle.apps.wf.notification.send, key=8156228, priority=50, correlationId
=null, sendDate=Thu Apr 01 10:05:11 PDT 2021, receiveDate=Thu Apr 01 10:05:59 PDT 2021, From Agent:Agent{agent=WF_NOTIFICATION_OUT, system=DV2.SAUSD.US}, To Agent: , Last Subscription=90FF
557CD883457B87435359EB7F9046, Error Message=null, Error Stack=null, OBJECT_NAME=oracle.apps.fnd.wf.worklist.server.AllNotificationsVO, GROUP_ID=8156228, ROLE=022235, CHANGE_TYPE=INSERT, #CU
RRENT_PHASE=100, ID_TYPE=PK, PK_NAME_1=NOTIFICATION_ID, PK_NAME_2=LANGUAGE, #MSG_DQ_ATTEMPTS=0, NOTIFICATION_ID=8156228, PK_VALUE_1=8156228, #MSG_ID=BEECC98D2DE540CCE0500F0ABE170BCF, BES_PA
YLOAD_OBJECT=false, Q_CORRELATION_ID=WFTESTS:OAFWK_MSG, PK_VALUE_2=US}
[Apr 1, 2021 10:05:59 AM PDT]:1617296759905:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[SVC-GSM-WFMLRSVC-168820-10010 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getNtfAttrValue(int, String)]:Exception occurred while getting notification attribute ->java.
sql.SQLException: ORA-20002: 3203: Attribute '#WFM_HTMLAGENT' does not exist for notification '8156228'.
ORA-06512: at "APPS.WF_NOTIFICATION", line 2359
ORA-06512: at line 1
[GC 35605K->18747K(63360K), 0.0025790 secs]
[Apr 1, 2021 10:06:06 AM PDT]:1617296766862:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Defer the Read of CLOB reference of Event Data
[Apr 1, 2021 10:06:06 AM PDT]:1617296766863:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Dequeued the following BusinessEvent -> BusinessEvent{name=oracle.apps.wf.notification.send, key=8156229, priority=50, correlationId
=null, sendDate=Thu Apr 01 10:05:11 PDT 2021, receiveDate=Thu Apr 01 10:06:06 PDT 2021, From Agent:Agent{agent=WF_NOTIFICATION_OUT, system=DV2.SAUSD.US}, To Agent: , Last Subscription=90FF
557CD883457B87435359EB7F9046, Error Message=null, Error Stack=null, OBJECT_NAME=oracle.apps.fnd.wf.worklist.server.AllNotificationsVO, GROUP_ID=8156229, ROLE=022235, CHANGE_TYPE=INSERT, #CU
RRENT_PHASE=100, ID_TYPE=PK, PK_NAME_1=NOTIFICATION_ID, PK_NAME_2=LANGUAGE, #MSG_DQ_ATTEMPTS=0, NOTIFICATION_ID=8156229, PK_VALUE_1=8156229, #MSG_ID=BEECC98D2DE640CCE0500F0ABE170BCF, BES_PA
YLOAD_OBJECT=false, Q_CORRELATION_ID=WFTESTS:PLSQL_MSG, PK_VALUE_2=US}
[Apr 1, 2021 10:06:06 AM PDT]:1617296766867:-1:-1:ndevapp.sausd.us:10.15.23.188:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1570283275:81015:161729262278
3:17:EXCEPTION:[SVC-GSM-WFMLRSVC-168820-10010 : oracle.apps.fnd.wf.mailer.NotificationFormatter.getNtfAttrValue(int, String)]:Exception occurred while getting notification attribute ->java.
sql.SQLException: ORA-20002: 3203: Attribute '#WFM_HTMLAGENT' does not exist for notification '8156229'.
ORA-06512: at "APPS.WF_NOTIFICATION", line 2359
ORA-06512: at line 1