Fusion – Query to extract Oracle Enterprise Contract Clauses
Cloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_articles_b [...]
Fusion – Query to extract Customer Details
select hp.party_name customer_name, a1.account_number customer_number, a3.STATUS site_status, SITE_USE_CODE,LOCATION,PRIMARY_FLAG [...]
Fusion – Global Human Resources Views
Global Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS_F_VL [...]
Fusion – Global Human Resources Tables
Global Human Resources Tables EEC_CONTEST_HDR EEC_CONTEST_METRIC_DETAILS EEC_CONTEST_PARTICIPANTS EEC_CONTEST_REWARDS EEC_CONTEST_STAGES EEC_CONTEST_TEMPLATE_DTL EEC_CONTEST_TEMPLATE_HDR_B [...]
Fusion – Sample Payload For FindCustomerAccount Operation In TCA Account Web Service
SOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” [...]
Fusion – Update Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” [...]
Fusion – Create Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” [...]
Fusion – Sample Payload To Update Descriptive Flexfield On Internet Supplier Portal Invoice
Sample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” [...]
EBS – API to Create Bank Branch Account creation in single procedure
CREATE OR REPLACE PROCEDURE INSERT_SINGLE_BANKS IS x_response_rec apps.iby_fndcpt_common_pub.result_rec_type; l_init_msg_list VARCHAR2 (2000); o_bank_id NUMBER; x_return_status VARCHAR2 (3000); [...]
OAF Date Converter, Formatter and Validation – Reusable Methods
Various Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * [...]