[AR][Setting] 進DB修改Flexfield造成錯誤訊息

前陣子發生件事，在AR設定時使用Flexfield來設定Country(路徑為：Receivables Responsibility-> Setup-> Financials-> Flexfields-> Key-> Values)，設定人A將Hong Kong設成Hong Kon，後來被B同事發現有錯，通常Flexfield的Value一經設定後就不能修改，所以B同事便進入DB內將Hong Kon update成Hong Kong。
後來USER反應在AR的Transactions->Transactions內查詢資料時都會出現下圖的訊息，

經過協助才找到原來RA_TERRITORIES裡也存有相關資料而且存的是Name(或稱Code)而非ID，因該table的資料沒一起修改，造成查詢時都出現訊息。

所以，千萬不要自行至DB修改資料，你永遠不會知道是否修改完全，是否會造成另一隻程式出現訊息。

[AP] Why "View journal entries" display nothing?

近日user對於某張被cancel 的 Invoice於Create Accounting後，View journal entries但無任何Subledger Journal Entry 的detail資料顯示感到疑惑。

依以下步驟檢示設定，並配合Oracle Support的解釋，就能了解為何 "View journal entries"看不到journal lines 的資料。

a)      Subledger Accounting Options
GL Responsibility->Setup->Accounting Setup Manager->Accounting Setups
1) Choose the ledger
2) Click on "Update Accounting Options"
3) Scroll to “Subledger Accounting Options” in the Primary Ledger section
4) Click on Update Icon
5) Click on “Update Accounting Options” Icon against the Application to be setup(Example: Payables)
6) Field: General Ledger Journal Entry Summarization
Ans:General Ledger Journal Entry Summarization= Group by GL Date

b)      Journal Line Types
Payables Responsibility->Setup->Accounting Setups-> Subledger Accounting Setup->Accounting Methods Builder->Journal Entry Setups-> Journal Line Types
1) Application to be setup(Example: Payables)
2) Field: Transfer to GL
Ans:Transfer to GL= ‘Summary’

c)      Profile : "SLA: Show Zero Amount Journal Lines"
System administrator Responsibility->Profile->System
1) Enter Application : Payables
2) Responsibility: Your responsibility(Example: Payables)
3) Profile : "SLA: Show Zero Amount Journal Lines"
4) Click Find
Ans:SLA: Show Zero Amount Journal Lines=> Site level = ‘No’

Oracle Support's Explanation & Solutions

1. "SLA: Show Zero Amount Journal Lines" is control if you can view the journal lines with 0 amount.

Here in your case , you set it at Site level to No, which means once the journal lines with 0 amount, you cannot view it in page.

2.You also has below setups:
General Ledger Journal Entry Summarization :Group by GL Date
Transfer to GL : Summary

Which means the journal lines transferred will be in summary mode which means , your journal lines will be summarized together grouped by GL Date.

So in your case , as the invoice lines has been discarded, and the GL date is all the same, so when you create accounting, the journal lines summarized by the GL date will has the total amount with 0.
And as your 1 setup, the 0 amount journal line will not be displayed.

That is why you can not view the journal lines for this invoice.
===
So for your confirmation, you can set the "SLA: Show Zero Amount Journal Lines" to Yes and see if you can view journal with 0 amount.
Or transfer to GL in details.