correr tkprof

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


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.


3/9

Thanksqin

28-JAN-08 20:22:16 GMT


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


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:


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


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.


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


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





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


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




4) Run Prepayment Status Report,


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


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


31-JAN-08 07:53:04 GMT


01-FEB-08 13:51:37 GMT

Hi,

The DEV is actively working on the bug.


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


05-FEB-08 08:03:59 GMT


05-FEB-08 14:34:58 GMT


06-FEB-08 12:06:24 GMT


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


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.

Documents

correr tkprof