Assignment Set Conversion
Assignment Set: Once sourcing rules has been defined, you must assign them to particular items and/or organizations. These assignments are grouped together in assignment sets. In an assignment set you…
Read MoreSourcing Rule Conversion
Sourcing Rule: Sourcing Rule Provides list of approved suppliers where we can rank the suppliers on a percentage basis. This is useful for the buyers/requestors at the time of making…
Read MoreLot-Wise Onhand Availability across Inventory Orgs
Standard functionality in the SO Form, provides the On-Hand visibility of an Item at the Specific Inventory Org (Ship From Org) level. In case the Visibility is required as per…
Read MoreCreate Bank and Bank Branch Using API
When performing Master Data Migration for Supplier or Customer business also needs the migration of Associated Banks and Bank Branches.In order to perform this we need to migrate Banks, Bank…
Read MoreValidating the Custom(User Entered) Exchange Rate
Validating the Custom(User Entered) Exchange Rate à Need to Enable the setup in the Payable Options for Enabling the Exchange Rate or Functional Amount Columns if Exchange Type is “USER”…
Read MoreLOV Changing Using Custom.pll
à Need to Create a new Procedure in the custom.pll à Need to find the Standard Lov name form the application by placing the cursor on the particular field form…
Read MoreDynamic Logo Chaining in BI Publisher Report
Dynamic Logo Chaining in BI Publisher Report Need to Created a Lookup where we can map the required Logo image names Need to create a formula column in report builder…
Read MoreAR Transactions and Tax Query – India Localization
SELECT TO_CHAR (trx_date, ‘DD-MON-YYYY’) ar_posting_date, TO_CHAR (jatt.excise_invoice_date, ‘DD-MON-YYYY’) excise_invoice_date, rcta.trx_number ar_trx_number, flv.meaning document_type, jatt.excise_invoice_no, hca.account_number cust_bill_to, hp.party_name cust_name,…
Read MoreBI Publisher Report with Excel Template
Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…
Read MoreRegion Interface – Shipping
Interface Tables: WSH_REGIONS_INTERFACE WSH_REGIONS_TL_INTERFACE Base Tables: WSH_REGIONS WSH_REGIONS_TL Create Country: Insert the following data into Interface tables Generate Sequence_ID and…
Read More