Showing posts with label TCA. Show all posts
Showing posts with label TCA. Show all posts
Friday, August 8, 2014

Create Person Party and Org Contact for a Organization Pary in Oracle R12

›
 --It is always a good idea to initialize apps and set global policy context before using standard API CREATE OR REPLACE PROCEDURE create...
Tuesday, August 5, 2014

API to create Contact Point ID for a Party in Oracle R12 Example

›
 -- Make Sure you initialize apps and set mo_global.set_policy_context   PROCEDURE create_contact_point_id (       p_in_contact_point_ty...
Tuesday, July 15, 2014

Update OSR in Oracle R12 for HZ_PARTY_SITES table

›
 -- Make Sure you initialize apps and set mo_global.set_policy_context    set serveroutput on; DECLARE       v_xref_rec               ...
Sunday, June 15, 2014

Query to find the orig system reference for a Customer/Party and other TCA entities

›
If the data was imported into the EBS system from ABC system and ABC's party id was used as the cross system , the below query can be u...
1 comment:

Important TCA lookups

›
Lookup for Customer Class code select lookup_type,lookup_code,meaning from ar_lookups where lookup_type in (select class_category from HZ...
Wednesday, May 28, 2014

Customer Conversion/Interface Techniques in Oracle EBS R12

›
These 3 methods can all be used to create customer records. Following are some considerations to help you decide which method to use: Cu...
Saturday, May 17, 2014

TCA Parties Table Drill Down

›
SELECT * FROM hz_parties WHERE party_name = 'Saikam INTL' -- party_id = 39266,party_number(registry_id)= 1849,party_type = organiza...