8/7/2019 correr tkprof
1/9
correr tkprof
Resolution History
25-JAN-08 00:45:01 GMT
### Detailed Problem Statement ###When I run request "Prepayment Status Report" this not displaying PO Number
### Steps to Reproduce ###Payable Super User ResponsabilityView -> Request -> Submit a New Request -> Single RequestName Prepayment Status ReportParameters:Include Invoices YESInclude Credit/Debit Memos NOSupplier Type
Supplier NameFrom Date 22-JAN-2008To Date 24-JAN-2008Prepayment Type TemporaryShow Prepayment Lines YES
SubmitView OutputI view the invoice but in the PO Number Column is null, if I review the invoiceismatch with PO Number
### Instance Name and Type of System ###
TEST
### Recent Changes ###NA
### Workaround ###NA
### Impact on Business ###I need the match Prepayment vs PO Number
### Files to be Loaded:Note183274.1,Note198799.1 ###
No Files
Can you easily recover from, bypass or work around the problem?No
Does your system or application continue normally after the problem occurs?Yes
Are the standard features of the system or application still available; is the loss of service minor?Yes
Contact me via : MetaLink
8/7/2019 correr tkprof
2/9
25-JAN-08 00:48:03 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:Prepayments_Status_Report_240108.txt
25-JAN-08 00:51:02 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:Oracle_Diagnostics_Report_Prepayment_PO.htm
25-JAN-08 00:52:14 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:444_PREPAYMENT.doc
25-JAN-08 00:53:03 GMT
New info : [email protected] Prepayment is 444 an the PO Number is 103
Thank You
25-JAN-08 04:22:10 GMT
UPDATE
======Hi Dulce,
Thank you for using MetaLink. We are currently reviewing/researching the situation and will update the Service Request (SR) or call youas soon as we have relevant information. Thank you for your patience.
Best Regards,Global Customer Services
STATUS=======
@WIP -- Work In Progress
25-JAN-08 04:22:19 GMT
Email Update button has been pressed: Sending email to [email protected].
28-JAN-08 20:22:07 GMT
Hi,
please upload the report in English,also please upload the log file.
8/7/2019 correr tkprof
3/9
Thanksqin
28-JAN-08 20:22:16 GMT
Email Update button has been pressed: Sending email to [email protected].
28-JAN-08 21:45:23 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:Prepayments_Status_Report_280108LOG.txt
28-JAN-08 21:47:38 GMT
Hi,
are these prepayments in the report matched to PO?
please provide me your version:
cd $AP_TOP/reports/USstrings -a APXINPSR.rdf grep '$Header'
ThanksQin
28-JAN-08 21:47:47 GMT
Email Update button has been pressed: Sending email to [email protected].
28-JAN-08 21:48:07 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:Prepayments_Status_Report_280108444english.txt
28-JAN-08 21:57:05 GMT
New info : [email protected]
I did upload the report and the Log Files
Thank you
29-JAN-08 14:13:47 GMT
Hi,
please do:
1)please provide me your version:
8/7/2019 correr tkprof
4/9
cd $AP_TOP/reports/USstrings -a APXINPSR.rdf grep '$Header'
2) To download and install the eBusiness Oracle Diagnostics Framework Oracle Diagnostic Suppport Pack
To access using the Application Diagnostic Framework. Please run the Accounts Pa
yables (AP) Invoice Data Collection Test=================================================================================================
Please run the "Accounts Payables (AP) Invoice Data Collection Test" against theprepayment "96667",please upload the result.
ThanksQin
29-JAN-08 14:13:55 GMT
Email Update button has been pressed: Sending email to [email protected].
29-JAN-08 16:07:12 GMT
The customer : [email protected] : has uploaded the following file via MetaLink:Oracle_Diagnostics_Report96667.htm
29-JAN-08 16:08:15 GMT
New info : [email protected] Qin
1)In the afternoon I will tell the version
2) I upload the Diagnostic for the prepayment 96667
29-JAN-08 16:14:06 GMT
Hi,
ok, once you provide me the version,I will file a new bug.
please also verify the following steps.
steps======
0) APXINPSR.rdf 120.7.12000000.2
1) create a prepayment and match to a PO,
2) validate the prepayment,
3) pay the prepayment, so the prepayment is available for applying.
8/7/2019 correr tkprof
5/9
4) Run Prepayment Status Report,the prepayment is in the report,but it does not display the PO number on the prepayment in the report.
Thanks
Qin
29-JAN-08 16:14:14 GMT
Email Update button has been pressed: Sending email to [email protected].
29-JAN-08 19:36:13 GMT
New info : [email protected]
Hi Qin
[applmgr@ITZAMNA US]$ pwd
/d01/oracle/TEST/apps/apps_st/appl/ap/12.0.0/reports/US
[applmgr@ITZAMNA US]$ strings -a APXINPSR.rdf grep '$Header'
w$Header: APXINPSR.rdf 120.7.12000000.2 2007/04/23 23:40 gagrawal ship
$
[applmgr@ITZAMNA US]$
29-JAN-08 20:00:04 GMT
Hi,
please let me know if the following is your issue:
steps======
0) APXINPSR.rdf 120.7.12000000.2
1) create a prepayment and match to a PO,
2) validate the prepayment,
3) pay the prepayment, so the prepayment is available for applying.
8/7/2019 correr tkprof
6/9
4) Run Prepayment Status Report,the prepayment is in the report,but it does not display the PO number on the prepayment in the report.
ThanksQin
29-JAN-08 20:00:11 GMT
Email Update button has been pressed: Sending email to [email protected].
29-JAN-08 23:06:05 GMT
New info : [email protected] Qin
I was review the Report and I viewed that when I selected Show Prepayments Lineslike "YES". The values Line
Num, Line Type, Line Description, Line Amount, PO Number, Receipt Number andAmount Remaining were null
1) create a prepayment and match to a PO,R=OK
2) validate the prepaymentR=OK
3) pay the prepayment, so the prepayment is available for applying.R=OK
4) Run Prepayment Status Report,the prepayment is in the report,but it does not display the PO number on the prepayment in the report.R=YES
ThanksQin
30-JAN-08 14:11:17 GMT
Hi,
Bug 6784808 has been filed for the following issue.I will update you asap.
steps======
0) APXINPSR.rdf 120.7.12000000.2
1) create a prepayment and match to a PO,
2) validate the prepayment,
3) pay the prepayment, so the prepayment is available for applying.
4) Run Prepayment Status Report,
8/7/2019 correr tkprof
7/9
the prepayment is in the report,but it does not display the PO number on the prepayment in the report.
ThanksQin
30-JAN-08 14:11:32 GMT
Email Update button has been pressed: Sending email to [email protected].
30-JAN-08 14:21:11 GMT
Associated bug 6784808 has been updated and is still at status: 11.
30-JAN-08 21:55:53 GMT
.GLOBAL ESCALATION REQUEST
==========================The customer called. They want to escalate this issue.
Requestor's name, if different from header: HECTOR CARRILLO DULCE GONZALEZRequestor's email, if different from header: [email protected]'s telephone number, if different from header: +52-998-843-5647
Requested manager callback: NORequested severity change: YES, to SEV2 ESC
Reason for Escalation:Expedite the resolution of this SR, in order to solve the issue as soon as possible.
Thank you.Catalina VelasquezOracle HUB Team
30-JAN-08 21:57:47 GMT
Email Update button has been pressed: Sending email to [email protected] [email protected].
31-JAN-08 01:21:47 GMT
Associated bug 6784808 has been updated and is still at status: 11.
31-JAN-08 07:53:04 GMT
Associated bug 6784808 has been updated and is still at status: 11.
01-FEB-08 13:51:37 GMT
Hi,
The DEV is actively working on the bug.
8/7/2019 correr tkprof
8/9
I will update you asap.
ThanksQin
01-FEB-08 13:51:45 GMT
Email Update button has been pressed: Sending email to [email protected] [email protected].
05-FEB-08 05:04:31 GMT
Associated bug 6784808 has been updated and has changed status to 30.
05-FEB-08 06:33:20 GMT
Associated bug 6784808 has been updated and is still at status: 11.
05-FEB-08 08:03:59 GMT
Associated bug 6784808 has been updated and has changed status to 30.
05-FEB-08 14:34:58 GMT
Associated bug 6784808 has been updated and is still at status: 11.
06-FEB-08 12:06:24 GMT
Associated bug 6784808 has been updated and has changed status to 30.
06-FEB-08 15:00:03 GMT
Hi,
please provide us the trace file:
1) System Administrator Responsibility,Concurrent->Program->Define,query on Short Name = APXINPSR,Set Enable Trace = Yes,save it.
2) Clean up all the trace files under $USER_DUMP_DEST
$ORACLE_HOME/admin/TEST_itzamna/udump
3) Run the Prepayment Status Report for the following paramters:
@ Include Invoices - Yes@ Include Credit/Debit Memos - No@ Supplier Type -@ Supplier Name - fill in one of suppliers which has matched prepayment@ From Date - 22-JAN-2008@ To Date - 24-JAN-2008@ Prepayment Type - Temporary
@ Show Prepayment Lines - Yes
8/7/2019 correr tkprof
9/9
4) Find the trace file under $USER_DUMP_DEST
$ORACLE_HOME/admin/TEST_itzamna/udump
5) tkprof explain=apps/pwd
6) please upload the trace file and the tkprof output file.
7) Please upload the log file.