IMP Profiles in Oracle Quotes & i Store

Profile Option Name 
Value 
IBE:Category Set 
Valid Value from LOV 
IBE:Item Master Organization 
Valid Value from LOV 
MO:Operating unit 
Valid Value from LOV 
IBE:Price Event For Shopping Cart 
Batch Processing 
IBE:Create Order In Entered State if It has errors while Booking 
Yes 
IBE:Shopping Event Before Shopping Cart 
Enter Order Line 
IBE:Default Payment Term 
Valid Value from LOV 
JTF_PROFILE_DEFAULT_APPLICATION 
671 


JTF_PROFILE_DEFAULT_CSS 
jtfucss.css 


JTF_PROFILE_DEFAULT_CURRENCY 
USD 
JTF_PROFILE_DEFAULT_RESPONSIBILITY 
21819 (iStore Admin at Application Level) 
ASO:Automatic Numbering 
Yes 
ASO:Credit Card Authorzation 
Yes (if CC Allowed) 
ASO:Default Quote Status 
Store Draft 
ASO:Default Order State 
Booked 
ASO:Default Order Type 
Mixed 
ASO:Default Sales Rep 
No sales credit 
ASO:Enable TCA Changes 
Yes 
ASO:OM Defaulting 
Yes or No (based on OM Defaulting Rules) 
HZ:Generate Party Number 
Yes (ApplicationLevel) 
HZ:Generate Party Site Number 
Yes (ApplicationLevel) 
Sequential Numbering 
Yes (Site Level) 
QP:Item Validation Organization 
Valid Master Org 
ASO : ATP Default Customer  
Valid Customer 
IBE: Retrieve Price When Displaying Items 
Yes 
IBE: Use Price list associated with Specialty Site 
Yes 

Comments

Post a Comment

Popular posts from this blog

Queries For Oracle Interface Errors Records.

Below are the queries to get the error records information while processing interface data. AP Invoices:   SELECT    airl.last_update_date process_date,    HU.NAME,   nvl(ail.invoice_line_id,aii.invoice_id) process_id,   'AP' module,   'Import AP Invoice' interface_name,   aii.source source,   NVL(SUBSTR( ail.dist_code_concatenated,1,instr(ail.dist_code_concatenated,'.',1,1)-1),'ALL') company,   'ERROR' status,   ail.line_type_lookup_code ,   airl.parent_table ,   ail.description ,   NVL(ail.distribution_set_name,dist_code_concatenated) ,   pvsa.vendor_site_code ,   listagg(NVL(airl.reject_lookup_code,'AP_INV_ERROR') ,';') within group (order by NVL(airl.reject_lookup_code,'AP_INV_ERROR')) error_code,   listagg(flv.meaning,';')  within group (order by NVL(flv.meaning,'AP_INV_ERROR'))error_summary,   NULL error_details,   pv.vendor_name ,   pv.segment1 ,   aii.invoice_amount,   aii.i
Read more

Customising PO Output For Communication Report in Oracle Purchasing

Image
PO Print PDF Report: Oracle EBS provided  a standard functionality to print the PO report directly from the PO form itself by clicking tools menu and view PDF option. Once we select that option output will be rendered in PDF format in the browser instantly. Internally it will run the concurrent program 'PO Output For Communication'. This concurrent program is of JAVA type which will uses the seeded package  'PO_COMMUNICATION_PVT'  for generating the XML data and later this XML data will be processed and formatted by using the XSL template of data definition 'Standard Purchase Order Data Source' in case of standard PO's. Oracle by default will provide one standard BI publisher template for this. In case if we want to have custom layout for this report we can build a new template for the same data definition and this template has to be used while doing the setup for PO Document types. Creating Custom Template and Setup this for PO Document type: To c
Read more

Oracle APPS Useful Queries

                       ACCOUNT PAYABLES Payable Open Interface Rejection:   SELECT ail.* FROM AP_INVOICES_INTERFACE ai ,   ap_invoice_lines_interface ail ,   ap_interface_rejections AIR WHERE ai.GROUP_ID='EO_AUG-13_010813_443' AND ai.status    ='REJECTED' AND ai.invoice_id=ail.invoice_id   --and ail.dist_code_concatenated='66810-00-999-00000000-00000000-00000-FI100' AND air.parent_id = DECODE(air.parent_table,'AP_INVOICES_INTERFACE',AI.INVOICE_ID,'AP_INVOICE_LINES_INTERFACE',ail.invoice_line_id,NULL) ORDER BY 2; AP Invoices Query: /*+INDEX (AP_INVOICES_ALL [XXDG_TEST]) */ SELECT  apia.invoice_id,        alc.displayed_field "Invoice Type",        apia.invoice_num "Invoice Number",        apia.invoice_date "Invoice Date",        apia.gl_date   "Invoice GL Date",        nvl(apia.VOUCHER_NUM,doc_sequence_value)"Voucher Number",        apia.description inv_Description,  
Read more