how can i check the error of Journal import date source

最新推荐文章于 2024-07-09 10:04:12 发布

cuisi0912

最新推荐文章于 2024-07-09 10:04:12 发布

阅读量719

点赞数

文章标签：数据库开发工具

历史记录

ORION_MIGRATION - 2009年10月7日下午02时19分04秒

问题说明: how can i check the error of Journal import date source?

ORION_MIGRATION - 2009年10月7日下午02时19分05秒

### Detailed Problem Statement ###
1、when i run import Journals,there has warning.
2、i want to check the source of the gl import date.

### Steps to Reproduce ###
1、when i run import Journals,there has warning.
2、i want to check the source of the gl import date.

### Instance Name and Type of System ###
test

### Recent Changes ###
no

### Workaround ###
No

### Impact on Business ###
For we don't know what is the reason caused the problem,we may have the some error in the next period

### Files to be Loaded:Note183274.1,Output,Log ###
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?
No

Contact me via :
E-mail -> zhangxiaoying@tjpcb.com

Oracle 技术支持 - 2009年10月7日下午02时41分17秒

(Update for record id(s): 388056683)

UPDATE
======
Hi Hui,

We are currently reviewing/researching the situation and will update the SR / call you as soon as we have relevant information. Thank you for your patience.

Thank You,
Ramprasad
Global Customer Services

STATUS
======
@WIP - Work In Progress

ORION_MIGRATION - 2009年10月7日下午02时41分17秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月7日下午03时13分27秒

(Update for record id(s): 388056774)

Oracle 技术支持 - 2009年10月7日下午03时13分27秒

(Update for record id(s): 388056778)

UPDATE
======
Hi Hui,

Hope above Q/A clarifies the issue. Please let us know if you have further queries. We would be glad to assist you.

Thank you,
Ramprasad
Global Customer Services

STATUS
======
@CUS -- Waiting for customer response

ORION_MIGRATION - 2009年10月7日下午03时13分27秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月7日下午03时13分28秒

========
1. How to verify the reason for Journal import warning message or error?
User Question:
when i run import Journals,there has warning.
i want to check the source of the gl import date.

Oracle 技术支持 - 2009年10月7日下午03时13分29秒

======
1. There are two ways to verify reasons for journal import warning or error message:

a) Journal Improt Execution Report - This report is triggered for every Journal Import program and will give output of imported journals information and also details of warning or failues and reason for failure. This will give group id and request id and source of journals.

b) If Journal import is failed, With journal data source and group id/request id, errored gl_interface lines can be reviewed from Journal Import Correction Form.
Navigation: General ledger->Journals->Import->Correct;
You can query errored gl_interface records with group_id, Journal source and Request Id; Here in this form, user can correct errored lines. Correcting errored lines is not recommanded always. It is advised to log SR with oracle if any help is needed.

ORION_MIGRATION - 2009年10月7日下午03时24分02秒

New info : zhangxiaoying@tjpcb.com
Hi Ramprasad,

Thanks for your update.
With Journal Improt Execution Report i still can't find which action i did cause the Journal import error?

Now i have the error ER02 and EF05.
I know ER02 This reversal period name is invalid. Check your calendar for valid periods.
and EF05 There is no Accounting Flexfield with this Code Combination ID.

But for EF05 i don't know which transaction generate the code combination id?
How the i check the transaction from the Gl_interface information?

How can i solve the errors?

Look forward to your kind reply!
Best Regards

ORION_MIGRATION - 2009年10月7日下午03时27分03秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\1004\Journal_Import_071009.htm

ORION_MIGRATION - 2009年10月7日下午03时28分15秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\1004\1.jpg

Oracle 技术支持 - 2009年10月7日下午04时22分52秒

(Update for record id(s): 388056996)

Oracle 技术支持 - 2009年10月7日下午04时22分53秒

==============
DC#1: Journal_Import_071009.htm

Filename = https://gtcr.oracle.com/gtcr-dir/gtcr_12930/7746331.993/Journal_Import_071009.htm

The uploaded journal import execution report shows following error message:

Set of Books Name: SOB_TJ2
Concurrent Request ID: 2655526
============-=============== Error Lines ================-==============

Accounting
Error Code Source Date Currency Entered Debit Entered Credit Accounting Flexfield/CCID
------------------------------ ------------- ----------- -------- ------------------ ------------------ ----------------------------
EF05 Periodic Inve 01-SEP-09 NTD 117.1 0 2651
EF05 Periodic Inve 14-SEP-09 NTD 16.9 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 150 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 1380.5 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 500 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 138.05 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 2743 0 2651
EF05 Periodic Inve 18-SEP-09 NTD 500 0 2651

EF05 There is no Accounting Flexfield with this Code Combination ID

Oracle 技术支持 - 2009年10月7日下午04时24分30秒

(Update for record id(s): 388079005)

Oracle 技术支持 - 2009年10月7日下午04时24分31秒

==============
DC#2: 1.jpg

Filename = https://gtcr.oracle.com/gtcr-dir/gtcr_12930/7746331.993/1.jpg

screenshot shows Error EF05 and code_combination_id=2651

Oracle 技术支持 - 2009年10月7日下午04时26分14秒

(Update for record id(s): 388079016)

UPDATE
======
Hi Hui,

ORION_MIGRATION - 2009年10月7日下午04时26分14秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月7日下午04时26分15秒

===========
1. Please run the following query and upload the output in excel format. Ensure that column headings are clearly visible:

select * from gl_interface where group_id=632508;

Thanks,
RamPrasad

STATUS
======
@CUS - Waiting for customer response

Oracle 技术支持 - 2009年10月7日下午04时29分38秒

(Update for record id(s): 388079036)

Oracle 技术支持 - 2009年10月7日下午04时29分39秒

===================
-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to import journals, journal import program occured following error:

ERROR
-----------------------
EF05 There is no Accounting Flexfield with this Code Combination ID

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot import journals

Oracle 技术支持 - 2009年10月7日下午04时29分39秒

(Update for record id(s): 388079047)

Oracle 技术支持 - 2009年10月7日下午04时29分40秒

==================
Verified the issue referencing data collected records as noted below.

Verified that journal import program resulted into following error:
EF05 There is no Accounting Flexfield with this Code Combination ID
Relevant Data Collected => DC#1: Journal_Import_071009.htm

Oracle 技术支持 - 2009年10月7日下午04时30分40秒

(Update for record id(s): 388079057)

UPDATE
======
Hi Hui,

ORION_MIGRATION - 2009年10月7日下午04时30分40秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月7日下午04时30分41秒

===========
1. Please run the following query and upload the output in excel format. Ensure that column headings are clearly visible:

select * from gl_interface where group_id=632508;

select * from gl_code_combinations_kfv where code_combination_id=2651;

Thanks,
RamPrasad

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月7日下午05时18分07秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\1004\account.xls

ORION_MIGRATION - 2009年10月7日下午05时20分07秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\1004\gl_interface.xls

ORION_MIGRATION - 2009年10月7日下午05时31分02秒

New info : zhangxiaoying@tjpcb.com
Hi RamPrasad,

I know the code_combination_id=2651 not useable in organization TJ2（set of books id =1002）.

But i Urgently want to know which transaction generate the accout combination.

Looking forward to your help!

Regards,

Hui Wang

Oracle 技术支持 - 2009年10月7日下午06时00分04秒

(Update for record id(s): 388079487)

UPDATE
======
Hi Hui,

ORION_MIGRATION - 2009年10月7日下午06时00分04秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月7日下午06时00分05秒

===========
1. Please run the following query and upload the output. This transaction is generated from Inventory source. We refer issue to Invetory to findout problematic transaction:

select * from gl_sets_of_books where set_of_books_id=1002;

Thanks,
RamPrasad

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月7日下午06时54分02秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\1004\TJ2.xls

ORION_MIGRATION - 2009年10月7日下午06时56分03秒

New info : zhangxiaoying@tjpcb.com
Hi RamPrasad,

I want to know from which information i can findout problematic transaction?

Best Regards,
Hui Wang

Oracle 技术支持 - 2009年10月7日下午08时00分48秒

(Update for record id(s): 388079955)

Oracle 技术支持 - 2009年10月7日下午08时00分49秒

==============
DC#3: gl_interface.xls

Filename = https://gtcr.oracle.com/gtcr-dir/gtcr_12930/7746331.993/gl_interface.xls

GL_INTERFACE table shows following record for Errored line

STATUS EF05
SET_OF_BOOKS_ID 1002
ACCOUNTING_DATE 40071
CURRENCY_CODE NTD
ACTUAL_FLAG A
USER_JE_CATEGORY_NAME Receiving
USER_JE_SOURCE_NAME Periodic Inventory
ENTERED_DR 16.9
ENTERED_CR
ACCOUNTED_DR 16.9
ACCOUNTED_CR
REFERENCE1 28089
REFERENCE2 102 1242 8001
REFERENCE5 102 1242 8001
REFERENCE10 Accrual
REFERENCE21 28089
REFERENCE22 117
REFERENCE23 1199017
JE_BATCH_ID 245668
PERIOD_NAME SEP-09
JE_HEADER_ID 71844
JE_LINE_NUM 1
CODE_COMBINATION_ID 2651
GROUP_ID 632508
REQUEST_ID 2655562
GL_SL_LINK_ID 136040
GL_SL_LINK_TABLE CSTECL

Oracle 技术支持 - 2009年10月7日下午08时24分08秒

(Update for record id(s): 388095049)

Oracle 技术支持 - 2009年10月7日下午08时24分09秒

==============
DC#4

Filename = https://gtcr.oracle.com/gtcr-dir/gtcr_12930/7746331.993/account.xls

Filename = https://gtcr.oracle.com/gtcr-dir/gtcr_12930/7746331.993/TJ2.xls

The uploaded gl_sets_of_books query output shows following information:

SET_OF_BOOKS_ID 1002
NAME SOB_TJ2
SHORT_NAME TJ2
CHART_OF_ACCOUNTS_ID 50269

Journal import failed with invalid code_combination_id=2651
for set_0f_books_id=1002

Chart_of_accounts_id assigned to above set of books is 50269

Where as code_combination_id 2651 is under chart_of_accounts_id= 50270
Hence this code_combination_id in invalid for set of books 1002;
Hence journal import failed.

ORION_MIGRATION - 2009年10月8日上午10时53分02秒

New info : zhangxiaoying@tjpcb.com
Hi RamPrasad,

I want to know which transaction generate the account?

Looking forward to your quickly reply!

Regards,
Hui Wang

ORION_MIGRATION - 2009年10月12日上午10时04分02秒

New info : zhangxiaoying@tjpcb.com
Hi Babita,

Sorry for the late reply.

I have read the Note 1012982.102, it seems the note does not useful for me because at present we don't have the status Error-10.

Now i found in organization TJ2 the correct Journal Import date form(GLXJICOR)
has the accounts code combination ID 2651 which belongs to organization TTJ.

Now i am more confused with the intercompay transaction account.

Hope you can explain this for me!

Regards
Hui Wang

ORION_MIGRATION - 2009年10月12日上午10时05分02秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\GPO\SR\why_TTJ_account_post_to_TJ2.doc

Oracle 技术支持 - 2009年10月14日上午01时20分43秒

(Update for record id(s): 388454538)

UPDATE
======
Hi Hui,

Your issue was transferred to me. My name is Marius Garip and I will be helping you with your issue.

Thank you for your patience,
Marius Garip
Global Customer Services

STATUS
======
@WIP - Work In Progress

ORION_MIGRATION - 2009年10月14日上午01时20分43秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月14日下午11时25分52秒

(Update for record id(s): 388531475)

ORION_MIGRATION - 2009年10月14日下午11时25分52秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月14日下午11时25分53秒

========
Q1:
I want to check the source of the gl import date.

Oracle 技术支持 - 2009年10月14日下午11时25分54秒

======
Hi Hui,

Navigate to> Cost> Accounting Close Cycle>View General Ledger Transfers.
Query the GL transfers based on appropriate criteria in the find screen to view the transfer details. This
would give details of the transfer including: Processing Status, Transfer Date, GL Date, GL Batch, Period. This screen can be used further to drill down to transaction distributions.

For example in your case you could query : after the GL Batch Id=28089

STATUS
======
@CUS -- Waiting for customer

ORION_MIGRATION - 2009年10月15日上午07时58分01秒

New info : zhangxiaoying@tjpcb.com
Hi,

Thanks for your update. There was no information for the transfer details.
I think the function of view general ledger transfer is for detail information of inventory transfer to General Ledger not for PAC.

Hope you can provide more information for me!

Regards,

Hui Wang

Oracle 技术支持 - 2009年10月16日上午11时31分54秒

.
** HUB **

CUSTOMER UPDATE
================
Customer contact name (if not same as in SR header): HUI WANG
Verify preferred method of contact: PHONE OR METALINK
Phone#: +86 752 8218157
Email: zhangxiaoying@tjpcb.com

Comments for this update:

Customer is requesting the owning engineer to update this SR ASAP.

Thank you.
Crystal Lin
Oracle HUB Team

Oracle 技术支持 - 2009年10月17日下午04时49分21秒

(Update for record id(s): 388727332)

UPDATE
======
Hi Hui,

1. Please use the below command to check your file version:
strings -a $BOM_TOP/ patch/115/odf/cstcxla.odf | grep Header

2. Upload completed spooled file CstDiag115.txt after running CstCheck.sql
Diagnostics Script.
(see Note 378348.1) If prompted by customer id , just enter your company name.
It will help us understand your Costing Setups and important File versions

3. Run and upload output of Costing_hook.sql and err_txn from the same Note 378348.1

4. Please let us know the following
What is the transfer to Gl mode is it summary or detailed?

Thank You,
Marius Garip
Global Customer Services

STATUS
======
@CUS - Waiting for customer response

Oracle 技术支持 - 2009年10月17日下午04时52分45秒

(Update for record id(s): 388727333)

Oracle 技术支持 - 2009年10月17日下午04时52分46秒

========
WebIV Search

WebIV SEARCH
------------------------
TAR:7152233.992 7413402 PAC ACCOUNTING DISTRIBUTION ENTRIES MISSING FROM
TAR:6401600.994 THERE IS NO DRILLDOWN INFORMATION IN GL JOURNAL SOURCE FROM
PERIODIC INVENTORY.
BUG:3487427 Abstract: CANNOT DRILLDOWN JOURNAL SOURCE ''PERIODIC INVENTORY''
TAR:7424301.994 No data is shown when drilldown the source Periodic
Inventory" from GL
TAR:6500110.994 RECORDS STILL IN GL_INTERFACE AFTER JOURNAL IMPORT FROM
PERIODIC INVENTORY
TAR:6468377.992 HOW TO GET LINES OF JOURNALS FROM PERIODIC INVENTORY IN GL
TAR:7105745.994 GL12I-THE DRILLDOWN BUTTON IS GRAYED OUT FOR THE JOURNAL
LINE PERIODIC INVENTORY
TAR:6586478.993 PERIODIC INVENTORY JOURNALS CAN NOT EXECUTE LINE DRILLDOWN
NOTE:232017.1 General Ledger 11i Drilldown Troubleshooting Guide

ORION_MIGRATION - 2009年10月19日上午11时49分04秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\metaSR\GLPAC\CstDiag115.txt

ORION_MIGRATION - 2009年10月19日上午11时50分05秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\metaSR\GLPAC\hook.txt

ORION_MIGRATION - 2009年10月19日上午11时52分01秒

New info : zhangxiaoying@tjpcb.com
Hi Marius,

I have upload two files for you!

For some reason I will provide the file version for you later.

Our system set up for transfer to GL mode is detailed.

Best Regards,

Hui Wang

Oracle 技术支持 - 2009年10月20日上午12时26分22秒

(Update for record id(s): 388806431)

UPDATE
======
Hi Hui,

I logged bug 9032930 for this issue. I will let you know as soon as I have more information.

Thank You,
Marius Garip
Global Customer Services

STATUS
======
@DEV - Waiting for Oracle Development response

ORION_MIGRATION - 2009年10月20日上午12时26分22秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月20日上午12时49分34秒

Associated bug 9032930 has been updated and is still at status: 11.

ORION_MIGRATION - 2009年10月20日上午11时50分21秒

Associated bug 9032930 has been updated and has changed status to 30.

Oracle 技术支持 - 2009年10月20日下午05时55分44秒

(Update for record id(s): 388860165)

UPDATE
======
Hi Hui,

Please see the action plan below.

Thanks,
Marius Garip

ORION_MIGRATION - 2009年10月20日下午05时55分44秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月20日下午05时55分45秒

===========
Pls provide output of following queries:

1. SELECT * FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089')

2. SELECT * FROM cst_ae_headers
WHERE ae_header_id IN
(SELECT ae_header_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089'))

3. SELECT * FROM rcv_transactions
WHERE transaction_id IN
(SELECT source_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089'))

4. SELECT * FROM rcv_accounting_events
WHERE rcv_transaction_id IN
(SELECT source_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089'))

5. SELECT * FROM rcv_receiving_sub_ledger
WHERE rcv_transaction_id IN
(SELECT source_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089'))

6. SELECT * FROM po_distributions_all
WHERE po_distribution_id IN
(SELECT po_distribution_id FROM rcv_transactions
WHERE transaction_id IN
(SELECT source_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089')) )

7.select * from po_headers_all
where po_header_id in
(SELECT po_header_id FROM rcv_transactions
WHERE transaction_id IN
(SELECT source_id FROM cst_ae_lines
WHERE gl_sl_link_id IN
(SELECT gl_sl_link_id FROM
gl_interface WHERE status='EF05'
AND reference21='28089')) )

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月21日下午01时36分02秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\metaSR\GLPAC\sqlresult.rar

ORION_MIGRATION - 2009年10月21日下午02时08分02秒

New info : zhangxiaoying@tjpcb.com
Hi Marius,

The file version of cstcxla.odf is:

cstcxla.odf 115.40.115100.5 2005/04/06 13:15:20 arathee ship

Regards,

Hui Wang

Oracle 技术支持 - 2009年10月21日下午03时49分12秒

(Update for record id(s): 388940071)

UPDATE
======
Hi Hui,

I updated the bug with the information provided.

Thank you,
Marius Garip
Global Customer Services

STATUS
======
@DEV - Waiting for Oracle Development response

ORION_MIGRATION - 2009年10月21日下午03时53分58秒

Associated bug 9032930 has been updated and is still at status: 11.

ORION_MIGRATION - 2009年10月21日下午04时23分30秒

Associated bug 9032930 has been updated and is still at status: 11.

ORION_MIGRATION - 2009年10月21日下午05时54分18秒

Associated bug 9032930 has been updated and has changed status to 30.

Oracle 技术支持 - 2009年10月21日下午10时46分40秒

(Update for record id(s): 388974432)

UPDATE
======
Hi Hui,

I sent an email to the following address with the following attachments:

To: zhangxiaoying@tjpcb.com
Subject: 7746331.993

Attachments: CSTAPPRB_debug.pls

And the following update from Development
"
After analyzing the data found following points:

1.Return to vendor transactions of Centralized Procurement get wrong
accounting in PAC

To avoid this issue in future ask ct to implement following action plans
in test instance cloned of production:

1.Get the debug file 'CSTAPPRB_debug.pls' ( I have sent you the file by email : at zhangxiaoying@tjpcb.com

2.Execute and compile it.
3.Try to reproduce the issue using below steps:
a.make a global BPA in OU1
b.make a PR in OU2
c.Auto create a standard PO from the BPA and PR.
d.receive, some quantity say 100
e.Do return to vendor for 50 Qty.
f.Rerun the PAC processors, and view the return to vendor transactions of

OU2, the entries should get correct account(Account should belong to OU2
and not OU1)
In order to correct the present error 'EF05' in gl_interface
do following in test instance cloned of production:

1.Update gl_interface
set CODE_COMBINATION_ID = 2758 --(Correct account )
where STATUS ='EF05'
AND reference21='28089'
AND USER_JE_SOURCE_NAME ='Periodic Inventory'
AND USER_JE_CATEGORY_NAME = 'Receiving'

2.update cst_ae_lines
set CODE_COMBINATION_ID =2758
where AE_LINE_TYPE_CODE =16
and SOURCE_TABLE ='RT'
AND SOURCE_ID in
(1199017,1196013,1200029,1200032,1200034,1200036,1200038,1200040)

3. Issue a commit
4. After this run the Journal Import Program and check whether the issue is
resolved or not.
"

Thank you,
Marius Garip
Global Customer Services

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月21日下午10时46分40秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月22日下午01时48分03秒

New info : zhangxiaoying@tjpcb.com
Hi,

Thanks for your update. Sorry the mail i can't receive the attachment.

Can you please send me again to the mail work_116@hotmail.com?

Best regards,

Hui Wang

Oracle 技术支持 - 2009年10月22日下午05时02分10秒

(Update for record id(s): 389035302)

UPDATE
======
Hi Hui,

I have sent the email at : work_116@hotmail.com

Thank You,
Marius Garip
Global Customer Services

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月22日下午05时02分10秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月24日上午11时40分02秒

New info : zhangxiaoying@tjpcb.com
Hi Marius,

Now i have update the code combination ID,and run the Journal Import Program successful.

But if i want to retest the issue, perhaps i need to wait for the PAC period close, then i can run transfer to General Ledger. for the PAC period can't be reopen so i can't do the test immediatelly. If there any other method to quickly do the test?

Regards,

Hui

Oracle 技术支持 - 2009年10月25日下午08时34分17秒

(Update for record id(s): 389181731)

UPDATE
======
Hi Hui,

I updated the bug with the information provided.

Thank you,
Marius Garip
Global Customer Services

STATUS
======
@DEV - Waiting for Oracle Development response

ORION_MIGRATION - 2009年10月25日下午08时34分18秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月25日下午09时03分03秒

Associated bug 9032930 has been updated and has changed status to 30.

Oracle 技术支持 - 2009年10月25日下午09时05分40秒

(Update for record id(s): 389181787)

UPDATE
======
Hi Hui,

Bug update:
"
No need to wait until the pacc period close.Can do the test case mentioned in the above update Support Update (mgarip.ro 21-Oct-2009 17:46 EEST)
and once after
running the pac distribution processor,check that the Account should belong to OU2and not OU1.Pls verify this and let me know if you have any queries
"

Thank You,
Marius Garip
Global Customer Services

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月25日下午09时05分40秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月27日下午11时26分15秒

TAR has passed review date of:
27-OCT-2009

Oracle 技术支持 - 2009年10月28日上午01时05分09秒

(Update for record id(s): 389387976)

UPDATE
======
Hi Hui,

Please update the SR as soon as possible with the current status

Thank You,
Marius Garip
Global Customer Services

STATUS
======
@CUS - Waiting for customer response

ORION_MIGRATION - 2009年10月28日上午01时05分09秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

ORION_MIGRATION - 2009年10月28日下午03时26分13秒

New info : zhangxiaoying@tjpcb.com
Hi Marius,

Thanks for your help. With the sql scrip,the problem have solved.

But i have another bigger problem hope you can help me to solve. Prohaps you can help me to create another SR continue with this SR.

The problem is for global procurement, i found after i run Periodic Acquisition Cost Processor, and Periodic Cost Processor,then i check the item's PAC cost (in the receiving org),the PAC cost is equal to the shipping organization ' price list price. But the shipping organization's price list's currency is USD, and receiving organization currency is RMB.

Please refer the upload file for more detail.

I really hope you can help me to solve the problem. Thanks very much!!

Regards,

Hui Wang

ORION_MIGRATION - 2009年10月28日下午03时37分02秒

The customer : zhangxiaoying@tjpcb.com : has uploaded the following file via MetaLink:
E:\metaSR\GLPAC\pac_cost.xls

Oracle 技术支持 - 2009年10月31日上午02时01分00秒

(Update for record id(s): 389664175)

UPDATE
======
Hi Hui,

I am currently reviewing/researching the situation and will update the SR / call you as soon as I have additional information. Thank you for your patience.

Best Regards,
Marius Garip
Global Customer Services

STATUS
======
@WIP - Work In Progress

ORION_MIGRATION - 2009年10月31日上午02时01分00秒

Email Update button has been pressed: Sending email to zhangxiaoying@tjpcb.com.

Oracle 技术支持 - 2009年10月31日上午02时06分56秒

(Update for record id(s): 389664210)

Oracle 技术支持 - 2009年10月31日上午02时06分57秒

========
WebIV Search

WebIV SEARCH
------------------------
TAR:4031073.999 8/16 - PRICE ON INTERNAL REQUISITION

ORION_MIGRATION - 2009年11月4日下午09时24分47秒

Associated bug 9032930 has been updated and has changed status to 30.

ORION_MIGRATION - 2009年11月5日上午02时33分32秒

TAR has passed review date of:
04-NOV-2009

Oracle 技术支持 - 2009年11月19日上午12时50分43秒

Comments
--------
=== ODM Action Plan ===
Hi,
Sorry for tthe delay

Basically Periodic costing is used for reporting purposes and it works along with your perpetual costing method.
The cost in Item cost inquiry screen is not taken from the Price list but calculated as follows

PWAC =
(Beginning-Balance-Qty*Previous-Period-Acquisition-
Cost+ReceivedQty*Acquisition Cost)
-------------------------------------------------------------------------
(Beginning Balance Qty + Received Qty)

The above paper gives you a fair idea on Periodic average costing for purchased
items.
Refer Note 245487.1

Regards,
Marius Garip
Oracle Support

Oracle 技术支持 - 2009年11月19日上午12时51分32秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,

Marius Garip
Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

ZHANGXIAOYING@TJPCB.COM - 2009年11月19日上午08时46分05秒

Hi,
I have read the Note 245487.1,but i still can't understand about the intercompany transaction for PAC very well.

In the upload file pac_cost.xls, you know the item was new created and the begin qty is 0 and begin price is 0 too.
So the PWAC =(60(receivedqty)* Acquisition cost)/60(receivedqty)
the result is 20.So the Acquisition cost is 20. I don't know the system how to get the acquisition cost.And i thinks the PWAC for the item is not correct too.
Hope you can help me again.

Regards,
Hui

Oracle 技术支持 - 2009年11月19日下午04时19分28秒

Comments
--------
=== ODM Action Plan ===
Hi,

1. Hi please provide the output of following scripts capturing the transactions we are analyzing:-

a)
Select * from mtl_material_transactions
where transaction_id=’&trx_id’

b) select * from mtl_transaction_accounts
where transaction_id=’&trx_id’

c)
Select * from MTL_PAC_ACTUAL_COST_DETAILS
where inventory_item_id = '&inv_id'
and transaction_id = &txnId from query a) ;

d)
Select INVENTORY_ITEM_ID, PAC_PERIOD_ID , BEGIN_LAYER_QUANTITY, LAYER_QUANTITY
From CST_PAC_QUANTITY_LAYERS
where PAC_PERIOD_ID = '&PAC_PERIOD_ID'
and INVENTORY_ITEM_ID = '&INVENTORY_ITEM_ID';

e)
Select COST_LAYER_ID , INVENTORY_ITEM_ID, PAC_PERIOD_ID, TOTAL_LAYER_QUANTITY,
ISSUE_QUANTITY, BUY_QUANTITY, MAKE_QUANTITY
from CST_PAC_ITEM_COSTS
where PAC_PERIOD_ID = '&PAC_PERIOD_ID'
and INVENTORY_ITEM_ID = '&INVENTORY_ITEM_ID';

2. Please upload output of PO_Details.sql for the related PO.
(refer to Note 462680.1:PO_Details Diagnostic Script. for Accounting Details)

Regards,
Marius
Oracle Customer Support

Oracle 技术支持 - 2009年11月19日下午04时19分49秒

Oracle 技术支持 - 2009年11月19日下午08时47分34秒

Virus scan completed for file 1119.rar

ZHANGXIAOYING@TJPCB.COM - 2009年11月19日下午08时47分36秒

Uploaded Attachment 1119.rar in GTCR

ZHANGXIAOYING@TJPCB.COM - 2009年11月19日下午08时48分37秒

Hi Marius ,
All the result please refer the upload file.

Best regards,
Hui

ZHANGXIAOYING@TJPCB.COM - 2009年11月25日上午11时38分57秒

Hi Marius,
I want to know the progress about the issue. Please update the SR ASAP.
Regards,
Hui

ZHANGXIAOYING@TJPCB.COM - 2009年12月1日下午05时01分36秒

Hi Marius,
How are you now? I hope everything goes well with you. and i also want you will update the SR as soon as possible.
Best Regards,
Hui

ZHANGXIAOYING@TJPCB.COM - 2009年12月22日上午09时22分13秒

Hi Marius,

Do you still remember the question? Please let me know you are still dealing with the question.
Looking forward to your reply.
Best Regards,
Hui

Oracle 技术支持 - 2010年1月12日上午12时39分14秒

Generic Note
------------
Hi,

Sorry for the delay, I know it has been a while since there was any
communication on this SR. Before proceeding, I hoped to make sure that we
are still facing the same issue and that there is no new information to
share regarding the status of the issue, symptoms, or business impact.
Please let me know.

I am currently reviewing/researching the situation and will update the SR / call you as soon as I have additional information. Thank you for your patience.

Regards,
Marius Garip
Oracle Customer Support

ZHANGXIAOYING@TJPCB.COM - 2010年1月12日上午09时19分52秒

Hi Marius,
I am very glad that you have update the SR.
Do you still remember the script. CSTAPPRB_debug that you provide us? For we use the script. in the production environment,there have some error, for some files version in the production environment is lower than the test environment. Perhaps you need to provide us the patch we use in the production environment.
For the Global procurement's price still not correct. Perhaps we can have an OWC to help you understand the problem more clearly.

Looking for to your reply.
Best Regards,
Hui

Oracle 技术支持 - 2010年1月13日上午09时07分18秒

Oracle 技术支持 - 2010年1月13日上午09时16分53秒

Call - Inbound
--------------
Comments for this update:

Customer called in for checking location of SR owner, he had updated this SR yesterday morning, but until now he didn't get update from engineer. He asked for escalation for this SR, business impact is as follows:
Because of this issue, parts of system function could't work, when customer did return, GL subjects would have errors. So the following business stopped by this issue.
Customer wanted to get effective solution to this problem as quickly as possible. Also, customer asked for patch suggested by SR owner.
Pinged EM and SR owner, send him e-mail accordingly, applied escalation request.

Thank you.
Joy Zhao
Oracle Global Customer HUB

Oracle 技术支持 - 2010年1月13日上午09时27分01秒

Name of Person Escalating:
--------------------------
Hui Wang

Who needs to be contacted?
--------------------------
Hui Wang

Contact Phone Number:
---------------------
+86 752 8218157

Reason for Escalation / What Customer needs:
--------------------------------------------
Because of this issue, parts of system function could't work, when customer did return, GL subjects would have errors. So the following business stopped by this issue.

Business Impact / Environment (UAT, Dev, PRODN, etc) / Deadline Issues / No. of users affected:
-----------------------------------------------------------------------------------------------
Because of this issue, parts of system function could't work, when customer did return, GL subjects would have errors. So the following business stopped by this issue.

Manager Callback Requested? (Yes/No)
------------------------------------
No

Additional Comments / Advice given to Escalator:
------------------------------------------------
customer asked for effective solution to this SR as quickly as possible.

Oracle 技术支持 - 2010年1月13日上午10时27分07秒

Generic Note
------------
DUTY MANAGER UPDATE
=====================
Escalating SR as requested. Business Case:
- production instance
- users cannot import journals
- issue has been open for several months

Note: customer is requesting an OWC

Oracle 技术支持 - 2010年1月13日上午11时02分14秒

Call - Inbound
--------------
Comments for this update:Customer called in and said he thinks the action plan engineer given is not related to the issue, so he hope the engineer can review the sr, and if needed, they can open OWC to discuss the issue.

Thank you.
Cynthia
Oracle Global Customer HUB

Oracle 技术支持 - 2010年1月13日下午03时49分13秒

Call - Inbound
--------------
The customer calls in
It's very urgent for this issue, please update and feedback ASAP.
Thank you.

Sara
eHUB , NASC

Oracle 技术支持 - 2010年1月13日下午03时54分33秒

Email To
--------
marius.garip@oracle.com

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Marius,
Please review the update in your Service Request # 2-5950053.
The customer calls in
It's very urgent for this issue, please update and feedback ASAP.
Thank you.

Sara
eHUB , NASC

Oracle 技术支持 - 2010年1月13日下午04时46分15秒

Call - Inbound
--------------
Customer called in, requested to chase up the SR processing speed, also requested the engineer to make a summary for this SR progressing.

Pinged the engineer and left message accordingly.

Thanks,
Bo

Oracle 技术支持 - 2010年1月13日下午05时07分58秒

Oracle 技术支持 - 2010年1月13日下午05时17分39秒

Generic Note
------------
Customer called and request the engineer to update the SR.
Pinged the engineer who agreed to update the SR before the ct gets off work.

Faye

Oracle 技术支持 - 2010年1月13日下午05时29分58秒

Generic Note
------------
Hi Hui,

Actually CSTAPPRB_debug.pls it was provided by Development for debugging purposes and it was not a script.It was meant to capture the root cause of the issue.That's why you have been asked to reproduce the issue by making a new global BPA

For fixing the "EF05 error" development provided the update statements.

Thanks,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月13日下午05时30分14秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

Oracle 技术支持 - 2010年1月13日下午05时38分47秒

Generic Note
------------
Hi Hui,

Please update the SR with your availability and a preferred contact number, and we will schedule a time for the session.
(I have tried to call @ +86 752 8218157 but I don't think I got the right person)

Thank you,
Marius Garip
Global Customer Services

Oracle 技术支持 - 2010年1月13日下午05时39分11秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

ZHANGXIAOYING@TJPCB.COM - 2010年1月13日下午05时44分18秒

Hi Marius,
Thanks for your update. After we run the CSTAPPRB_debug.pls, there have no EF05 error in the test istance. But the PAC cost is still not correct. I hope we can have an OWC tomorrow, perhaps OWC will be more effective to understand the question.

Best Regards,
Hui

ZHANGXIAOYING@TJPCB.COM - 2010年1月13日下午05时46分30秒

Hi Marius,
I just answered your phone, but i can't understand what you said.
Sorry for any inconvenience!
Regards,
Hui

Oracle 技术支持 - 2010年1月13日下午05时52分50秒

Generic Note
------------
Hi Hui,

The initial issue Return to vendor transaction of Centralized Procurement get wrong account in PAC.As a result Journal Import program error with following "EF05 error
For this purpose was provided the debug file CSTAPPRB_debug.pls and Development provided a datafix to correct the wrong accounting.

Regarding the PAC Cost not correct to avoid confusion please allow me to start a new SR addressing this only issue.
Also please update the SR with the correct phone number ( including country code ). I have tried to call 15 minutes ago .. but I think i spoke with the wrong person.
Please let me know your availability for tomorrow 14 Ian-2009

Regards,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月13日下午05时53分05秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

ZHANGXIAOYING@TJPCB.COM - 2010年1月13日下午06时06分22秒

Hi Marius,
I can confirm you that i have answered your phone. But i can't understand what you said. My phone is 86 752 8218157.
Perhaps you may help me start a new SR addressing the pac cost is not correct.
I hope you can provide us the patch to solve the error EF05 error.
Regards,
Hui

MIS05@TJPCB.COM - 2010年1月14日下午01时44分25秒

Thanks for your help!
I want to take a conference call. And need an Chinese hub holding the simultaneous interpreter.
Can the hub open a conference call? I hope the time at BeiJing time 16:00-17:30, and What do you say?
If Ok, please tell the conference call number.

Oracle 技术支持 - 2010年1月14日下午03时47分18秒

Oracle 技术支持 - 2010年1月14日下午03时54分20秒

Call - Inbound
--------------
Customer contact name (if not same as in SR header): Mr.Liu
Verify preferred method of contact: PHONE OR My Oracle Support customer portal

Phone#: +86 752 8218188 ext.902
Email:

Comments for this update:

He wanted to have a concall with the engineer and hub to discuss this issue.
His available time is from 16.30 to 17.30 (GMT+8) today.

regards,
Ellis,
Support Engineer, Global eHUB
North Asian Support Center

Oracle 技术支持 - 2010年1月14日下午04时10分44秒

Email To
--------
marius.garip@oracle.com

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Marius,

Please review the update in your Service Request # 2-5950053.

Thank you,
Hui Wang
Translation of Customer update provided by Global Customer HUB

Oracle 技术支持 - 2010年1月14日下午05时06分19秒

Generic Note
------------
Hi Hui,

If it's not possible to have the OWC with voice support will have to communicate trough chat window.
I opened an OWC session where the details are
“
1. MS INTERNET EXPLORER: https://strtc.oracle.com
2. In the "Join Conference" box on the right, please enter the following:
Conference ID: 6148630
Conference Key: 1234
Your Name: Hui
3. Click "Join Conference"

Regards,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月14日下午05时06分38秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

Oracle 技术支持 - 2010年1月14日下午05时28分44秒

Comments
--------
=== ODM Research ===

BUG:8684475 Abstract: RECEIVE TRANSACTION OF CENTRALIZEDPROCUREMENT GET WRONG CURRENCY_CONVERSION_RATE

ZHANGXIAOYING@TJPCB.COM - 2010年1月14日下午06时28分41秒

hi,
the internet is suddendly interrupt. So i cann't join the conference again.
Sorry for any inconvenience.
Regards,

Oracle 技术支持 - 2010年1月14日下午06时35分10秒

Generic Note
------------
Hi Hui,

I am currently reviewing/researching the situation and will update the SR / call you as soon as I have additional information. Thank you for your patience.

Best Regards,
Marius Garip
Global Customer Services

Oracle 技术支持 - 2010年1月14日下午08时14分10秒

Virus scan completed for file pac_setup.sql

Oracle 技术支持 - 2010年1月14日下午08时14分15秒

Uploaded Attachment pac_setup.sql in GTCR

Oracle 技术支持 - 2010年1月14日下午08时14分31秒

Virus scan completed for file pac_txn_4_item.sql

Oracle 技术支持 - 2010年1月14日下午08时14分34秒

Uploaded Attachment pac_txn_4_item.sql in GTCR

Oracle 技术支持 - 2010年1月14日下午08时14分49秒

Virus scan completed for file PO_Details.sql

Oracle 技术支持 - 2010年1月14日下午08时14分51秒

Uploaded Attachment PO_Details.sql in GTCR

Oracle 技术支持 - 2010年1月14日下午08时18分25秒

Comments
--------
=== ODM Action Plan ===

Hi Hui,

I have uploaded the following files in SR : PO_Details.sql, pac_txn_4_item.sql, pac_setup1.sql
Please provide the following
a. Provide output of Sections A,B,C for the script. "PO_Details.sql" for the problematic po.
b. Provide output of the script. "pac_txn_4_item.sql"for the problematic item.
c. Provide output of the script. "pac_setup1.sql"

Regards,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月14日下午08时21分50秒

Virus scan completed for file pac_setup1.sql

Oracle 技术支持 - 2010年1月14日下午08时21分53秒

Uploaded Attachment pac_setup1.sql in GTCR

Oracle 技术支持 - 2010年1月14日下午08时22分43秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

Oracle 技术支持 - 2010年1月14日下午08时34分26秒

Comments
--------
=== ODM Research ===
BUG:5637002 Abstract: CST:ST3:RG:INCORRECT CURRENCY CONVERSIONS FOR PAC GLOBAL PROCUREMENT RECEIPT
BUG:6164920 Abstract: DATAFIX:WRONG AMOUNT-INTRANSIT SHIPMENT BETWEEN COMPANY WITH DIFFERENT CURR.COD
BUG:5654427 Abstract: ST3: CURRENCY CONVERSTION RATE STAMPED IN RT INCORRECT FOR GP RECEIPTS

Oracle 技术支持 - 2010年1月15日上午09时23分14秒

Virus scan completed for file 0115.rar

ZHANGXIAOYING@TJPCB.COM - 2010年1月15日上午09时23分18秒

Uploaded Attachment 0115.rar in GTCR

Oracle 技术支持 - 2010年1月15日上午09时28分50秒

Virus scan completed for file pac_inv_txns.lst

ZHANGXIAOYING@TJPCB.COM - 2010年1月15日上午09时28分53秒

Uploaded Attachment pac_inv_txns.lst in GTCR

Oracle 技术支持 - 2010年1月15日上午10时20分07秒

Virus scan completed for file pac_setup.lst

MIS03@TJPCB.COM - 2010年1月15日上午10时20分10秒

Uploaded Attachment pac_setup.lst in GTCR

Oracle 技术支持 - 2010年1月15日下午01时41分20秒

Oracle 技术支持 - 2010年1月15日下午01时45分14秒

Call - Inbound
--------------
Comments for this update:

Customer called in and wanted to transfer his SR to APAC time zone.
Pinged CTC for help.

Thank you.
Loki
Oracle Global Customer HUB

Oracle 技术支持 - 2010年1月15日下午04时53分38秒

Defect 9288347 has been created via Defect Workbench iBug portal request id: (2271333).

Oracle 技术支持 - 2010年1月15日下午04时58分19秒

Generic Note
------------
Hi,

I logged bug 9288347 for this issue. I will let you know as soon as I have more information.

Thank You,
Marius Garip
Global Customer Services

MIS03@TJPCB.COM - 2010年1月16日上午08时43分10秒

Hi,

The bug is not informations.

Article or Bug cannot be displayed. Possible reasons are:
The article Id or bug number was entered incorrectly. Please check and try again.
The article Id or bug number does not exist (was referenced incorrectly).
The article or bug is not classified as publicly accessible ("non-public").
The content is being updated and it is temporarily unavailable but will be made available again soon.
If you still have questions about why you could not access this article or bug, please use Feedback.

Oracle 技术支持 - 2010年1月19日上午10时13分36秒

Call - Inbound
--------------
Customer called in to chase up the SR processing, and he cannot see the BUG information in MOS.
Told customer, the BUG is logged, and development is working on it now.

Oracle 技术支持 - 2010年1月20日上午09时18分08秒

Call - Inbound
--------------
Customer called and request updates from engineer.
Explained to him why he cannot see the content of the bug.

Thank you.
Faye
Oracle Global Customer HUB

Oracle 技术支持 - 2010年1月23日上午12时08分39秒

Virus scan completed for file CSTAPPRB_jan22.pls

Oracle 技术支持 - 2010年1月23日上午12时08分42秒

Uploaded Attachment CSTAPPRB_jan22.pls in GTCR

Oracle 技术支持 - 2010年1月23日上午12时09分17秒

Virus scan completed for file CSTAPPRS_JAN22.pls

Oracle 技术支持 - 2010年1月23日上午12时09分20秒

Uploaded Attachment CSTAPPRS_JAN22.pls in GTCR

Oracle 技术支持 - 2010年1月23日上午12时09分33秒

Virus scan completed for file CSTPACQB_JAN22.pls

Oracle 技术支持 - 2010年1月23日上午12时09分36秒

Uploaded Attachment CSTPACQB_JAN22.pls in GTCR

Oracle 技术支持 - 2010年1月23日上午12时11分38秒

Comments
--------
=== ODM Action Plan ===

Hi Hui,

Please implement following action plan in test instance cloned of production:

1.Get the following files uploaded in the Service Request

a)CSTAPPRB_jan22.pls
b)CSTAPPRS_JAN22.pls
c)CSTPACQB_JAN22.pls

Compile the files and commit.

2.Do the reproducible test case and check whether the issue is resolved or not

Regards,
Marius Garip
Oracle Customer Support

ZHANGXIAOYING@TJPCB.COM - 2010年1月25日上午11时32分37秒

Hi,

How to find the three files?

Thank you ,
XiCheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月25日上午11时33分43秒

Hi,

How to find the three files?

Thank you ,
XiCheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月25日上午11时33分51秒

Hi,

How to find the three files?

Thank you ,
XiCheng Yang

Oracle 技术支持 - 2010年1月26日上午12时11分47秒

Generic Note
------------
Hi

Files are uploaded in the Service Request

Also I sent an email to the following address with the following attachments:
To: ZHANGXIAOYING@TJPCB.COM
Subject: 2-5950053 how can i check the error of Journal import date source?
Attachments: 9288347.zippp

1.Just rename the attachment to zip.
2.Extract the pls. files

CSTAPPRB_jan22.pls
CSTAPPRS_JAN22.pls
CSTPACQB_JAN22.pls

3.On your test instance compile the files and commit.

4.Do the reproducible test case and check whether the issue is resolved or not

Thanks,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月26日上午12时50分01秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello Hui,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

ZHANGXIAOYING@TJPCB.COM - 2010年1月26日上午08时17分30秒

Hi,

How to find the three files ?

Thank you,
Xicheng yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月26日上午08时17分37秒

Hi,

How to find the three files ?

Thank you,
Xicheng yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月26日上午08时18分02秒

Hi,

How to find the three files ?

Thank you,
Xicheng yang

Oracle 技术支持 - 2010年1月26日下午06时59分58秒

Generic Note
------------
Hi,

1.Files are uploaded in the SR
You login to support.oracle.com
Navigate to the Service Request
View the files uploaded in the SR

2.Also I sent an email with the files to the following address:
zhangxiaoying@tjpcb.com

3.Or you can use the following links

ftp://ftp.oracle.com/support/outgoing/sr2-5950053/CSTAPPRB_jan22.pls
ftp://ftp.oracle.com/support/outgoing/sr2-5950053/CSTAPPRS_JAN22.pls
ftp://ftp.oracle.com/support/outgoing/sr2-5950053/CSTPACQB_JAN22.pls

Thanks,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月26日下午07时00分45秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello,

Please note that your Service Request Number 2-5950053 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.

ZHANGXIAOYING@TJPCB.COM - 2010年1月27日上午08时14分55秒

Hi,

How to find the three files?

Thanks,
XiCheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月27日上午08时15分16秒

Hi,

How to find the three files?

Thanks,
XiCheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月27日上午08时15分23秒

Hi,

How to find the three files?

Thanks,
XiCheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月27日上午08时17分09秒

Hi,

PLS tell me ,how to find the three files.

thanks ,
Xicheng Yang

Oracle 技术支持 - 2010年1月28日上午12时20分26秒

Oracle 技术支持 - 2010年1月28日上午12时21分06秒

Oracle 技术支持 - 2010年1月28日下午02时28分56秒

Virus scan completed for file Compiled_With_Error.doc

ZHANGXIAOYING@TJPCB.COM - 2010年1月28日下午02时30分07秒

Hi,

I have uploaded the error images.

Xicheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月28日下午02时30分45秒

Uploaded Attachment Compiled_With_Error.doc in GTCR

Oracle 技术支持 - 2010年1月28日下午05时38分05秒

Generic Note
------------
Hi,

I have updated the bug with information provided

Thank you
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月28日下午07时15分11秒

Comments
--------
=== ODM Action Plan ===

Hi,
1.Please, provide the following
Upload completed spooled file CstDiag115.txt after running CstCheck.sql
Diagnostics Script. (see Note 378348.1) If prompted by customer id , just enter your company name.

Thanks,
Marius Garip
Oracle Customer Support

Oracle 技术支持 - 2010年1月28日下午07时15分48秒

ZHANGXIAOYING@TJPCB.COM - 2010年1月29日上午10时36分54秒

Hi,

Now ,i can't see your update infromations, please email to my
e-mail:yxc_2009@live.cn

Thanks,
Xicheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月29日上午11时03分34秒

Hi,

Thanks for your help.
Your three file Compiled With Error.

Thanks ,
Xicheng Yang

ZHANGXIAOYING@TJPCB.COM - 2010年1月29日上午11时03分56秒

Hi,

Thanks for your help.
Your three file Compiled With Error.

Thanks ,
Xicheng Yang

Oracle 技术支持 - 2010年1月29日下午11时24分37秒

Email To
--------
zhangxiaoying@tjpcb.com,

Email Subject
-------------
SR #2-5950053: how can i check the error of Journal import date source?

Email Body
----------
Hello,

Please, provide the following
Upload completed spooled file CstDiag115.txt after running CstCheck.sql
Diagnostics Script. (see Note 378348.1) If prompted by customer id , just enter your company name.

Regards,
Marius Garip, Oracle Customer Support

Note: Please do not reply to this email. This mailbox does not allow incoming messages.