ITPub博客

Mark the Database Column based on what counting should be done.For Example if, Report is related with Purchase order print , then PO_Header_id or Segment1 can be treated as Base Database Column from SQL Query.or if report belongs to Order Management , and records are fetched based on Order nu...

问题：Exchange Rate使用了长整形，10进制数值大约长度17位，在pl/sql developer 上数值由科学计数法显示。在查看时不是很方便，且数值进行了省略显示，不准确。 解决方法：在tools菜单下，Tools - Prefrence - SQL Window - 选择："Number fields to_char" ，保存。PS: 遇到这种情况可以在...

最近工作中要添加PARTY里面的PROFILE,因为界面上没有添加和修改的地方。可能ORACLE是希望这些PROFILE都从PROFILE CLASS那里带过来，不希望维护客户的地方改这些PROFILE.不过TCA API还是能实现改PROFILE和PROFILE AMT的值。下面是CREATE PROFILE , CREATE PROFILE AMT & UPDATE PROFILE AMT的脚本，希望对大家有用。[@more@] --CREATE CUSTOMER PROFILE & CUSTOMER PROFILE AMTdeclare -- Local variables here p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; p_cust_acct_relate_r

• Personalize Self-Service Defn– Yes to allow ‘Personalize’ button to appear at the top of the page • FND: Personalization Region Link Enabled – Yes to display all the regional links above each region – Minimal to display key regional links • Disable Self-Service Personal – Yes will disable all personalizations at any level • FND: Diagnostics – Turns on ‘About this Page’ • FND: Personalization Document Root Path (new in 11.5.10) – Required to migrate pers

In this post, I tried to explain the example implementation of a Zoom Functionality in R12[@more@]Instance: R12.1.1Requirement: 1. Add an option named “Responsibility Details” to Tools Menu of the “APPLICATION USERS” Form.2. By clicking the option said in requirement 1, the user must be able view the complete details of the selected responsibility via “DEFINE: RESPONSIBILITIES” forms 3. Independent Functionalities of “USERS” and “RESPONSIBILITIES” FORM should not

Within Oracle R12 it’s possible to Personalize Self-Service pages. To enable this option you need to set the the following profile options at user level.Personalize Self-Service DefnFND: Personalization Region Link EnabledAfter setting the above profile options you can see now different region links which you can click on and do personalization for. You can undo all personalization from the same region link on the self-serivce page. But with personalization it’s possibleto unhide a

1. 图片尺寸大小，不可以大于40K。2.用report builder的话，里面编码要选UTF8.3. 对于要显示的图片，不可以做为公式列，因为类型无法选择Character LOB.4. 对于这个图片栏位的属性，File format须选定Text. 而不能是Image.5.需要自定义一个函数，把BLOB类型转成CLOB.DBMS_LOB.createtemporary(lob_loc => l_result, CACHE => FALSE,dur => 0);Wf_Mail_Util.EncodeBLOB ( P_blob, l_result);[@more@]

GoalThis document was produced for an Oracle Premier customer that wanted a consolidated list of investigative / repair sql addressing manufacturing processes. The idea was to include DEV specific suggestions not published in Metalink (MyOracle Support) as well as known solutions in one doc to save time. The commentary is derived from DEV, myself and Global Support.The following SQL is meant to assist in debugging transactional issues and in some cases repair such transactions. This list is

INV_Quantity_Tree_PUBHow does one check onhand quantity levels with PL/SQL?This script will provide snapshot for stock(material) for Item in an Organization / Subinventory. The script output will provide details with the following results:TitleExplanationQuantity on handOnhand Quantity for the ItemQuantity res ohReservable Quantity On handQuantity resQuantity reservedQuantity sugQuantity SuggestedQuantity ATTAvailable To TransactQuantity ATRAvailable To ReserveNote : Do not enter input parameter

9i的bug，10g后才ok，plsql dev编译package报600错误。ORA-0600 error with arguments: [17113].ORA-0600 error with arguments: [17113].You may be getting this ORA-600 when recompiling a PL/SQL package.The Package shows in OEM as valid even though compiling gives ORA-600 error.You can reproduce the error when a PL/SQL package is in an editor in the PL/SQL developer tooland you select Compile. But if the package is selected to compile from the window"navigator" - it compiles successfully.The a

操作系统：AIX 6.1 数据库环境：RAC 10.2.0.52011/10 /08 16:33左右，节点1出现的ORA-00600错误，产生dump文件为5M多的 zgscdb1_ora_26739166.trc ，2011/10/09 15:43左右，节点二出现ORA-00600错误，dump文件为 159K的zgscdb2_ora_35651868.trc节点1：这个错误是由于取消当前操作所引发。Sat Oct 08 16:33:46 GMT+08:00 2011Errors in file /oracle10g/app/oracle/admin/zgscdb/udump/zgscdb1_ora_26739166.trc:ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], []ORA-00604: error occurred at recur

我在pl/sql 7.0.3 的sql窗口里写sql语句，用键盘上的home,end键子怎么不好使啊？谁知道应该怎么设置？ 你可以在菜单“工具”选“首选项”，进入到配置界面，选“用户界面”下的“键配置”，然后按“恢复到默认...”键,最后按“确定”，就可以 了。英文的顺序是："Preferences"->"User Interface"->"Key Configuation"->"Reset to Default..."[@more@]

Checked for relevance on 08-Dec-2008Problem Description-------------------You are running Customer Interface RACUST and there is an error message in theINTERFACE_STATUS column, but you don't know what it means.Solution Description--------------------INTERFACE_STATUS appears in the following tables:RA_CUSTOMERS_INTERFACE_ALLRA_CUSTOMER_PROFILES_INT_ALLRA_CONTACT_PHONES_INT_ALLRA_CUSTOMER_BANKS_INT_ALLRA_CUST_PAY_METHOD_INTERFACEThese are the message codes and their meaning:A1 --> The customer

orig_system_customer_ref ： The customer reference must exist inHZ_CUST_ACCOUNTS or be successfully validated inRA_CUSTOMERS_INTERFACE.ORIG_SYSTEM_ADDRESS_REF： For insert, the address reference must exist inHZ_CUST_ACCT_SITES_ALL or be successfully validatedin RA_CUSTOMERS_INTERFACE (derived fromORIG_SYSTEM_CUSTOMER_REF)[@more@]

Applies to:Oracle Receivables - Version: 12.1.1 and later [Release: 12.0 and later ]Information in this document applies to any platform.SymptomsRelease 12. - Receivables Manager ResponsibilityUnable To Select and add Existing Contacts on the Customers Standard Page at Sites level.This was available in 11i. ChangesRelease 12 CauseThe new customer UI comes with Oracle (TCA)Data Quality Management (DQM) feature in Release 12. SolutionWhat you are seeing is standard functionality in R12. Please r

Applies to:Oracle Trading Community - Version: 12.0Oracle Customers Online - Version: 12.0Oracle Receivables - Version: R12This problem can occur on any platform.R12SymptomsR12Navigation Path -> (R) Receivables-> Customers -> Search Screen Unable to query customer with the partial Customer Account number .Example:Search on D% no resultsSearch on D12% no resultsSearch on full D12345 - received results.CauseThe data that the customer was querying on did not yet existin the hz_staging tabl

Applies to:Oracle Trading Community - Version: 12.0 to 12.1.0 - Release: 12 to 12Information in this document applies to any platform.GoalHow does the DQM Real Time (Automatic) Synchronization work for R12? SolutionIn Release 12, the DQM Synchronization can be set to: Automatic Batch Disabled Navigation Path: (R) Customers Online Data Librarian Super User or Trading Community Manager Administration Tab > DQM tab > DQM Synchronization Method Release 12 no longer uses the Real Time Work fl

SymptomsAfter creating a new Supplier, Supplier Site and defining a Contact, the Contact list of values in the Enter Purchase Order form returns the error "FRM-41830 List of values contains no entries"CauseContact record was not linked to the Supplier / Site address. Solution-- To implement the solution, please execute the following steps::Ensure the Contact is tied to the Supplier/Site address1) Open the Supplier form and click on Contacts.2) Find the Contact name and click on the Upd

Issue: after the R12 upgrade i'm trying to do a help--diagnostics--examine or help--diagnostics--custom code--personalize from any form and it gives the error "function not available to this responsibility".[@more@]Solution:- Log in as System Administrator- Choose Profile/System- Find profile "Utilities:Diagnostics" and change it's value to "Yes".

The method of storing information for supplier contacts is very much different in R12 than it isin 11i. Most of the information is stored in various TCA tables. [@more@]The method of storing information for supplier contacts is very much different in R12 than it isin 11i. Most of the information is stored in various TCA tables. The table AP_SUPPLIER_CONTACTSis a linking table between the supplier address and the various TCA tables if the contact isassigned to an address in the form or during Imp