Oracle eBS經驗分享

 

Root Cause

I set Character mode , but use <Unit of Measurement> as ‘Inch ‘.

Solution

Set <Unit of Measurement> to ‘point’

Tools> Preference

When I create Data Link between two sql query , I got below error message.

< Root Cause >

These steps are my way , I am not following oracle coding standard guide.

For you all reference.

Submit Report Error :

REP-0002: Unable to retrieve a string from the Report Builder message file.

REP-0151: Duplicate argument specification for keyword ''.

首先New user parameter

Before report  ==> srw.user_exit('FND SRWINIT');

After report ==> srw.user_exit('FND SRWEXIT');

這樣就行了！！

報表的Size

Report Size 單位	A4 (直印)	A4 (橫印)
mm	210 x 297	297 x 210
Report Layout Section Width/Height	8.5 x 11 (inches)	11 x 8.5 (inches)
characters	66 x 80	132 x 66

Style
The print style you select depends on your system and printer setup.
Print styles include:
• 132 columns and 66 lines (Landscape)
• 180 columns and 66 lines (Landwide)
• 80 columns and 66 lines (Portrait)
• 132 columns and 62 lines (A4)

Server 上 $AU_TOP/PLSQL 裡

XML Publisher Report Issue:

目前為止已經開發了三四隻XML Report (Output Format = Excel).

這兩天竟然出現這個怪異的現象.. 這隻報表只要Run 3 以上就會出現Warning,

重點是之後跑XML Rerport 也都會Warning ，跑不出來了，

也就是說只有有隻XML Report Fail 就會擋到後面XML Report的路，大家都不能走了！！！

Log ==>

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 22190736 on node ERPDEMODB at 10-JUL-2009 07:34:26.
Post-processing of request 22190736 failed at 10-JUL-2009 07:36:25 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

+------------- 2) PRINT   -------------+
Not printing the output of this request because post-processing failed.
+--------------------------------------+

今天發生了一個Report Issue
在Report Client Runtime試Run是正常的
但掛到ERP後～～
會出現下面的錯誤訊息

REP-1212 Error:  Object <object_name> is not fully enclosed by  its enclosing object 'body'.
上Metalink查詢後...
發現橫印的Rows Number必需為 65 or 66(如下內容)
{補充}
雖然按照下面步驟執行一遍...
發現一樣有錯誤

後來發現一件事情
我的Report Header中的帳本名稱  與Print Date欄位重疊...
我調整了一下讓他們不要重疊後
就可以了...
提供給大家參考..

---

Problem
--------------
A report runs fine from the command line; but when you run it from the
concurrent manager, you receive the following error:

   REP-1212:  Object <object_name> is not fully enclosed by its enclosing  object 'body'

Solution
---------------
To resolve this issue, perform the following steps:

   a.  From the System Administrator responsibility, Navigate to the printer driver style form: /Navigate Install Printer Style.
   b.  Query up Landscape and change the rows fields to 65 (66); Commit.
   c.  Query up Landwide and change the rows fields to 65 (66); Commit.
   d.  Log onto the Application Developer responsibility.
   e.  /Navigate Concurrent Program.
   f.  Query up <report with error, ex RAXINV>. (as the short name).
   g.  Change a Name value to itself; Commit.

Note:  You should go into System Administrator responsibility to ensure  the printer style was changed to 65.

If you are running FSG reports, change the style to Landwide.

Information From
--------------------------------
Metalink Doc ID:  Note:47841.1