Customer Interface Status Error Codes
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge oracle customer interface error codes Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP http status error codes SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE
Nt Status Error Codes
A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael
303 Status Code
Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle oracle customer interface tables Applications Your premier resource for objective technical discussion and peer-to-peer support on Oracle Applications. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Customer Interface Error table Sasikanth Reddy asked Jan 16, 2008 | Replies (5) Hi, Can anyone tell what is the interface error table when we run customer interface program. Regards, -Sashi. Join this group Popular White P
when you run Customer Interface. RA_CUSTOMERS_INTERFACE This table stores customer, address, and business purpose
Ra_customers_interface_all In R12
information. You do not have to enter values in this address validation for this record failed table if you do not want to import customers, addresses, or business purposes. Column ra_contact_phones_int_all Name Value ADDRESS1 through 4 Enter the address for your customer in these four columns. You can enter up to four lines of an address. http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/customer-interface-error-table-1832503 Validation: If you enter a value in ORIG_SYSTEM_ADDRESS_REF, you must enter a value in ADDRESS1. For multiple rows with the same address reference, insert values in address 1-4. Destination: RA_ADDRESSES.ADDRESS1, RA_ADDRESSES.ADDRESS2, RA_ADDRESSES.ADDRESS3, RA_ADDRESSES.ADDRESS4 CITY STATE PROVINCE COUNTY POSTAL_CODE COUNTRY Enter the city, state, province, county, and postal code for https://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/cusimp08.htm this customer's address. You must enter values that have already been defined in AR_LOCATION_VALUES if Address Validation is set to 'Error' and you are calculating sales tax. You must do this for each address component on which your tax location flexfield structure is based. If Address Validation is set to 'No Validation' and you pass a value that does not exist in AR_LOCATION_VALUES, Customer Interface inserts this value into AR_LOCATION_VALUES. You must always enter a value for Country. Validation: The county must exist in FND_TERRITORIES. Destination: RA_ADDRESSES.CITY, RA_ADDRESSES.STATE, RA_ADDRESSES.PROVINCE, RA_ADDRESSES.COUNTY RA_ADDRESSES.POSTAL_CODE, RA_ADDRESSES.COUNTRY ADDRESS_KEY This column is not currently used by Customer Interface. BILL_TO_ORIG_ ADDRESS_REF Enter the Bill-To location that you want to associate with the Ship-To address on this record. Validation: You can enter a value only if the SITE_USE_CODE column in this record is 'Ship-To'. Also, the Bill-To address must exist for this cus
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of https://community.oracle.com/thread/2399983 it will not work correctly without it enabled. http://www.geekinterview.com/question_details/16072 Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in On Demand: E-Business error codes Suite All PlacesOracle ApplicationsE-Business SuiteOn Demand: SaaS and Managed ApplicationsOn Demand: E-Business Suite This discussion is archived 1 Reply Latest reply on Jun 5, 2012 3:57 PM by Hussein Sawwan-Oracle Customer Interface 923413 Jun 5, 2012 9:29 AM HI i'm using Oracle status error codes EBS Release 1, and been trying to insert customer into 'RA_CUSTOMERS_INTERFACE and ra_customer_profiles_interface' but when i run customer interface request it show exception error message: Customer Reference Address Reference Site Use Error Message --------------------------- --------------------------- ----------- ---------------------------------------------------------------- INT-11 INT-22 DELIVER_TO Customer record for insert must have validated profile record de fined in the RA_CUSTOMER_PROFILES_INTERFACE table. Customer Reference Address Reference Currency Error Message --------------------------- --------------------------- ----------- ---------------------------------------------------------------- INT-11 INT-22 USD The specified address either has an inactive bill-to, dunning, o r statements site defined, or has errors in the RA_CUSTOMERS_INT ERFACE table. Customer record for insert must have validated profile record de fined in the RA_CUSTOMER_PROFILES_INTERFACE table. INSERT INTO apps.RA_CUSTOMERS_INTERFACE ( orig_system_customer_ref ,site_use_code ,orig_system_address_ref ,insert_update_flag ,customer_name ,customer_number ,customer_status ,primary_site_use_flag ,address1 --,address2 --,postal_code --,city ,
Management Accounting Operating System Operating System Android iOS Microsoft Coding Programming J2EE Languages Database Database Data Warehousing Oracle Applications Applications Clarify CRM Oracle Apps Peoplesoft Siebel Software Testing Testing Testing Tools Miscelleanous Helpdesk Mainframe Networking SAP R/3 Web Interview Coaching Career Counseling Job Interview Interview eBooks Accounting eBook C eBook Citrix eBook Job Interview eBook Career Advice Career Change Jobs Help Projects Requests Resume Help Training Advice Engineering Chemical Engineering Civil Engineering Electrical Engineering Electronics Engineering Micro Processor Mechanical Engineering By Company Ask Question Home Interview QuestionsOracle AppsApps Technical How to handle errors in Customer interface ? Interview Candidate Aug 15th, 2005 2 2904 Apps Technical Answer First Prev Next Last Showing Answers 1 - 2 of 2 Answers gangadharchandaluri ProfileAnswers by gangadharchandaluri Jun 16th, 2006 Hi,Take the error code which you have encountered in the interface table and check it in AR document where u can find the list of customer error codes and their description.You can act on the error code accordingly.ThanksGanga
Was this answer useful?Yes Reply Mr.KUK Jul 13th, 2011 Insert the customer details viz., name, country, ship to address, bill to address etc into ra_customer_interface_all table. Then run the customer interface program to import the customers. Was this answer useful?Yes Reply Give your answer: If you think the above answer is not correct, Please select a reason and add your answer below. - Reason - Answer is wrong Spelling Mistakes Duplicate Answer Inappropriate Answer Other Answer Question Click here to Login / Register your free account Name: Email: Answer: Insert Code: Code Language