FOrmsPersonalization:To restrict a receipt method LOV for a responsibility

In Order Management Responsibility go to quick sales order menu

• create a sales order
• click on actions
• Choose payments
• form main menu go to help-diagnostics-custom code-personalize

1.Add a Sequence with description,

 

 

Under Condition ;
trigger event ; when_new_item_instance
Trigger_object ; blockname.filed-name(In which u need the personalization)
Condition:optional,can give any default values e.g:
Block_name.field_name=’Value’

 

e.g: WHEN-NEW-ITEM-INSTANCE;
OE_PAYMENTS.RECEIPT_METHOD:OE_PAYMENTS.PAYMENT_TYPE_CODE='CASH'
Under Level Choose the responsibility that you want to assign.

 

 

 

Now go to actions tab

 

2.The first sequence is built-in and the second sequence is property for a LOV
e.g:Seq 10
type;Builtin
In Builtin Type Choose;Create record group for query
Argument;Enter your query
NOTE:
1. If u r changing the existing record group the you need to check the exiting record group query and develop your query by choosing same columns and with your own condition appropriately.
2. U need to refer the the LOV that u r Personalizing.
Group Name;Give a custom name
E.g. query
**-For type Cash**
SELECT rm.NAME,rm.receipt_method_id
/*Have choosen the same columns as per the default LOV Record group query and changed the where clause as per my requirement*/
FROM
ar_receipt_methods rm,
oe_payments b,
ar_receipt_method_accounts_all rma,
fnd_lookup_values flv,
ce_bank_acct_uses_all cba
where
rm.receipt_method_id=b.receipt_method_id
AND rm.receipt_method_id = rma.receipt_method_id
AND flv.lookup_type like '%PAYMENT_METHODS%' --Existing LOV Name--
AND rma.remit_bank_acct_use_id = cba.bank_acct_use_id and
rma.org_id = cba.org_id
AND flv.enabled_flag = 'Y'
AND Flv.LOOKUP_CODE not IN('CCR')--Condition for Where Clause--
AND rm.receipt_method_id IN('2012')
GROUP BY rm.NAME,rm.receipt_method_id

 

3.Create property for the built-in type

 

My desp; Restrict Receipt Method for cash
Object_type;Cash

 

Target_Object;Payment_Methods
Property_name;Group Name
Value;Give the custom name that u have given for the Builtin Group Name

 

And ITS DONE !!!!

 

 

 

 

 

FND_CANONICAL

In HRMS we do use date with timestamp for EIT ans SIT segments.

To change the format od the date we can use fnd_date.canonical_to_date default function:

e.g:

before using fnd_date function

SELECT pei_information2 Visit_date from per_people_extra_info where pei_attribute_category = '02' and person_id=1101

After using fnd_date function:

SELECT fnd_date.canonical_to_date(pei_information2) from per_people_extra_info where pei_attribute_category = '02' and person_id=1101

 And you can use to_chat over uit to make it in words as

SELECT TO_CHAR(fnd_date.canonical_to_date(pei_information2),'Month ddTH, YYYY') from per_people_extra_info where pei_attribute_category = '02' and person_id=1101

 

Find log using Request id

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = 515172

Adding LOV list to forms

1.Create a record group with the query required for lov list.
2.Create a LOV with the created Record group and give the subclass information as LOV
3.Map the field from the form in LOV mapping property field.

AP Check Printing R12

From Scratch:

1. Create XML Template
Payables Manager>Setup>Payment>Payment Administrator>Formats>XML Publisher Format Templates
Click on 'Create Template'
Enter the name,Code,Application is Payments
Type=RTF
Data Definition=Oracle Payments FUnds Disbursement Payment Instruction Extract 1.0
Lanuguage:English
File Territoru:US
Upload your RTF File
2.Create Payment Format:
Payables Manager>Setup>Payment>Payment Administrator>Formats>Formats
Select Type=Disbursement Payment Instruction
Click On create
Enter Code,NameType:Same as above we have created for template
Data Extract=Oracle Payments FUnds Disbursement Payment Instruction Extract 1.0
XML PUblisher Extract=XML Template Name Created in Step1

3.Create Payments Document:
Payment Manager>Setup>Payment>Bank Accounts

Query The Bank Name(Assuming bank setup has been done already)
Select The Bank Account and Click on manage Payment Documents.
Click on create,Enter name as 'Sample Check Payment Document'
Paper Stock Type:Blank Stock or Pernumbered Stock
Check the box for attached Remittance stub if Available.(A new filed no.of lines per Remittance Stub' Will be shown up.)-error may occur in printing so adjust the nuber while testing
Format:Enter the Format Defined in Step 2
First Avilable document number:Last available document Number
Enter any other additional field if needed.Click Apply

4.Create Payment Profile:
Payables Manager>Setup>Payment>Payment Administrator>Payment Process Profiles:
Click on create>Enter Code Name
Payment Instruction Format:As defined in step 2
Processing type: Printed
Payment Completion Point:when the payment Instruction is formatted
Default Payment Document:Document Created in step3
Payment file:Send to printer
Check the box 'Automatically Print After Formatting'
Default Printer:Printer name
Click Apply

Now create a invoice in Payable superuser, validate, create account and pay in full,check the payment document in request 'Format Payment Instruction'
set output format as xml if u need to extract the xml file.
Set as pdf by default

R12 AP Check Printing

Check Printing Concepts in R12:
1.Check Data moved to Payments from Payables.
2.Can Update the RTF to change the template of check Printing.
3.No of lines to be printed can be set in Payment Process Profile.


How to download Check Printing RTF:
Download standard oracle template
Payables Manager>Setup>Payment>Payment Administrator>Formats>XML Publisher Format Templates>Query and downloa 'Standard Check Format' IBYDC_STD1.rtf


Generating XML Is Little Difficult.
Can Refer to metalink Note ID:457539.1
Go to Payables>Setup>Payment Administrator

Click on go task of Formats>XML Publisher Formats

Select Data Extract as Oracle Payment Funds Disburesement Payment Instruction Extract,Version 1.

And XML Publisher Type as data Extract Identity In format

Update in Bank Account Documents and in Pay Process request

Go to Payable Super user Responsibility and Create a batch process and submit  the SRS as below with required parameters.

PGM:Create printed Payment Instruction

XML Extract will be in the output file.

R12 Migration Check points:

Migrating a Report:

1.Check The model query for obsolete tables and view.
2. Replace the obsolete tables and view with corresponding joints.
3.Check the program units for the same as mentioned above.
4.Run the query in sql developer and verify the output in 11i and R12 Instances.
5.Recompile and load to location after changes and compare the application outputs.


Happy Reading !!!
Comments are invited.......