ITPub博客

最近工作中要添加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

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