How To Cancel Prepayment Invoice

To cancel an Unapplied prepayment:

1.    Void Payment associated with prepayment.
    Got To Payables Responsibility > Payments > Entry > Payments > Query with Payment Number > Actions1 (B) > Check Void Check Box > Ok (B)
2.    Cancel Prepayment Invoice.
    Got To Payables Responsibility > Invoices > Entry > Invoices > Query with Prepayment Invoice Number > Actions1 (B) > Check Cancel Invoices Check Box > Ok (B)
   
3.    Ran Create Accounting Program.


To cancel an Fully Applied prepayment:

1.  Fully Unapply the Prepayment
    Got To Payables Responsibility > Invoices > Entry > Invoices > Query with Prepayment Invoice Number > Actions1 (B) > Use Apply/Unapply Prepayment Check Box
   
2.    Void Payment associated with prepayment.
3.    Cancel Prepayment Invoice.
4.    Ran Create Accounting Program.

***************************************************************
For Online And Classroom Training on 
R12 SCM Functional
Fusion Procurement
Fusion SCM
Fusion Procure To Pay
Please Contact -
Gmail # rishitechnologies9@gmail.com
Cell # 9071883639

Overview Of Create Accounting in AP

The Create Accounting program processes eligible accounting events to create subledger journal entries. To create the subledger journal entries, the Create Accounting program applies application accounting definitions that are created in the Accounting Methods Builder (AMB).

The Create Accounting program:

•     Validates and creates subledger journal entries 
•     Generates the Subledger Accounting Program Report, which documents the results of the Create Accounting program.  

Accounting entries are automatically generated for transactions based on your accounting setup in Oracle Subledger Accounting and Oracle General Ledger. We can only adjust accounting entries in Payables if we ran the Create Accounting program in Draft mode. To adjust accounting entries, adjust the transaction details and rerun the Create Accounting program.

 

How to Setup Default values for Create Accounting Program

Go to GL Responsibility > Setups > Financials > Accounting Setup Manager > Accounting Setup

1. Search With Ledger Name.
2. Click On "Update Accounting Options" Button.
3. Clisk On "Update" Button Of "Subledger Accounting Options".
4. Click On "Update Accounting Options" Of corresponding Application.
5. Select All the default parameter values for " Create Accounting" Program.

***************************************************************
For Online And Classroom Training on 
R12 SCM Functional
Fusion Procurement
Fusion SCM
Fusion Procure To Pay
Please Contact -
Gmail # rishitechnologies9@gmail.com
Cell # 9071883639

Enable/Disable the Concurrent Program Parameters

HI Friends,

Here is the requirement.

1. I want to enable/disable concurrent program parameter based on other parameter value. Ex : If value for parameter1 is "Summary" i have to enable the parameter2 and if the value for parameter1 is "Detail" i have to disable the parameter2.

2. If user user select "Summary", i have to display the pop message, saying the "Please enter value for parameter2"

Step 1:

Create independent value set  "PARA_1" set for first parameter.

Step 2: Create one hidden dummy parameter (PARA_2 ) and create NONE value set and enter default value as

select decode(:$FLEX$.PARA_1,'Summary','Summary',null) from dual

Step 3:

Create third parameter which depends on value of first parameter.

For third parameter,create table value set and enter below condition in Where/Order By Clause.

WHERE :$FLEX$.PARA_2 = 'Summary'

Now test your concurrent program.

Step 4 : To Display Popup Message.

a). Create one dummy parameter.
b). Create special value set and attach this to parameter.
c). Pass some dummy constant value to parameter.

FND PLSQL "declare
begin
  if ':$FLEX$.PARA_1:NULL' = 'Summary' AND ':$FLEX$.TEST_9:NULL' IS NULL  THEN
  fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE' ) ;
  fnd_message.set_token( 'MESSAGE', 'Enter Value for parameter 3' ) ;

 fnd_message.raise_error ;
  end if ;
END ;"

Now test your concurrent Program.

How to Print record Number in XML Publisher

Hi Friends,

To Print record number in XML Publisher report output, Use function called position().

Issues With Profile Values Retrieving

Hi Friends,

Today i came across one issue.

i have changed the profile value "Concurrent:Report Copies" from 0 to 1 and i am trying to retrieve the profile value by using  select  fnd_profile.value('CONC_COPIES') from dual; . But still sql query is showing old value as 0.

Solution : Once after updating the profile value, open new toad session to get latest value.

How to cancel Scheduled Concurrent Programs

Use below query to cancel scheduled concurrent programs.

UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N';

COMMIT;