Best Of
Re: where to get Perl Patch 31732095?
JDK and PERL Patches for Oracle Database Home and Grid Home (Doc ID 2584628.1)
2.2 Latest Perl Patches for Database
Re: R12.1.3 - How to transfer data from Projects Module to GL
There are a few steps to try.
If cost /revenue have been distributed, then run the Subledger Period Close Exception report to see if they are just waiting to go to GL, are in SLA, have issues, etc.
If you're not sure, make sure cost distribution has been run -- you can use Expenditure Inquiry with the parameter costed = No and the date range. If you have a high volume, this can take a long time. If cost is not distributed, then run PRC: Distribute Labor Costs and/or PRC: Distribute Usage and Miscellaneous costs, etc
If cost has been distributed, then try running PRC: One-Step Interface Streamline Processes to GL This will interface the costs to GL and import the journal. If this doesn't send anything to the GL, then try running PRC Transfer Journal Entries to GL. This will find any entries sent from PA to SLA that didn't get all the way to the GL and send them over to GL. You may need to query the journals and post them. If neither of these work, go to the GL and go to Journal --> Import --> Run and check for anything in the GL interface with a source of Projects. If you find journals, import them.
The cost journals above will have a source of Project Accounting and categories of Labor Cost, Miscellaneous Cost, Inventory, Work in Process, Burden, Usage, depending on what kind of costs you actually incur.
On to revenue.... Similar to above, check in Expenditure Inquiry for the date range, billable = Yes and revenue = No. If there are items that haven't had revenue generated, then run PRC Generate Draft Revenue Then run the PRC One Step Interface Streamline to send revenue to the GL. If that doesn't do it, try the PRC Transfer Journal Entries to GL. Then the GL Journal --> Import --> Review. These journals will have source Project Accounting and category Revenue. Also note that projects must have baselined funding in order to generate revenue.
If none of this helps, post your results and we can try to help more.
Regards,
J
Re: IE Announcement: Customer Communication IE SEPA PAYMENT FILE CHANGES FOR 2024 TO SUPPORT PAIN 009
Hello Melissa,
All legislative patches are cumulative and include the previous ones.
Kind regards,
Mariana
AR Trx Dist BETC GDF single-row subquery error, when fund_value exists in multiple ledgers
Hi All,
For any agencies/installs who happen to have the same fund values used across multiple ledgers, there's a bug in the new FV_AR_BETC_GDF_FG value-set which could be encountered. This value-set is used for the Agency BETC GDF (JG_AR_DISTRIBUTIONS DFF/attribute1) on AR Transaction Distributions, and results in ORA-01427 single-row subquery error when an AR Trx Distribution uses a Fund that exists in fv_fund_parameters for multiple ledgers. This value-set was recently introduced with the new FV Funding Group changes (primarily to help drive DISGF vs DISNGF BETC differently on the disbursement side). We've included the latest FV Funding Group functionality updates as part of our G-Invoicing patching, so we're running into it as part of our G-Invoicing testing.
Example error:
There are a variety of ways it could be fixed, but we fixed by updating the FV_AR_BETC_GDF_FG value-set to add the following condition:
AND set_of_books_id=FV_GTAS_UTILITY_PVT.GET_LEDGER_ID
Updated definition:
This fix mirrors how the issue is handled in the FV_AR_BETC_GDF value-set, which was used for the BETC GDF previous to the funding group enhancement.
I did an SR to ask Development to fix in a later release, but was told "Unfortunately, development will not be providing an update regarding the value-set definition. However, they are aware of the issue." So, just thought I'd share here.
Good Luck!
Larry
Re: R31410 and Work Order Dates
Hello Jason,
This typically is the work order start date.
Per KM Solution E1: 31: What date on the work order header determines Item Effective Dates when parts list and routing are attached (P48013) Enter Change Order (Doc ID 2822368.1), by default, these dates are checked against the Start Date of the work order (F4801 STRT). However, when running the Work Order Processing program (R31410), processing option #1 on the Defaults tab controls which date is used for this purpose. The help text reads, "Use this processing option to specify the default work order date for effectivity checking. If you leave this field blank, the system uses the work order start date." If this option is set to 1, the Work Order Date (F4801 TRDJ, the date that an order was entered into the system) will be used instead.
Regards,
Jeff
Re: Unifier Cost Sheet - locking budget distribution for many projects at once
Hi Karen, There is no bulk lock/unlock through the UI, but we did add a REST API in 24.10 to update the cost sheet lock status
Re: Is it possible to update the "Type of Hire" on the Hire tab within the Manage Application page?
I know many customers have them in job data (hire - 08/13/2025) and insert a term row (8/13/2025) with the action reason of termination - no show. They want to track if this person applies again for a job that they never showed up.
-Julie
Re: How to change phone number on oracle support ID?
Hi @User_QQ244 ,
If you are asking about the two-factor authentication number that you use to log into the support portal:
- Your default factor is set during initial MFA registration. To add an additional phone number, modify, or change your default verification method, go to My Login Profile page., and use the Action menu under Authentication Factors.
Please refer to the FAQ:
Regards,
Jennifer B
My Oracle Support Community Administrator
