Why organization that I want is not in the list when I create PR?

When PR is created for the certain item, the item should be assigned for this organization first.

Go to Inventory> Items>Master Items

Search for the Item> Go to Organization Assessment folder:

As it is seen above, the item is assigned to other organization but not to the one we need.

So click on the box for it to be assigned and pop up in Organization list while creating PR.

Why the journals are not posted automatically to GL even ‘Transfer to General Ledger’ and ‘Post in General Ledger’is set to Yes?

This is because the period is closed for running period. You should open the period and run Create Accounting again with ‘Transfer to General Ledger’ and ‘Post in General Ledger’ set to Yes.

The journals will be posted automatically.

Bank Account Transfer

Go to CM Accountant→ Bank Account Transfers

Click Create button:

Fill the fields below:

Settle Transactions Through Oracle Payments: Yes

Transaction Subtype: Bank Transfer

Transfer date: 12.01.2017

Currency: XXX

Transfer amount: 30.000

Source Bank Account: XXX Bank

Destination Bank Account: XXX Bank

Go to Payment Details Tab:

Choose Payment Method: EFT (Electronic)

Then click Apply and Validate:

Check the Status of Bank Transfer Account.

It should be: Settlement In Process

Now Change the responsibility to : Funds Disbursement Process Manager>Home

See the Payment Process Request on Home Page and click on Take action:

Choose Payment Process Profile: Bank

Click Go:

Click on Create Printed Payment Instructions:

Click on Continue:

Fill the fields below:

Payment Process Profile: Bank

Internal Bank Account: XXX Bank (the account the money is transferred from)

Payment Document: Payment_Order_XXX

Payment from Date: 12.01.2017

Payment to Date: 12.01.2017

Click on Continue:

Click on Submit:

The request has been submitted.

Go to View> Request> Find:

See the submiited request: Format Payment Instructions

Click on View Output:

See the created Payment Order.

Go again to Home page and Click on Take Action:

Click Continue:

Click Apply:

Now go back to CM Accountant> Bank Account Transfers

The status of Bank Account should be: Settled

Create Bank Statement for XXX Bank as Payment (which money has been transferred from)

Reconcile the line with Payment.

Now Create Bank Statement for XXX Bank as Receipt (the bank which the money is transferred to)

Reconcile the line.

Now go back to Bank Account Transfer and check the status.

It should be: Settled and Cancel option should be Disabled.

Concurrent Programs Incompatibilities

When a concurrent program is incompatible with another program, the two programs cannot access or update the same data simultaneously. You can make a program incompatible with itself which means that the program will not start while it is running. It will run one by one.

System Administrator/ Concurrent/Program/Define
then click
Incompatibilities

How to find concurrent request status and meaning

select status_code from apps.fnd_concurrent_requests where request_id=23756693;

Status_code shows if request completed normal or not.

The meaning of status_code column is shown below.

C - Normal
E- Error
I - Scheduled
X - Terminated
G - Warning

How to find responsibility name and request group name for given concurrent program

By using below script it is possible to find responsibility name and request group name for given concurrent program.

SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description,
                fcpt.user_concurrent_program_name
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
 AND   fcp.concurrent_program_name = 'PROGRAM_SHORT_NAME'
 AND   fcpt.user_concurrent_program_name LIKE '%PROGRAM_NAME%'

Error: Line#1 This line references a source document or source document line that has expired.

When the PO does not go to approval and gives below error:

This error occurs because effective date of Contract Purchase Agreement (CPA) (43918) has been expired which is specified in PO.

Go inside Contract Purchase Agreement (43918) > Terms and Conditions>and change effective date of CPA.

Note that, CPA should be approved before you create PO.  So after changing effective end date, send CPA  to approval again and then send PO 44642 to approval as CPA is approved.