Monday, September 10, 2018

Profile Options used in Pricing Data Bulk Loader in Oracle APPS

Below are the Profile Options need to be set:

QP: Pricing Transaction Entity:- When the Pricing Data Bulk Loader API is called, the price list data is picked up from the interface table when the Pricing Transaction Entity attribute or column is either: NULL or same as the Profile Value.

QP: Source System Code:- When the Pricing Data Bulk Loader API is called, the price list data is picked up from the interface table when the Source System Code attribute or column is either NULL or same as the Profile Value.

QP: Batch Size for Bulk Import:- This profile value determines the number of records loaded into the memory for processing. For improved performance, set an appropriate value for this profile based on your hardware configuration. If the profile value is set too high, then the system may "hang." The default value is 1000.

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...